RaiseTell
Lapse Prevention

Active Bottom Donor Frequency and Mo Distribution Analysis

This analysis creates a detailed "dossier" or donor profile for every donor who was in your bottom segment last year.

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

Active Bottom Donor Frequency and Mo Distribution

How to use the Active Bottom Donor Frequency and Mo Distribution analysis

This analysis identifies and profiles your bottom-tier donors- those whose total giving in the last full fiscal year falls below a set threshold, providing detailed insights into their giving patterns and tendencies. The analysis draws data from your Gifts and Constituents tables, focusing on donors who remain active, and compiles a comprehensive overview of their lifetime giving, frequency, and preferred times of year for making gifts. By surfacing trends such as each donor's most frequent giving months (their mode and second mode months), active years, and recency of gifts, it helps you understand not just how much these donors give, but also when and how often they engage.

You'll find supporting information such as each donor's total lifetime giving, largest significant single gift, number of active giving years, and most recent gift date and amount. These details are presented alongside calculated giving patterns,  which categorize donors (e.g., Frequent Giver, Quarterly Responder,  Annual Giver ) based on their average number of gifts per year. This segmentation enables you to quickly identify which donors are most engaged and which may require reactivation or special attention.

Use this analysis to prioritize outreach strategies for retaining and upgrading bottom-tier donors. For example, knowing a donor's preferred giving months allows you to time appeals for maximum relevance. The breakdown of monthly giving activity and recency helps you identify lapsed donors at risk of attrition or those transitioning to more frequent engagement. You can also use the donor name and organization details to craft highly personalized messages, leveraging lifetime and recent gift information to acknowledge their history and prompt renewed support.

Fundraising managers, annual fund directors, and stewardship teams should regularly review this analysis as part of their Constituent Intelligence routines. Apply these insights to segment communications, test timing of asks, and identify bottom-tier donors with the potential for upgrade. To measure success, track improvements in retention rates, increases in average gift frequency, and the number of bottom-tier donors who move to higher giving segments over time. By integrating these findings into your engagement strategies, you can build stronger, data-driven relationships and drive sustainable fundraising growth.


Analytics Reference: QX135

Focus: 2.3: Within-Segment Growth

Type: Cohort | Lifecycle: Portfolio Management | Time: Retrospective | Audience: Operational

Segments: Bottom | Scope: Segment, Individual Donor

VARIANT FAMILY: Active Donor Frequency & Monthly Distribution (segment variants)

Other members: QX131 Active Top Donor Frequency And Mo Gift Distri; QX133 Active Middle Frequency and Mo Distribution

RUN FIRST: QX172 Segmentation Break Points

Columns included in this analytic: Constituent ID, Donor, Gross Lifetime Giving, Lifetime Total Writeoffs, Net Lifetime Giving, Largest Gift Amount, Largest Gift Date, Number of Active Giving Years, Most Recent Gift Date, Most Recent Gift Amount, Mode Month, Second Mode Month, Giving Pattern, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec, Constituency, Assigned Fundraiser, Deceased

Analytic Details

Analytic ID
RT1
Analytic Name
Active Bottom Donor Frequency and Mo Distribution 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