Home > Destinations > Data Studio (ex Looker Studio) > Hubspot

Connect Hubspot to Data Studio (ex Looker Studio)

Connect Hubspot to Data Studio (ex Looker Studio) and and build automated dashboards without CSV exports, spreadsheets, or manual API setup.

Looker Studio
Power BI
Google Sheets
BigQuery
Snowflake

Used by the world's leading companies

Why do agencies use Catchr for Hubspot reporting in Data Studio (Looker Studio)?

Catchr lets media buyers and agencies stop rebuilding Hubspot reports by hand: the data lands in Data Studio ready to chart, for every ad account you manage.

No manual csv export
‍

Stop downloading files from Hubspot every time a client report, spreadsheet, or dashboard needs fresh numbers.

Connected in minutes

Your first Hubspot report can be live in a few minutes. Authorize your Hubspot account, pick your ad accounts, and your data source is ready.

Built for agencies with many CRM accounts

Pull several CRM accounts into one data source, then filter by account to build a report per client or brand in the same Data Studio file.

Hubspot to Looker Studio pricing

Choose your plan by the number of platforms and accounts you report on.

Starter

For freelancers and small teams.

$ 24 /mo

Billed monthly · cancel anytime

Platforms3
Accounts10
Start free trial

Growth

For agencies managing more clients.

$ 239 /mo

Billed monthly · cancel anytime

Platforms10
Accounts100
Start free trial

Scale

For teams reporting at scale.

$ 599 /mo

Billed monthly · cancel anytime

Platforms25
Accounts500
Start free trial

How to connect Hubspot to Data Studio with Catchr?

To connect Hubspot to Looker Studio (Data Studio), open the Catchr connector, authorize your Hubspot account, select the ad accounts you want to report on, then create your report.

1. Open the Catchr Hubspot connector in Looker Studio

Click the connector link to open it inside Looker Studio. You will be asked to authorize the connector before creating your data source.

2. Authorize Looker Studio (Data Studio) and Catchr

Choose the Google account you use for Looker Studio and authorize Catchr to create a secure Hubspot data source.

3. Connect your Hubspot account

Sign in with your HubSpot account that has access to the accounts you want to report on. Make sure your user has the right HubSpot permissions.

4. Select your Hubspot accounts

Choose one or several CRM accounts, depending on the report you want to build.

5. Create your Data Studio report

Click Create report, then add charts, scorecards, tables, filters, and date controls using your Hubspot metrics and dimensions.

6. Customize your dashboard

Use Marketing Email Sent, Marketing Email Delivered, Marketing Email Open, Marketing Email Click, Marketing Email Click Through Ratio, Closed Deal Amount, Deal Closed won count, Contact Original Source, Contact Latest Source Date, Contact First Touch Converting Campaign, Contact Last Touch Converting Campaign, Marketing Email Campaign Name, Deal HubSpot Campaign, Contact Country/Region and many more.

Hubspot metrics and dimensions available in Data Studio

Access 77 metrics and 759 dimensions from Hubspot connectors including Marketing Email Sent, Marketing Email Delivered, Marketing Email Open, Marketing Email Click, Marketing Email Click Through Ratio, Closed Deal Amount, Deal Closed won count, Contact Original Source, Contact Latest Source Date, Contact First Touch Converting Campaign, Contact Last Touch Converting Campaign, Marketing Email Campaign Name, Deal HubSpot Campaign, Contact Country/Region and more.

77

Available metrics

759

Available dimensions

Build better Hubspot dashboards in Data Studio (ex Looker Studio)

Use Catchr to create dashboards that show what is working, what is wasting budget, and where performance is changing.

Client reporting for agencies

Create clean Looker Studio dashboards for each client with with Marketing Email Sent, Marketing Email Delivered, Marketing Email Open, Marketing Email Click, Marketing Email Click Through Ratio, Closed Deal Amount, Deal Closed won count always up to date.

Budget pacing

Compare daily spend with the monthly budget of each campaign, so overspend shows up mid-month instead of on the invoice.

Review what drives results across

Compare to see where budget, traffic, or revenue is improving and where performance is dropping.

Compare with your other channels

Combine with your others marketing to understand performance across your full acquisition journey.

Keep an eye on Hubspot performance

Track Hubspot Marketing Email Sent, Marketing Email Delivered, Marketing Email Open, Marketing Email Click, Marketing Email Click Through Ratio, Closed Deal Amount, Deal Closed won count in refreshable Data Studio dashboards so you can spot changes before they become reporting problems.

Customer testimonials

What our customers say about us.

85 %
Faster
Reporting time

After three years of use, Catchr has become essential for both our teams and our clients. So far, it has been our best solution for compiling and analyzing data from different advertising platforms. It’s easy to set up, and the customer service is responsive and excellent.

Valentin Keravel
CEO, Laio – Agency

With Catchr’s automated API, we can finally collect and centralize all advertising data, connect it with booking information, and calculate the real ROAS for our restaurant clients. It gives them full visibility, more autonomy, and the ability to optimize campaigns to maximize ROI.

Corentin Largeron
Freelance
30
hours saved

The solution is a real game changer, providing optimal time savings for our data reporting. The major strength of the solution is their highly responsive and professional support.

Corentin Largeron
CEO at The Browz – Agency

Hubspot to Data Studio (ex Looker Studio): FAQ

Answers to common questions about connecting data to spreadsheets, dashboards, AI assistants, and reporting tools with Catchr.

How do I connect HubSpot to Looker Studio?

Authorize your HubSpot account in Catchr and select it in the Catchr Looker Studio connector. Create a report and choose the CRM records that answer your question, such as deals for pipeline reporting or contacts for lead analysis. Check a few record IDs against HubSpot before relying on the dashboard totals.

Can I build a HubSpot sales pipeline dashboard?

Yes. Catchr exposes deal stage, pipeline, amount, owner and deal identifiers. Use a table or chart to show value and deal count by stage, with a pipeline filter when teams use different sales processes. Keep open pipeline separate from closed-won revenue so potential business is not presented as completed sales.

Should my deal report use create date or close date?

Use create date to measure when opportunities entered the CRM. Use close date for a view of deals expected to close or already closed, with the appropriate stage filter. These date fields describe different events. A monthly pipeline-creation report should not be compared directly with monthly closed-won sales.

Why is deal revenue duplicated after I blend HubSpot data?

A deal may be associated with multiple contacts or activities. A join can repeat the deal amount on each matching row and inflate a summed total. Keep one row per deal for revenue calculations, aggregate the other data before joining, and check distinct deal IDs alongside the total amount.

Can I compare performance by sales owner?

Yes. Catchr includes deal owner information. Group deal counts and values by owner, then apply consistent pipeline, stage and date filters. Distinguish current ownership from ownership at an earlier point in time; a current CRM record alone does not provide a historical snapshot of every reassignment.

What is the difference between pipeline amount and weighted amount?

Pipeline amount is the potential value of the selected deals. Weighted amount applies the relevant probability to that value. HubSpot exposes separate amount and weighted-amount properties, and Catchr's field catalog includes both. Label the chosen measure clearly: a probability-adjusted forecast is not booked revenue.

How should I handle deals in different currencies?

Do not add amounts in different deal currencies without conversion. Catchr includes the deal amount in company currency as well as the original amount. Use a consistent currency for combined reporting and verify that the field matches the one used in the HubSpot report you are reconciling.

Can I compare HubSpot pipeline with Google Ads spend?

Yes. Add Google Ads to compare acquisition spend with leads and pipeline outcomes. Use consistent campaign identifiers and a defined attribution method. Simply putting daily spend beside daily deal value shows a trend; it does not establish which ad generated each deal.

Still have a question?

Our team is always here to answer any questions you may have about our data connector.