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
Created At
Ad creation Unix timestamp. Example: 1735689800
Field IDad/created_at
TypeNUMBER
Data Typedimension
Creative Body
Creative body copy shown in the ad. Example: Coordinate tasks, docs, and meetings in one place.
Field IDad/creative_body
TypeTEXT
Data Typedimension
Creative File Id
Creative file identifier from creative.file_id. Example: file_901
Field IDad/creative_file_id
TypeTEXT
Data Typedimension
Creative Image Url
Creative image URL from creative.image_url. Example: https://cdn.openai.com/ads/file_901.png
Field IDad/creative_image_url
TypeURL
Data Typedimension
Creative Target Url
Creative landing URL from creative.target_url. Example: https://example.com/workspace-planner
Field IDad/creative_target_url
TypeURL
Data Typedimension
Creative Title
Creative title shown in the ad. Example: Try the new workspace planner
Field IDad/creative_title
TypeTEXT
Data Typedimension
Creative Type
Creative type from creative.type. Example: chat_card
Field IDad/creative_type
TypeTEXT
Data Typedimension
Id
Ad identifier. Example: ad_501
Field IDad/id
TypeTEXT
Data Typedimension
Name
Internal ad name. Example: Planner launch card
Field IDad/name
TypeTEXT
Data Typedimension
Review Status
Ad review status. Example: approved
Field IDad/review_status
TypeTEXT
Data Typedimension
Status
Ad delivery status. Example: active
Field IDad/status
TypeTEXT
Data Typedimension
Updated At
Ad update Unix timestamp. Example: 1735776200
Field IDad/updated_at
TypeNUMBER
Data Typedimension
Currency Code
Account currency code. Example: USD
Field IDad_account/currency_code
TypeTEXT
Data Typedimension
Id
Ad account identifier. Example: act_123
Field IDad_account/id
TypeTEXT
Data Typedimension
Name
Ad account display name. Example: Acme Ads
Field IDad_account/name
TypeTEXT
Data Typedimension
Preview Url
Account preview URL when returned. Example: https://preview.acme.example
Field IDad_account/preview_url
TypeURL
Data Typedimension
Timezone
Timezone used by the ad account. Example: UTC
Field IDad_account/timezone
TypeTEXT
Data Typedimension
Url
Advertiser website URL. Example: https://www.acme.example
Field IDad_account/url
TypeURL
Data Typedimension
Bidding Config Billing Event Type
Billing event type from bidding_config.billing_event_type. Example: impression
Field IDad_group/bidding_config_billing_event_type
TypeTEXT
Data Typedimension
Bidding Config Max Bid Micros
Maximum bid in micros from bidding_config.max_bid_micros. Example: 60000
Field IDad_group/bidding_config_max_bid_micros
TypeNUMBER
Data Typedimension
Context Hints Json
JSON-encoded ad group context hints. Example: ["productivity","team collaboration"]
Field IDad_group/context_hints_json
TypeTEXT
Data Typedimension
Created At
Ad group creation Unix timestamp. Example: 1735689700
Field IDad_group/created_at
TypeNUMBER
Data Typedimension
Description
Ad group description. Example: Primary English-speaking audience.
Field IDad_group/description
TypeTEXT
Data Typedimension
Id
Ad group identifier. Example: adgrp_301
Field IDad_group/id
TypeTEXT
Data Typedimension
Name
Ad group name. Example: US English
Field IDad_group/name
TypeTEXT
Data Typedimension
Status
Ad group delivery status. Example: active
Field IDad_group/status
TypeTEXT
Data Typedimension
Updated At
Ad group update Unix timestamp. Example: 1735776100
Field IDad_group/updated_at
TypeNUMBER
Data Typedimension
Ad Group Name
Ad group display name returned by the insights API. Example: US English
Field IDad_group_name
TypeTEXT
Data Typemetric
Ad Name
Ad display name returned by the insights API. Example: Planner launch card
Field IDad_name
TypeTEXT
Data Typemetric
Aggregation Level
Insight aggregation level used by the connector. Example: ad
Field IDaggregation_level
TypeTEXT
Data Typemetric
Budget Lifetime Spend Limit Micros
Lifetime spend limit in micros from budget.lifetime_spend_limit_micros. Example: 25000000
Field IDcampaign/budget_lifetime_spend_limit_micros
TypeNUMBER
Data Typedimension
Created At
Campaign creation Unix timestamp. Example: 1735689600
Field IDcampaign/created_at
TypeNUMBER
Data Typedimension
Description
Campaign description. Example: Promote the new productivity bundle.
Field IDcampaign/description
TypeTEXT
Data Typedimension
End Time
Campaign end Unix timestamp. Example: 1738368000
Field IDcampaign/end_time
TypeNUMBER
Data Typedimension
Id
Campaign identifier. Example: cmpn_101
Field IDcampaign/id
TypeTEXT
Data Typedimension
Name
Campaign name. Example: Spring launch
Field IDcampaign/name
TypeTEXT
Data Typedimension
Start Time
Campaign start Unix timestamp. Example: 1735689600
Field IDcampaign/start_time
TypeNUMBER
Data Typedimension
Status
Campaign delivery status. Example: active
Field IDcampaign/status
TypeTEXT
Data Typedimension
Targeting Excluded Country Codes Json
JSON-encoded excluded targeting country codes. Example: ["CA"]
Field IDcampaign/targeting_excluded_country_codes_json
TypeTEXT
Data Typedimension
Targeting Included Country Codes Json
JSON-encoded included targeting country codes. Example: ["FR","US"]
Field IDcampaign/targeting_included_country_codes_json
TypeTEXT
Data Typedimension
Updated At
Campaign update Unix timestamp. Example: 1735776000
Field IDcampaign/updated_at
TypeNUMBER
Data Typedimension
Campaign Name
Campaign display name returned by the insights API. Example: Spring launch
Field IDcampaign_name
TypeTEXT
Data Typemetric
Clicks
Ad clicks. Example: 75
Field IDclicks
TypeNUMBER
Data Typemetric
Conversions
Conversion count when returned by the API. Example: 12
Field IDconversions
TypeNUMBER
Data Typemetric
Cpc
Average cost per click. Example: 1.64
Field IDcpc
TypeNUMBER
Data Typemetric
Cpm
Average cost per thousand impressions. Example: 82.30
Field IDcpm
TypeNUMBER
Data Typemetric
Ctr
Click-through rate. Example: 0.05
Field IDctr
TypePERCENT
Data Typemetric
End Time
Insight bucket or range end Unix timestamp. Example: 1714607999
Field IDend_time
TypeNUMBER
Data Typemetric
Id
Insight row identifier when returned by the API. Example: insight_123
Field IDid
TypeTEXT
Data Typemetric
Impressions
Delivered ad impressions. Example: 1500
Field IDimpressions
TypeNUMBER
Data Typemetric
Readable Time
Daily bucket label returned by the API. Example: 2026-04-25
Field IDreadable_time
TypeYEAR_MONTH_DAY
Data Typemetric
Spend
Ad spend in the account currency unless the API returns another precision. Example: 123.45
Field IDspend
TypeNUMBER
Data Typemetric
Start Time
Insight bucket or range start Unix timestamp. Example: 1714003200
Field IDstart_time
TypeNUMBER
Data Typemetric
Time Granularity
Insight time bucket size requested by the connector. Example: daily
Field IDtime_granularity
TypeTEXT
Data Typemetric
Timezone
Timezone used for the insight bucket. Example: UTC
Field IDtimezone
TypeTEXT
Data Typemetric