RaiseTell
Lapse Prevention

All Donors 5-Year Score Detail thru Current Fiscal Year Analysis

This analysis is a comprehensive, detailed donor file that provides a multi-year giving history and a behavioral trend score across all donors

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

All Donors 5-Year Score Detail thru CFY

How to use the All Donors 5-Year Score Detail thru CFY analysis

This analysis provides you with a detailed, year-over-year profile of every donor's giving behavior across the current and four previous fiscal years.  It summarizes each donor's giving totals by year, as well as their total giving over five years and their lifetime. Central to this analysis is a four-character Score  assigned to each constituent, which encodes their giving trend for each of the past four years (including the current year). Each character in the score reveals whether the donor is new (N), returned after lapsing (R), lapsed (L), increased their giving (I), maintained (E), or declined (D) compared to the prior year. This enables you to quickly identify patterns such as consistent upgrades, recent re-engagements, or at-risk lapsed donors.

There is a summary version of this analysis, which provides a high-level overview of the number of donors with the same score, useful for high-level planning. This analysis, on the other hand, provides actionable information required to execute on that planning.

In addition to the behavioral score, the analysis provides supporting columns, including current and historical giving amounts, lifetime total, and the first fiscal year in which the donor donated. These data points are not part of the score calculation but are essential for crafting tailored messaging, stewardship plans, and major gift strategies. For example, knowing a donor's cumulative contributions can help you acknowledge lifetime impact in your outreach.

The key metrics—five-year giving totals, year-by-year giving changes, and the behavioral score—allow you to craft and target communication more effectively. You can identify donors with increasing trends for upgrade campaigns, spot recent lapses for targeted reactivation, and recognize steady supporters for ongoing stewardship. This analysis is particularly valuable for prioritizing your moves management and personalizing asks and acknowledgments.

Development officers, advancement services, and fundraising team leads should regularly review this analysis—ideally, monthly or quarterly —as part of their Constituent Intelligence routines. Use it to flag donors for follow-up, plan personalized solicitations, and assess the effectiveness of your retention and upgrade strategies. Success should be measured by improvements in year-over-year retention, increases in average gift size, and higher rates of donor reactivation following targeted outreach inspired by this analysis. By applying these insights, you ensure that your engagement is both data-driven and deeply attuned to each donor's unique journey with your organization.


Analytics Reference: QX36

Focus: 3.1: Health Checks

Type: Score+Detail | Lifecycle: Portfolio Management | Time: Current/Monitoring | Audience: Operational

Segments: Top, Middle, Bottom | Scope: Individual Donor

COLLECTIONS: Year-End Campaign War Room

VARIANT FAMILY: Donor Score Detail (segment+metric variants)

Other members: QX31 Active Top Donor 2-Year Frequency Trend Score; QX32 Active Top Donor Combined Frequency and Amt S; QX82 Middle Level Donor 5 yr Giving Amt Score Deta

SEE SUMMARY: QX35 All Donors 5-Year Score Summary Thru CFY; QX37 All Donors Score Summary -Last 5 yrs thru LFY

ALSO TRY: QX35 All Donors 5-Year Score Summary Thru CFY; QX37 All Donors Score Summary -Last 5 yrs thr

Columns included in this analytic: Constituent ID, Donor Name, Organization Donor, Score, Giving Current FY, Giving FY-1, Giving FY-2, Giving FY-3, Giving FY-4, Total Giving (5yrs), Total Lifetime Giving, Donor Since (FY), Constituency, Assigned Fundraiser, Lifetime Total Writeoffs, Net Lifetime Giving

Analytic Details

Analytic ID
RT1
Analytic Name
All Donors 5-Year Score Detail thru Current 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