Insights at four levels
Daily performance by account, campaign, ad group, and ad.
OpenAI Ads
Polytomic connects OpenAI Ads to your data warehouse, databases, and SaaS tools for advertising ETL. Replicate campaigns, ad groups, ads, and daily performance insights into your data warehouse and other systems so spend on a new channel can be measured against pipeline and revenue from day one, without writing code.
Incremental with a rewind
Insights resume by date window and re-read recent days for restatements.
Deep backfill
Roughly three years of insight history available on the first load.
Example workflows
Replicate OpenAI Ads performance into your data warehouse
What you can sync
OpenAI Ads is supported as a source. Read campaign structure and daily performance, then land it in your data warehouse, databases, or SaaS tools.
From OpenAI Ads
Ad account
Campaigns, ad groups, and ads
Daily insights at account, campaign, ad group, and ad grain
Impressions, clicks, spend, CTR, CPC, and CPM
To your destinations
Data warehouses including Snowflake, BigQuery, and Databricks
Databases including PostgreSQL and MySQL
Cloud storage including Amazon S3 and Google Cloud Storage
SaaS tools including Salesforce, HubSpot, and spreadsheets
How it works
Connect OpenAI Ads with an API key and Polytomic reads your account, campaigns, ad groups, and ads into your data warehouse, alongside daily performance insights at each level of that hierarchy.
Having insights at all four grains matters more on a new channel than an established one. Account level tells you whether the channel is working at all, while ad level tells you which creative is carrying it, and early on you need both answers quickly.
- Connect OpenAI Ads with a bearer API key
- Read the ad account, campaigns, ad groups, and ads
- Read daily insights at account, campaign, ad group, and ad grain
- Get impressions, clicks, spend, CTR, CPC, and CPM
- Insights resume by date window with a short rewind for restatements
- Monitor sync health, record volume, and failures from one interface
How to set up
Authentication is a bearer API key rather than OAuth, so setup is a single credential and a connection test. Once connected, the account, campaign, ad group, ad, and insight objects appear for selection.
How to get connected
- 1In OpenAI Ads, generate an API key for your account
- 2In Polytomic, navigate to Connections, then Add Connection, then OpenAI Ads
- 3Paste the key
- 4Test the connection
- 5Select the entity objects and the insight grains you want
- 6Choose a destination, set a schedule, and click Save
See the documentation for full setup details.
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with OpenAI Ads in minutes
No credit card required. Free trial available.