Operations
The Donor Database Cleanup Nobody Wants to Do (But Everyone Needs)
ConsultNonprofit.com · 6 min read
Almost every fundraising problem eventually traces back to the database. Duplicate donors, bad addresses, inconsistent coding, and unused fields quietly erode retention, inflate acquisition costs, and make every report unreliable.
The five things that are almost certainly broken
1. Duplicates. Most CRMs have 8–15% duplicates. Every dedupe recovers gift history and lapsed donors.
2. Bad addresses. Run NCOA once a year, minimum. A 10% return rate on appeal mail typically means 3–5% of your file has moved.
3. Inconsistent coding. "Board", "Board Member", "BOD", and "Trustee" are four codes for the same audience. Pick one and merge.
4. Unused custom fields. If a field hasn't been queried in a year, archive it. It's slowing your reporting.
5. Missing soft credits. Foundations, DAFs, and employer matches must soft-credit the human. Otherwise you're stewarding the wrong donor.
A 90-day plan
Month 1, audit and dedupe. Month 2, address hygiene and coding standardization. Month 3, rebuild your core queries and a one-page dashboard the ED reads weekly. Do not skip to month 3.
Who should own it
Not the ED. Not the development director. A database administrator — even at 10 hours a week — pays for itself. If you can't hire one, the second-best option is a specialized consultant on a 90-day contract, not "someone on staff will get to it."
Frequently asked questions
- How often should we clean the database?
- A full NCOA + deceased screen once a year, deduplication quarterly, and constituent code hygiene monthly. Data debt compounds fast if you skip a year.
- What's an acceptable duplicate rate?
- Under 2% of active constituents. Above 5% and your reports, mailings, and major-gift research all start to break down.
- Should we outsource data cleanup?
- For NCOA, deceased suppression, and email verification — yes, it's cheaper than staff time. For merges and coding, keep it in-house so institutional knowledge doesn't get lost.
- Will cleanup lose us donors?
- No, if you do it right. Suppress, don't delete. Keep the record and history; just stop mailing until you re-verify the address or email.
Need help finding the right consultant?
Browse experienced nonprofit consultants by specialty and state — or let us shortlist a few for you.