Skip to content

How to build a board-ready sales dashboard in HubSpot

If your board looked at your HubSpot dashboard today, would the pipeline figure be right?

Most HubSpot dashboards start life as a handful of reports someone built in a hurry. A year later, the live pipeline number includes deals you won last spring, last year's enquiries are bleeding into this year's, and nobody's quite sure which figure to trust.

The good news? It's usually fixable in days, not months, and most of the work is agreeing what the numbers should mean.

In short: decide what each number means before you build it. Keep won and lost deals out of anything that claims to be live, count enquiries by the date they came in, show targets in their own reports, and keep pipelines that measure different things apart. Then make sure someone in-house can look after it.

We rebuilt the sales reporting for a marine engineering company whose board uses HubSpot for pipeline, intake and margin. Here's how we go about it, and where it usually goes wrong.

Agree what each number means first

Before touching a report, write down what each headline figure should include. It sounds obvious, but most reporting problems we see come from two people meaning different things by the same word.

(If your HubSpot numbers don't match what finance reports, that's a related but different problem. We cover it in why your HubSpot reporting doesn't match your revenue.)

Typical board figures and what they should include

Figure

What it should include

The common mistake

Live pipeline value

Open deals only, across the pipelines that count as sales

Won and lost deals left in, which inflates the figure

Enquiries received this year

Deals created this year, whatever stage they are at now

Filtering by close date, so older deals bleed in

Intake

The value of deals won this year

Mixing in other pipelines, such as grants or investment

Margin

Margin on won work, taken from your pricing model

Trying to rebuild your accounts inside HubSpot

 

Keep won and lost deals out of anything called live

This is the big one. If a report is meant to show what you still have to go for, every version of it, whether pie chart, bar chart or single number, needs a filter that excludes won and lost stages across every pipeline.

For our client, the live pipeline figure the board saw had been inflated by years of closed deals. One filter, applied consistently, fixed it.

Count enquiries by when they came in

For year-on-year enquiry reports, filter on the date the deal was created, not the close date. That way an enquiry from last November stays in last year's figure, even if you won it in March. These reports can include won and lost deals, because you're measuring demand, not what's still live.

Not sure your reports are telling the truth?

Our free HubSpot health check takes a few minutes and shows where your setup is getting in the way, from pipelines to dashboards.

 

Show targets in their own report

Here's a quirk that catches people out. If a report only looks at won deals, it shows nothing at all until the first deal of the year closes, and that includes the target line.

The fix is simple: split it into two reports. One shows actual intake and margin from won deals, the other shows the target with the won filter removed. Side by side on the dashboard, they read as one.

Keep different pipelines apart

If you track sales, grants, investment or partnerships in separate pipelines, keep them separate in reporting too. A deals-by-owner report that quietly adds grant funding to someone's sales total will cause an awkward board meeting.

Don't turn HubSpot into your accounts system

HubSpot is great at tracking sales activity, pipeline and project-level margin. It isn't your finance system, and it shouldn't try to be. Let your accounting software handle the books, keep your pricing model where it is, and store the agreed margin on each deal so HubSpot can report on it.

Make it something the team can maintain

  • Name reports clearly, including the year, so nobody edits last year's by mistake
  • Keep board reports in their own dashboard and folder
  • Record a short video for each report that has a workaround in it, so the next person understands why

Common mistakes we see

  • Live pipeline figures that include won and lost deals
  • Enquiry reports filtered by close date
  • Targets that vanish until the first deal closes
  • Different pipelines mixed into one total
  • Rebuilding the accounts in HubSpot
  • Reports only one person knows how to fix

A few questions we often get asked

Can HubSpot show sales against target?

Yes. You can use HubSpot's goals, or store targets as properties and report on them. Either way, keep the target in its own report so it shows even before any deals have closed.

Does HubSpot handle more than one currency?

Yes. With multiple currencies switched on, reports convert values into your company currency using the exchange rates set in HubSpot, so keep those rates up to date.

How long does a dashboard rebuild take?

A focused rebuild often takes days rather than weeks. Agreeing what each number should mean is usually what takes the time.

Over to you

So, back to that board meeting. Would you trust the pipeline figure on the screen? If you'd want to double-check it first, it's probably worth a closer look.


At Disruptive Thinking, we help engineering, construction and property firms build HubSpot reporting the board can rely on, and that the team can keep running themselves.

If you'd like a second pair of eyes on your setup, take our free HubSpot health check or book a free 30-minute consultation. No obligation, just a sensible conversation about what your business actually needs.