RaiseTell
Lapse Prevention

CFY results vs Monthly Baseline by Segment

This analytic provides visibility into how individual segments have performed by month in the current FY relative to their 3 year trailing average.

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

How to use the CFY results vs Monthly Baseline by Segment

This analysis compares the current fiscal year's monthly giving performance against a three-year historical baseline, segmented by donor categories: Top, Middle, and Bottom. It leverages data from your gifts database, examining donor contributions over time to identify trends and deviations. By breaking down donor activity into segments and further into status categories (New, Retained, Recaptured), it provides a nuanced view of how different donor groups are performing.

The analysis involves several critical calculations. It first establishes thresholds to categorize donors into segments based on their annual giving amounts. It then tracks each donor's status each year to determine whether they are new, retained, or recaptured. Using this data, the analysis calculates average monthly giving over the past three years segmented by donor status and segment. These historical figures serve as the baseline against which current fiscal year performance is measured.

This analysis is strategically valuable for understanding how well you are engaging different donor segments compared to historical performance. It helps identify which segments are performing above or below expectations, allowing you to tailor engagement strategies accordingly. For example, if you notice that 'New' donors in the 'Top' segment are performing below baseline, it may signal the need for enhanced onboarding and engagement initiatives for high-potential new donors.

You should consider running this analysis monthly to keep a close eye on donor performance trends. Development officers and fundraising directors are key stakeholders who should review this analysis regularly to inform strategic decisions. By identifying segments that are underperforming, you can prioritize these areas for targeted campaigns or personal outreach, ensuring that efforts are aligned with areas of greatest need.

To measure success, track changes in donor retention rates and average gift size after implementing strategies based on this analysis. Additionally, monitor increases in giving from underperforming segments as a direct result of targeted engagement. By using this analysis regularly, you can enhance your understanding of donor behavior, improve relationship management, and ultimately increase fundraising effectiveness.


Analytics Reference: QX150

Focus: 3.1: Health Checks

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

Segments: All/None specified | Scope: Segment, Individual Donor

COLLECTIONS: Year-End Campaign War Room

WORKFLOWS: Quarterly Strategic Review (Step 2)

VARIANT FAMILY: Monthly Fundraising Baseline (detail_level variants)

Other members: QX103 Monthly Fundraising Baseline; QX104 CFY results vs Monthly Fundraising Baseline

SEE SUMMARY: QX104 CFY results vs Monthly Fundraising Baseline

ALSO TRY: QX173 Linchpin Indiv Donor Current FYTD Enrich; QX84 Giving Pyramid CFY

RUN FIRST: QX103 Monthly Fundraising Baseline

Columns included in this analytic: Month, Donor Segment, Baseline (3yr Avg), Actual (Current FY), % vs Baseline, Base Retained, Actual Retained, Base New, Actual New, Base Recaptured, Actual Recaptured

Analytic Details

Analytic ID
RT1
Analytic Name
CFY results vs Monthly Baseline by Segment
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