Audit Your Dashboard: Three Metrics to Add Next to CTRD
Jenny Love
Published: 07/07/2026

Walk into a healthcare foundation Board meeting and you can almost guess the dashboard before you see it. Revenue to date against goal. Cost to raise a dollar (CTRD). Maybe a chart of gifts closed by month. The numbers are clean, comparable, and immediately legible to any Board member with a finance background.
They are also missing the entire other half of the story.
Every metric on that traditional dashboard answers the same question: How efficient were we last quarter? None of them answers the harder one: Are we building a foundation that can still hit its goals five years from now?
That second question is the one the data says actually predicts long-term success. Here are three metrics to put alongside your existing dashboard so that question gets asked every time you present.
1. Staff Turnover
Most foundations track turnover for HR purposes and never bring it into a fundraising conversation. That's a mistake.
Major and planned gift revenue is relationship work. It depends on continuity, on trust built over years, on the same gift officer being in the seat when a donor is ready to talk about a transformational gift. Every time you lose a frontline fundraiser, you reset the clock on every relationship they were holding.
Pair your turnover rate with your CTRD on every Board report. A foundation running at $0.14 CTRD with 30% turnover is not actually outperforming the foundation running at $0.19 with 8% turnover. The first one is liquidating its future to look efficient today.
If you want a single number to put on the slide, calculate the percentage of your frontline fundraisers who have been in their current role for at least two years. That's the population producing your major gifts.
2. Five-Year Pipeline Growth
CTRD looks backward. It tells you what last year cost. Your five-year pipeline tells you what next decade will produce.
The math is simpler than it sounds. For every prospect in your pipeline, multiply the gift's potential dollar value by the likelihood of closing. A $100,000 prospect at a 20% likelihood is worth $20,000 in expected value. Add up every prospect, and you have your weighted five-year pipeline.
This is not fuzzy math. Think of it like a weather forecast. A 50% chance of rain doesn't mean you get half a rainstorm; it means that across 100 forecasts, it will rain on about 50 of them. Your pipeline behaves the same way. You don't know which specific gift will close, but the math averages out across a full five-year horizon.
The number you actually want to watch is the year-over-year change in that total. Is it growing? Holding steady? Quietly shrinking while your annual revenue stays flat?
A growing pipeline is the leading indicator of a healthy foundation. A flat or shrinking one is the early warning sign that no amount of efficiency will fix.
3. Revenue Mix Maturity
Foundations that perform consistently over time look different on a revenue-by-source chart than foundations that are riding a wave. The sustainable ones have diversified across major gifts, planned gifts, corporate and foundation gifts, and a smaller share of events. The fragile ones are over-reliant on whichever channel had a great year.
You can audit this in 30 minutes. Pull your last five years of revenue by source. Calculate what percentage of total revenue came from each channel in each year. Then look for two things.
The first is the size of your largest single channel. If any one channel is contributing more than 40% of revenue most years, you have concentration risk. The second is the trend in planned giving. Even if it is a small share of revenue this year, the presence of an active planned giving program is one of the strongest predictors of long-term sustainability in the data.
A mature mix isn't an even split, and there’s no “right answer” in terms of the exact percentages that should be coming from each channel. The primary goal is a mix where no single line item can disappear and take your foundation with it.
Why Three Numbers Change the Conversation
Adding these three metrics to your dashboard does something subtle but powerful. It stops leadership from asking only, “How much did we raise this quarter?” and forces them to ask, “Are we building something that can still raise it in five years?”
That is a different question, and it produces different decisions about staffing, investment, and risk.
The foundations that thrive in the next decade are not going to be the ones with the lowest CTRD. They are going to be the ones whose Boards started asking the right question now.