BigQuery Connector

Sync ChatGPT Ads Data to BigQuery

Detrics loads ChatGPT 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.

Get Started Free

*No credit card required

SELECT
  campaign_name,
  SUM(impressions) AS impressions,
  SUM(clicks) AS clicks,
  SUM(spend) AS spend
FROM `your_project.marketing_data.openai_ads_campaign_performance_daily`
WHERE date >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY campaign_name
ORDER BY impressions DESC
LIMIT 10

Why send ChatGPT 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 ChatGPT Ads sync is stored across its 7 tables, so you accumulate years of your own history.

One warehouse for everything

Join ChatGPT Ads with the rest of your platforms in one place, without copy-pasting between sheets.

Ask Claude about it

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

ChatGPT Ads tables in BigQuery

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

Account

daily_spend_and_results_daily

Daily trend of impressions, clicks, spend, CTR, conversions and ROAS for the whole account

account nameaccount IDimpressionsclicksspendCTR+4

ad_performance_daily

Delivery and cost metrics for every ad, with its ad group and campaign

campaign namead group namead nameimpressionsclicksspend+8

Breakdowns

performance_by_country_daily

Impressions, clicks, spend, CTR and conversions per campaign and country

campaign namecountry namecampaign IDimpressionsclicksspend+3

performance_by_device_daily

Impressions, clicks, spend, CTR and conversions per campaign and device

campaign namedevice typecampaign IDimpressionsclicksspend+3

performance_by_platform_daily

Delivery and cost split by ChatGPT surface (iOS app, Android app, desktop web, …)

campaign nameplatformcampaign IDimpressionsclicksspend+3

Campaigns

campaign_performance_daily

Impressions, clicks, spend, CTR, CPC, conversions, CPA and ROAS per campaign

campaign namecampaign statuscampaign IDimpressionsclicksspend+7

weekly_campaign_trend_daily

Week-over-week impressions, clicks, spend, conversions and ROAS per campaign

campaign namecampaign IDimpressionsclicksspendCTR+3

HOW IT WORKS

From ChatGPT Ads to your warehouse

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

First step

Connect your first datasource

Link any of 39+ 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.

Get started free

No credit card required.

Then ask Claude about it

With ChatGPT Ads in BigQuery, the Detrics MCP server lets you manage your warehouse and run queries in plain language. MCP access is included with every BigQuery plan.

Build a weekly ChatGPT Ads report for my client meeting

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

Which ChatGPT Ads campaigns should I pause this quarter?

Explore the ChatGPT Ads MCP server

Every ChatGPT 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

10 metrics

14 dimensions

View ChatGPT Ads Fields

Get ChatGPT Ads into your warehouse this week