A major gift pipeline report shows whether the opportunities that could realistically close within a defined period are sufficient to support the remaining fundraising goal. It should separate closed revenue from open opportunities, exclude prospects that are outside the decision window, weight eligible opportunities with organization-owned stage factors, and expose concentration and aging before a forecast reaches leadership.
The useful question is not, “How much is in the pipeline?” A prospect list can look large while containing early-stage names, stale records, unrealistic ask amounts, and opportunities that cannot close before the deadline. The better question is, “How much decision-ready coverage do we have for this goal, by when, and with what risk?”
What is a major gift pipeline report?
A major gift pipeline report is a time-bound view of active fundraising opportunities as they move from qualification through cultivation, solicitation, and a documented outcome. It connects each opportunity to an owner, ask amount or range, current stage, evidence for that stage, expected decision date, last meaningful activity, and next action.
The report is not a wealth-screening list and it is not a promise of future revenue. Capacity may help a team decide whom to research, but an active opportunity also needs relationship evidence, a plausible funding fit, a next step, and a realistic time horizon. Counting every prospect at the full potential ask turns possibility into false precision.
This distinction matters operationally. In a 2025 survey focused on higher-education advancement programs, CASE reported that 51.3% of respondents disagreed that they had sufficient donors at all pipeline levels to meet future giving needs. The same report found less consensus around formal handoffs between teams and noted staff bandwidth and prioritization as challenges. The findings are not a universal nonprofit benchmark, but they show why pipeline strength must be assessed across stages rather than inferred from a large top-of-funnel list. Review the CASE donor pipeline report.
Start with four numbers that answer different questions
A leadership-ready major gift pipeline report should put four numbers beside one another. None should be presented as a substitute for the others.
| Number | What it means | What it prevents |
|---|---|---|
| Closed and committed revenue | Eligible gifts or documented commitments already secured for the named goal and period | Mixing completed outcomes with uncertain opportunities |
| Remaining goal | Goal minus eligible closed and committed revenue, using the organization’s approved recognition rules | Comparing an open pipeline with the original goal after progress has already been made |
| Time-eligible raw pipeline | The full ask amount of active opportunities that could plausibly close inside the reporting horizon | Inflating coverage with distant, paused, unqualified, or unowned prospects |
| Weighted pipeline | Time-eligible ask amounts multiplied by documented, organization-owned stage factors | Treating every open opportunity as equally likely to close |
Two coverage ratios follow:
- Raw pipeline coverage = time-eligible raw pipeline ÷ remaining goal
- Weighted pipeline coverage = weighted pipeline ÷ remaining goal
Raw coverage describes available possibility. Weighted coverage describes a planning estimate under the current stage model. Neither is guaranteed revenue. A report should show both so leaders can see how much of the apparent cushion disappears after timing and stage evidence are considered.
Define stages with evidence, not intuition
Stage labels become useful only when every fundraiser applies the same entry and exit rules. A practical first model can use four open stages plus outcomes:
| Stage | Minimum evidence | Required next field |
|---|---|---|
| Qualification | A named prospect fits the program’s eligibility rules and has a documented reason for active review | Qualification action and due date |
| Cultivation | Relationship activity and funding fit are documented; the opportunity is more than a screened name | Next meaningful interaction |
| Solicitation ready | Purpose, ask range, internal strategy, and decision participants are sufficiently defined | Ask preparation or approval milestone |
| Asked | A specific request has been made and the expected decision timing is recorded | Follow-up date and expected decision date |
| Closed, declined, deferred, or disqualified | A documented outcome removes the opportunity from the open pipeline | Stewardship, recycle, or close reason |
Do not move an opportunity forward because a meeting felt positive. Require the evidence named in the stage rule. Store those definitions in a reporting rules registry so a stage means the same thing across portfolios and reporting periods.
Build stage factors from your own outcomes
A stage factor is the share of comparable historical opportunities that reached the report’s recognized outcome within a similar period. It is not a generic probability borrowed from another organization.
Start with closed cohorts of opportunities. Group them by the stage they occupied at a fixed point before the deadline, then calculate the share that produced an eligible gift or commitment by that deadline. Keep the reporting horizon, gift type, program, and stage definition stable enough that the comparison is meaningful. When history is thin or the process has changed, label the factor provisional instead of implying more confidence than the data supports.
The 2026 North American Prospect Development Benchmark Study, summarized by the Giving Institute, also illustrates the importance of complete stage tracking. Its analysis of 500 participating organizations found that not every organization tracked solicitation or close rates; compound conversion analysis was limited to the 328 that reported all four studied stages. That scope matters: a pipeline model cannot learn from transitions the organization does not record. Read the study summary and methodology notes.
A worked major gift pipeline coverage example
Suppose a nonprofit has a $1,000,000 major gift goal for the year. It has secured $420,000 under its approved recognition rules, leaving a $580,000 remaining goal. After removing paused, unowned, out-of-period, and disqualified records, the team has these time-eligible opportunities:
| Stage | Opportunities | Raw ask amount | Illustrative stage factor | Weighted amount |
|---|---|---|---|---|
| Qualification | 12 | $600,000 | 10% | $60,000 |
| Cultivation | 8 | $520,000 | 25% | $130,000 |
| Solicitation ready | 5 | $410,000 | 50% | $205,000 |
| Asked | 4 | $300,000 | 70% | $210,000 |
| Total | 29 | $1,830,000 | — | $605,000 |
These values are illustrative, not benchmarks. The organization’s raw coverage is $1,830,000 ÷ $580,000 = 3.16. Its weighted coverage is $605,000 ÷ $580,000 = 1.04.
A 3.16 raw ratio might look comfortable, yet the weighted view shows only a narrow cushion. That does not mean the model predicts exactly $605,000. It means the current stage mix barely covers the remaining goal under the organization’s assumptions. A delay, decline, or ask reduction among a few late-stage opportunities could change the outlook quickly.
Add three risk checks before calling the pipeline healthy
1. Concentration
Calculate the share of the weighted pipeline represented by the largest one, three, and five opportunities. If the top three in the example contribute $270,000 of the $605,000 weighted amount, the top-three concentration is 44.6%. Show that dependency plainly. A coverage ratio near 1.0 means something different when it rests on three decisions rather than twenty.
2. Aging
Track days in current stage, days since last meaningful activity, and days until expected decision. Compare each with organization-defined review thresholds. Aging should trigger review, not an automatic downgrade: a complex gift can move slowly for legitimate reasons. The report should distinguish a well-documented long cycle from a record that has simply stopped moving.
3. Ask and timing confidence
Flag opportunities with an unset or stale ask amount, no expected decision date, no owner, or no next action. Those records can remain visible, but they should not silently receive the same planning weight as a fully documented opportunity. Show the share of raw and weighted value with complete decision fields.
Every major gift pipeline report also needs an as-of date and source-refresh status. The ReportWerks guide to fundraising data freshness explains how to keep source timing beside the result.
Turn the report into four decisions
A report earns its place when it changes work. Use the combination of coverage, stage mix, concentration, aging, and field completeness to choose the next operating priority.
- Build: Time-eligible raw coverage is weak. Add qualified prospects or revisit the goal, horizon, or program strategy rather than pressuring the existing portfolio to carry an impossible load.
- Qualify: Raw coverage is large, but too much value sits in qualification without evidence, ownership, or a near-term path. Prioritize research and disposition so possibility becomes a real pipeline or leaves it.
- Advance: Coverage exists, but opportunities are aging in cultivation or solicitation-ready stages. Assign specific next actions and remove internal approval delays.
- Forecast cautiously: Weighted coverage reaches the goal, but concentration, timing, or incomplete fields make the cushion fragile. Present a range and name the opportunities that could materially change it.
Before leadership relies on the result, run the same context, data, calculation, and decision checks used in the ReportWerks fundraising report preflight checklist.
Minimum fields for a decision-ready pipeline
- Opportunity ID and prospect or household ID
- Portfolio owner
- Program, purpose, or funding fit
- Current stage and stage-entry date
- Stage evidence or milestone
- Ask amount or documented range
- Expected decision date
- Last meaningful activity date
- Next action, owner, and due date
- Outcome and close reason
- Reporting horizon and eligibility flag
Do not hide incomplete records. Field-completion rates are part of pipeline health because a missing date, owner, or next action changes how safely the opportunity can support a forecast.
Where ReportWerks fits
ReportWerks brings fundraising, marketing, and performance data into connected reporting views. For a major gift pipeline workflow, the value is not inventing a universal score. It is keeping goals, opportunity stages, historical outcomes, portfolio activity, and reporting rules close enough that leaders can see both the coverage number and the evidence behind it.
Start with one goal and one reporting horizon. Remove ineligible opportunities, define stage evidence, calculate raw and weighted coverage, then add concentration and aging. That first version will be more useful than a larger prospect list because it tells the team what to do next and how much confidence the current pipeline deserves.
Sources
- CASE Insights on the Donor Pipeline, March 2025; higher-education advancement survey, accessed October 9, 2026.
- What 500 Organizations Taught Us About the State of Prospect Development in 2026, Giving Institute, accessed October 9, 2026.
