Introduction

Datasources and destinations

Fields listing for ChatGPT Ads

Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
TypeDAY
Data Typedimension
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
TypeDAY_OF_WEEK
Data Typedimension
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
TypeHOUR
Data Typedimension
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
TypeMONTH
Data Typedimension
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
TypeMONTH_DAY
Data Typedimension
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
TypeQUARTER
Data Typedimension
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
TypeWEEK
Data Typedimension
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
TypeWEEK
Data Typedimension
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
TypeYEAR
Data Typedimension
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
TypeYEAR_MONTH
Data Typedimension
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
TypeYEAR_MONTH_DAY
Data Typedimension
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
TypeYEAR_MONTH_DAY_HOUR
Data Typedimension
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
TypeYEAR_QUARTER
Data Typedimension
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
TypeYEAR_WEEK
Data Typedimension
Ad — Created at
Ad creation Unix timestamp.
Field IDad/ad_created_at
TypeNUMBER
Data Typedimension
Ad — Destination URL
Creative destination URL.
Field IDad/ad_destination_url
TypeURL
Data Typedimension
Ad — ID
Ad identifier. Example: ad_501
Field IDad/ad_id
TypeTEXT
Data Typedimension
Ad — Name
Internal ad name.
Field IDad/ad_name
TypeTEXT
Data Typedimension
Ad — Review status
OpenAI ad review status.
Field IDad/ad_review_status
TypeTEXT
Data Typedimension
Ad — Status
Ad delivery status.
Field IDad/ad_status
TypeTEXT
Data Typedimension
Ad — Text
Customer-visible creative body text.
Field IDad/ad_text
TypeTEXT
Data Typedimension
Ad — Title
Customer-visible creative title.
Field IDad/ad_title
TypeTEXT
Data Typedimension
Ad — Updated at
Ad update Unix timestamp.
Field IDad/ad_updated_at
TypeNUMBER
Data Typedimension
Ad — Creative file ID
Creative asset file identifier.
Field IDad/creative_file_id
TypeTEXT
Data Typedimension
Ad — Creative image URL
Creative image URL.
Field IDad/creative_image_url
TypeURL
Data Typedimension
Ad — Creative type
OpenAI creative type.
Field IDad/creative_type
TypeTEXT
Data Typedimension
Ad account — Currency code
Account currency code. Example: USD
Field IDad_account/ad_account_currency_code
TypeTEXT
Data Typedimension
Ad account — Daily budget
Daily budget in the account currency, converted from OpenAI micros when available.
Field IDad_account/ad_account_daily_budget
TypeNUMBER
Data Typedimension
Ad account — Daily budget micros
Raw OpenAI daily budget in millionths of the account currency.
Field IDad_account/ad_account_daily_budget_micros
TypeNUMBER
Data Typedimension
Ad account — ID
Ad account identifier. Example: act_123
Field IDad_account/ad_account_id
TypeTEXT
Data Typedimension
Ad account — Lifetime budget
Lifetime budget in the account currency, converted from OpenAI micros when available.
Field IDad_account/ad_account_lifetime_budget
TypeNUMBER
Data Typedimension
Ad account — Lifetime budget micros
Raw OpenAI lifetime budget in millionths of the account currency.
Field IDad_account/ad_account_lifetime_budget_micros
TypeNUMBER
Data Typedimension
Ad account — Name
Ad account display name. Example: Acme Ads
Field IDad_account/ad_account_name
TypeTEXT
Data Typedimension
Ad account — Preview URL
Account preview URL when returned.
Field IDad_account/ad_account_preview_url
TypeURL
Data Typedimension
Ad account — Review status
Brand review status returned by OpenAI.
Field IDad_account/ad_account_review_status
TypeTEXT
Data Typedimension
Ad account — Status
OpenAI ad account status.
Field IDad_account/ad_account_status
TypeTEXT
Data Typedimension
Ad account — Timezone
Timezone configured on the ad account. Example: UTC
Field IDad_account/ad_account_timezone
TypeTEXT
Data Typedimension
Ad account — URL
Advertiser website URL. Example: https://www.acme.example
Field IDad_account/ad_account_url
TypeURL
Data Typedimension
Ad account currency code
The currency code of the ad account.
Field IDad_account_currency_code
TypeTEXT
Data Typedimension
Ad account daily budget
The daily budget of the ad account in its configured currency.
Field IDad_account_daily_budget
TypeNUMBER
Data Typedimension
Ad account ID
The unique identifier of the ad account.
Field IDad_account_id
TypeTEXT
Data Typedimension
Ad account lifetime budget
The lifetime budget of the ad account in its configured currency.
Field IDad_account_lifetime_budget
TypeNUMBER
Data Typedimension
Ad account name
The name of the ad account.
Field IDad_account_name
TypeTEXT
Data Typedimension
Ad account URL
The URL of the ad account.
Field IDad_account_url
TypeURL
Data Typedimension
Ad destination URL
The destination URL of the ad.
Field IDad_destination_url
TypeURL
Data Typedimension
Ad group — Created at
Ad group creation Unix timestamp.
Field IDad_group/ad_group_created_at
TypeNUMBER
Data Typedimension
Ad group — Description
Ad group description.
Field IDad_group/ad_group_description
TypeTEXT
Data Typedimension
Ad group — ID
Ad group identifier. Example: adgrp_301
Field IDad_group/ad_group_id
TypeTEXT
Data Typedimension
Ad group — Name
Ad group name.
Field IDad_group/ad_group_name
TypeTEXT
Data Typedimension
Ad group — Status
Ad group delivery status.
Field IDad_group/ad_group_status
TypeTEXT
Data Typedimension
Ad group — Updated at
Ad group update Unix timestamp.
Field IDad_group/ad_group_updated_at
TypeNUMBER
Data Typedimension
Ad group — Billing event type
OpenAI bidding billing event type.
Field IDad_group/bidding_config_billing_event_type
TypeTEXT
Data Typedimension
Ad group — Maximum bid micros
OpenAI maximum bid in micros.
Field IDad_group/bidding_config_max_bid_micros
TypeNUMBER
Data Typedimension
Ad group — Context hints JSON
JSON-encoded context hints retained as configuration context.
Field IDad_group/context_hints_json
TypeTEXT
Data Typedimension
Ad group description
The description of the ad group.
Field IDad_group_description
TypeTEXT
Data Typedimension
Ad group ID
The unique identifier of the ad group.
Field IDad_group_id
TypeTEXT
Data Typedimension
Ad group name
The name of the ad group.
Field IDad_group_name
TypeTEXT
Data Typedimension
Ad group status
The status of the ad group.
Field IDad_group_status
TypeTEXT
Data Typedimension
Ad ID
The unique identifier of the ad.
Field IDad_id
TypeTEXT
Data Typedimension
Ad name
The name of the ad.
Field IDad_name
TypeTEXT
Data Typedimension
Ad review status
The review status of the ad.
Field IDad_review_status
TypeTEXT
Data Typedimension
Ad status
The status of the ad.
Field IDad_status
TypeTEXT
Data Typedimension
Ad text
The text of the ad.
Field IDad_text
TypeTEXT
Data Typedimension
Ad title
The title of the ad.
Field IDad_title
TypeTEXT
Data Typedimension
Aggregation level
OpenAI entity level selected by the connector.
Field IDaggregation_level
TypeTEXT
Data Typedimension
Campaign — Created at
Campaign creation Unix timestamp.
Field IDcampaign/campaign_created_at
TypeNUMBER
Data Typedimension
Campaign — Daily budget
Campaign daily budget in the account currency when available.
Field IDcampaign/campaign_daily_budget
TypeNUMBER
Data Typedimension
Campaign — Daily budget micros
Raw OpenAI campaign daily budget in micros when available.
Field IDcampaign/campaign_daily_budget_micros
TypeNUMBER
Data Typedimension
Campaign — Description
Campaign description.
Field IDcampaign/campaign_description
TypeTEXT
Data Typedimension
Campaign — End time
Campaign schedule end formatted as YYYY-MM-DD HH:MM:SS.
Field IDcampaign/campaign_end_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Campaign — ID
Campaign identifier. Example: cmpn_101
Field IDcampaign/campaign_id
TypeTEXT
Data Typedimension
Campaign — Lifetime budget
Campaign lifetime budget in the account currency.
Field IDcampaign/campaign_lifetime_budget
TypeNUMBER
Data Typedimension
Campaign — Lifetime budget micros
Raw OpenAI campaign lifetime budget in micros.
Field IDcampaign/campaign_lifetime_budget_micros
TypeNUMBER
Data Typedimension
Campaign — Name
Campaign name.
Field IDcampaign/campaign_name
TypeTEXT
Data Typedimension
Campaign — Start time
Campaign schedule start formatted as YYYY-MM-DD HH:MM:SS.
Field IDcampaign/campaign_start_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Campaign — Status
Campaign delivery status.
Field IDcampaign/campaign_status
TypeTEXT
Data Typedimension
Campaign — Updated at
Campaign update Unix timestamp.
Field IDcampaign/campaign_updated_at
TypeNUMBER
Data Typedimension
Campaign — Excluded targeting JSON
JSON-encoded excluded targeting countries retained as configuration context.
Field IDcampaign/targeting_excluded_country_codes_json
TypeTEXT
Data Typedimension
Campaign — Included targeting JSON
JSON-encoded included targeting countries retained as configuration context.
Field IDcampaign/targeting_included_country_codes_json
TypeTEXT
Data Typedimension
Campaign daily budget
The daily budget of the campaign in the account currency.
Field IDcampaign_daily_budget
TypeNUMBER
Data Typedimension
Campaign description
The description of the campaign.
Field IDcampaign_description
TypeTEXT
Data Typedimension
Campaign end time
The scheduled end time of the campaign.
Field IDcampaign_end_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Campaign ID
The unique identifier of the campaign.
Field IDcampaign_id
TypeTEXT
Data Typedimension
Campaign lifetime budget
The lifetime budget of the campaign in the account currency.
Field IDcampaign_lifetime_budget
TypeNUMBER
Data Typedimension
Campaign name
The name of the campaign.
Field IDcampaign_name
TypeTEXT
Data Typedimension
Campaign start time
The scheduled start time of the campaign.
Field IDcampaign_start_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Campaign status
The status of the campaign.
Field IDcampaign_status
TypeTEXT
Data Typedimension
Clicks
The total number of clicks on the ads.
Field IDclicks
TypeNUMBER
Data Typemetric
Conversions
The total number of click-through conversions attributed to the ads.
Field IDconversions
TypeNUMBER
Data Typemetric
Country name
The country of the reporting data as an ISO 3166-1 alpha-2 code.
Field IDcountry_name
TypeCOUNTRY_CODE
Data Typedimension
CPC
Cost per click, recomputed after aggregation as spend divided by clicks.
Field IDcpc
TypeNUMBER
Data Typemetric
CPM
Cost per thousand impressions, recomputed after aggregation.
Field IDcpm
TypeNUMBER
Data Typemetric
CTR
Click-through rate, recomputed after aggregation as clicks divided by impressions.
Field IDctr
TypePERCENT
Data Typemetric
Device type
The device type of the reporting data.
Field IDdevice_type
TypeTEXT
Data Typedimension
End time
End of the OpenAI reporting bucket as a Unix timestamp.
Field IDend_time
TypeNUMBER
Data Typedimension
Impressions
The total number of times the ads were displayed.
Field IDimpressions
TypeNUMBER
Data Typemetric
Insight row ID
Opaque OpenAI identifier for the insight row.
Field IDinsight_row_id
TypeTEXT
Data Typedimension
Product availability
The availability of the product.
Field IDproduct_availability
TypeTEXT
Data Typedimension
Product body
The body content of the product.
Field IDproduct_body
TypeTEXT
Data Typedimension
Product brand
The brand of the product.
Field IDproduct_brand
TypeTEXT
Data Typedimension
Product description
The description of the product.
Field IDproduct_description
TypeTEXT
Data Typedimension
Product feed ID
The unique identifier of the product feed.
Field IDproduct_feed_id
TypeTEXT
Data Typedimension
Product image URL
The image URL of the product.
Field IDproduct_image_url
TypeURL
Data Typedimension
Product image URL (Google Sheets)
The product image URL alias published for Google Sheets compatibility.
Field IDproduct_image_url_gs
TypeURL
Data Typedimension
Product item ID
The unique identifier of the product item.
Field IDproduct_item_id
TypeTEXT
Data Typedimension
Product price
The price of the product.
Field IDproduct_price
TypeNUMBER
Data Typedimension
Product seller name
The name of the product seller.
Field IDproduct_seller_name
TypeTEXT
Data Typedimension
Product target URL
The target URL of the product.
Field IDproduct_target_url
TypeURL
Data Typedimension
Product title
The title of the product.
Field IDproduct_title
TypeTEXT
Data Typedimension
OpenAI readable time
Flat readable_time value returned by OpenAI.
Field IDreadable_time
TypeYEAR_MONTH_DAY_SECOND
Data Typedimension
Spend
The total amount spent on the ads in the account currency.
Field IDspend
TypeNUMBER
Data Typemetric
Start time
Start of the OpenAI reporting bucket as a Unix timestamp.
Field IDstart_time
TypeNUMBER
Data Typedimension
Time granularity
OpenAI time bucket selected by the connector.
Field IDtime_granularity
TypeTEXT
Data Typedimension
Reporting timezone
The timezone of the reporting data.
Field IDtimezone
TypeTEXT
Data Typedimension