Live Fundraising Board Dashboards From DonorPerfect Data in HubSpot

The monthly fundraising board report is the most expensive recurring document a small nonprofit produces. Not in dollars, in hours. Your development director spends three days every month pulling exports, building pivot tables, color-coding lapsed-donor lists, and stitching the result into slides. By the time the deck reaches the board, the data is two weeks old and the development director has lost half a workweek they will never get back.

The pattern repeats at every school foundation, alumni fund, and community foundation in the country. The board wants trend lines, segment cuts, and progress against goal. The data exists in DonorPerfect. The reporting layer does not, so the reporting layer becomes a person.

Why the obvious fixes do not fit a small shop

The instinct is to buy a business intelligence tool. Most of them collapse under nonprofit constraints.

Heavyweight BI tools need a direct database connection or a scheduled export pipeline plus someone fluent in their formula language. That someone usually does not exist on a four-person development team.

Native DonorPerfect dashboards have improved, but they slice giving the way DonorPerfect wants to slice it, not the way a board wants to see it. Combining giving with alumni engagement or event attendance needs data that lives outside DonorPerfect.

And hand-built spreadsheets break the moment a column is added, a row moves, or a new code appears. Whatever you build, it rots, and the rebuild lands on your most senior fundraiser every month.

A reporting layer you may already pay for

The cheapest dashboard layer most foundations already have is HubSpot. It offers free reports, paid dashboards, and a permissions model that lets board members read a dashboard without seeing anything they should not.

CRMConnect for DonorPerfect and HubSpot keeps the financial picture current: lifetime giving, average gift, largest gift, first and last gift date, donor type, and the full record of each gift. Dashboards reflect today’s gifts, not last week’s export. When you add a new campaign or appeal in DonorPerfect, your HubSpot dashboards keep working without anyone retyping anything. Any DonorPerfect detail you care about, alumni class year, parent of a current student, board affiliation, can travel into HubSpot for segmentation.

Six dashboards a board chair actually reads

Here is an illustrative scenario. Northbrook Schools Foundation is a hypothetical school district foundation with 6,500 alumni and family donors. It is not a real organization.

Revenue versus goal, year to date. One chart: cumulative revenue this fiscal year against last year and against the board-approved goal. This is the first thing most board chairs look at.

Revenue by campaign. A sortable table of every campaign this year, with revenue raised, goal, gifts received, average gift, and percent to goal. This is the view your development director uses every Monday.

Donor segments. A grid of donor counts: new this year, retained from last year, recovered, lapsed, upgraded sustainers, downgraded sustainers. The board does not need the math. They need to see whether the new-this-year count beats the lapsed count.

Major gift watchlist. A list of donors whose lifetime giving is above your major-gift threshold but whose last gift was more than a year ago. These are the donors who need a human, not an email. Each one gets assigned to a development officer with a follow-up task.

Recurring gift health. Active sustainers, average monthly gift, sustainers added this month, sustainers lost this month, recovery rate. The sustainer base is usually your most predictable revenue, and the board should see it monthly.

Pledge and proposal pipeline. Major-gift opportunities by stage, with a forecast for the next two quarters.

Sharing this with the board does not mean buying everyone a seat. Dashboards can go out as scheduled PDF emails, or the whole board can share one view-only login.

Getting your evenings back

The fifth of every month should not feel like a fire drill. With dashboards in place, board materials are screenshots from views that already exist plus a one-page narrative your development director writes in 90 minutes instead of three days. A mid-month question like “can you pull the donors who gave between $500 and $2,500 last year” becomes a five-minute filter, not a half-day pivot table. For the annual report and audit, giving totals and segment classifications flow back into DonorPerfect so finance and program staff see the same numbers.

What to keep off the dashboard

Boards drift toward vanity metrics: email open rates, social followers, website sessions. Resist that. The board’s job is fiduciary oversight, not marketing tactics. Keep the dashboards on cash and donors. If the marketing committee wants engagement data, give them a separate dashboard. And resist piling on cuts. Six dashboards is the right number for a quarterly board cycle. A seventh and an eighth turn the meeting into a data review instead of a strategy review.

What this means for your fundraising

For an illustrative foundation the size of Northbrook (6,500 donors, $2.4M in annual giving), moving from manual board reporting to live HubSpot dashboards typically saves 15 to 20 hours of staff time a month. Across a development team of three to five, that is roughly $25,000 to $40,000 of annual capacity returned to actual fundraising. The bigger shift is the meeting itself: it moves from “let me walk you through these numbers” to “here is the trend and here is what we are doing about it.”

Want to see CRMConnect DonorPerfect and HubSpot in action? View the API App page.