Recency Rule based Lapse Predictor

It answers one question: is this donor overdue, relative to their own giving rhythm? Recency ratio = months since their last gift or pledge payment ÷ their typical interval between gifts

By RaiseTellJune 6, 20262 min read

How to use the Recency Rule based Lapse Predictor

This analysis, titled "Recency Rule based Lapse Predictor," provides valuable insights into donor behavior by evaluating whether a donor is overdue for making a gift based on their historical giving patterns. It uses data from two primary sources: the Gifts table, which records donations, and the GiftActivity table, which tracks pledge payments. By combining these datasets, the analysis creates a comprehensive view of each donor's activity, allowing you to assess their engagement.

The core calculations within this analysis focus on the recency of a donor’s last contribution relative to their typical giving rhythm. It computes the "Recency Ratio" by comparing the months since their last gift to their average interval between gifts. This ratio helps identify if a donor is on track, overdue for a follow-up, or at risk of lapsing. The analysis categorizes donors into statuses such as "On track," "Overdue - follow up," or "Well overdue - likely lapsing," providing you with clear guidance on how to prioritize outreach efforts.

Strategically, you can leverage this analysis to enhance donor relationships and optimize fundraising strategies. By identifying donors who may be falling behind their usual giving cadence, you can proactively engage them through personalized communication, targeted campaigns, or reminder messages. This tailored approach not only fosters donor retention but also maximizes the potential for increased contributions.

To make the most of this analysis, consider running it quarterly or after major fundraising events to capture shifts in donor behavior. Development officers and fundraising directors should review the results to identify key segments for engagement. For instance, focusing on those labeled as "Well overdue - likely lapsing" can prompt immediate action to re-engage these donors before they drift away.

To evaluate the impact of utilizing this analysis, track metrics such as donor re-engagement rates, the number of overdue donors converted to active contributors, and the overall increase in donations from previously inactive donors. By assessing these success measures, you can determine the effectiveness of your outreach efforts and continually refine your strategies for donor engagement.


Analytic ID: QX207

Analytic Name: Recency Rule based Lapse Predictor

Focus: 2.1: Outright Lapse Mitigation YOY

Type: Standard Analytic

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

Description: It answers one question: is this donor overdue, relative to their own giving rhythm? Recency ratio = months since their last gift or pledge payment ÷ their typical interval between gifts

Key Question: Is this donor overdue to make a gift relative to their recent giving rhythm?

Action: Plan engagement for overdue donors.

Columns included in this analytic: Constituent ID, Donor Name, Last Activity Date, Activity Events, Months Since Last Gift, Typical Interval (Months), Recency Ratio, Recency Status, Primary Constituency, Assigned Fundraiser, Deceased