The PIpeline Report

The Overview

The Problem

  • The team could not quickly report anticipated funding to senior leadership
  • Manual tracking was prone to human error.
  • No version history existed.
  • The report was inaccessible by the majority of the team as it was only saved to the computer of the VP of development.

The Goal

Using the limited available tools, create a system for tracking anticipated funded that is simple, functional, and accessible.

The Process

Step one: Mind map what this report might look like and where the data would come from.
I assessed the current report and talked with it's users: directors and senior leaders. There were no complaints about the columns used in the manually tracked document, so we primarily discussed what information they would add if they could.

The final needs list included:
  • Donor name
  • Solicitation Date
  • Solicitation Amount
  • Expected Date
  • Expected Amount
  • Current Status
  • Funding Project
  • Solicitor Name
  • Relevant Notes.


Step two: Identify where we could consistently track this information in our current CRM database.
We determined additional software was not an option, nor was it a need. Instead, I needed to identify a location within the database that was available for this information.

After working cross-functionally with our lead database director, I found the 'Proposal' tab within each donors record was not being formally used across the organization. This tab had fields that perfectly matched the report needs.

Step three: Develop a process for inputting data in the database.
I presented the initial idea to senior leadership showing them a test workflow and how the data could be used beyond just reporting information out, but also for planning upcoming quarters and Fiscal year planning. I also received feedback from the directors who would be using the process weekly.

Leadership was interested and gave me the green light to develop training materials and implement the new reporting structure.
Step four: Testing and training the new process.
After developing presentation and training materials. I met presented the new structure at the monthly team huddle, and followed up by scheduling 1:1 visits with each director to discuss data input and timelines for reporting.

Through testing different iterations of the process we identified any errors and were able to find an input method that worked for the staff, and an export method that worked for leadership.
Step five: Fully launch the new process and monitor the process.
Expectations were set between leadership and each director about reporting data and how important accuracy would be. We implemented the process in 2017, and monitored it closely for the next 90 days.

the outcome

We piloted the new pipeline report in 2017, and it was still in operation when I left the organization in 2023.

The pipeline report grew to be the primary source for planning annual fundraising goals for development staff in the Central Texas division. It was later adopted by two additional divisions with in the organization and remained integral in providing senior leadership with insights into regional performance.

As the department gained funding to use PowerBI for analytics, the report grew to live in an automated dashboard and continued to be used by all divisions for reporting.


Leadership faced the hurdle of manually tracking anticipated funding for the fiscal year and were often unable to report information to senior leadership when requested. With very few resources, I created a system for inputting & tracking this information that was adopted across multiple departments.

Case study 1

The PIpeline Report

The Overview

Leadership faced the hurdle of manually tracking anticipated funding for the fiscal year and were often unable to report information to senior leadership when requested. With very few resources, I created a system for inputting & tracking this information that was adopted across multiple departments.

The Problem

  1. The leadership team could not quickly and accurately report anticipated funding to senior leadership.
  2. The current method of manual tracking in an unlocked excel document was prone to human error
  3. No version history existed allowing for tracking progress over time
  4. The report was inaccessible to the majority of the team and lived solely on the computer of the VP of Advancement.

The goal

Using the limited available tools, create a system for tracking anticipated funded that is simple, functional, and accessible.

The Process

Step one: Mind map what this report might look like and where the data would come from.

I met with users and found there were no complaints about what the current report contained, but they did want to include more information.

Needs list:
  • Donor name
  • Ask date & Amount
  • Expected date & Amount
  • Current Status
  • Funding Project
  • Solicitor
  • Notes


Step two: Identify where we could consistently track this information in our current CRM database.

After working with our lead database director, I found the 'Proposal' tab within each donors record was not being formally used across the organization. This tab had fields that perfectly matched the report needs.

Step three: Develop a process for inputting data in the database.

I presented the initial idea to senior leadership showing them a test workflow and how the data could be used beyond just reporting, but also for planning.

Leadership was engaged and gave me the green light to develop training materials and implement the new reporting structure.
Step four: Testing and training the new process.

After developing presentation and training materials. I met presented the new structure at the monthly team huddle, and followed up by scheduling 1:1 visits with each director to discuss data input and timelines for reporting.

Through testing different iterations of the process we identified any errors and were able to find an input method that worked for the staff, and an export method that worked for leadership.
Step five: Fully launch the new process and monitor the process.

Expectations were set between leadership and each director about reporting data and how important accuracy would be. We implemented the process in 2017, and monitored it for the next 90 days.

The Outcome

We piloted the new pipeline report in 2017, and it was still in operation when I left the organization in 2023.

  • The report grew to be the primary source for planning annual fundraising goals in Central Texas.
  • It was adopted by 2 additional divisions within the organization.
  • it was integral in providing senior leadership insights into regional performance.

As the department gained funding to use PowerBI for analytics, the report grew to live in an automated dashboard and continued to be used by all divisions for reporting.