Donor Retention Dashboard Template
TLDR
Most nonprofits cannot answer 'are we retaining donors better than last year?' without an hour of spreadsheet work. This dashboard template defines the metrics, segments, and triggers that turn retention data into monthly action. Use it to replace the annual retention surprise with a monthly rhythm of small, specific interventions.
Why Most Nonprofits Discover Retention Problems Too Late
The annual report shows total donors and total revenue. The board hears them quarterly. Neither number reveals what is actually happening with retention. A nonprofit can grow total donors by 10 percent while its first-year donor retention collapses from 25 percent to 15 percent. By the time anyone notices, the cohort is gone.
The Fundraising Effectiveness Project consistently reports sector-wide donor retention around 42 to 45 percent. That means more than half of donors who give in any given year do not give the next. Most of that loss is preventable, but only if it is visible. The retention dashboard makes it visible.
This template defines a monthly dashboard structure: metrics, segments, triggers, and actions. It works for organizations from $500K to $10M in revenue. Larger organizations can extend the segment depth; smaller organizations can simplify. The discipline is the same.
For underlying retention strategy, see the donor retention strategies guide.
Section 1: Headline Metrics
These four numbers belong at the top of the dashboard. Track month-over-month and year-over-year.
Total active donors
Count of unique donors with at least one gift in the trailing 12 months.
- Trigger: Decline of 5 percent or more month-over-month or 10 percent year-over-year.
- Action: Run a lapsed donor reactivation campaign within 30 days.
Donor retention rate (overall)
Of donors who gave in the prior 12-month period, what percentage gave in the current 12-month period?
- Trigger: Decline of 3 percentage points or more from prior period.
- Action: Drill into segments to identify which group is declining; design segment-specific intervention.
New donor count and retention
Count of first-time donors acquired in the prior 12 months. First-year retention rate (percentage who gave a second gift within 12 months of first).
- Trigger: First-year retention below 20 percent.
- Action: Audit the new donor onboarding sequence: acknowledgment timing, welcome series, second-gift ask.
Revenue per active donor
Total revenue divided by total active donors. Indicates whether you are retaining higher-value donors or losing them.
- Trigger: Decline of 5 percent or more year-over-year.
- Action: Segment revenue per donor by cohort to identify whether decline is from major donor lapse or broader.
Donor Retention Dashboard Template
A monthly dashboard template that surfaces donor retention, lapsed donors, segment performance, and the actions each metric should trigger. Delivered by email.
We'll email the resource and a short follow-up sequence. Unsubscribe any time.
Frequently asked