From ChatGPT Ads to BigQuery: managed, scheduled, no code.
Creating a pipeline that sends data from ChatGPT Ads to BigQuery data warehouses takes only a few minutes with Kondado. And the whole integration from ChatGPT Ads to BigQuery is managed and executed by our platform. With Kondado, you can focus on extracting value from ChatGPT Ads data and combining it with other data in your BigQuery data warehouse
You can send ChatGPT Ads data to BigQuery by using Kondado to set up a direct pipeline between your OpenAI Ads account and your Google data warehouse. After authenticating your ad account, you choose which pipelines to activate and define an update schedule that fits your reporting needs. Kondado manages replication automatically, delivering structured advertising data into BigQuery so your team can analyze performance.
Once your data lands in BigQuery, you can blend ChatGPT Ads performance with other marketing sources and build custom dashboards that track spend, conversions, and ROAS across campaigns. Analysts can query impressions, clicks, and attributed sales alongside CRM or web analytics data to understand how ChatGPT placements contribute to the full customer journey.
Kondado replicates ChatGPT Ads data to BigQuery on a configurable schedule, offering eight pipelines that cover ad registries, campaign settings, ad group details, hourly or daily performance metrics, custom audiences, conversion events, ad previews, and account metadata across 144 fields.
The Ad performance pipeline delivers hourly or daily metrics broken down by campaign, ad group, and individual ad, including impressions, clicks, spend, CTR, CPC, conversions, and ROAS. With this data in BigQuery, analysts can build custom dashboards that identify top-performing creatives and reallocate budget toward the highest-yielding ChatGPT placements.
You can also replicate the Campaigns and Custom audiences pipelines to bring targeting settings, budget limits, and audience match ranges into the same BigQuery warehouse. Combining these registries with performance metrics lets technical teams calculate segment efficiency, monitor pacing against lifetime spend caps, and model lookalike strategies using SQL.
Try out all the features for free for 14 days
Replicated to BigQuery
ChatGPT Ads data available for BigQuery
Tables Kondado writes into your BigQuery, on a schedule you control.
8
available pipelines
144
extractable fields
BigQuery
Destination
Available integrations
Ads
Registry of the account's ads, with the parent ad group and campaign, status and review outcome, creative format and copy (headline, body, price and destination URL with tracking parameters), and the reasons an ad is not serving.
Campaigns
Registry of campaigns, with objective, bidding strategy, billed event, start and end windows, daily and lifetime spend limits in the account currency, product catalog, and countries included in targeting.
Conversion event settings
Conversion events configured on the account, with type, the sources that feed them (pixels or integrations), associated campaigns, and the click-through and view-through attribution windows.
Ad account
Details of the connected ad account: name, main website, status and review, the time zone that defines how report days are cut, and the currency every monetary value in this connector is expressed in.
Ad groups
Registry of ad groups, with the parent campaign, status, context signals used for targeting, associated product feed, bidding strategy, billed event, and maximum bid in the account currency.
Ad performance
Performance report grouped by hour, day or month at account, campaign, ad group or ad level, with impressions, clicks, spend, CTR, CPC, CPM, conversions, CPA, ROAS and attributed sales, plus breakdowns by product, country, device or platform.
Ad preview
Renderable preview of each ad: an HTML snippet with the creative's iframe and the moment the preview was generated — the address inside the iframe expires 24 hours later.
Custom audiences
Registry of custom audiences, with status, hash specification version, and the ranges of uploaded, matched and invalid identifiers — for privacy the API returns text ranges, never the exact count.
Sync data automatically — no code, no manual exports.
1
Connect ChatGPT Ads
Log in to Kondado, add ChatGPT Ads as a new data source, and authenticate your OpenAI Ads account to grant pipeline access.
2
Configure BigQuery
Select BigQuery as your destination and provide the target dataset details where your advertising data will be stored.
3
Select Pipelines and Schedule
Choose the ChatGPT Ads pipelines you want to replicate, such as Ad performance or Campaigns, and define an update schedule that keeps your BigQuery data fresh.
Try out all the features for free for 14 days
Hundreds of data-driven companies trust Kondado
Why Kondado?
Focus on extracting value from your data and leave the rest to us
Start by adding ChatGPT Ads as a data source in Kondado and authenticating your OpenAI Ads account. Then select BigQuery as the destination, choose the pipelines you need, and set your preferred update interval.
You can analyze impressions, clicks, spend, CTR, CPC, CPM, conversions, CPA, ROAS, and attributed sales from the Ad performance pipeline. Breakdowns by product, country, device, and platform let you slice performance across multiple dimensions using SQL.
Kondado replicates data on a configurable schedule, with options ranging from every five minutes to daily or longer intervals. You select the frequency when setting up the pipeline, and updates continue on schedule.
Each pipeline writes to its own structured dataset in BigQuery, preserving fields such as campaign objectives, bid strategies, creative copy, and audience match ranges. This schema-ready format lets you join advertising data with other business datasets immediately.
Yes, you can replicate data from additional sources into the same BigQuery project and join it with ChatGPT Ads records. Many teams blend these metrics with web analytics or CRM data to build unified attribution models in Looker Studio or Power BI.
What is included in the ChatGPT Ads Ad preview pipeline?▼
The Ad preview pipeline stores a renderable HTML snippet containing the creative's iframe and the generation timestamp for each ad. Note that the iframe address expires after 24 hours, so the preview serves as a historical reference of what creative was live at a given moment.
The Conversion event settings pipeline replicates each configured event, its type, feeding sources, associated campaigns, and both click-through and view-through attribution windows. Having this metadata in BigQuery helps you validate why certain conversions are credited and align reporting logic across channels.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
