RaiseTell
Lapse Prevention

Segment Migration Summary (First 5 Years)

This analysis looks at how donors acquired in specific fiscal years migrate between giving segments ('Top', 'Middle', 'Bottom', or 'Lapsed') during the first five years following their initial gift.

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

How to use the Segment Migration Summary (First 5 Years) analysis

This analysis examines how donors acquired during specific fiscal years transition between giving segments-'Top', 'Middle', 'Bottom', or 'Lapsed'-over the first five years following their initial gift. It utilizes data from your donor database, specifically focusing on gift amounts and dates to categorize donors into different segments based on their giving behavior. By tracking the migration of these donors, you can gain insights into donor retention and engagement trends, which are crucial for optimizing fundraising strategies.

The analysis calculates the initial segment for each donor based on their cumulative giving within their first year and then tracks their segment status for the subsequent four years. Key metrics include the percentage of donors who remain in or move between segments year-over-year. For example, understanding how many donors from the 'Top' segment remain in that category versus those who lapse can inform your engagement strategies and retention efforts.

This analysis holds significant strategic value. By identifying trends in donor migration, you can tailor your communication strategies to better engage each segment. For instance, if a high percentage of 'Top' donors are moving to 'Lapsed', it may be time to implement targeted re-engagement campaigns. Conversely, if 'Bottom' donors are frequently moving to 'Middle', you can focus on nurturing those relationships to encourage further giving.

To maximize the benefits of this analysis, consider running it annually after the close of your fiscal year. It should be reviewed by fundraising directors and development officers who can translate the findings into actionable engagement plans. Use the insights to create segmented outreach strategies based on donor behavior, which can improve overall retention rates.

Success measures for evaluating the impact of utilizing this analysis include tracking changes in donor retention rates over time, monitoring the growth of each segment, and assessing the effectiveness of targeted engagement campaigns. Additionally, you can measure the average gift size and frequency of donations from each segment to ensure that your strategies are leading to increased financial support for your organization. By continuously applying these insights, you can foster stronger relationships with your donors and enhance your fundraising effectiveness.


Analytics Reference: QX163

Focus: 1.5: Donor Lifecycle Analysis

Type: Cohort | Lifecycle: Acquisition, Lapse Prevention | Time: Retrospective | Audience: Operational

Segments: Top, Middle, Bottom | Scope: Segment

COLLECTIONS: Segmentation Deep Dive

VARIANT FAMILY: Segment Migration Analysis (timeframe+detail variants)

Other members: QX168 Segment Migration Detail (Last 5 FY); QX169 Segment Migration Detail (Last 7 FY)

DRILL DOWN TO: QX168 Segment Migration Detail (Last 5 FY); QX169 Segment Migration Detail (Last 7 FY)

ALSO TRY: QX136 Annual Segment Transition Stats- Basic

RUN FIRST: QX100 Segmentation Data LFY

Columns included in this analytic: Acquisition FY, Initial Segment, Cohort Size, Y2 Top %, Y2 Middle %, Y2 Bottom %, Y2 Lapsed %, Y3 Top %, Y3 Middle %, Y3 Bottom %, Y3 Lapsed %, Y4 Top %, Y4 Middle %, Y4 Bottom %, Y4 Lapsed %, Y5 Top %, Y5 Middle %, Y5 Bottom %, Y5 Lapsed %

Analytic Details

Analytic ID
RT1
Analytic Name
Segment Migration Summary (First 5 Years)
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