ChatGPT Ads metrics and dimensions

  • Updated on May 15, 2026
  • Published on May 14, 2026
Prev Next

Supermetrics brings all your ChatGPT Ads data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

Early Access6 metrics47 dimensions
ad_id
Field label Ad ID
Description The unique identifier of the ad
Field type dimension
Data type string.text.value
ad_name
Field label Ad name
Description The name of the ad
Field type dimension
Data type string.text.value
ad_title
Field label Ad title
Description The title of the ad
Field type dimension
Data type string.text.value
ad_text
Field label Ad text
Description The text of the ad
Field type dimension
Data type string.text.value
ad_review_status
Field label Ad review status
Description The review status of the ad
Field type dimension
Data type string.text.value
ad_status
Field label Ad status
Description The status of the ad
Field type dimension
Data type string.text.value
ad_destination_url
Field label Ad destination URL
Description The destination URL of the ad
Field type dimension
Data type string.text.url

AD ACCOUNT

ad_account_id
Field label Ad account ID
Description The unique identifier of the ad account
Field type dimension
Data type string.text.value
ad_account_name
Field label Ad account name
Description The name of the ad account
Field type dimension
Data type string.text.value
ad_account_url
Field label Ad account URL
Description The URL of the ad account
Field type dimension
Data type string.text.url
ad_account_lifetime_budget
Field label Ad account lifetime budget
Description The lifetime budget of the ad account
Field type dimension
Data type float.currency.value
ad_account_currency_code
Field label Ad account currency code
Description The currency code of the ad account
Field type dimension
Data type string.currency.code

AD GROUP

ad_group_id
Field label Ad group ID
Description The unique identifier of the ad group
Field type dimension
Data type string.text.value
ad_group_name
Field label Ad group name
Description The name of the ad group
Field type dimension
Data type string.text.value
ad_group_status
Field label Ad group status
Description The status of the ad group
Field type dimension
Data type string.text.value

CAMPAIGN

campaign_id
Field label Campaign ID
Description The unique identifier of the campaign
Field type dimension
Data type string.text.value
campaign_name
Field label Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
campaign_status
Field label Campaign status
Description The status of the campaign
Field type dimension
Data type string.text.value
campaign_lifetime_budget
Field label Campaign lifetime budget
Description The lifetime budget of the campaign
Field type dimension
Data type float.currency.value

DATASOURCE

dataSourceName
Field label Data source
Description The name of the source for this data, as listed on supermetrics.com/docs
Field type dimension
Data type string.text.value
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

PERFORMANCE

impressions
Field label Impressions
Description The total number of times your ads were displayed
Field type metric
Data type int.number.value
clicks
Field label Clicks
Description The total number of clicks on your ads
Field type metric
Data type int.number.value
spend
Field label Spend
Description The total amount spent on your ads
Field type metric
Data type float.currency.value
ctr
Field label CTR
Description Click-through rate. (Clicks / Impressions)
Field type metric
Data type float.number.ratio
cpc
Field label CPC
Description Cost per click. (Spend / Clicks)
Field type metric
Data type float.currency.value
cpm
Field label CPM
Description Cost per mille. ((Spend / Impressions) * 1000)
Field type metric
Data type float.currency.value

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json
system_metadata.query_excluded_accounts
Field label Excluded invalid accounts
Description A list of unavailable accounts excluded from the query due to the "Exclude invalid accounts" setting
Field type dimension
Data type string.text.json

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
year
Field label Year
Field type dimension
Data type string.time.year
year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
month
Field label Month
Field type dimension
Data type string.time.month
year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
date
Field label Date
Field type dimension
Data type string.time.date
atom
Field label Datetime
Field type dimension
Data type string.time.datetime
timezone
Field label Timezone
Description The timezone of the reporting data
Field type dimension
Data type string.time.timezone

© Supermetrics 2025