From ChatGPT Ads to SQL Server: managed, scheduled, no code.
Kondado is a platform that replicates ChatGPT Ads data to SQL Server on a configurable schedule, offering eight pipelines and 144 fields covering ad registries, campaign details, ad group configurations, conversion event settings, performance metrics, and custom audiences.
With Kondado, you can replicate ChatGPT Ads data to SQL Server on a configurable schedule without writing any code. Simply connect your ChatGPT Ads data source, choose SQL Server as your destination, and select the exact pipelines you need from the available options. Kondado handles the replication automatically, keeping your database updated with fresh campaign metrics so your team can analyze performance directly in SQL Server.
Once your ChatGPT Ads data lands in SQL Server, you can build custom reports, join it with CRM or finance data, and power dashboards in Power BI or Looker Studio. Analysts and engineers gain a centralized environment to track advertising spend, measure ROAS, and optimize campaign performance using standard SQL queries against fresh, structured data.
The Ad performance pipeline delivers hourly, daily, or monthly metrics at account, campaign, ad group, or ad level, complete with impressions, clicks, spend, CTR, CPC, conversions, and ROAS. In SQL Server, you can trend this data over time, calculate custom efficiency metrics, and slice results by product, country, device, or platform to identify your highest-performing segments. The Campaigns pipeline brings in objectives, bidding strategies, spend limits, and targeting countries, while the Custom audiences pipeline supplies audience status and match ranges. Together, these datasets enable you to correlate targeting decisions with actual outcomes, build granular cost-analysis models, and feed consolidated marketing data warehouses that support reporting tools like Power BI.
Try out all the features for free for 14 days
Replicated to SQL Server
ChatGPT Ads data available for SQL Server
Tables Kondado writes into your SQL Server, on a schedule you control.
8
available pipelines
144
extractable fields
SQL Server
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 ad account. Once connected, Kondado will display the available pipelines for you to browse before replicating.
2
Configure SQL Server
Add SQL Server as your destination by entering your database connection details and specifying the target schema. Kondado validates the connection to ensure your ChatGPT Ads data lands in the correct environment.
3
Select pipelines and schedule
Choose the ChatGPT Ads pipelines you want, such as Ad performance or Campaigns, and set your update frequency to run every five minutes, hourly, or daily. Kondado will begin replicating the selected data to SQL Server on that schedule automatically.
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 SQL Server automatically
What ChatGPT Ads data is available in the Ad account pipeline?▼
The Ad account pipeline replicates essential account metadata including the account name, main website, status, review state, time zone, and currency. This ensures every monetary value and date in your SQL Server queries aligns with the same settings used inside the ChatGPT Ads platform. It serves as the reference layer for joining and validating all other pipeline data.
How often can I update ChatGPT Ads data in SQL Server?▼
Kondado replicates data on a configurable schedule, with options ranging from every five minutes to daily intervals. You choose the frequency that matches your reporting needs, ensuring your SQL Server database reflects the latest campaign activity without manual exports. This keeps your dashboards and analyses current throughout the day.
Can I merge ChatGPT Ads data with other sources inside SQL Server?▼
Yes, Kondado can replicate additional data sources into the same SQL Server database, allowing you to join ChatGPT Ads metrics with ecommerce, analytics, or other advertising data. This unified approach lets you write SQL queries that correlate ChatGPT spend against broader business metrics or attribute revenue to specific campaigns. You can then connect SQL Server to Power BI or Looker Studio to visualize consolidated results.
Can I use SQL Server to track ChatGPT Ads creative compliance?▼
Yes, the Ad preview pipeline stores an HTML snippet with the creative's iframe and generation timestamp, allowing you to maintain a historical record of every ad rendered in your account. Because the preview URL expires after 24 hours, SQL Server becomes your long-term archive for auditing creative versions against approval status. You can join these previews with the Ads pipeline to see exactly which copy and formats were under review at any point.
How can I analyze ChatGPT Ads conversion attribution in SQL Server?▼
The Conversion event settings pipeline replicates each event's type, attribution windows, and the campaigns associated with it. In SQL Server, you can compare these click-through and view-through windows against actual conversion timestamps to validate your attribution model. This helps you understand whether your internal reporting matches the logic configured inside your ChatGPT Ads account.
What format does ChatGPT Ads data take once it lands in SQL Server?▼
Each pipeline arrives as structured data with typed fields that map directly to the available attributes, ready for immediate SQL querying. Monetary values use the account currency, dates respect the ad account's time zone, and performance metrics are stored as numeric values. This structure lets you build custom reports, create views for stakeholder dashboards, and feed downstream tools without additional transformation.
Does ChatGPT Ads data in SQL Server include audience match counts?▼
The Custom audiences pipeline provides text ranges for uploaded, matched, and invalid identifiers rather than exact counts, following the API's privacy guidelines. In SQL Server, you can track these ranges over time to monitor audience health and match quality trends. Joining this data with campaign performance lets you see which custom audiences are growing or degrading without exposing sensitive identifier counts.
'%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)
