HubSpot reporting and dashboards: a practical guide

Good HubSpot reporting starts with the decisions you need to make, not the reports the tool lets you build. Get that order right and your dashboards earn their place. Get it wrong and you end up with twenty charts nobody reads and one person who quietly checks the spreadsheet instead.

This guide walks through how I approach HubSpot reporting and dashboards in practice, after more than ten years in the platform daily. It is deliberately blunt about where reporting goes wrong, because in nearly every account I am called into, the problem is not the report builder. It is the data underneath.

Start with decisions, not reports

Before you build anything, ask what decision the report is meant to support. A sales manager working out where to spend coaching time needs different numbers from a founder deciding whether to hire another rep. If a report does not change a decision or prompt an action, it is wall art. Nice to look at, does nothing.

The cheapest way to keep reporting useful is to write down the three or four questions your team genuinely asks each week. How healthy is the pipeline. Are we on track for the quarter. Which channels bring in deals that actually close. Who is doing the work that moves things forward. Build for those and resist the urge to chart everything HubSpot can measure, which is roughly everything.

This matters more in HubSpot than in most tools, precisely because it makes reports so easy to spin up. Easy to create is not the same as worth having, and the gap between the two is where dashboards go to die.

The metrics that matter

A focused reporting setup tracks a small set of metrics that map cleanly to revenue and effort:

• Pipeline value and coverage, so you can see whether there is enough in play to hit the number.
• Conversion rates between deal stages, which show you exactly where deals stall.
• Win rate and average deal size, the two levers behind forecast accuracy.
• Sales activity such as calls, emails and meetings, a leading indicator that moves before the revenue does.
• Lead source and attribution, so you put money where deals actually come from rather than where you assume they do.

Five or six metrics reported every week beat fifty reported when someone remembers. That trade rarely feels generous enough when you are building, and it is right every time.

The main report types

Most reporting needs are met by a handful of report types. You do not need exotic funnels and custom objects to run a sales operation well, and I would gently push back on anyone who tells you that you do.

Pipeline reports

Pipeline reports show what is in play by stage, value and owner. A clear pipeline view answers the question every manager asks first: is there enough here, and is it moving. Keep an eye on deals parked in one stage far longer than your sales cycle says they should be. They are usually dead and nobody has said so.

Forecast reports

Forecast reporting projects what is likely to close in a period. It is only ever as good as your deal stage probabilities and close dates, which is exactly why disciplined data entry matters so much. A forecast built on close dates everyone has stopped updating is a guess in a smart suit.

Activity reports

Activity reports cover calls, emails, meetings and tasks. They are leading indicators, handy for spotting effort before the results show up. Use them to coach, not to police. The point is to see whether the right work is happening, and the moment a team works out you are using them as a stick, the numbers stop telling you anything true.

Source and attribution reports

These tie closed revenue back to where contacts and deals came from, be it paid search, referrals, events or outbound. Attribution is never perfect, and anyone who promises you it is should be treated with suspicion. Even so, a rough source report stops you guessing about which channels deserve budget. If lead sources are filled in any old how, this is the first report to fall apart.

Building role-based dashboards

A dashboard is just a grouping of reports for one audience. The mistake I see most often is the single shared dashboard that tries to serve everyone and ends up serving no one. Build by role instead.

• Reps need their own pipeline, their own activity and their own targets. Keep it personal and actionable, so a rep opens it and knows what to do next without thinking.
• Managers need team pipeline, stage conversion and activity across their reps, so they can see where to step in.
• Leadership needs the headline view: forecast, win rate, revenue trend and source. High level, few numbers, no clutter. If a board member has to scroll, you have already lost them.

HubSpot supports personal and team dashboards, and you can schedule them to land in inboxes on a set cadence. The scheduled email is underrated: a weekly dashboard in someone’s inbox gets read when the dashboard they have to log in for never does. Set the permissions on purpose so people see what is theirs and are not buried under everyone else’s numbers.

If you are setting all this up from scratch, dashboards are far easier to get right when the underlying HubSpot CRM setup is sound from the start. Build the reporting on a shaky foundation and you will be back here in six months.

Why reports mislead

Here is the honest part, and it is the part nobody wants to hear. When a HubSpot report looks wrong, the report is almost always fine. The data feeding it is the problem. Three culprits account for nearly all of it.

Bad data. Duplicate contacts, blank amounts, missing close dates and deals still owned by someone who left last year all quietly bend the numbers. A pipeline report that includes long-abandoned deals overstates your coverage and flatters your forecast, right up until the quarter closes and reality turns up.

Badly defined deal stages. If your stages do not match how you actually sell, every pipeline and forecast report inherits the confusion. Stages should be clear, mutually exclusive and pinned to a real buyer action, not a feeling someone in sales has. This is one of the first things I pull apart in a HubSpot audit and health check, and it is almost always a mess.

Inconsistent properties. When ten people fill in lead source ten different ways, or leave it blank because they are in a hurry, your source reporting turns to noise. Consistency comes from required fields, sensible defaults and a bit of HubSpot automation setting values reliably, not from hoping everyone remembers.

Fix the data and the deal stages and the vast majority of reporting complaints vanish, without you touching a single chart. It is the least glamorous work in HubSpot and the most valuable.

A note on the advanced report builder

HubSpot includes a more advanced custom report builder that lets you combine multiple objects, build funnels and create proper cross-object views. How deep you can go, including how many custom reports you can save, depends on your subscription tier, with the richer capabilities sitting on the higher plans.

The practical point is this: most teams get the bulk of their value from standard pipeline, forecast, activity and source reports long before they go near the advanced builder. Reach for it when a real question genuinely cannot be answered any other way, not because it is sitting there looking clever. I have watched plenty of people spend a fortnight on an elaborate custom report to answer something a standard pipeline view already showed. If you are unsure what your plan includes, check before you assume you need to upgrade.

Keeping reporting maintained

Reporting is never a one-off build, however much you want it to be. Pipelines change, products change, the team changes, and dashboards quietly rot if nobody owns them. Set a light routine: review your core dashboards each quarter, bin the reports nobody opens, and check that deal stages and key properties still match how you actually sell.

This is exactly the kind of ongoing care that ongoing HubSpot management is built around. A little regular maintenance keeps the numbers trustworthy, and trustworthy numbers are the only kind anyone ever acts on. Numbers people quietly doubt might as well not exist.

Frequently asked questions

How many dashboards should I have in HubSpot?

Fewer than you think. Most teams do well with one dashboard per role: reps, managers and leadership. If you cannot name the decision a dashboard supports, it almost certainly does not need to exist. Clarity beats quantity every single time, and a tidy three will always outperform a sprawling fifteen.

Why do my HubSpot reports show different numbers?

Almost always because of the data, not the report. The usual suspects are duplicate records, missing amounts or close dates, two reports running slightly different filters, and deal stages that do not match how you sell. Line up the filters and clean the underlying data and the numbers fall back into agreement. The report builder is rarely the villain here.

Do I need HubSpot Enterprise for good reporting?

No. The core pipeline, forecast, activity and source reports cover what most teams actually need, and dashboards work perfectly well across plans. The advanced custom report builder adds depth on the higher tiers, but get the fundamentals solid before you talk yourself into an upgrade you may not need.

If your HubSpot reporting feels untrustworthy, or you are quietly drowning in dashboards nobody opens, get in touch and we can work out what is genuinely worth measuring.