From ChatGPT Ads to Redshift: managed, scheduled, no code.
Kondado provides a direct integration between ChatGPT Ads and Redshift, replicating 8 pipelines and 144 fields on a configurable schedule ranging from every 5 minutes to daily.
To send ChatGPT Ads data to Redshift, start by connecting your ChatGPT Ads account as a data source inside Kondado. Then select the pipelines you want and point them to your Redshift cluster as the destination. Kondado replicates your advertising metrics on a configurable schedule, eliminating manual CSV exports and keeping your AWS data warehouse current with hourly, daily, or monthly performance data. Once the data is available, your analysts can query structured advertising datasets directly alongside existing business datasets in Redshift to uncover insights quickly.
The automated replication covers ad registries, campaign configurations, ad group settings, performance metrics, custom audiences, conversion events, ad previews, and account details, all normalized and loaded into Redshift. You can analyze ChatGPT advertising performance alongside other business data and visualize results in Power BI or Looker Studio for fully custom reporting.
Once your ChatGPT Ads data lands in Redshift, the Ad performance pipeline lets you build custom efficiency dashboards tracking impressions, CTR, CPC, conversions, and ROAS across hours, days, or months. You can slice results by product, country, device, or platform to identify exactly which segments drive the best returns. Meanwhile, the Campaigns and Ad groups pipelines deliver complete registry data with budgets, bidding strategies, and targeting parameters, making it easy to audit spend pacing, correlate creative settings with outcomes, and optimize live campaigns directly from SQL queries in your warehouse.
Try out all the features for free for 14 days
Replicated to Redshift
ChatGPT Ads data available for Redshift
Tables Kondado writes into your Redshift, on a schedule you control.
8
available pipelines
144
extractable fields
Redshift
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 and add ChatGPT Ads as a new data source by authenticating your OpenAI ad account. Once connected, Kondado will display the available pipelines for replication.
2
Configure Redshift Destination
Enter your Redshift cluster credentials and schema details so Kondado knows where to load the replicated data. You can use an existing schema or create a dedicated one for your advertising datasets.
3
Select Pipelines and Schedule
Choose the pipelines you want such as Ad performance, Campaigns, or Custom audiences, then set your update frequency from every 5 minutes to daily. Kondado will begin replicating data to Redshift automatically according to your chosen schedule.
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
Answers about sending ChatGPT Ads data to Redshift automatically
How can I join ChatGPT Ads performance data with my CRM in Redshift?▼
Because Kondado loads normalized schemas into Redshift, you can write SQL to join the Ad performance pipeline with sales datasets already in your warehouse. This lets you calculate true cost per acquisition and return on ad spend using internal conversion events rather than platform-reported numbers.
What schema structure does Kondado use for ChatGPT Ads in Redshift?▼
Each pipeline becomes its own dataset within the schema you designate, using clear column names and appropriate data types for immediate SQL analysis. Monetary values use the account currency, while time-based columns follow the ad account time zone, so your Redshift queries return consistent results.
Can I build custom dashboards from ChatGPT Ads data stored in Redshift?▼
Yes, because the data resides in your own Redshift warehouse, you can connect Power BI or Looker Studio to build fully custom dashboards. Many users blend ChatGPT Ads metrics with internal sales data to create cross-channel reports that update automatically as Kondado refreshes the underlying pipelines.
What is the difference between the Ad performance and Ads pipelines in Redshift?▼
The Ads pipeline stores creative registry information such as headline, body text, price, destination URL, and review status, while the Ad performance pipeline contains time-series metrics like impressions, clicks, spend, and ROAS. In Redshift, you can join these two pipelines on ad ID to correlate creative attributes with actual performance outcomes.
Does Kondado load ad preview HTML from ChatGPT Ads into Redshift?▼
Yes, the Ad preview pipeline replicates a renderable HTML snippet containing the creative iframe for each ad, along with the generation timestamp. Note that the iframe address expires after 24 hours, so the preview pipeline serves archival and audit purposes rather than live rendering inside your dashboards.
How do custom audiences from ChatGPT Ads appear in Redshift?▼
The Custom audiences pipeline creates a registry row for each audience with its status, hash version, and text ranges for uploaded, matched, and invalid identifiers. Since the API returns ranges rather than exact counts for privacy, your Redshift queries can segment campaigns by audience health without accessing personal data.
How often can I update ChatGPT Ads data in my Redshift warehouse?▼
Kondado lets you set a configurable schedule ranging from every 5 minutes to daily, depending on how fresh your dashboards need to be. Shorter intervals keep your Redshift datasets close to current, while longer intervals reduce API load and warehouse compute for slower-moving reporting needs.
'%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)
