Printed cohort analysis chart with highlighted data columns

Board members understand "donor retention rate" as a single number. That number hides the question that actually matters: which acquisition channels produce donors who give again?

Cohort charts answer a different question

A cohort chart tracks donors who made their first gift in a specific period — say, Q1 2024 — and shows what percentage gave again within 6, 12, and 18 months. When segmented by acquisition channel (direct mail, event, peer referral, online), the chart reveals which channels produce durable relationships versus one-time transactions.

A real example from our client work

One Gyeonggi health foundation saw overall retention of 41% — respectable but uninformative. Cohort segmentation showed event-acquired donors retained at 28% while peer-referred donors retained at 57%. The board reallocated event sponsorship budget toward a referral incentive program. Eighteen months later, first-year retention for the referral cohort reached 62%.

How to structure the chart for board readability

Use rows for acquisition cohorts (by quarter or half-year) and columns for 6-, 12-, and 18-month retention percentages. Color-code cells below your organization's target threshold. Include a footnote defining "retained" — we use "any gift of any amount within the period."

Avoid cumulative line charts for this data. Board members scan tables faster than they interpret trend lines, especially when multiple cohorts overlap.

Data you need before charting

First-gift date for every donor in the CRM, acquisition channel field (even if inconsistently populated — we clean this during intake), and complete giving history for 18 months after each cohort's start date. Missing acquisition channel data is the most common reason cohort charts get delayed.

Presenting uncomfortable findings

Cohort charts sometimes show that your most visible campaign — a gala, a telethon — produces the lowest retention. Present this finding with a recommended action, not just the data point. Boards respond better to "event donors retain at 28%; recommend adding a 30-day follow-up call" than to a red cell with no context.

Questions about a reporting engagement for your organization?

Contact our office