Your donor data isn't neutral. It's costing you money.

Your donor data isn't neutral. It's costing you money.

Nonprofit CRM data has a decay rate. Studies put it somewhere between 20–30% annually — meaning if you haven't actively cleaned your database in the last 18 months, a significant portion of what you're working with is wrong. Wrong addresses. Duplicate records. Giving histories that don't reflect upgrades, lapses, or channel preferences your team has been tracking manually in spreadsheets because the CRM never got updated.

Most organizations know this in the abstract. What they don't reckon with is what it actually costs.

Bad data doesn't just make your reports uglier. It changes who gets what message.

A donor who gave three consecutive years and then missed one gets treated as lapsed — when she's actually a retention risk who needed a different kind of outreach six months ago.

A monthly donor whose card failed twice is still coded active because nobody closed that loop.

A $450 cumulative giver gets the same appeal as a $45 giver because the mid-level segment was never built to distinguish them.

Every campaign you run on top of that produces results you can't fully trust. Open rates look lower than they are.

Retention looks worse than it is. Upgrade numbers look flat.

And because the results are murky, it's hard to know whether your fundraising strategy is working or whether your data is just getting in the way.

Here's the honest version of why this persists: cleaning a database takes time nobody has. The person who knows the CRM best is also running the campaigns, managing the major donor relationships, and putting out whatever fire started this morning. There's no slack. The cleanup keeps getting pushed.

So the data stays messy. The campaigns keep running. The uncertainty compounds.

The place to start isn't a full audit — it's two questions.

First: is your lapsed definition applied consistently across the entire database, or are there records that fall outside it based on how they were entered?

Second: how many monthly donors in your file have lapsed payment statuses that are still coded as active?

Those two things alone will tell you more about the reliability of your data than anything else. And what you find will probably explain a few reporting anomalies you've been quietly ignoring.

Revenue instability usually isn't a fundraising problem. It's a visibility problem. You can't make good decisions about donors you can't see clearly.

If you want a clearer picture of where your file actually stands, the Revenue Volatility Risk Assessment looks at exactly this. DM me for more info.