The dashboard says fundraising is ahead of goal. The finance report shows a different total. At the meeting, the first discussion is about which gifts each report includes.
A useful dashboard begins with those definitions. Everyone reading it needs to understand the question being answered, the records being counted, and the date through which the information is current.
Build the first version around a small set of questions your team needs to act on. These five provide a practical starting point.
1. Where do we stand against the goal?
Label the measure precisely. Cash received, new commitments, and campaign credit answer different questions. Give each measure its own definition and make sure the goal uses a compatible basis.
For example, an organization might show payments received toward a cash goal and separately track new pledges toward a commitments goal. Define how pledge payments affect each measure so the same commitment is counted appropriately.
Include the reporting period and the last refresh time. For comparisons with the prior year, use equivalent periods. A current year-to-date total needs a comparable prior-year cutoff.
The next decision might be whether to adjust an appeal plan, investigate an unusual result, or review progress in a particular fund.
2. Are last year's donors giving again?
Donor retention adds context to the revenue total. Blackbaud defines annual donor retention as the share of prior-year donors who give again in the following year.
As an illustrative calculation, if 600 constituents gave last year and 270 of those same constituents give again this year, retention is 270 divided by 600, or 45%. Count unique donors according to an agreed policy rather than counting transactions.
During an unfinished year, label the result as retention to date. Compare it with the equivalent point in the previous cycle. Document how the calculation handles households, organizations, soft credits, and the qualifying gift types.
If the result prompts concern, the team needs to be able to examine the relevant donor segments and plan appropriate stewardship.
3. Who needs follow-up?
A retention percentage becomes more useful when staff can identify the constituents behind it.
A common starting point is LYBUNT: “last year but unfortunately not this year.” Define the qualifying giving periods and the cutoff date. Make the audience definition visible wherever the list is used.
Before assigning outreach, apply communication preferences and review relevant circumstances, such as a known pledge schedule or an existing relationship plan. Assign an owner and a next action to the resulting list.
Restrict donor-level detail to staff who need it. A board summary can show aggregate trends while the development team works from an appropriately controlled follow-up list.
4. What is moving through the pipeline?
A pipeline view should help staff see the stage of an opportunity, its owner, the next action, and the expected timing. Document what qualifies an opportunity to enter each stage.
Look for records with no next action or an expected date that has passed. Those are useful review prompts for the relationship owner.
If the dashboard includes a weighted forecast, show the assumptions behind it. An estimated outcome based on stage probabilities needs a clear label, and the underlying opportunities should remain available for review.
5. What operational work needs attention?
Include the work that supports the donor experience: gifts awaiting review, unresolved processing questions, and acknowledgments awaiting completion.
Show age alongside volume. Ten items opened this morning create a different decision from ten items that have been unresolved for weeks. Agree on when an item needs escalation and who handles it.
Start with a measure your team can maintain reliably. A small, current view of pending work can guide the next staff meeting and help distribute assignments.
Put a definition behind every number
For each metric, record its purpose, source, calculation, reporting period, refresh schedule, and owner. Validate the result against a known report and inspect the records behind it before sharing it widely.
Then ask the person who will use the dashboard what action they would take from the information shown. Their answer will help you decide which details belong in the first view and which need a drill-down.
The Venti Group builds reporting and KPI dashboards for nonprofit executives, boards, and development teams. Explore our dashboard work, or talk with us about the questions your team needs to answer.