Integration of ChatGPT Ads with BigQuery

📢 Introduction

This module integrates with the ChatGPT Ads API (OpenAI Advertiser API), enabling you to collect campaign performance and cost data and store it in Google Cloud BigQuery. Gain deeper insights into your data and optimize the performance of your ad campaigns with real-time data collection.

📝 Configuration Guide

Follow the steps below to connect ChatGPT Ads with BigQuery. Once the setup is complete, your ad data will be automatically transferred to your BigQuery project.

💡 Tip: Make sure you have access to ChatGPT Ads Manager. You need to create an API key before starting the configuration — each key grants access to a single ad account.

🔧 Module Setup

Go to the Integrations section in the menu > Click Add integration.

Select ChatGPT Ads from the list of available integrations.

Enter the Collect Name, e.g., "ChatGPT Ads Collect".

🔑 Authorization

💡 Tip: If you have already created a ChatGPT Ads authorization, simply pick it from the drop‑down and skip ahead to selecting the account.

ChatGPT Ads does not use a Google consent window — you authorize it with an API key generated in ChatGPT Ads Manager.

Click Authorize.

In the authorization window, paste the API Key copied from ChatGPT Ads Manager → Settings.

Click Create to save the authorization.

The saved authorization now appears in the Select ChatGPT Ads authorization drop‑down. Pick the one you want to use — it is labelled with the ad account name and a masked fragment of the key, so several keys stay easy to tell apart.

Back in WitCloud, choose the ChatGPT Ads account you wish to export.

💡 Tip: An API key is issued per ad account, so exactly one account is available for each authorization. To collect several accounts, add a separate authorization and a separate collect for each key.

Optionally, expand Advanced settings to narrow down the Tables to collect if you don't need every table. By default all of them are collected.

Click Next to move on to the data collection settings.

⏳ Historical Data and Scheduling

Enter the number of days of historical data you want to fetch.

During the initial setup, you can retrieve data going back up to 365 days, with the possibility of importing older data.

A data synchronization schedule will be created automatically and runs once per day — each run rewrites that day's partition with the data reported for it. More information on this topic can be found here.

Click Create to complete the configuration.

✅ Done! Your ChatGPT Ads data will now be synchronized with BigQuery, providing you with detailed insights into the performance of your ad campaigns.

📊 Data Schema

Expand the tables below to view the full data schema collected from ChatGPT Ads.