BigQuery Connector

Sync Google Ads Data to BigQuery

Detrics loads Google Ads 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
  campaign_name,
  SUM(impressions) AS impressions,
  SUM(clicks) AS clicks,
  SUM(conversions) AS conversions
FROM `your_project.marketing_data.google_ads_performance_max_asset_group_analysis_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY campaign_name
ORDER BY impressions DESC
LIMIT 10

Why send Google Ads data to BigQuery?

Ad creatives that never expire

Creative URLs expire. Detrics archives your campaign images and videos permanently.

History without limits

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

One warehouse for everything

Join Google Ads 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 Google Ads in plain language.

Google Ads tables in BigQuery

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

Ad & Keyword Performance

performance_max_asset_group_analysis_daily

Monthly main PPC metrics in the last 12 months

customer descriptive namecampaign nameasset group namecost microsimpressionsclicks+4

standard_ad_groups_performance_daily

Ad group performance across campaign types

customer descriptive namecampaign namecampaign advertising channel typecost microsimpressionsclicks+5

keyword_performance_daily

Search keyword performance and match types

campaign namekeyword textkeyword match typecost microsimpressionsclicks+5

+2 more tables in this group

Audience & Reach

unique_users_and_frequency_daily

Reach and frequency metrics by campaign

customer descriptive namecampaign namecampaign advertising channel typecost microsimpressionsclicks+2

gender_analysis_daily

Performance breakdown by gender demographics

customer IDcustomer descriptive namecampaign IDcost microsimpressionsclicks+4

Campaign & Budget

account_overview_daily

High-level performance metrics across all accounts

customer descriptive namecost microsimpressionsclicksconversionsconversions value+2

campaign_performance_daily

Detailed campaign-level metrics and insights

customer descriptive namecampaign namecampaign advertising channel typecost microsimpressionsclicks+4

campaign_conversions_daily

Monthly conversion metrics by campaign and action

campaign namesegments conversion action nameconversionsconversions value

+2 more tables in this group

HOW IT WORKS

From Google Ads 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 Google Ads in BigQuery, the Detrics MCP server lets you run queries in plain language. MCP access is included with every BigQuery plan.

Build a weekly Google Ads report for my client meeting

Detect anomalies in my Google Ads spend over the past 14 days

Which Google Ads campaigns should I pause this quarter?

Explore the Google Ads MCP server

Every Google Ads 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

92 metrics

173 dimensions

View Google Ads Fields

Get Google Ads into your warehouse this week