Data connector

Send ChatGPT Ads data to AI, reports, spreadsheets and ETL

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

ChatGPT Ads

Advertising and Media

ChatGPT Ads gives you granular visibility into campaign performance across OpenAI’s advertising platform. Through Kondado, you can access registries for campaigns, ad groups, individual ads, and custom audiences alongside hourly, daily, or monthly performance metrics. The data includes impressions, clicks, spend, CTR, CPC, conversions, CPA, and ROAS with breakdowns by product, country, device, and platform, plus ad previews, conversion event settings, and account metadata.

Connect ChatGPT Ads now →

Try out all the features for free for 14 days

Kondado provides 8 pipelines and 144 fields for ChatGPT Ads, covering ad registries, campaign settings, conversion event configurations, ad group targeting signals, performance analytics, renderable ad previews, custom audience lists, and full ad account details.

Marketing teams can monitor creative performance and budget pacing against daily or lifetime spend limits while checking which ads are actively serving. Data analysts build cross-channel reports comparing ChatGPT Ads CPA and ROAS against other paid media channels to optimize allocation. Operations teams track ad status, review outcomes, and audience match ranges to ensure campaigns stay compliant and reach the right users. Each role gets the exact granularity they need, from account-level summaries to individual ad copy, destination URLs, and tracking parameters.

The Kondado platform takes care of refreshing ChatGPT Ads data, allowing you to stop wasting time with manual work and complex workflows, and focus on analyzing ChatGPT Ads data with AI (Claude, ChatGPT and MCP) or in your report, spreadsheet, data warehouse, data lake, or database

Try out all the features for free for 14 days

Available ChatGPT Ads pipelines

Below you will find every pipeline available to replicate your ChatGPT Ads data into your preferred destination. The Ad performance pipeline delivers hourly, daily, or monthly metrics including impressions, clicks, spend, and ROAS broken down by product, country, device, or platform. Campaigns and Ad groups provide structural and targeting context, such as bidding strategies, billed events, spend limits, and context signals. The Ads pipeline captures creative details like headline, body, price, and destination URL with tracking parameters, while Custom audiences offers privacy-safe match ranges to evaluate list quality. Joining these datasets lets you correlate creative format with conversion rates, or map audience segments to campaign objectives and attributed sales. Because Kondado refreshes data on a configurable schedule ranging from every five minutes to daily, your KPIs stay current without manual exports.

Connector schema

Available ChatGPT Ads data

available pipelines

144

extractable fields

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.

See all available data → Use this connector in chat (AI + MCP) →

Try out all the features for free for 14 days

How to visualize ChatGPT Ads data in 3 steps

Connect ChatGPT Ads to AI (Claude/ChatGPT via MCP), dashboards, spreadsheets, or databases — no code required.

Add ChatGPT Ads API Key

Enter your ChatGPT Ads API Key in Kondado to authenticate your ad account and unlock the available pipelines.

Choose pipelines and destination

Select the ChatGPT Ads pipelines you want to replicate, such as Ad performance or Campaigns, and choose where to send them, for example BigQuery, PostgreSQL, or Google Sheets.

Analyze dashboards, spreadsheets, databases

Query your replicated data in Power BI or Looker Studio for dashboard visualization, explore it in Google Sheets or Excel for spreadsheet analysis, or run SQL directly on PostgreSQL, MySQL, Redshift, and SQL Server databases.

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

Wherever you need

With the same platform, you send data to AI (Claude/ChatGPT via MCP), reports, spreadsheets, databases, data warehouses, and data lakes. ETL and ELT

Learn More About Our Platform →

From wherever you need

Data from over 80 sources for Marketing, Ecommerce, ERPs, Customer Service, Finance, Databases, and much more

Learn More About Our Data Sources →

Predictable pricing

No surprise invoices, pick a plan and change it anytime

Check out our plans →

Pick an AI, Spreadsheet, Database, Data Warehouse or Data Lake to use ChatGPT Ads data

ChatGPT Ads > AI (Claude, ChatGPT, MCP)

ChatGPT Ads > Looker Studio (now Data Studio)

ChatGPT Ads > Power BI

Other visualizations

ChatGPT Ads > Amazon S3

ChatGPT Ads > BigQuery

ChatGPT Ads > Excel

ChatGPT Ads > Google Sheets

ChatGPT Ads > MySQL

ChatGPT Ads > PostgreSQL

ChatGPT Ads > Redshift

ChatGPT Ads > SQL Server

Choose a tool to visualize your ChatGPT Ads data

If the software you need is not listed, drop us a messagem. You can use almost every tool

ChatGPT Ads > Airtable

ChatGPT Ads > Alteryx

ChatGPT Ads > Amazon Quicksight

ChatGPT Ads > BIMachine

ChatGPT Ads > Cortex

ChatGPT Ads > Data Studio

ChatGPT Ads > Geckoboard

ChatGPT Ads > Grafana

ChatGPT Ads > IBM Cognos Analytics

ChatGPT Ads > Klipfolio

ChatGPT Ads > Looker

ChatGPT Ads > Looqbox

ChatGPT Ads > Metabase

ChatGPT Ads > Microstrategy

ChatGPT Ads > Pentaho

ChatGPT Ads > Power BI

ChatGPT Ads > Qlik Cloud Analytics

ChatGPT Ads > Qlik Sense

ChatGPT Ads > Qlik

ChatGPT Ads > QlikView

ChatGPT Ads > Redash

ChatGPT Ads > Superset

ChatGPT Ads > Tableau

ChatGPT Ads > BI TOTVS

ChatGPT Ads > Zoho Analytics

Frequently Asked Questions (FAQ)

Find answers to common questions about connecting ChatGPT Ads to AI (Claude/ChatGPT via MCP), dashboards, spreadsheets, and databases

What ChatGPT Ads metrics are available at the campaign and ad level? ▼

The Ad performance pipeline includes impressions, clicks, spend, CTR, CPC, CPM, conversions, CPA, ROAS, and attributed sales. You can group this data by hour, day, or month and break it down by product, country, device, or platform for precise attribution.

How do I connect my ChatGPT Ads account to Kondado? ▼

Authentication requires your ChatGPT Ads API Key. After entering it in Kondado, the platform retrieves the available pipelines from your ad account, including campaign registries and performance datasets.

How frequently does Kondado refresh ChatGPT Ads data? ▼

Updates run on a configurable schedule that you control, ranging from every five minutes to daily. This keeps your spreadsheets, databases, and dashboards aligned with current campaign activity.

Can I replicate ChatGPT Ads data into a data warehouse or BI tool? ▼

Yes, you can send data to BigQuery, PostgreSQL, Google Sheets, and other destinations, then visualize it in Power BI or Looker Studio.

What kind of cross-analysis can I run with ChatGPT Ads pipelines? ▼

You can join the Ads pipeline, which stores creative copy and destination URLs, with the Ad performance pipeline to see which headlines or formats drive the highest ROAS. Combining Custom audiences with Campaigns also reveals how audience match ranges affect conversion rates.

Is it possible to monitor custom audience upload quality? ▼

Yes, the Custom audiences pipeline returns status, hash specification version, and text ranges for uploaded, matched, and invalid identifiers, giving you a privacy-safe way to evaluate list health without seeing exact counts.

What destination options do I have for ChatGPT Ads data? ▼

Beyond BigQuery and PostgreSQL, you can also choose MySQL, Excel, Redshift, SQL Server, and Amazon S3 as destinations for your replicated data.

Can I track billing and budget settings from ChatGPT Ads? ▼

The Campaigns and Ad groups pipelines capture bidding strategies, billed events, daily spend limits, lifetime budgets, and maximum bids in your account currency, making it easy to monitor pacing and financial controls.

Related on Kondado

Try out all the features for free for 14 days