BigQuery Connector

Sync HubSpot Data to BigQuery

Detrics loads HubSpot into Google BigQuery on the schedule you set. The tables arrive clean, the history keeps growing, and you can query everything from SQL, Looker Studio, or Claude. We run the pipeline so you don't have to.

Book a Demo

*Free 30-minute consultation

SELECT
  company_country,
  SUM(company_count) AS company_count,
  SUM(company_annual_revenue) AS company_annual_revenue,
  SUM(company_total_deal_value) AS company_total_deal_value
FROM `your_project.marketing_data.hubspot_company_overview`
GROUP BY company_country
ORDER BY company_count DESC
LIMIT 10

Why send HubSpot data to BigQuery?

Historical pipeline

Snapshots of every pipeline stage to analyze close velocity and real stage-to-stage conversion.

History without limits

Platform APIs cap how far back you can query. In BigQuery every HubSpot sync is stored across its 12 tables, so you accumulate years of your own history.

One warehouse for everything

Join HubSpot with the rest of your platforms in one place, no copy-pasting between sheets.

Ask Claude about it

With your data in BigQuery, Claude can answer business questions about HubSpot in plain language.

HubSpot tables in BigQuery

This is what Detrics creates for HubSpot: 12 preset tables with scheduled syncs, plus any custom one you define.

Contacts & Support

contact_list_by_lifecycle_stage

Contacts with lifecycle stage, source, and engagement

contact lifecycle stagecontact sourcecontact owner namecontact countcontact total revenuecontact num associated deals

ticket_volume_by_priority

Ticket counts and response times by priority

ticket priorityticket statusticket pipeline nameticket countticket time to closeticket time to first response

contact_acquisition_report

Contact counts and engagement by source

contact sourcecontact lifecycle stagecontact countcontact num page viewscontact num visitscontact num associated deals

+3 more tables in this group

Sales & Deals

deal_pipeline_overview

Deals by pipeline and stage with amounts

deal pipeline namedeal stage namedeal owner namedeal countdeal amountdeal forecast amount+1

company_revenue_report

Companies with deal value and annual revenue

company namecompany industrycompany lifecycle stagecompany countcompany total deal valuecompany annual revenue+2

sales_rep_performance

Deal count, revenue, and close time per sales rep

deal owner namedeal pipeline namedeal countdeal amountdeal closed won countdeal forecast amount+1

+3 more tables in this group

HOW IT WORKS

From HubSpot to your warehouse

Connect your account once. Detrics handles schemas, syncs, and backfills.

First step

Connect your first datasource

Link any of 32+ marketing and ecommerce platforms in a couple of clicks.

Connect a source

Second step

Set up your destination

Point Detrics at your BigQuery project and dataset. We write the SQL and handle the setup for you.

Set up destination

Third step

Create your transfer

Choose what to sync and how often. Detrics builds and runs the pipeline for you.

Create a transfer

And that's it

Real-time data, forever

Your data lands in the warehouse and stays fresh automatically. We handle the syncing, the maintenance, and every API update for you.

Book a demo

In the demo we set everything up for you and save you hours.

Then ask Claude about it

With HubSpot in BigQuery, the Detrics MCP server lets you run queries in plain language. MCP access is included with every BigQuery plan.

Build a HubSpot sales summary for Monday's meeting

How long does a deal take to close on average in HubSpot?

Which rep closed the most revenue in HubSpot this quarter?

Explore the HubSpot MCP server

Every HubSpot field, on demand

Preset tables curated by our team
Custom tables with any field combination
Incremental syncs that only load new data
Automatic backfill of up to 12 months of history

105 metrics

189 dimensions

View HubSpot Fields

Get HubSpot into your warehouse this week