---
title: "HubSpot report building guide"
slug: "hubspot-report-building-guide"
description: "Analyze your HubSpot campaigns to track leads, conversions, and metrics like customers, deals, and form submissions for better insights."
updated: 2026-03-25T16:07:28Z
published: 2026-03-26T09:08:19Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# HubSpot report building guide

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.

- **Connection instructions:** See our [HubSpot connection guide](/v1/docs/hubspot-connection-guide).
- **Available metrics and dimensions:** Find the full list of fields in our [HubSpot field documentation](/v1/docs/hubspot-fields).

## 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, Data 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](https://supermetrics.com/blog/supermetrics-hubspot-integration) and [how to set up the ultimate HubSpot report](https://supermetrics.com/blog/hubspot-reporting).

You might also be interested in:

- [Supermetrics report template gallery](https://supermetrics.com/template-gallery)
- [HubSpot metrics and dimensions](/v1/docs/hubspot-fields)
- [HubSpot articles in the knowledge base](/v1/docs/hubspot)