Your CRM Is Lying to You: Five Metrics That Predict Donor Behavior

The Dashboard Is Full of Lies

Open your CRM dashboard. Total dollars raised. Number of donors. Average gift. Year-over-year growth. Green arrows.

Now answer this: is your fundraising program getting healthier or sicker? If those top-line tiles are all you look at, you don't know.

Total revenue can grow while the donor base shrinks, if one major gift covers the exit of a few hundred small donors. Donor count can rise while the program bleeds, if you're spending $3 to bring in every $1 of new gifts. The headline numbers say what happened. They don't say what's about to happen.

The Five Metrics That Predict What Happens Next

1. Donor Retention Rate, by Segment

Not overall retention. Retention by segment: first-time donors, repeat donors, major donors, monthly donors. Each group retains at a different rate, and the diagnostic value is in the comparison.

The Fundraising Effectiveness Project's Q4 2024 report (AFP and GivingTuesday, April 2025) puts first-time donor retention at about 19 percent, repeat donor retention near 69 percent, and overall retention at about 43 percent. There's no published benchmark for major or monthly donors; they should retain well above the repeat number, so track your own trend. If repeat retention drops below the FEP median, you have a stewardship problem regardless of what the revenue line says.

2. Revenue Concentration

What share of total revenue comes from your top 10 donors? There's no magic number, but if ten people fund 40 percent of the budget, one board retirement or one bad market year takes a full program with it. Run it for the top 10 and the top 25 and watch the trend, not the level.

3. Donor Lifetime Value by Acquisition Channel

A donor acquired through a peer-to-peer campaign has a different lifetime value than one acquired through a mail piece or a gala ticket. Most organizations know cost per acquisition by channel. Almost none know lifetime value by channel, and that's the number that says where the next marketing dollar should go.

4. Recency-Frequency-Monetary (RFM) Score Distribution

RFM analysis isn't new, and few development offices use it. Score every donor on three dimensions: how recently they gave, how often they give, and how much. Then look at the distribution.

A healthy file has a bell curve. An unhealthy one has a barbell: a few high-RFM major donors, a mass of low-RFM one-time donors, and nothing in between. The middle is the $250-a-year donor on a four-year streak. That group funds next year's budget.

5. Upgrade Rate

Of the donors who gave last year, what share gave more this year? Track this for two years and compare against yourself. If the share of returning donors who increased their gift is falling year over year, the ask ladder in your appeals isn't working. If it jumps, find out which appeal did it and run that again.

Why the Dashboard Doesn't Show These

Most dashboards total the current year. All five of these need a donor's history across years, which means a report keyed on donor ID and gift date, not a tile. Every one of them comes from four columns you already store: gift date, amount, donor ID, and source. Nobody has written the query.

Start Here

Pull these five numbers tomorrow morning. If your system can't produce them from the gifts already in it, that's the first thing to fix, before the next appeal goes out.