Donor retention is a cohort result, not a contact status

Donor retention rate answers one narrow question: Of the donors who gave in an earlier period, what percentage of those same donors gave again in the comparison period? Start with a fixed donor cohort, apply the same identity and gift rules twice, and keep the report specification beside the percentage.

That sounds simple. The division is simple. The harder part is making sure two staff members would build the same numerator and denominator.

Write the report rules before running the formula

The Fundraising Effectiveness Project defines donor retention rate as the percentage of people who donated in a prior period and donated again in the current period. It also defines overall, new-donor, repeat-donor, and database retention separately. A report labeled only “retention” leaves too much unstated.

Write four lines at the top of the report:

1. Period: the starting and comparison dates.
2. Donor identity: whether one donor means an individual, household, or organization.
3. Eligible gift: which completed transactions put that donor in either set.
4. Comparison cutoff: the date on which both periods were last refreshed.

These are operating choices, not universal rules. Your organization may have an approved reason to include or exclude refunded gifts, event purchases, soft credits, or third-party gifts. The important control is to document the choice and apply it to both periods.

Build two donor sets, not two gift totals

Suppose 120 unique donors gave during your starting period. During the comparison period, 54 of those same donors gave again.

`54 retained donors ÷ 120 starting donors × 100 = 45%`

The denominator stays at 120. New donors acquired during the comparison period do not enter it. A retained donor counts once even if that person made five gifts. Total gifts, current active donors, and retained donors answer different questions.

Microsoft's nonprofit fundraising dashboard illustrates the distinction. Its documentation lists donors, gifts, donor retention, new-versus-repeat giving, and lapsed donors as separate measures. A growing gift count does not tell you whether the same donors returned.

Use a stable donor identifier to compare the two sets. If duplicate contacts or household rules are unresolved, fix or declare those boundaries before trusting the percentage. The guides to merging duplicate donor records and keeping household members distinct cover those source-record decisions.

Keep the time windows comparable

A full prior year and the first quarter of the current year do not produce a useful annual-retention comparison. Either compare two complete periods or label both sides as year to date through the same point.

FEP's current time-series page states that its retention measure is computed year to date: it looks at people who donated last year and asks what share donated again in the current year to date. That scope belongs beside the number, especially when a dashboard will be reused later.

The refresh cutoff matters too. FEP's 2026 methodology notes that some gifts reach a donor system after the gift date, including offline gifts entered in batches and payments synced from another platform. If you rerun an older period after late records arrive, preserve the prior result or record the new refresh date. Otherwise a historical trend can change without an explanation.

Reconcile the result before interpreting it

Before sharing the rate, keep a small audit packet:

• the four-line report specification;
• an export of unique starting-period donor IDs;
• an export of retained donor IDs found in both periods;
• counts for the numerator and denominator;
• the formula and refresh date;
• a short exception note for unresolved identity or eligibility questions.

Then spot-check several records from each set. Confirm that a retained donor has an eligible gift in both periods. Confirm that a lapsed donor has no eligible comparison-period gift. Check a duplicate, a household, a recurring donor, and a third-party gift if those cases occur in your data.

This audit does not require a complex dashboard. It requires enough evidence to explain why each donor belongs in the calculation.

Let the rate point to a smaller question

Do not turn one retention percentage into a donor label or a verdict on your entire fundraising program. Use it to choose the next comparison.

If the overall rate changed, calculate separate rates only where the distinction changes an action: first-time versus repeat donors, recurring versus one-time donors, or one acquisition source versus another. Keep each segment's membership rules explicit. The four action rules for donor segments can keep that follow-up list usable.

Sector benchmarks can provide context, but they do not repair a report with mixed periods or unstable donor identities. First make your own calculation reproducible. Then compare the same definition over time and investigate the records behind the movement.