Skip to main content

OpenAI Ads

Pull advertising data from the OpenAI Ads platform including campaigns, ad groups, ads, and performance insights.

Setup Guide

To configure OpenAI Ads as a source, you'll need the following:

  1. Ads API Key - In your OpenAI Ads Manager account, open the Settings tab and generate an API key.
note

Each API key is scoped to a single ad account. If you need to sync multiple ad accounts, create a separate source for each one, or contact OpenAI advertiser support for multi-account API access.

Connection Setup Guide

Once you have connected OpenAI Ads to a destination, you will also need to configure:

  • Connection Pull Schedule: Determines how frequently data is extracted from the source.
  • Backfill (Days): Specifies the duration for which historical data will be retrieved during each connection run.
  • Destination specific settings: Different settings such as "Dataset Name" or "Target Schema" (depending on your destination).
  • Schema Migration Policy: Controls how Extract will handle schema changes from the source.

Schema ERD

Explore the interactive entity relationship diagram for OpenAI Ads.

Open page

Data Streams

ad_account_insights

Loading ....

ad_account

Loading ....

ad_group_insights

Loading ....

ad_groups

Loading ....

ad_insights

Loading ....

ads

Loading ....

campaign_insights

Loading ....

campaigns

Loading ....

Metadata

ad_account

Loading ....

campaigns

Loading ....

ad_groups

Loading ....

ads

Loading ....

Insights (Reports)

ad_account_insights

Loading ....

campaign_insights

Loading ....

ad_group_insights

Loading ....

ad_insights

Loading ....