Loading tutorials…
Loading tutorials…
HubSpot ships with 80+ default reports. They cover 30% of what your team actually needs. The Custom Report Builder is where the real leverage lives — and where most owners build dashboards nobody opens. Here is the design discipline that makes them load-bearing.
Who this is forRevOps leads, sales managers, marketing managers, and founders who want operational visibility beyond what defaults give them. Requires Sales Hub Pro / Marketing Hub Pro / Operations Hub Pro for the Custom Report Builder. Free CRM is read-only on reports.
What you'll need
Step 1
Every report should answer a specific business question. "Show me sales pipeline" is not a question. "Which deals over $50K have not moved stages in 30 days?" is.
Before opening the report builder, write down: what decision will I make differently based on this report's answer?
Good question examples: 'What is our deal velocity by stage compared to last quarter?' 'Which lead sources are producing customers vs. churned trials?' 'Which reps are above quota with 3 weeks left in the quarter?'
Bad question examples: 'Show me all my deals,' 'Build a marketing dashboard,' 'Pull a report on contacts.'
For each question, identify the object (Contact / Company / Deal / Ticket), the metric (count, sum, average), the breakdown (by stage, by owner, by source), and the filter (last 90 days, owner = team).
Write 5-8 questions before building. You will end up with a focused dashboard instead of one with 20 charts nobody reads.
Step 2
Reports → Reports → Create report → Custom report builder. This is where multi-object queries live (impossible in default reports).
HubSpot → Reports → Reports → click "Create report" top-right → "Custom report builder."
First screen: pick objects. You can pick 1 (single-object report) or multiple (cross-object report).
Single-object example: Deals only — "deals by stage" or "deals by owner."
Multi-object example: Contacts + Deals — "deals with associated contacts in industry SaaS, closing this quarter." Multi-object is the killer feature.
Pick the chart type: Vertical bar, Horizontal bar, Line, Pie, Number, Table, Funnel, Custom data, Comparison. Match chart to question — count goes Number, distribution goes Bar, trend goes Line, conversion goes Funnel.
Step 3
Dimensions = what you break the data by (stage, owner, source). Measures = what you measure (count, sum, average). Filters = narrow the dataset.
In the report builder, drag a property to "X-axis" or "Group by" — this is your dimension.
Drag a measure (Count, Sum, Average) to "Y-axis." For "sum of deal amount by stage," X-axis = Deal Stage, Y-axis = SUM(Amount).
Add filters: Date range (last 90 days), object filters (Deal pipeline = New Business), owner filters (Deal owner = sales team).
For multi-object reports, the filter syntax is "Object A has filter X AND Object B has filter Y." Example: "Contact lifecycle stage = Customer AND Deal stage = Closed Won AND Deal close date in last 90 days."
Preview the data table at the bottom. If row counts look wildly off, the filter logic is wrong. Common mistake: AND/OR confusion between filters that should be union vs. intersection.
Step 4
Naming convention: [Object] - [Metric] - [Filter]. "Deals - Velocity by Stage - Last 90 Days." Reports without good names become unfindable graveyards.
Click Save → Name the report.
Bad names: "Sales Report," "Deals 2," "Test Report Final."
Good names: "Deals - Pipeline by Stage - This Quarter," "Contacts - New This Week by Source," "Reps - Tasks Completed - Last 30 Days."
Save report to a folder. Create folders by use case: "Leadership Dashboard," "Sales Ops," "Marketing Performance," "Customer Success."
Sharing: "Only me" or "All users." For company-wide leadership reports, share with all. For experimental reports, keep personal until validated.
Step 5
Reports → Dashboards → Create dashboard. Each dashboard should have 6-12 reports max, organized by a single audience.
Reports → Dashboards → "Create dashboard" → choose template or start blank.
Audience-first: build one dashboard per audience. "Leadership Weekly Review," "Sales Ops Daily," "Marketing Monthly," "CS Quarterly." Do not mix audiences.
Add reports: drag from your report library to the dashboard canvas. Arrange so the most-important metric is top-left (where the eye lands first).
Restraint: a dashboard with 6 sharp reports gets opened. A dashboard with 24 reports gets ignored. Cut ruthlessly.
Set the date range: dashboards have a global date filter at the top. Reports within can inherit it or override. Default to inherit so changing the date updates the whole view.
Step 6
Dashboards can be shared via link, scheduled email, or Slack. Decide how each audience consumes the data.
Open the dashboard → click Share (top-right).
Sharing options: Private (just you), Specific users (pick), Specific teams (pick), Everyone (entire portal).
Email reports: Set up scheduled email delivery — daily / weekly / monthly. The dashboard sends as a PDF snapshot to recipients.
Slack: Connect HubSpot to Slack (Marketplace) and route dashboard updates to channels. Useful for "Sales Daily" in a sales channel.
For leadership: schedule a Monday morning email with the leadership dashboard. People open scheduled emails 5x more reliably than they remember to open HubSpot themselves.
Step 7
Dashboards rot. Reports go stale, questions evolve. Audit quarterly: archive dashboards nobody opens, retire reports that have not loaded in 60 days.
Quarterly: Reports → Dashboards → sort by Last Viewed. Any dashboard not opened in 60 days is dead weight.
Talk to dashboard owners (or audiences). Ask: "what decision have you made from this dashboard in the last 60 days?" If "none," archive.
Reports → sort by Last Used. Reports not loaded in 90 days: archive (Reports → click report → Actions → Archive). They can be restored if needed.
Active dashboard set should be 4-8 dashboards across the portal. Past 15, the system has become a dashboard graveyard.
Replace dead dashboards with new ones that answer current questions. Dashboards should evolve as the business evolves.
Common mistakes
Building reports before defining the question
What goes wrong: Dashboard has 16 charts; nobody knows what decision each supports. Leadership opens it once, doesn't understand it, never opens it again. Hours of build time produce a screensaver.
How to avoid: Write the question first. "What decision will I make from this report?" If you cannot answer that, do not build the report.
Using default reports forever instead of building custom ones
What goes wrong: Default 'Deals by stage' shows raw count but not value or weighted forecast. You make decisions on count instead of value. Half-million-dollar deals get same weight as $5K deals in your visual scan.
How to avoid: Custom report builder lets you weight by Amount, segment by Pipeline, filter by Close Date. Build the custom version once and pin it. Default reports are starting points, not endpoints.
Dashboards mixing audiences
What goes wrong: Leadership dashboard has 'rep activity by SDR' (relevant to sales ops, not leadership) and 'top 10 deals' (relevant to leadership). Both audiences ignore it because half of it is irrelevant to them.
How to avoid: One audience per dashboard. Leadership = company-level metrics. Sales ops = rep-level operational metrics. CS = customer-health metrics. Marketing = campaign + funnel metrics.
Putting too many reports on one dashboard
What goes wrong: Dashboard has 24 charts on a 1080p screen. Each is shrunk to a postage stamp. Nobody can read them. Cognitive load is too high. Dashboard gets ignored.
How to avoid: 6-12 reports per dashboard. The most-important metric (the one decision driver) goes top-left. Everything else is supporting context. If you need more, build a second dashboard for the same audience.
No scheduled delivery — relying on people to open HubSpot
What goes wrong: Leadership opens HubSpot dashboard once a quarter. Sales reps never. Marketing manager checks weekly. Most people forget. Dashboards exist but are not consumed.
How to avoid: Scheduled email delivery (weekly for leadership, daily for ops). Slack delivery to relevant channels. Push the dashboard to where people work, not where HubSpot lives.
No quarterly audit — dashboards rot indefinitely
What goes wrong: Three years in, the portal has 45 dashboards. 30 are stale. New hires can't tell which are current. Decisions get made from old reports. Trust in the data erodes.
How to avoid: Quarterly audit: archive dashboards not opened in 60 days, retire reports not loaded in 90 days. Replace stale ones with new ones answering current questions.
Recap
Done — what's next
How to set up a HubSpot sales pipeline that produces accurate forecasts
Read the next tutorial
Hand it off
Good dashboards drive decisions. Bad dashboards waste hours. The difference is design discipline — knowing which questions to ask, which charts to use, and how to ruthlessly cull noise. EverestX HubSpot specialists who have built 50+ dashboard sets do this in days. Typical engagement: $300-600 for the initial design, $200-400/mo ongoing iteration at $14-16/hr.
See specialist rates
Yes. Custom Report Builder requires Marketing Hub Pro, Sales Hub Pro, Service Hub Pro, or Operations Hub Pro (or above). Free CRM and Starter tiers can only use predefined reports. For most teams running real ops, Pro is where the platform starts paying for itself.
Pro tiers: up to 100 custom reports per Hub. Enterprise: up to 500. Practically, most healthy portals have 20-40 active custom reports. Past 100, you have report sprawl and the value-per-report drops fast.
Yes — Operations Hub Pro+ includes data sync that can push HubSpot objects (Contacts, Deals, etc.) to Snowflake / BigQuery / Redshift / Postgres. From there, your BI tool of choice can consume them. For one-off exports without Ops Hub, use the export-to-CSV from any report.
Reports are the static query-and-visualize tool. Insights (Sales Hub Pro+) is the AI-driven anomaly detection layer that surfaces 'Deal X has stalled' or 'Rep Y is below pace' notifications without you building a report. Use both — reports for structured questions, Insights for unstructured surfacing.
Breeze Copilot (2026) can suggest reports based on a natural-language question ('show me deal velocity by stage this quarter') and draft the report config. Treat its output as a starting point — always verify the dimensions, measures, and filters match what you actually wanted before saving.
HubSpot CRM
A HubSpot pipeline is the single most-referenced screen in the CRM. Set up wrong, the forecast number is fiction and reps stop trusting it. Set up right, the CRO walks into Monday with a real number. Here is the discipline that holds up.
HubSpot CRM
The marketing-sales handoff is where most B2B revenue gets lost. Marketing thinks they delivered 800 MQLs; sales worked 40 of them. Sales says MQLs are garbage; marketing says sales never follows up. HubSpot has the tools to fix this — here is the setup.
HubSpot CRM
Tasks are how HubSpot enforces sales discipline. Set them up right and reps work a tight daily list. Set them up wrong — too many tasks, vague descriptions, no queues — and tasks become noise reps ignore. Here is the discipline that holds up.
HubSpot CRM
DIY HubSpot CRM is a great idea — until it isn't. This is the honest framework for when the cost of self-managing exceeds the cost of hiring help, and how to tell which side you are on.