RaiseTell
Lapse Prevention

All Donors Score Summary -Last 5 years thru Last Fiscal Year Analysis

This analysis summarizes the behavioral patterns of all donors who have been active within the last five years.

By CI Blog May 17, 2025 10:32:47 AM 3 min read

All Donors Score Summary -Last 5 yrs thru LFY

How to use the All Donors Score Summary -Last 5 yrs thru LFY analysis

This analysis enables you to quickly assess how your donor base has engaged with your organization over the past five fiscal years, including the most recent completed fiscal year (LFY). Drawing from your gifts and thresholds tables, it examines each donor's giving activity for each of the last five years, classifying donors into segments based on their annual giving patterns. The analysis produces a Score for each donor, reflecting their giving behavior year over year, identifying new donors, repeat donors, lapsed donors, and those whose giving has increased, decreased, or remained steady. These scores are then summarized into broader Indicator categories, such as Positive, Neutral, Possible Concern, and Long-Term Lapse, allowing you to visualize the overall health of your donor community.

You can use this to pinpoint which groups require urgent attention, such as those showing signs of lapsing (e.g., Long Term Lapse or Possible Concern), and which groups are trending positively and likely to respond well to stewardship or upgrade asks. The scoring logic incorporates not only whether donors gave, but also whether their giving is improving, stable, or declining compared to previous years. This nuanced view supports more sophisticated Constituent Intelligence, enabling you to tailor your strategies for re-engagement, retention, or recognition.

Fundraising directors, development officers, and donor relations staff should review the analysis, ideally as part of regular Constituent Intelligence routines, on a quarterly basis, or at key planning junctures. Use the summary counts to identify segments that are growing or shrinking in size. For example, focus on re-engaging donors flagged as Long Term Lapse,  or invest in stewardship for those identified as Positive.  If your version of the analysis includes individual donor details, leverage those columns to craft customized outreach based on each donor's recent giving trajectory.

To measure success, track changes in the number of donors transitioning from 'Possible Concern' or 'Long Term Lapse' into 'Positive' or 'Neutral' categories over time. You can also monitor improvements in retention rates and average gift size among the identified segments. By regularly applying these insights, you position your team to make data-driven decisions that strengthen donor relationships and drive sustainable growth in fundraising.


Analytics Reference: QX37

Focus: 1.5: Donor Lifecycle Analysis

Type: Score+Detail | Lifecycle: Retention, Recovery | Time: Retrospective (Multi-Year) | Audience: Operational

Segments: Top, Middle, Bottom | Scope: Organization

VARIANT FAMILY: Donor Score Summaries (segment+timeframe variants)

Other members: QX29 Active Top Donors 2-Year Giving Amt Score Sum; QX30 Active Top Donors 5-Year Giving Amt Score Sum; QX33 Active Middle Donor 5-Year Amt Score Summary ; QX34 Active Middle Donors 2-Year Score thru LFY; QX35 All Donors 5-Year Score Summary Thru CFY

DRILL DOWN TO: QX36 All Donors 5-Year Score Detail thru CFY

ALSO TRY: QX36 All Donors 5-Year Score Detail thru CFY

Columns included in this analytic: Score, Indicator, Number of Donors

Analytic Details

Analytic ID
RT1
Analytic Name
All Donors Score Summary -Last 5 years thru Last Fiscal Year Analysis
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