Why does donor retention look worse than it is?
5,510 people were stored as 6,214 records, depressing reported retention by 10.9 points.
What went in
- Files
- 3
- Rows
- 24,680
- Period
- Jul 1, 2022 – Jun 30, 2026
- Verification
- 25 checks passed
Source files
- gifts_fy23_fy26.csv18,432 rows
- constituents.xlsx6,214 rows
- campaigns.xlsx34 rows
What came back
- 58.1%
- 5,510
- 52.0%
The finished project
gifts_fy23_fy26.csv
18,432 rowsCheckedYour retention is 11 points better than you think, and your income is far less safe.
704 of the 6,214 constituent records are the same people entered twice, mostly by online appeals creating a new record for someone already in the postal file. Counting records, retention is 47.2%; counting people, it is 58.1% — above the sector benchmark rather than below it. The same defect has been hiding the number that matters more: eleven households give 52% of unrestricted income, and two of those eleven are one household.
$1,842,000Raised, FY2026+2.8%
58.1%Retention, by person−1.2pp
5,510Donors−4.3%
The same donors, counted two ways
- 015,510 people are stored as 6,214 records, and it is depressing your retention.
- 02The win-back appeal is addressed to 312 people who are giving right now.
- 03Eleven households are 52% of unrestricted income, and one of them ends this year.
Filed under
Closest to this one
Have something like this?
Drop it in and see what comes back. You only pay once you like it.
No account needed to start. You only pay when you like what you see.