Open navigation

HubSpot: Query setup guide

Once you’ve authenticated your connection to HubSpot, you’re ready to create your first query. 


This guide will walk you through HubSpot query setup for Google Sheets, Data Studio, and Excel, as well as data warehouse destinations like Google Cloud Storage, BigQuery, and the Supermetrics API.


Before you begin

To connect Supermetrics to HubSpot, you need:


Here’s an example of sufficient user permissions:



Data refresh

A HubSpot account can contain a very large amount of data. To improve performance, Supermetrics caches this data, which means that it might take some time to complete the import when you first connect Supermetrics to HubSpot.


The initial import could take days, depending on the size of the account. Once it’s completed, HubSpot will import data once per day. This means you’ll need to wait for the next daily import to finish if you’re looking for data — on deals or contacts, for example — that’s been modified since the last import.


Custom properties

The Supermetrics HubSpot connector supports custom properties for Contacts, Companies, Tickets, Products, Line items, and Deals. 


If the custom properties are not appearing, use Supermetrics’ monitoring tool check that the last successful import that included your custom properties.


If the import has been completed but you still don’t see the properties in Supermetrics, refresh your account data.


Available fields

Visit our documentation site for a full list of the metrics and dimensions Supermetrics can pull from the data source

  • Field label is the name that appears in the sidebar. 
  • Metrics can be found under type - “met”.
  • Dimensions can be found under type - “dim” .


Instructions

Google Sheets Data Studio Excel Data Integrations
  1. Authenticate the data source in Google Sheets. 
  2. Select Dates. Choose one date range (today, yesterday, last week, etc.). To select a custom date, you can insert the date manually in the Start and End fields in the calendar bar.
  3. Select Metrics
  4. Select Split by Dimensions.
    You can choose to split your data into rows and/or columns, reflect the number of rows or columns to be fetched, and define how the data is sorted.
  5. Click Get Data to Table to create your query and pull your data.

Advanced options for Google Sheets

  1. You can filter your data by selecting the field, operator, and value to filter by. Learn more about filters.
  2. Under Options, you can add additional features to your query. Learn more about Supermetrics advanced settings in Google Sheets.



Troubleshooting


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.