Aerial view of a braided glacial river whose many pale blue channels flow together under a long bridge

Reporting

How do I get ChatGPT ads data into Looker Studio or my cross-channel ad report?

By The Tofu team ·

Use a third-party connector such as Windsor.ai, Supermetrics or Coupler.io, because Data Studio (Looker Studio's name since April 2026) has no Google-made ChatGPT Ads connector. Windsor.ai is the cheapest: its connector is on every plan, from a free one-account plan to $19 a month billed annually for three sources. Supermetrics' connector is still in early access, with plans from $44 a month billed annually. Each one reads your account with an Advertiser API key that an Admin creates in Ads Manager. Build your own pull from OpenAI's Insights API only if you run a data warehouse.

Ask Tofu next

Pick a question and Tofu Ads Agent answers it in chat.

As of November 2026.

OpenAI's own tools vs Windsor.ai vs Supermetrics vs Coupler.io

OpenAI's own (Ads Manager and Insights API)Windsor.aiSupermetricsCoupler.io
What you getEvery Insights metric, breakdown and attribution setting, through your own code15 metrics in its field reference, including conversions, CPA and ROAS (its setup guide names 6), plus country and device7 metrics (impressions, clicks, spend, CTR, CPC, CPM, conversions), with country, device and product fieldsAccount, campaign, ad group and ad reports, plus country and conversion reports
Data StudioNo connector. Load a file or a Google Sheet yourselfYesYesYes
Other destinationsWherever your code writesSheets, BigQuery, Power BI, Snowflake, Excel, ChatGPT, Claude and moreSheets, Excel, Power BI, BigQuery, AI chat tools and moreSheets, BigQuery, Power BI, Excel, Snowflake, AI tools and more
CostFreeFree (1 source, 1 account). Basic $23 a month, or $19 billed annually, for 3 sourcesStarter $55 a month, or $44 billed annually, for 3 sources and 1 destinationFree (1 account, manual refresh, 100 rows a run). Starter $32 a month, or $24 billed annually
SetupCreate an Advertiser API key in Ads Manager settings, then write and host the scriptPaste the API key, pick fields and a destinationPaste the API key in the Supermetrics Hub or your destinationPaste the API key, then build a data flow
Main limitNeeds a developer, and history stops at 365 days unless you store itOne key per ad account, so agencies add each client separatelyStill labeled Early AccessStarter refreshes daily, with 5,000 rows a run

Prices are from each vendor's pricing page in November 2026.

When OpenAI's own tools are the right pick

Use them for a one-off report, or when you already load ad data into a warehouse.

A one-off report. OpenAI's help article on measuring results says, in the version shown in search results, that you can download Ads Manager reporting as a CSV, including daily values. We couldn't open OpenAI's help center to confirm the menu. Data Studio has its own file upload and Google Sheets connectors, so you can chart a downloaded file. Someone has to repeat it each time.

Your own pipeline. OpenAI's Insights API returns account, campaign, ad group and ad performance by hour, day or month. For what the Advertiser API can automate beyond reporting, and its rate limits, see what you can automate with OpenAI's ChatGPT Ads API. For the list of metrics and breakdowns, see what ChatGPT ads reporting shows.

Store what you pull. OpenAI's daily data goes back only 365 days, so a dashboard that needs year-over-year comparisons has to keep its own copy, whichever route you choose.

When Windsor.ai is the right pick

Pick Windsor.ai when cost matters most. Its setup guide says the connector reads reporting data only and "does not create, edit, or pause campaigns." Its field reference lists 15 metrics, including conversions, CPA, attributed sales and ROAS, which is more than Supermetrics lists today. Its setup guide names only 6 (impressions, clicks, spend, CTR, CPC and CPM), so check that conversions come through during a trial.

For a cross-channel report, count your sources. Google Ads has a free Google-made Data Studio connector, so ChatGPT, LinkedIn and Meta fit Windsor's 3-source Basic plan. Basic refreshes daily. Hourly refresh starts on Standard ($118 a month, or $99 billed annually). For LinkedIn and Meta connector options, see cheaper alternatives to Supermetrics.

When Supermetrics is the right pick

Pick Supermetrics if it already feeds your other channels, so ChatGPT data lands in the same place with the same naming. Supermetrics said in June 2026 that the connector is "available for free in early access for all Supermetrics users," so you pay only for your Supermetrics plan. Its field list still says "Early Access," so fields may change. Starter's 3 sources and 1 destination fill up fast once ChatGPT joins LinkedIn and Meta. The next plan, Growth, costs $222 a month, or $177 billed annually.

When Coupler.io is the right pick

Pick Coupler.io if you want ready-made report types and flexible schedules. Its ChatGPT Ads source offers reports by ad account, campaign, ad group and ad, campaign performance by country, campaign conversions, and campaign performance by conversion event. Refresh can run monthly, weekly, daily, hourly or every 15 minutes, depending on your plan. The free plan's 100 rows a run and manual refresh suit a quick test, not a live dashboard.

Other options

  • Dataslayer has a ChatGPT Ads connector for Google Sheets, Data Studio, Power BI and BigQuery, with a 15-day free trial. Its pricing FAQ lists plans from 29€ a month billed annually, for 3 connectors.
  • Fivetran has an OpenAI Ads connector in Private Preview, for teams that load everything into a warehouse first.

What to check before you blend ChatGPT ads with other channels

  • Attribution windows. OpenAI's reporting defaults to a 30-day click and 1-day view window, counted on the date of the ad interaction, not the conversion. Ask your connector which windows it uses, and match them to your other channels where you can. How to track conversions from ChatGPT ads covers how to change them.
  • Late numbers. OpenAI says clicks can show within minutes, spend updates later, and you should "allow at least one day for conversion data to appear." Refresh the last few days on each run, not only yesterday.
  • Currency. Spend comes in the ad account's currency.
  • The key. The connector gets the same Advertiser API key that can change your campaigns through OpenAI's ChatGPT Ads API, not only read reports. Supermetrics and Windsor.ai say you need the Admin role in Ads Manager to create one, and Windsor.ai's guide says to "treat it like a password." Give it only to tools you trust, and replace it when you stop using one.
  • Your analytics side. Tag ChatGPT ad clicks with UTMs so GA4 and your CRM can see them next to other channels. What ChatGPT ads reporting shows covers OpenAI's tracking parameters.

Sources

Let an agent build your next campaign.

Tofu Ads Agent reads your CRM, plans the funnel, builds the audience and creative, and stages full campaigns across LinkedIn, Google and Meta for your approval.