How to Connect to HubSpot
This article will help new subscribers to connect to HubSpot. If you are new to Power My Analytics, begin at our Getting Started page to learn how to activate your free trial and start automating your reports.
Before you begin
Check your HubSpot plan
Certain reports will run only for certain HubSpot plans.
Table | Supported plans |
Geo | Marketing Hub Starter, Professional, or Enterprise, or HubSpot CMS |
Sources | Marketing Hub Starter, Professional, or Enterprise, or HubSpot CMS |
Landing_pages | Marketing Hub Professional or Enterprise, or HubSpot CMS |
Emails_stats | Marketing Professional, or Enterprise |
On your first connection
Include "today" in your reporting range so that we can begin storing your data the first time you connect.
Check the complete list of available fields. Custom fields are also supported with our HubSpot connector.
Connect to HubSpot from your Hub
Begin at your Hub. Select Sources from the menu in the left navigation pane. Add a new data source by clicking + New Data Source.
Select HubSpot from the gallery that appears.
Authenticate by signing in to your HubSpot account.
After authenticating, click Looker Studio under Reports in the left navigation pane. Select HubSpot from the gallery that appears.
Select your Hub, then click Next.
Select your HubSpot account under User Account and click Next.
Select the stage in the customer lifecycle that you want your contact dates to be based on in your reports. If you want this setting to be variable in your HubSpot reports, check the box Allow 'Contacts dates based on' to be modified in reports.
Select the date you would like the deals to be based on in your report. Check the box beside Allow 'Deals dates based on' to be modified in reports if you would like to modify this setting after the report has been created.
Leave the checkbox checked for Use report template for new reports to use our convenient pre-made templates. Click Connect to continue.
Click Create Report in the top-right of the page, and then again on the pop-up.
Your report should then appear with your data.
Modify Deals data
To modify deals data within your report, you must leave the "Allow 'Deals dates based on' to be modified in reports" box checked when connecting your data source.
You can filter your individual reports by Create Date, Last Modified Date, or Closed Date.
Still having issues?
Send us a ticket and we will get back to you.
Related Articles
HubSpot Data Connector User Guide
The following article is a guide for automating reports with your HubSpot connector. It includes metrics available and how to connect, backfill, and blend your HubSpot data. To create a HubSpot report, you will need access to at least one or more ...How to Connect to Campaign Monitor
This guide will show you how to connect to Campaign Monitor and start creating reports. You can connect using your Campaign Monitor login or using your API keys. Begin in your Power My Analytics Hub. Under Sources, click + New Data Source. ...How to Connect to BigCommerce
This guide will walk you through the process of getting the credentials you need to connect to BigCommerce with Power My Analytics. You will need to create an API Account and get an Access Token. Before Getting Started You'll Need A BigCommerce ...How to Filter Out Deleted Deals in Hubspot
An API limitation in Hubspot makes it impossible to remove deleted deals from your data set. Follow the instructions in this article to learn how to filter out deals that you no longer want in your reports. Data Studio Select a chart that contains ...How to Connect to Criteo
This guide will walk you through the process of getting the credentials you need to connect to Criteo with Power My Analytics. Before Getting Started You'll Need Admin access to Criteo A Power My Analytics Hub Creating new Criteo credentials Create a ...