The Relationship Report | Show Me the Receipts

About this report

You came into this work because you wanted to help an organization sustain its mission. The thank-you call, the follow-up you remembered to make, the donor whose name you finally got right on the wall plaque — that is the work. And almost none of it shows up in the report your CEO reads on Monday morning.

The financial report tells you what you raised last quarter. It does not tell you whether you will raise it next quarter. It tells you the boat is floating today. It does not tell you whether the hull is sound. By the time the financial report shows the leak, the water is already in the engine room.

The relationship report is the other side of the dashboard. It tells you whether the receipts are landing. Whether your donors are staying. Whether the trust you are building is being built. It is made of the same data your organization is already collecting — gifts, donor records, communications — just looked at from the angle that matters for keeping promises.

If you are a first-year DOD reading this: the most honest measure of whether your work is succeeding is not what you raised. It is whether your donors came back. The relationship report puts that number in front of you, alongside four others that round out the picture. None of them require new software. All of them can be built from what you have.

This is what the receipts add up to.

What the report answers

Five questions. Asked in plain language. Answered with numbers from your own database.

Did your new donors come back this year?
Are your donors choosing to deepen the relationship?
How long do your donors stay with you?
Are you keeping the receipts that matter?
Are you stewarding your donors — or only asking?

A sample report

What it could look like for a single-staff or small-shop development office. The numbers below are illustrative — mixed signals on purpose, the way a real first read usually goes.

Hope Valley Community Services

Donor file: 1,847 active records

Reporting period
Q1 2026 (Jan–Mar)

Metric 01

Did your new donors come back?

28%

↑ 3 points from last year (was 25%)

Industry typical

Of donors who gave their first gift last year, about one in four gave again this year. Aligned with the field average — but the field average is the floor of what is possible, not the goal. Sustained gains here roughly double cohort lifetime value over five years.

Metric 02

Are donors deepening the relationship?

247

↑ 18 net new this quarter (29 added, 11 cancelled)

Healthy growth

Donors who chose to give monthly. They have moved from “I gave” to “I’m with you.” Net positive growth means more new commitments than cancellations — the most reliable signal in the report.

Metric 03

How long do donors stay?

4.2 yrs

Median tenure of active donors

Solid depth

The middle of your active donor file has been with you four years. A healthy file shows depth — donors who have stayed, not just been acquired. Watch the distribution: a healthy file has a thick middle band, not a thin year-one bulge.

Metric 04

Are you keeping the receipts that matter?

4.5 days

Median time from gift to thank-you

Needs attention

Field standard is under 48 hours. Yours is more than twice that. Acknowledgment lag is a leading indicator of attrition — the donor who waits five days for a thank-you is the donor who is harder to retain next year. Fixable this week.

Metric 05

Stewarding or only asking?

+47 days

Median gap, last contact vs. last gift

Needs attention

A positive number means the donor heard from you 47 days before they gave — and has not heard from you since. You are showing up to ask, but not between asks. The receipt for the gift is being issued; the receipts that come before the next gift are not.

All metrics pulled from the donor database. No surveys, no self-report, no new software. The numbers are not flattering. They are honest. That is the point of the report.

How to read this report

The metrics that look healthy — the sustainer growth, the tenure depth — are the work of years. They tell you the file has been built well over time. The metrics that need attention — the acknowledgment lag, the contact gap — are this month’s work. They are the receipts that are slipping right now.

The good news in a mixed report is that the visible failures are usually the most fixable. Acknowledgment lag is solved by a process change. Contact gap is solved by a stewardship calendar. Neither requires a campaign, a consultant, or a new line in the budget. They require a director who decides they matter.

The next quarter’s report will tell you whether the decision held.

Build it from what you have

Every metric in the sample report can be calculated from data your donor database already holds. Here is what to pull, where to pull it from, and how to know what good looks like.

Build 01 · Retention

Did your new donors come back?

What to pull For donors whose first gift was in calendar year N, the count of those donors. Then the count of that same group who gave any gift in calendar year N+1.

How to calculate (Donors in year-N cohort who gave in year N+1) ÷ (Total donors in year-N cohort) = first-year retention rate.

Database fields Constituent first_gift_date; gift history with gift_date by constituent.

What good looks like Field benchmark: ~25–30% for new cash donors; ~60%+ for monthly donors. A 10-point gain on first-year retention roughly doubles cohort lifetime value with no change in acquisition spending.

Build 02 · Sustainers

Are donors deepening the relationship?

What to pull Active recurring-gift commitments as of report date. New recurring commitments started in the period. Cancelled commitments in the period.

How to calculate Count of active recurring gifts (the headline number). Net new = new commitments − cancellations (the trend).

Database fields Recurring gift records with status (active / cancelled), start_date, cancellation_date.

What good looks like Net positive growth quarter over quarter. Cancellation rate above 5% per quarter warrants a look at why donors are leaving the program.

Build 03 · Tenure

How long do donors stay?

What to pull For each active donor (gave in last 18 months), the years between their first gift and their most recent gift.

How to calculate Median of (most recent gift date − first gift date) across active donors. Also useful: count of donors in tenure bands — 1 yr, 2 yrs, 3–5 yrs, 6–10 yrs, 10+ yrs.

Database fields Constituent first_gift_date; gift history with gift_date.

What good looks like No single threshold — track the distribution shape year over year. A healthy file thickens in the middle bands over time. A churning file stays heavy at year 1 and thin everywhere else.

Build 04 · Acknowledgment Lag

Are you keeping the receipts that matter?

What to pull For each gift in the period, the date the gift was recorded and the date the acknowledgment communication was sent.

How to calculate For each gift: hours (or days) between gift date and acknowledgment date. Report the median, by gift size band if you have the data.

Database fields Gift gift_date; communication record where type = acknowledgment and send_date. Tip: if acknowledgments are not consistently logged as communication records, this metric exposes the inconsistency — which is itself diagnostic.

What good looks like Under 48 hours for general gifts. Under 24 hours for gifts of $250 and up, with a personal call or note to follow on $1,000+. Over 72 hours is a leading indicator of attrition.

Build 05 · Contact Gap

Stewarding or only asking?

What to pull For each active donor, the date of their most recent non-ask contact (thank-you, impact update, personal note, call, visit) and the date of their most recent gift.

How to calculate For each donor: (most recent gift date) − (most recent non-ask contact date). Report the median across active donors. A negative number means the contact was more recent than the gift — the donor heard from you since they gave. A positive number means the gift was more recent — you have not been back since they helped you.

Database fields Contact / interaction records with contact_type distinguishing ask from non-ask; gift history with gift_date.

What good looks like A negative median is the goal. A positive median over 90 days for major donors is a red flag. Tip: this metric depends on staff logging non-ask contacts; if it is not being logged, the metric is reading the logging problem, not the relationship.

What to do with it

A relationship report is only useful if it changes what you do. Five steps for the first time you build it.

Build the five numbers once. Do not try to perfect them. Get them on a page. The first report will surface as much about your data hygiene as about your donor relationships, which is also useful.
Note which look healthy and which look like the worst news you have read this month. Both are real. The healthy ones tell you what the file has built over time. The bad ones tell you this quarter’s work.
Pick one number to move. Not all five. One. The one you can affect this quarter with no new budget. Usually that is acknowledgment lag or contact gap — the operational receipts.
Make a thirty-day promise. Specific, measurable, and small enough to keep. “Every gift over $100 gets a personal call within 48 hours” is a promise. “We will steward better” is not.
Rerun the report next quarter. The same five numbers. The same calculations. The discipline is in the repetition. A report run once is a snapshot. A report run quarterly is a practice.

The relationship report is not a scoreboard. It is a mirror. It shows you what your donors are experiencing in numbers you can act on, and it shows you what you decided to be accountable to when you committed to look at it.