<aside>

HubSpot is a powerful customer relationship management and marketing automation platform that provides valuable insights into your sales, marketing, and customer service efforts. By connecting HubSpot to Power My Analytics, you can automate data collection and create comprehensive reports that showcase your HubSpot performance alongside other marketing channels. This guide will walk you through the process of adding HubSpot as a data source and creating insightful reports in Looker Studio.

</aside>

Prerequisites

Before connecting HubSpot to Power My Analytics, ensure you have:

• A HubSpot account with Admin, Super Admin, or Owner (full access) permissions

Adding HubSpot as a Data Source

1. Log in to your Power My Analytics hub
2. Navigate to the Sources section from the main menu
3. Click the + Add new source button
4. Locate and select HubSpot from the list of available data sources
5. Sign in to your HubSpot account and authorize the Power My Analytics app

For more information on connecting or disconnecting Power My Analytics and HubSpot, please see How to Connect to HubSpot.

Creating a Looker Studio Report

Follow these steps to create a Looker Studio report using your HubSpot data:

1. In the Power My Analytics hub, go to Reports > Looker Studio
2. Select HubSpot from the list of available data sources (this will open the official Looker Studio application in a new window)
3. Google Looker Studio Configuration:
   • Step 1:
     • Name your data source (e.g., "HubSpot - Your Organization Name")
     • Choose your Power My Analytics hub from the dropdown
     • Optional: Leave "Use report template for new reports" checked to use the PMA demo template
     • Click Next
   • Step 2:
     • User Account: Select your HubSpot account (for real data) or "Sample Account" (for sample data)
     • Click Next
   • Step 3:
     • Under “Email dates based on”, select “Publish Date” (to report data on only email campaigns that were published during the report’s date range) or “None” (to report data on all email campaigns regardless of the date selected)
     • Choose options for "Contact dates based on" (stage of customer lifecycle) and "Deals dates based on" for your reports
     • Optional: Allow modification of these date settings in reports
     • Click Connect (top right) to complete the data source configuration
   • Step 4:
     • Click Create Report (top right)
     • Include “today” in your report’s date range to begin historical data storage when you first create a report

For a quick start, use our pre-built HubSpot demo template.

Key Reports and Fields

HubSpot offers a wide range of metrics and dimensions for reporting. Some popular fields include: