Most HubSpot users never touch the custom report builder. They use the pre-built templates, pull the same three numbers every month, and wonder why investors keep asking follow-up questions.
The custom report builder is where HubSpot stops being a CRM and starts being an actual intelligence layer for your business. If you know how to use it properly, you can walk into any investor conversation with a clear, connected story from first touch to closed revenue. If you don't, you're leaving some of the most powerful data in your stack completely unused.
This is the guide we wish existed when we started building reports for clients.
HubSpot has several ways to build reports. The custom report builder is the most powerful one because it lets you pull from multiple data sources at once. Not just a single object like contacts or deals, but combinations of marketing activity, sales pipeline, web behaviour, and service data in a single view.
The standard report templates are useful for quick snapshots. The custom report builder is for when you need to answer a question that no pre-built template can handle. Like which marketing channel produces contacts that close the fastest, or which lifecycle stage has the longest average time between transitions.
It's available on Professional and Enterprise tiers across Marketing Hub, Sales Hub, Service Hub, Content Hub, Commerce Hub, and Data Hub. To use it, you need Create/Own and Edit report permissions in your HubSpot account.
The first decision you make in the custom report builder is which data sources to include. This matters more than most people realise.
Data sources are the objects, assets, and events you want to report on. Things like Contacts, Deals, Companies, Marketing Emails, Blog Posts, or Web Activities. You can include up to five data sources in a single custom report.
The key concept here is the distinction between your primary data source and any secondary sources. The primary source sets the focus of the report. Everything else relates back to it. Swap the primary and you can get completely different numbers from the same underlying data, so choose deliberately.
When you select data sources that cannot connect directly, HubSpot automatically adds connective data sources to bridge the gap. These count towards your five-source limit and appear with a grey tick to show they were added automatically.
For ROI reporting specifically, these are the sources you will use most:
Contacts - the backbone of most marketing attribution reports. Use this as your primary source when you are reporting on lead volume, source attribution, lifecycle stage progression, or conversion rates.
Deals - essential for anything revenue-related. Pipeline value, win rates, average deal size, time to close. If you are reporting to investors, deals data is usually at the centre of it.
Companies - useful for account-based reporting, particularly if you're tracking penetration into target accounts or reporting at the company level rather than the individual contact level.
Marketing Emails - pairs with Contacts to build campaign performance reports. Open rates and click rates are fine on their own, but connected to deal outcomes they become genuinely valuable.
Web Activities - connects browsing behaviour to contact records. Useful for understanding which pages are part of the journey that leads to a conversion.
Campaigns - lets you group activity by campaign and measure the downstream impact on pipeline and revenue. This is one of the most useful sources for proving marketing ROI.
Once your data sources are selected, you add fields to the report. Every field in the custom report builder falls into one of two types, and understanding the difference is what separates useful reports from confusing ones.
Dimensions are fields with no aggregation. They display as grey in the interface. These are the categorical labels in your report: things like Lifecycle Stage, Deal Stage, Contact Owner, Create Date, or Industry. Dimensions go on the X-axis or in the "Break down by" channel.
Measures are fields with an aggregation method applied. They display as green. These are the numbers in your report: Count of Contacts, Sum of Deal Amount, Average Days to Close. Measures go on the Y-axis. You can add up to twelve measures to a single report.
The aggregation method you choose for a measure controls how the data is calculated. The options are:
Distinct count - counts unique values only. The default for most count fields. Useful when you want to avoid double-counting.
Sum - adds all values together. Use this for revenue fields where you want the total.
Average - returns the mean. Useful for things like average deal size or average time in a lifecycle stage.
Median - the middle value when sorted. More resistant to outliers than average, which can matter a lot in deal value reporting.
Min and Max - the smallest or largest value in the dataset. Useful for range analysis.
One thing worth knowing: if you add a field with a large number of unique values to the "Break down by" channel, the report may fail with a "Too many data points requested" error. The fix is to set a limit on that field (the limit should not exceed 100) or add a filter to narrow the dataset before breaking it down.
The custom report builder supports the following chart types, and choosing the right one matters for readability, especially in a board presentation or investor deck.
Vertical bar chart - the default workhorse. Best for comparing values across categories, like deal count by pipeline stage or new contacts by month. Supports up to twelve measures on the Y-axis.
Horizontal bar chart - same logic as vertical, but better when your category labels are long. Easier to read for things like performance by sales rep name.
Line chart - for trends over time. Revenue growth month-on-month, cumulative leads by quarter, MQL volume across a year. Add the "Cumulative" chart setting to show running totals rather than point-in-time values.
Area chart - a line chart with the area filled in. Useful for showing volume growth in a visually clear way.
Combination chart - lets you add a second Y-axis, which means you can overlay two different measures with different scales on the same chart. This is one of the most powerful chart types for investor reporting because it lets you tell a cause-and-effect story in a single visual.
Donut and pie charts - for proportional breakdowns. Marketing channel mix, deal type distribution, revenue by product. Keep these for cases where the proportion is the point, not for trend data.
KPI - a single number with context. Use this for the headline metrics on your dashboard: total revenue this quarter, MQLs this month, pipeline coverage ratio. Supports up to thirty value fields and can be configured with a "Compare by" date range to show period-on-period movement.
Gauge - a single value shown against a target range, with configurable coloured bands. Useful for goals: green when you are above target, amber when you are close, red when you are behind.
Pivot table - a cross-tabulation of two dimensions with a measure in the intersecting cells. Useful for something like deal count broken down by both deal stage and sales rep, shown in a single table. Supports up to four row fields and four column fields.
Table - the most flexible format for detailed data. Supports up to thirty fields. Use this when the audience needs to read individual records, not just aggregated totals.
Scatter plot - plots individual data points across two axes. Useful for spotting correlations, such as whether higher lead scores actually correlate with faster close times.
If you are not sure which chart type suits the fields you are using, turn on Smart Chart before adding your fields. HubSpot will recommend chart types based on what you add and automatically arrange the fields into the recommended channels. Once you have a starting point, you can toggle smart chart off and continue configuring manually.
Filters determine which records actually appear in your report. They're where precision comes from.
The filter logic options are: ALL of the filters below (AND logic - every condition must be true), ANY of the filters below (OR logic - at least one condition must be true), or Custom filter rules (where you write your own AND/OR combinations, including NOT logic).
A few things worth knowing about filters in HubSpot's report builder:
Date-based filters like "This month" use the account's time zone, not your local time zone. If your team is distributed across time zones, the data in the report will be consistent. But the dates you see when you drill in might look slightly different depending on where you are sitting.
"This week" starts on a Monday.
Certain filter conditions, including "is not equal to any of" and "doesn't contain any of", will exclude records that have no value for the filtered property. Keep this in mind when building filters for pipeline or attribution reports, where empty fields are common.
Building reports is one thing. Organising them into dashboards that tell a coherent story is what makes the difference in a board meeting.
Here are the dashboards worth building if you are reporting on ROI and business performance:
The reports to include: new contacts by source (bar chart, broken down by Original Source), MQL volume by month (line chart), email campaign click-to-deal conversion rate (table), website sessions to contact conversion rate (KPI), and cost per lead if you are connecting ad spend data.
This tells you where your leads are coming from, which channels are converting, and whether volume is growing month-on-month.
The reports to include: open deal pipeline by stage (horizontal bar or funnel), deals closed this quarter vs last (combination chart with deal count on one axis and deal value on the other), average deal size by source (bar chart), win rate by sales rep (table), and time-to-close trend over time (line chart).
This shows the health of your pipeline, where deals are getting stuck, and whether revenue is accelerating.
The reports to include: contacts by lifecycle stage (KPI set or donut chart), average time between lifecycle stage transitions (table), lead-to-MQL conversion rate, MQL-to-SQL conversion rate, and SQL-to-Customer conversion rate (all KPIs or a combination chart showing the full funnel).
The story this tells is funnel efficiency. For investors, this is often the most important dashboard because it shows whether your unit economics are improving over time.
The reports to include: deals created by original contact source (bar chart), revenue closed by original contact source (bar chart), and a comparison of marketing-sourced vs sales-sourced pipeline (combination chart or KPI side by side).
This tells which channels are producing revenue, not just leads. This is the report that justifies the marketing budget.
Reports built in the custom report builder refresh automatically every two hours. If you need fresher data before the next automatic refresh, you can manually refresh a report or an entire dashboard once every fifteen minutes.
For non-table reports, there is a limit of 1,000 unique rows of data. If your report is returning fewer results than expected, adding filters to narrow the dataset will usually resolve it. Table reports are paginated and can exceed 1,000 rows.
New records take ten to fifteen minutes to appear in reports after they are created. So if you just closed a deal and it is not showing up yet, wait a few minutes and refresh.
The custom report builder is not complicated once you understand the logic behind it. Primary data source sets the lens. Dimensions give you the categories. Measures give you the numbers. Chart type determines how clearly the story reads. Filters make the data precise.
Get those five things right consistently, and you can build a reporting setup that makes every investor conversation significantly easier. Because the data is already organised into a narrative before anyone asks a question.
If you're not sure where to start or your HubSpot reporting setup needs a proper audit, that is exactly the kind of work we do. Give us a nudge and we'll help you build your own workflow.
Love a good HubSpot hack? Subscribe to our YouTube channel for deep-dives and more HubSpot guides. Follow us on Facebook to stay in the loop with the latest updates.
Happy HubSpotting!