Skip to content
Knowledge Base

ChatGPT Ads Data Connector User Guide

Last updated

Note: ChatGPT Ads lets businesses advertise inside ChatGPT, with campaigns managed in OpenAI Ads Manager. With the Power My Analytics ChatGPT Ads connector, you can bring your ChatGPT Ads impressions, clicks, and spend into your reports. This guide covers what you need before you connect, how to add ChatGPT Ads as a data source, how to build your first report, and where to find the available fields.

Note: ChatGPT Ads is a Beta connector. It is available and supported now, and it appears in your Hub's source gallery with a BETA label. While it is in Beta, some fields and behavior may still change as we continue to improve it. We will expand this guide as the connector develops, and your feedback helps shape what comes next.

Note: ChatGPT Ads connector or PMA MCP Server? The ChatGPT Ads connector brings your advertising data from OpenAI Ads Manager (impressions, clicks, and spend for the ads you run in ChatGPT) into your Hub as a data source, while the Power My Analytics MCP Server works the other way around: it lets you ask ChatGPT questions about the data from all of your connected sources. To use ChatGPT with your PMA data, see Connect to the PMA MCP Server from ChatGPT.

Prerequisites

Before you begin, make sure you have:

  • Access to OpenAI Ads Manager for the ChatGPT Ads ad account you want to report on.
  • A ChatGPT Ads API key. You will create this in OpenAI Ads Manager under Settings and paste it into your Hub when you add the source. Each key covers one ad account, so you need a separate key for each ad account you want to connect.

Adding ChatGPT Ads as a Data Source

  1. In OpenAI Ads Manager, go to Settings, create an API key, and copy it.
  2. In your Power My Analytics Hub, select Sources from the menu.
  3. Click + Add new source and choose ChatGPT Ads from the gallery. You can type "ChatGPT" in the search box to find it quickly.
  4. Paste your key into API key. If you like, enter an Account name to help you tell this ad account apart from others (leave it blank to use the ad account's name from OpenAI Ads Manager), then click Connect.

Power My Analytics begins backfilling up to 365 days of your daily ChatGPT Ads history. To connect another ad account, repeat these steps with that ad account's API key.

Creating a Data Studio Report

  1. In your Hub, go to Reports > Data Studio and click the orange + Create report button.
  2. In the Templates window, select Single sources, find ChatGPT Ads, and click Open in Data Studio.
  3. In Data Studio, click Authorize if you are prompted, then select your Power My Analytics Hub and the ChatGPT Ads account you connected.
  4. Click Connect (top right), then click Create report.

Add ChatGPT Ads to an Existing Data Studio Report

To add ChatGPT Ads to a report you already use, such as a dashboard that combines several platforms, create the ChatGPT Ads data source first and then add it to the report:

  1. Follow steps 1 to 3 above, then click Connect (top right). Data Studio saves the ChatGPT Ads data source to your Data Studio account, so you do not need to click Create report.
  2. Open your existing report in Data Studio and click Edit.
  3. Click the Resource menu, select Manage added data sources, and click Add a data source.
  4. Select the My data sources tab, choose your ChatGPT Ads data source, and click Add. Click Add to report to confirm.

You can now add ChatGPT Ads charts to the report, including the spend and budget fields described in Key Reports and Fields. For more ways to adapt a report, see Can I Customize Data Studio Templates?.

Key Reports and Fields

The ChatGPT Ads connector provides four daily performance tables: Ad Performance, Country Breakdown, Device Breakdown, and Platform Breakdown. Along with impressions, clicks, and spend, they include Conversions and CPA (except Platform Breakdown) when you track conversions with OpenAI's pixel or Conversions API.

The connector also provides settings tables for Campaigns, Ad Groups, Ads, and Ad Account. They include fields such as Campaign Status, Campaign Start Date, Campaign End Date, Campaign Daily Budget, Campaign Lifetime Budget, Ad Account Daily Budget, and Ad Account Lifetime Budget, which you can use alongside your performance metrics (for example, to compare spend with budget).

For the complete list of available ChatGPT Ads fields, open the ChatGPT Ads Schema Explorer in your Hub.

Limitations and Important Considerations

  • Backfilling: Power My Analytics backfills up to 365 days of daily history when you first connect a ChatGPT Ads ad account. ChatGPT Ads does not provide daily data older than 365 days.
  • Beta connector: While ChatGPT Ads is in Beta, fields, configuration options, and behavior may change. If a field is renamed or removed, you may need to update the reports that use it.
  • One breakdown per table: Country Breakdown, Device Breakdown, and Platform Breakdown are separate tables, so you cannot combine country, device, and platform in one view (for example, clicks by country by device).
  • Today's data: All four performance tables (Ad Performance, Country Breakdown, Device Breakdown, and Platform Breakdown) include today's results so far. Today's numbers keep changing until the day ends and ChatGPT Ads finishes processing, so compare complete days when checking trends.
  • Conversions: Conversions and CPA appear only when conversions are tracked with OpenAI's pixel or Conversions API. Conversions can take a day or more to appear and keep updating for up to 30 days, so judge CPA on settled periods. The Platform Breakdown table does not include Conversions or CPA.
  • Currencies: Spend and cost metrics are reported in your ad account's currency. If your ad accounts use different currencies, report on them separately or convert the values before totaling spend.
  • API keys: If you revoke or rotate your API key in OpenAI Ads Manager, your data source stops syncing until you connect it again with a current key.
  • Who sees ChatGPT ads: OpenAI shows ads to adult users on the ChatGPT Free and Go plans, in select regions; Plus, Pro, Business, Enterprise, and Edu accounts do not see ads. Your reach and results reflect that audience.

Unavailable Data

The following ChatGPT Ads data is not currently available through the Power My Analytics ChatGPT Ads connector:

  • Conversions and CPA on the Platform Breakdown table
  • Separate click-through and view-through conversion counts, conversion value, and attributed sales
  • Product (shopping feed) breakdowns
  • Hourly data

If there is a ChatGPT Ads field or report you would like to see, please submit a ticket with a description or screenshot of what you need. Requests during Beta help us decide what to add next.

Troubleshooting

If your ChatGPT Ads data does not look the way you expect, start with Basic Troubleshooting. A few ChatGPT Ads patterns are worth checking first:

  • The connection fails when you click Connect: Check that your API key was copied in full with no extra spaces and that it has not been deleted in OpenAI Ads Manager. If in doubt, create a new key and connect with it.
  • Your data source stopped syncing: Your API key may have been revoked or rotated in OpenAI Ads Manager. Connect your ChatGPT Ads source again with a current key.
  • Only one ad account appears: Each API key covers one ad account. Add each additional ad account as its own source, using that ad account's key.
  • Today's totals look low or keep changing: This is expected. Today's results are partial until the day ends and ChatGPT Ads finishes processing, so compare complete days.
  • ChatGPT Ads does not appear when you add a source: Type "ChatGPT" in the gallery search box; ChatGPT Ads is listed with a BETA label. If it still does not appear, submit a ticket and we will help.

Still have questions? Submit a ticket and our support team will be glad to help. Please include the connector name and a short description of what you are seeing; screenshots are always helpful.

Related Articles