HubSpot Custom Report Builder: Sources, Fields and Limits

Which HubSpot plans include custom reports, and how many?

When we checked HubSpot's documentation in October 2026, the custom report builder needed Marketing Hub, Sales Hub, Service Hub, Data Hub, Content Hub or Revenue Hub at Professional or Enterprise. Users need Create/own and Edit report permissions. How many custom reports you can create depends on your subscription, and HubSpot publishes those numbers in its Product and Services Catalog.

• Limits don't stack: if you have two subscriptions of the same tier, such as Sales Hub Professional and Service Hub Professional, the custom report limits don't combine. You buy a Reporting limit increase instead.
• Dashboards follow your highest tier: the number of dashboards you can have is based on the highest subscription tier in the account.
• Check the catalog for the numbers. HubSpot keeps the per-tier counts for custom reports, dashboards and reports per dashboard in its Product and Services Catalog, not in the knowledge base. Read it against your own contract before you plan a large build.

If you are deciding whether reporting is worth the upgrade, our Starter vs Professional comparison covers what else changes between tiers.

How do you choose data sources and join associated objects?

The first data source you tick becomes the primary source and sets the focus of the report; every other source is secondary and relates back to it. A report can use up to five sources. When two objects aren't directly associated, HubSpot adds connective sources automatically, and those count toward the five.

To start, go to Reporting > Reports, click the arrow next to Create report and select Custom report. Data sources are the objects, assets and events you want to report on.

• Direct joins: contacts and deals join directly because they are closely associated.
• Connective sources: with Deals as the primary source, adding blog post data also selects Contacts and Web activities. These show a grey check mark.
• Greyed-out sources: when HubSpot can't build a path between sources, they become unavailable. With Contacts as primary and Blog posts as secondary, Marketing email is greyed out.
• Data join info: click View data join info to see how the sources are joined, which records are included or excluded, and a preview table.
• Association labels: open the three-dot menu at the top right of the Data panel to report on specific association labels.
• Datasets: the Dataset tab lets you build from a prepared dataset (Data Hub Enterprise only).

Reporting on your own objects? Plan their associations before you build. Our HubSpot custom objects guide covers how to model them.

Why do HubSpot cross-object reports count records twice?

A cross-object report can count a record once per association. In a Companies report with Contacts as a secondary source, adding a contact field such as Create date (Contact) counts a company with two contacts twice. The primary source also decides what is left out, so the same two objects can return different totals when you swap them.

• Primary source changes totals: with Contacts as primary and Deals as secondary, deals with no contact are left out. Swap them and HubSpot adds a (No value) row for those deals, so the total Count of deals goes up.
• Filter on the right object: using Create date (Company) instead counts each company once, even with no contacts. Drill into the report to see the associated contacts.
• Watch rollup fields: in a Contacts report with Companies as secondary, the company field Number of page views totals page views across the whole company's contacts. Use the contact field if you want each contact's own number.
• Empty values: fields with no value are not counted in aggregations.

Before you share a cross-object report, check one or two rows against the records themselves. It is the quickest way to catch a join that counts the wrong thing.

How do fields, dimensions and measures work?

Every field is either a dimension or a measure. Dimensions, shown in grey, have no aggregation and group the data, such as Lifecycle stage on the X-axis. Measures, shown in green, have an aggregation method such as Sum or Count and supply the values. Most fields start as dimensions; you change one by editing its aggregation.

• Aggregation methods: None, Distinct count, Sum, Average, Median, Min and Max. Sum and Average need number fields; Median, Min and Max work on numbers and dates.
• Distinct count can show fewer data points than you expect: two deals with the same contract date count as one.
• Table totals only appear for measure columns set to Sum.
• Clickable rows: add a Record ID field, such as Record ID - Deals, without aggregation to link each row to its record.
• Up to 12 measures per report, and only one event field.
• More than one measure means you can't add another dimension to Break down by, because the report is already broken down by the measures.

Can you add formulas or calculated fields to a custom report?

Yes, with formula fields. They do row-level math, calculating each row before any column aggregation, so you can report on amount minus discount or a margin per deal. HubSpot's pages disagree on access: the formula article says all Professional and Enterprise subscriptions, while the builder article says Data Hub Enterprise only. Check your own account.

• Where: after selecting data sources, click Add + next to Formula fields, name the field, then define the formula with Insert field and, where available, Insert function.
• Functions need access to datasets, which means Data Hub Enterprise.
• Not reusable: a formula field lives in one report unless you clone it. HubSpot suggests datasets for logic you reuse.
• Empty values: the Change null values to zero? switch treats No value as zero in that report only. Leave it off when a blank should skip the row, for example a fixed discount on deals with a known amount.
• Internal values: some properties need their internal value, not the label you see, or the formula won't validate.
• Limits: the number of formula fields per report depends on your subscription, and HubSpot marked the article as beta when we checked.

How do filters and visualizations work in the report builder?

Filters limit which records the report shows, by date or by dimension; you can't filter on an aggregated measure. You drag fields into Filters, set each rule, group filters and choose how they combine under Rules. Visualizations come from the Visualization menu, and Recommend based on data can suggest a chart from the fields you add.

• Chart types include vertical and horizontal bar, line, area, combination, donut, pie, KPI, gauge, scatter plot, pivot table and table.
• Compare by: bar, line, area, KPI and gauge charts can compare against a date range.
• Multiple Y-axes: bar, line, area and combination charts can compare two fields on different scales.
• Style tab: stacking, data labels, linear or logarithmic scale, legend position, color palette (including Pattern Fill for accessibility), axis min and max, and gauge bands.
• Monthly goal line: only on XY charts with a date property on the X-axis.
• Templates and Breeze Assistant: start from a prebuilt template, or describe the report in a prompt and click Apply to builder.

Reporting on how long deals sit in each stage? See our HubSpot time in deal stage report guide.

How do you save a custom report to a dashboard?

Click Save, add a name, tags and description, then choose Don't add to dashboard, Add to existing dashboard or Add to new dashboard. Click Next, set who can access the report and save. Adding a report to a dashboard can change who sees it, because dashboards have their own access settings.

• Access doesn't override data: users without access to the underlying records, sources or fields may see partial data, a blank report or an error.
• Dashboard limits: each dashboard holds a set number of reports for your subscription, and notes count toward it.
• Share before saving: the Share button copies a link to your in-progress report.
• Export: Actions, then Export unsummarized data, exports every field as a column. Owner and HubSpot team fields export as internal IDs, not names.

Once your reports are saved, our HubSpot sales dashboard examples show how to arrange them for each audience, and our HubSpot dashboards guide covers filters and access.

What are the custom report builder's limits?

When we checked in October 2026, non-table reports were limited to 1,000 unique rows, while tables paginate past that. New data took 10 to 15 minutes to appear, reports refreshed about every two hours, and you could refresh manually once every 15 minutes. Large Break down by fields can stop a report loading on a dashboard.

• Too many data points: breaking down by a field with many values, such as First name, returns this error. Set a Break down by limit of no more than 100, or add filters.
• Dashboards and breakdowns: the builder article says reports with more than 99 Break down by values won't display on dashboards; the dashboard article says more than 100. Keep breakdowns well under either.
• Event reporting: a maximum time range of 10 years, capped at 10 million events on Professional and 100 million on Enterprise, with a minimum time frame of one month on Professional and two on Enterprise.
• No merging: existing reports can't be merged. Build a new report with the sources you need, or keep them side by side on a dashboard.
• Single object reports query the live CRM and update faster, but can't join other sources. They allow up to 20 metrics, and summarized tables stop at 500 results.

Our rule of thumb: if a question needs one object, use a single object report; reach for the custom report builder only when the answer depends on a second object or an activity.

HubSpot custom report builder checklist