Your top 10% of donors probably account for 60-80% of your revenue. If you do not know exactly which donors those are, what tier they sit in, and which ones are ready to give more, you are managing your fundraising program without a map.
The donor pyramid is that map. It is not a conceptual framework reserved for capital campaigns or major gift programs. It is a practical tool for understanding where your revenue comes from, where it is concentrated, and where the growth opportunities are hiding.
What Is a Donor Pyramid?
A donor pyramid is a visual framework that segments your giving base into tiers based on gift amount, with the broadest segment at the base and your most significant donors at the top.
A donor pyramid is a visual framework that segments your giving base into tiers — from broad-based annual fund donors at the bottom to planned giving donors at the top — revealing where revenue concentration and upgrade opportunities exist.
The classic structure:
- Base — Annual fund donors: The largest group by count, the smallest by revenue per donor. Typically gifts under $1,000. Your volume tier.
- Mid-level donors: Gifts in the $1,000 to $10,000 range (thresholds vary by organization). A critically underleveraged tier in most development programs.
- Major donors: Your most significant annual contributors. Threshold varies by organization size — $1,000 at a small nonprofit, $25,000 at a large institution.
- Planned giving: Legacy commitments through wills, trusts, and beneficiary designations. Often the most financially impactful gifts an organization will ever receive.
The pyramid shape reflects a fundamental truth about fundraising: you have many small donors and few large ones. Managing that concentration strategically — and upgrading donors through the tiers — is the central job of a development program.
The AFP Methodology: Gift Range Charts
The Association of Fundraising Professionals gift range chart methodology is the standard approach for planning major campaigns. It works backward from a revenue goal to determine how many donors at each level you need to reach it.
The rule of thumb: the top gift in a campaign typically represents 10-20% of the total goal. The top 10 gifts represent roughly one-third of the goal. The broad base of smaller gifts fills the remaining two-thirds.
This logic applies not just to campaigns, but to your ongoing annual fund strategy. If your goal is $1 million in annual giving, how many donors do you need at each tier? How many major gift donors can your current portfolio support? How many mid-level donors are ready for an upgrade cultivation strategy?
The pyramid answers these questions visually, making them easier to present to boards and leadership teams who are unfamiliar with development strategy.
How to Build a Donor Pyramid from Your Data
Building a donor pyramid from raw donation data requires four steps.
Step 1: Pull your full giving history for a defined period
Use the most recent completed fiscal year as your base. Export every gift for every donor, with donor ID, gift date, and gift amount.
Step 2: Aggregate to the donor level
Sum all gifts per donor for the year. You want total annual giving per constituent, not individual gift amounts. A donor who gave four times at $250 each is a $1,000 donor, not four $250 donors.
Step 3: Assign tier thresholds
Define your giving tiers based on your organization's giving patterns. Common starting thresholds:
| Tier | Typical Gift Range |
|---|---|
| Planned Giving | Legacy commitment (any gift size) |
| Major Donors | $10,000+ |
| Mid-Level | $1,000 to $9,999 |
| Annual Fund | $100 to $999 |
| Small Donors | Under $100 |
Adjust these thresholds to reflect your actual donor distribution. If your database has 1,500 donors and only two give above $10,000, your major donor threshold may need to be lower to be actionable.
Step 4: Count donors and sum revenue by tier
For each tier, calculate the number of donors, total revenue, average gift, and revenue as a percentage of total. This gives you both the shape of your pyramid and the financial weight of each tier.
In Excel, this is a SUMIF and COUNTIF exercise against your aggregated giving data. With a pivot table, it takes 20-30 minutes. Without prior aggregation, longer.
What the Pyramid Tells You
Once you have built your pyramid, three analyses are immediately actionable.
Revenue concentration
What percentage of your revenue comes from the top tier? If your top 50 donors represent 75% of revenue, that is a concentration risk. The loss of three major donors could be catastrophic. This framing resonates with boards and justifies investment in donor retention and pipeline development.
Tier gaps
Look at the donor count and revenue at each level. A thin mid-level tier is common and is almost always the most underleveraged opportunity in a development program. Mid-level donors have demonstrated capacity and loyalty. They are the most likely upgrade candidates for major gift cultivation.
Upgrade candidates
The top of each tier is where your upgrade prospects live. A donor who gave $850 last year is a potential mid-level donor. A donor who gave $8,500 last year is a potential major donor. Without the pyramid, these donors look like everyone else in their current tier. With it, they are visibly ready for upgraded cultivation.
The Mid-Level Tier: The Most Overlooked Opportunity
Most development programs have two cultivation tracks: a broad annual fund track and a major gift program with personal relationship management. The mid-level tier falls into the gap between them.
Mid-level donors give $1,000 to $10,000 annually. They are too significant to manage through mass email alone and too numerous for full major gift management at most organizations. This ambiguity means they often receive the same generic communications as $50 donors, while their actual relationship with your organization warrants something more personal.
Organizations that create a deliberate mid-level program — personal acknowledgment calls, impact reports, invitation-only events — consistently see both improved retention in this tier and meaningful upgrades into major gift status.
The pyramid makes this opportunity visible in a way that abstract discussions about donor management do not. When you can show a board that 47 donors gave between $1,000 and $5,000 last year and only three received any personal outreach beyond a mass email, the case for a mid-level program writes itself.
The Efficiency Gap: Board Decks and Obsolete Data
The standard donor pyramid workflow at spreadsheet-dependent organizations looks like this:
- Pull giving history in January for the annual report and board presentation
- Spend a day building the pyramid in Excel using pivot tables and manual tier assignments
- Present it to the board in February
- File it away and not look at it again until next January
By March, the pyramid is already out of date. New donors have joined. Others have upgraded or lapsed. The upgrade candidates at the top of each tier have either been contacted or they have not, and there is no easy way to know which without rebuilding the analysis from scratch.
The deeper problem is that a once-a-year pyramid does not drive fundraising strategy. It describes last year. Upgrade cultivation, mid-level stewardship, and pipeline management require knowing where donors sit right now, not where they were 11 months ago.
How Modern Software Makes the Pyramid Actionable
The Donor Pyramid Report in sherbertOSOS auto-generates with configurable tier thresholds, so you can adjust the tiers to match your organization's giving patterns and see the results instantly. It updates continuously as gifts come in.
More importantly, it identifies upgrade candidates automatically: donors at the top of their current tier who, based on giving history and engagement score, are ready for personal cultivation toward the next level.
This changes the pyramid from a presentation tool into an operational one. Instead of building it once a year for the board deck, your development team has live visibility into where every donor sits and which ones should be moved into a more personal relationship track.
For segmentation strategies that build on your pyramid structure, see Donor Segmentation Strategies That Actually Drive Revenue. For retention strategy that keeps each tier stable, see Donor Retention Rate: Benchmarks, Formulas, and How to Improve It.
Frequently Asked Questions
How many tiers should a donor pyramid have?
Most organizations use four to six tiers: planned giving, major gifts, mid-level, annual fund, and first-time donors. Adjust thresholds to your organization's actual giving distribution. If a tier has fewer than five donors, merge it with an adjacent tier until your database is large enough to support the distinction.
What gift amount defines a major donor?
The threshold varies by organization. For a nonprofit with $500,000 in annual revenue, $1,000 may qualify as a major gift. For a $50 million institution, the threshold might be $25,000. The right threshold is the one where personal relationship management becomes feasible and financially justified. If you have 200 donors above your threshold, you need a structured pipeline system to manage them.
How do I identify donors ready to move up the pyramid?
Look for donors at the top of their current tier with consistent giving history, high engagement scores (event attendance, email opens, volunteer activity), and multiple consecutive giving years. These behavioral signals are more reliable than gift amount alone. A donor who gave $900 three years in a row and attends your annual event is a better upgrade candidate than a donor who gave $950 once.
The Bottom Line
The donor pyramid is one of the most powerful analytical tools in fundraising because it makes revenue concentration visible. Most development directors know intuitively that a few donors carry most of the organization's revenue. The pyramid makes that concrete, identifies the upgrade opportunities, and gives leadership a clear strategic framework for investing in the right relationships.
Building it manually once a year is better than not building it at all. Using it continuously is what actually drives results.
→ Start your free trial and see your donor pyramid automatically populate from your giving data.
Frequently Asked Questions
How many tiers should a donor pyramid have?
Most organizations use 4-6 tiers: planned giving, major gifts, mid-level, annual fund, and first-time donors. Adjust thresholds to your organization's giving patterns.
What gift amount defines a major donor?
It varies by organization. For small nonprofits, $1,000+ may qualify. For larger institutions, the threshold might be $10,000 or $25,000.
How do I identify donors ready to move up the pyramid?
Look for donors at the top of their current tier with high engagement scores, event attendance, and consistent giving history — these are your upgrade candidates.
Related Articles
Try sherbertOS free
See how sherbertOS simplifies your nonprofit operations.