Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your OpenAI Ads / ChatGPT Ads data to
OpenAI Ads / ChatGPT Ads Connector Reference
15 metrics45 dimensions
The OpenAI Ads / ChatGPT Ads connector exposes 60 fields (15 metrics, 45 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Available actions
Enable Campaign Activate a paused OpenAI Ads campaign so it can deliver again. Reversible via pause_campaign.
Activate a paused OpenAI Ads campaign so it can deliver again. Reversible via pause_campaign.
Parameters
campaign_idstringRequired
Pause Campaign Pause an active OpenAI Ads campaign so it stops delivering. Reversible via enable_campaign.
Pause an active OpenAI Ads campaign so it stops delivering. Reversible via enable_campaign.
Parameters
campaign_idstringRequired
Set Campaign Budget Set the spend limit of an OpenAI Ads campaign. The amount is in the account currency major unit (e.g. 50 means 50.00, not micros) and must be at least 1.00. The campaign's existing budget type is preserved: a daily spend limit stays daily and a lifetime spend limit stays lifetime.
Set the spend limit of an OpenAI Ads campaign. The amount is in the account currency major unit (e.g. 50 means 50.00, not micros) and must be at least 1.00. The campaign's existing budget type is preserved: a daily spend limit stays daily and a lifetime spend limit stays lifetime.
Parameters
campaign_idstringRequiredamountnumberRequired
Enable Ad Group Activate a paused OpenAI Ads ad group so it can deliver again. Reversible via pause_ad_group.
Activate a paused OpenAI Ads ad group so it can deliver again. Reversible via pause_ad_group.
Parameters
ad_group_idstringRequired
Pause Ad Group Pause an active OpenAI Ads ad group so it stops delivering. Reversible via enable_ad_group.
Pause an active OpenAI Ads ad group so it stops delivering. Reversible via enable_ad_group.
Parameters
ad_group_idstringRequired
OpenAI Ads / ChatGPT Ads Fields
OpenAI Ads / ChatGPT Ads Insights fields
The Insights report of the OpenAI Ads / ChatGPT Ads connector includes 40 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| ad | TEXT | Ad | The name of the ad. |
| ad_account_budget_daily | NUMERIC | Ad Account Daily Spend Limit | The daily spend limit set on the ad account. |
| ad_account_budget_lifetime | NUMERIC | Ad Account Lifetime Spend Limit | The lifetime spend limit set on the ad account. |
| ad_account_id | TEXT | Ad Account ID | The OpenAI ad account identifier. |
| ad_account_name | TEXT | Ad Account Name | The name of the OpenAI ad account. |
| ad_account_url | TEXT | Ad Account URL | The website URL of the OpenAI ad account. |
| ad_copy | TEXT | Ad Copy | The body copy of the ad. |
| ad_group | TEXT | Ad Group | The name of the ad group. |
| ad_group_description | TEXT | Ad Group Description | The description of the ad group. |
| ad_group_id | TEXT | Ad Group ID | The unique identifier of the ad group. |
| ad_group_status | TEXT | Ad Group Status | The delivery status of the ad group. |
| ad_id | TEXT | Ad ID | The unique identifier of the ad. |
| ad_link | TEXT | Ad Link | The landing page URL of the ad. |
| ad_review_status | TEXT | Ad Review Status | The review status of the ad. |
| ad_status | TEXT | Ad Status | The delivery status of the ad. |
| ad_title | TEXT | Ad Title | The headline title of the ad. |
| campaign | TEXT | Campaign | The name of the campaign. |
| campaign_budget_daily | NUMERIC | Campaign Daily Spend Limit | The daily spend limit set on the campaign. |
| campaign_budget_lifetime | NUMERIC | Campaign Lifetime Spend Limit | The lifetime spend limit set on the campaign. |
| campaign_description | TEXT | Campaign Description | The description of the campaign. |
| campaign_end_time | Campaign End Time | The scheduled end time of the campaign. | |
| campaign_id | TEXT | Campaign ID | The unique identifier of the campaign. |
| campaign_start_time | Campaign Start Time | The scheduled start time of the campaign. | |
| campaign_status | TEXT | Campaign Status | The delivery status of the campaign. |
| clicks | NUMERIC | Clicks | The number of times the ad was clicked. |
| conversions | NUMERIC | Conversions | Click-through conversions for the configured conversion events. |
| country | COUNTRY | Country | The country the ad was served in. |
| cpa | NUMERIC | CPA | Average cost per action (spend divided by conversions). |
| cpc | NUMERIC | CPC | Average cost per click (spend divided by clicks). |
| cpm | NUMERIC | CPM | Cost per thousand impressions. |
| ctr | PERCENT | CTR | Click-through rate (clicks divided by impressions). |
| date | DATE | Date | The date of the report metrics. |
| device | TEXT | Device | The device type the ad was served on. |
| impressions | NUMERIC | Impressions | The number of times the ad was shown. |
| order_created_attributed_sales | NUMERIC | Attributed Sales | Value of attributed order_created events in the account currency. |
| order_created_attributed_sales_currency | TEXT | Attributed Sales Currency | Currency of the attributed sales value. |
| order_created_roas | NUMERIC | Attributed Sales ROAS | Return on ad spend (attributed sales divided by spend). |
| platform | TEXT | Platform | The platform the ad was served on. |
| post_click_cvr | PERCENT | Post-Click Conversion Rate | Conversions divided by clicks, reported as a ratio. |
| spend | NUMERIC | Spend | The amount of money spent on the ad. |
OpenAI Ads / ChatGPT Ads other fields
The OpenAI Ads / ChatGPT Ads connector has 20 fields that do not belong to a named report, or belong to a report with only one or two fields.
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account ID | Account ID in Windsor.ai. | Accounts |
| account_name | TEXT | Account Name | Account name in Windsor.ai. | Accounts |
| data_fetched_at | Data fetched at | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. | ||
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| day_of_month | TEXT | Day of month | Day of the month | |
| month | TEXT | Month | Number of the month | |
| now | Now | Current timestamp | ||
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| week | TEXT | Week | Week (Sun-Sat). | |
| week_day | TEXT | Day of week and day number | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. | |
| week_day_iso | TEXT | Day of week and day number, ISO | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 | |
| week_iso | TEXT | Week ISO | Week, ISO format (Mon-Sun). | |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| year_month_name | TEXT | Year month name | Year and month with the month name written out, e.g. "Jan 2025". | |
| year_of_week | TEXT | Year of week | The year that contains first day of the week (Sun-Sat). | |
| year_of_week_iso | TEXT | Year of week, ISO | The year that contains first day of the ISO week (Mon-Sun). | |
| year_week | TEXT | Year week | Year and week for US weeks (Sun-Sat), e.g. 2024|15 | |
| year_week_iso | TEXT | Year week ISO | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |