HubSpot report building guide

Prev Next

Use the HubSpot data source connector to see which campaigns are bringing in the most leads and which leads convert to customers. Pull data such as contacts, companies, deals, campaigns, emails, submitted form details, products, and analytics.

Before you begin

Before you build reports, you need to connect the data source to Supermetrics.

Popular queries

These query configurations help you track key performance indicators and analyze trends. You can use these settings in any Supermetrics destination, such as Data Explorer, Dashboards, Google Sheets, Looker Studio, or data warehouse destinations.

Track new customers by month

See how many new customers you've gained each month this year, so you can identify growth trends and spot months where acquisition was stronger or weaker than expected.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Date range

Year to date

Metrics

Customers

Dimensions

Month

Suggested visualization

Time series chart

Understanding the data

  • Customers: The number of new customers acquired within the reporting period.

  • Month: Splits results by month so you can compare customer acquisition across the year.

See contacts by list

View the number of contacts on each of your HubSpot lists — useful for understanding the size of different audience segments and keeping list health in check.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Metrics

Contacts

Dimensions

List name

Suggested visualization

Table

Understanding the data

  • Contacts: The number of contacts within the reporting period.

  • List name: The name of the contact list, used to compare contact counts across different audience segments.

Analyze form submissions by form and date

See how many form submissions each of your forms received over the last 28 days, broken down by day — useful for identifying which forms are generating the most leads and spotting any drop-offs.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Date range

Last 28 days

Metrics

Form submissions

Dimensions

Form name, Date

Suggested visualization

Table

Understanding the data

  • Form submissions: The total number of form submissions within the reporting period.

  • Form name: The name of the HubSpot form, used to compare submission volumes across forms.

  • Date: Splits results by day so you can track submission trends over time.

Track total deals year to date

Get a high-level scorecard of how many deals you've gained this year — a quick way to monitor pipeline health and progress toward annual targets.

To fetch this data, use the following settings in your reporting or visualization tool:

Setting

Value

Date range

Year to date

Metrics

Deals

Suggested visualization

Scorecard

Understanding the data

  • Deals: The number of deals recorded within the reporting period.

More resources

See the Supermetrics blog for posts about how the Supermetrics integration with HubSpot enhances data reporting and how to set up the ultimate HubSpot report.

You might also be interested in: