RaiseTell
Lapse Prevention

Giving Pyramid Detail -Donor View

This analytic provides a donor centric view of the gifts that make up the Giving Pyramid.

By RaiseTell Team May 12, 2026 12:00:00 AM 3 min read

How to use the Giving Pyramid Detail -Donor View

The Giving Pyramid Detail - Donor View analysis provides a comprehensive examination of individual donor gifts within the current fiscal year. The analysis focuses on categorizing donor contributions into various tiers based on the gift amount, allowing you to understand the distribution of donations across different levels. It utilizes data from the Gifts table, concentrating exclusively on donations made in the current fiscal year, which is calculated by adding six months to the current date to align with many fiscal year reporting standards.

The analysis breaks down donor gifts into six monetary categories: less than $100, between $100 and $499.99, between $500 and $2,499.99, between $2,500 and $9,999.99, between $10,000 and $99,999.99, and $100,000 and above. For each donor, it calculates the count and total amount of gifts in each category, providing a clear view of their contribution patterns. Additionally, it summarizes the total number of gifts and the total giving amount for each donor throughout the year.

These metrics are crucial as they help pinpoint where most donations are concentrated, identify major donors, and recognize potential growth areas within your donor base. By examining these tiers, you can tailor your engagement strategies, such as personalized communications or targeted campaigns, to different donor segments, thereby enhancing the effectiveness of your fundraising efforts.

To maximize the strategic value of this analysis, consider running it at the end of each quarter to track changes and trends in donor behavior over time. Development officers and fundraising directors should review the findings to identify both high-value donors and those who might be encouraged to increase their giving. The insights can also guide the planning of donor recognition programs or the allocation of resources to cultivate relationships with donors poised to move into higher giving tiers.

Success measures for this analysis could include an increase in donor retention rates, growth in average donation size, and a higher number of donors transitioning to upper giving tiers. By assessing these outcomes, you can gauge the effectiveness of strategies informed by this analysis and make data-driven decisions to optimize your fundraising initiatives.


Analytics Reference: QX179

Focus: 1.3: Gift Size Distribution Analysis

Type: Summary+Detail | Lifecycle: Portfolio Management | Time: Retrospective | Audience: Operational

Segments: All/None specified | Scope: Organization

VARIANT FAMILY: Giving Pyramid Analysis (time+detail variants)

Other members: QX41 Giving Pyramid Analysis LFY; QX84 Giving Pyramid CFY

SEE SUMMARY: QX41 Giving Pyramid Analysis LFY

Columns included in this analytic: Constituent ID, Gifts_0_99, Total_0_99, Gifts_100_499, Total_100_499, Gifts_500_2499, Total_500_2499, Gifts_2500_9999, Total_2500_9999, Gifts_10k_99k, Total_10k_99k, Gifts_100k_Plus, Total_100k_Plus, Total Gifts Year, Total Giving Year

Analytic Details

Analytic ID
RT1
Analytic Name
Giving Pyramid Detail -Donor View
Focus
2.1: Outright Lapse Mitigation YOY
Type
Cohort Portfolio Management Retrospective Operational
Segments
Top Middle Bottom New Individual Donor
Collections
Lapse Prevention Toolkit
Workflows
Lapse Prevention Protocol (Step 1)
Also Try
RT146 Recently Lapsed Top Donors (15 mo); RT18 Attrition Warning Summary View; RT20 Attrition Warning Detail; RT5 Active Top Donors FYTD vs Last Year
Columns Included
Constituent ID, Donor, Last Gift Date, Last Gift Amount, First Gift Date, Consecutive FYs Giving, Avg Gift Amount, Avg # of Months Between Gifts, Total Fiscal Years with Gift, Total Gifts, Total Giving, Deceased, Constituency, Assigned Fundraiser