A practical guide to building HubSpot dashboards that your team actually uses—covering essential reports by function, dashboard design principles, custom report setup, and the executive reporting framework that turns CRM data into strategic decisions.

What Reports Should Every HubSpot User Have?

Every HubSpot user should have role-specific dashboards that answer the three questions their function cares about most: where are we now, what changed, and what do we do next. Sales needs pipeline health, deal velocity, and activity metrics. Marketing needs campaign performance, lead generation trends, and attribution data. Customer success needs renewal pipeline, engagement scores, and escalation tracking. Executives need a single view that synthesizes all three into revenue trajectory and forecast confidence.

Before building reports, run a strategic HubSpot audit to confirm your data is clean enough to report on.

The problem isn’t that HubSpot lacks reporting capability. It’s that most portals are drowning in reports nobody uses while missing the ones that would actually change behavior. We consistently find 40–60 dashboards in audited portals where fewer than five get viewed regularly. The rest are ghosts—created for a one-time question, never deleted, cluttering the interface, and making the useful reports harder to find.

Great reporting isn’t about volume. It’s about signal clarity. Here’s how to build a reporting infrastructure that drives decisions instead of collecting dust.

Essential Reports by Function

Each revenue function needs a primary dashboard that serves as its daily operating view. Build these first. Everything else is secondary.

A RevOps audit explained guide can help you identify which functional reports are missing entirely.

Sales Dashboard

The sales dashboard answers one question: are we going to hit the number? Every report on it should contribute to that answer.

  • Pipeline snapshot. Total pipeline value by stage, with weighted and unweighted views. This is the single most important sales report—the real-time view of revenue in motion.
  • Deal velocity. Average time in each stage and overall cycle length, tracked monthly. Velocity slowdowns are early warning signals that appear weeks before pipeline value declines.
  • Stage conversion rates. Percentage of deals advancing from each stage to the next. Conversion drops at specific stages reveal process problems or qualification gaps.
  • Activity metrics. Calls made, emails sent, meetings booked—tracked by rep. Activity data without outcome correlation is vanity. Pair activity reports with conversion data to identify what activities actually drive pipeline movement.
  • Forecast vs. actual. Rolling comparison of forecasted close amounts against actual closed revenue. This report builds forecast discipline over time and exposes reps who consistently over- or under-commit.

Marketing Dashboard

The marketing dashboard answers: are we generating enough qualified demand to feed the pipeline?

  • Lead generation by source. New contacts entering the database, segmented by original source and campaign. Track volume, quality (lifecycle stage progression), and cost per lead by channel.
  • MQL to SQL conversion. The handoff metric. What percentage of marketing-qualified leads convert to sales-qualified? Low conversion indicates either a qualification problem or a handoff process problem.
  • Campaign performance. Revenue influenced and pipeline generated by campaign, with multi-touch attribution where possible. Single-touch attribution (first touch or last touch) misrepresents campaign value in complex B2B buying cycles.
  • Email health. Deliverability rates, open rates, click rates, and unsubscribe trends. Declining email metrics are often the first measurable symptom of data quality problems.
  • Content performance. Page views, conversion rates, and pipeline influence by content asset. Identifies which content actually drives revenue versus which generates traffic that never converts.

Customer Success Dashboard

The CS dashboard answers: are our existing accounts healthy, growing, or at risk?

  • Renewal pipeline. Upcoming renewals by month, segmented by account health score and contract value. This is the CS equivalent of the sales pipeline snapshot.
  • Engagement trends. Product usage, support ticket volume, and stakeholder engagement patterns by account. Declining engagement is the earliest indicator of churn risk.
  • NPS and satisfaction tracking. Aggregate and account-level satisfaction metrics. Trend direction matters more than the absolute number.
  • Expansion pipeline. Upsell and cross-sell opportunities by account, tracked through a dedicated pipeline or deal stage.

Executive Dashboard

The executive dashboard answers: are we on track, and where are the risks? Build it for a five-minute review. If it takes longer than that to parse, it’s too complex.

  • Revenue vs. target. Closed revenue against plan, displayed as a running total with a target line. Simple. Unambiguous.
  • Pipeline coverage ratio. Total pipeline divided by remaining quota. A 3x coverage ratio is the standard B2B benchmark for healthy pipeline. Below 2.5x triggers alarm.
  • Forecast confidence. Weighted pipeline in commit, best case, and upside categories. Executives need probability-adjusted views, not raw pipeline totals.
  • Funnel health. Top-of-funnel volume, middle-of-funnel conversion, and bottom-of-funnel velocity—displayed as a trend over the trailing 90 days. This single report tells leadership whether demand generation, pipeline development, and deal execution are all functioning.

Dashboard Design Principles

A dashboard that doesn’t get used is worse than no dashboard—it creates the illusion of visibility while providing none. Follow these principles to build dashboards that earn daily attention.

Dashboard hygiene is a core piece of any CRM governance framework—ungoverned dashboards erode trust fast.

One Dashboard, One Audience

Never build a dashboard that tries to serve multiple functions. A dashboard designed for sales managers and marketing leaders serves neither well. Each audience has different questions, different time horizons, and different action thresholds. One audience, one dashboard, one clear purpose.

Lead with the Answer

The most important metric goes in the top-left position. Below it, place the supporting context that explains why the number looks the way it does. The dashboard should tell a story: here’s where we are, here’s why, here’s what needs attention. A viewer should grasp the headline in three seconds and the full picture in thirty.

Limit Report Count

Six to eight reports per dashboard is the maximum for usability. Beyond that, cognitive load collapses signal into noise. If you need more than eight reports, you need two dashboards—not a longer scroll. Prioritize ruthlessly. Every report on the dashboard should earn its place by directly answering a question that drives a decision or action.

Use Consistent Time Frames

Mixing time frames within a dashboard—this week, this month, this quarter, last 90 days—creates confusion. Align all reports to the same period wherever possible. If the dashboard is a monthly operating review, every report should use the same monthly window.

Build for Action, Not Observation

Every report should imply a next step. If pipeline coverage drops below 3x, someone needs to generate more opportunities. If deal velocity slows, someone needs to investigate the bottleneck. If email deliverability drops, someone needs to clean the database. Dashboards that don’t prompt action are decoration.

Custom Reports That Earn Their Keep

HubSpot’s custom report builder is powerful but underutilized. Most teams rely on out-of-the-box reports because custom reports feel complex to build. Here are the custom reports worth the investment.

The reports available depend on your hub tier—see Sales Hub vs Marketing Hub to confirm you're on the right plan.

Custom reports are only valuable if they connect to measuring HubSpot ROI—vanity metrics don't count.

Revenue Attribution by Campaign

Multi-touch attribution that traces closed revenue back to every campaign touchpoint in the buyer journey. This is the report that tells marketing which investments actually drive revenue—not just traffic or leads, but dollars. Requires consistent campaign tracking and proper contact-to-deal association.

Pipeline Created vs. Pipeline Required

A forward-looking report that compares new pipeline generated each month against the pipeline needed to hit quota, based on historical conversion rates and average deal values. This report identifies pipeline generation shortfalls months before they become revenue misses.

Time-in-Stage Analysis

Tracks how long deals sit in each pipeline stage and flags outliers. Deals that exceed the average time-in-stage by more than 50% are either stuck or dead—either way, they need attention. This report prevents the “happy ears” problem of deals lingering in pipeline without real progress.

Lead-to-Revenue Waterfall

A full-funnel report that tracks cohorts from initial lead creation through to closed revenue, including every conversion step and the time between them. This report reveals where the funnel leaks, how long the full journey takes, and which entry points produce the highest-value outcomes.

Frequently Asked Questions

What reports should every HubSpot user have?

Every user should have a role-specific dashboard limited to six to eight reports. Sales teams need pipeline snapshot, deal velocity, stage conversion rates, activity metrics, and forecast vs. actual. Marketing needs lead generation by source, MQL-to-SQL conversion, campaign performance with attribution, and email health metrics. Customer success needs renewal pipeline, engagement trends, and expansion opportunity tracking. Executives need revenue vs. target, pipeline coverage ratio, forecast confidence, and a 90-day funnel health trend. Build for action—every report should imply a clear next step.

How do you create a revenue dashboard in HubSpot?

Build an executive revenue dashboard with five core reports: a revenue-vs-target tracker (closed revenue running total against plan), a pipeline coverage gauge (total pipeline divided by remaining quota, benchmarked at 3x), a weighted forecast view (commit, best case, and upside categories), a 90-day funnel trend (top-of-funnel volume, mid-funnel conversion, bottom-funnel velocity), and a deal velocity tracker (average cycle length by month). Place the revenue-vs-target report top-left as the headline metric. Keep all reports on the same time frame. The entire dashboard should be parseable in under five minutes.

What are the most important CRM reports for B2B?

The five most important B2B CRM reports are pipeline coverage ratio (total pipeline divided by remaining quota—the single best predictor of whether you’ll hit the number), stage conversion rates (where deals advance versus where they stall), deal velocity by stage (how quickly pipeline moves, measured monthly), lead-to-revenue waterfall (full funnel from first touch to closed won, by cohort), and forecast accuracy trend (predicted versus actual, measured quarterly). These five reports provide comprehensive visibility into demand generation health, pipeline efficiency, and revenue predictability.

Reporting Is a Revenue Function

Your dashboards aren’t decorative. They’re the telemetry system for your entire revenue operation. When the telemetry is wrong—or when nobody trusts it enough to check—the team flies blind. Decisions get made on gut feel instead of data. Problems get discovered in quarterly reviews instead of weekly dashboards. Revenue misses get explained instead of prevented.

Many of the underutilized HubSpot features live inside the reporting module—most teams barely scratch the surface.

If your current reporting infrastructure doesn’t drive weekly decisions across sales, marketing, and leadership, it’s not a reporting problem. It’s an operational problem that starts with how your portal is configured. A comprehensive portal audit evaluates reporting health as one of six critical dimensions and identifies the specific gaps between your current dashboards and the ones your team actually needs.

Book Your HubSpot Audit—Squad4 will assess your reporting infrastructure, identify the dashboards your team is missing, and build a roadmap to reporting that drives revenue decisions—all for $2,999. Or explore Mission Control on Launchpad for self-guided reporting templates to upgrade your dashboards today.

Squad4
Post by Squad4
June 2, 2026
Squad4 is a strategic RevOps—and HubSpot—Partner. We specialize in helping growing B2B Tech teams align their customer-facing teams and prepare, actualize, and manage their revenue engine. Successful revenue engines and CRM don't build themselves—that's where your growth squad comes in!