RaiseTell
Lapse Prevention

Buy Till You Die Source -Dash format

This is a query to set up a Buy Till You Die intermediate processing file from your data. BTYD models (like BG/NBD or Pareto/NBD) do not use raw transaction logs; they require a summary matrix containing four specific metrics for each donor:Frequency (1$x$): Count of repeat gifts (total gifts minus 1). 2Recency ($t_x$): Time between the first and last gift. T ($T$): Time between the first gift and the current analysis date (how long they've been "alive" on your file). Monetary ($m_x$): Average gift amount (optional for basic retention models, but needed for LTV).

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

How to use the Buy Till You Die Source -Dash format

This analysis is designed to create a foundational dataset for employing Buy Till You Die (BTYD) models, which are predictive tools used to estimate future donor behavior based on past actions. The analysis draws from the Gifts data, summarizing key metrics for each donor. It helps you understand the frequency of donations, the recency of donations, the donor's tenure with your organization, and the average gift amount. These metrics are crucial for predicting donor retention and lifetime value.

Frequency is calculated by counting the number of gifts a donor has made minus one, indicating how often a donor has returned after their initial contribution. Recency is measured in weeks, showing the time elapsed between a donor's first and last gift. This metric helps assess how recently a donor has engaged with your organization. The T metric, also in weeks, represents the donor's tenure, providing context for how long they have been active. Monetary value is the average gift amount, offering insight into the typical donation size from each donor.

The strategic value of this analysis lies in its ability to guide targeted donor engagement and retention strategies. By understanding these metrics, you can segment donors based on their giving patterns and tailor your communication efforts to enhance relationships. For example, donors with high frequency but low recency might be re-engaged with personalized messages or special campaigns. Understanding monetary value allows you to focus on high-value donors with tailored stewardship efforts.

You should consider running this analysis periodically, such as quarterly or bi-annually, to keep your donor insights current. Development officers and fundraising directors should review the results to inform strategies and action plans. Applying these insights can include designing targeted campaigns for different donor segments or refining solicitation strategies to increase engagement and retention.

To measure success, evaluate changes in donor retention rates, the number of repeat gifts, and the average donation amount over time. Additionally, monitor shifts in donor engagement levels and lifetime value. These indicators will help you assess the effectiveness of strategies informed by this analysis, ultimately enhancing your organization's fundraising outcomes.


Analytics Reference: QX176

Focus:

Type: Cohort | Lifecycle: Retention | Time: Retrospective | Audience: Operational

Segments: All/None specified

VARIANT FAMILY: Buy Till You Die (output_format variants)

Other members: QX177 By Till You Die Std Query

Columns included in this analytic: Constituent ID, Donor Name, frequency, recency, T, monetary_value, Deceased, Constituency, Assigned Fundraiser

Analytic Details

Analytic ID
RT1
Analytic Name
Buy Till You Die Source -Dash format
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