Xandr fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

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

36 metrics82 dimensions

ADVERTISER

advertiser_name
Field label Advertiser name
Description The name for each advertiser
Field type dimension
Data type string.text.value
advertiser_id
Field label Advertiser ID
Description The unique identification number for each advertiser
Field type dimension
Data type string.text.value
advertiser_code
Field label Advertiser code
Description The custom code for the advertiser
Field type dimension
Data type string.text.value
advertiser_currency
Field label Advertiser currency
Description The currency used by the advertiser
Field type dimension
Data type string.currency.code

APPLICATION

mobile_application_name
Field label Mobile application name
Description The name of the mobile application as it appears in the Apple App and Google Play Stores
Field type dimension
Data type string.text.value
mobile_application_id
Field label Mobile application ID
Description A targetable Apple App Store ID, Google Play package name, or Windows application ID
Field type dimension
Data type string.text.value

BASIC

impressions
Field label Impressions
Description The total number of impressions served
Field type metric
Data type int.number.value
clicks
Field label Clicks
Description The total number of clicks across all impressions
Field type metric
Data type int.number.value
ctr
Field label CTR
Description Click-through rate. Calculated as Clicks / Impressions
Field type metric
Data type float.number.ratio

CAMPAIGN

campaign_name
Field label Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
campaign_id
Field label Campaign ID
Description The unique identification number of the campaign
Field type dimension
Data type string.text.value
campaign_code
Field label Campaign code
Description The custom code for the campaign
Field type dimension
Data type string.text.value

CONVERSIONS

conversions
Field label Conversions
Description The total number of post view and post click conversions
Field type metric
Data type int.number.value
conversion_rate
Field label Conversion rate
Description The rate of conversions to impressions. Calculated as Conversions / Impressions
Field type metric
Data type float.number.ratio
post_view_conversions
Field label Post view conversions
Description The total number of recorded post view conversions
Field type metric
Data type int.number.value
post_click_conversions
Field label Post click conversions
Description The total number of recorded post click conversions
Field type metric
Data type int.number.value

COST

cpm
Field label CPM
Description Cost per 1000 impressions. Calculated as Cost / Impressions * 1000
Field type metric
Data type float.currency.value
cpc
Field label CPC
Description Cost per click. Calculated as Cost / Clicks
Field type metric
Data type float.currency.value
cpa
Field label CPA
Description The advertiser spend per conversion/acquisition. Calculated as Media cost / Conversions
Field type metric
Data type float.currency.value
cost
Field label Cost
Description The total cost
Field type metric
Data type float.currency.value
cost_eur
Field label Cost (EUR)
Description The total cost, converted to Euros
Field type metric
Data type float.currency.value
Services Currency conversion
cost_usd
Field label Cost (USD)
Description The total cost, converted to US dollars
Field type metric
Data type float.currency.value
Services Currency conversion
cost_gbp
Field label Cost (GBP)
Description The total cost, converted to British pounds
Field type metric
Data type float.currency.value
Services Currency conversion
cost_advertiser_currency
Field label Cost (advertiser currency)
Description The total cost in the advertiser's preferred currency
Field type metric
Data type float.currency.value

CREATIVE

creative_name
Field label Creative name
Description The display name of the creative
Field type dimension
Data type string.text.value
creative_id
Field label Creative ID
Description The unique identification number of the creative
Field type dimension
Data type string.text.value
media_type
Field label Media type
Description The general display style of the creative
Field type dimension
Data type string.text.value
placement_name
Field label Placement name
Description The name of the placement
Field type dimension
Data type string.text.value
placement_id
Field label Placement ID
Description The unique identification number of the placement
Field type dimension
Data type string.text.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

DEAL

deal_name
Field label Deal name
Description The name of the deal
Field type dimension
Data type string.text.value
deal_id
Field label Deal ID
Description The ID of the deal
Field type dimension
Data type string.text.value
deal_code
Field label Deal code
Description The custom code for the deal
Field type dimension
Data type string.text.value

DEMOGRAPHIC

gender
Field label Gender
Description The gender of the user
Field type dimension
Data type string.person.gender
age_bucket
Field label Age bucket
Description The bucket for the age of the user
Field type dimension
Data type string.text.value
age_bucket_id
Field label Age bucket ID
Description The ID of the age bucket
Field type dimension
Data type string.text.value

DEVICE

operating_system_name
Field label Operating system name
Description The name of the operating system of the device
Field type dimension
Data type string.text.value
operating_system_id
Field label Operating system ID
Description The ID of the operating system of the device
Field type dimension
Data type string.text.value
operating_system_family_name
Field label Operating system family name
Description The name of the operating system family of the device
Field type dimension
Data type string.text.value
operating_system_family_id
Field label Operating system family ID
Description The ID of the operating system family of the device
Field type dimension
Data type string.text.value
device_supply_type
Field label Device supply type
Description The seller-classified channel to denominate supply in terms of web, mobile-optimized web, and mobile app impressions. Possible values are 'web', 'mobile_app', and 'mobile_web'
Field type dimension
Data type string.text.value

DOMAIN

site_domain
Field label Site domain
Description The domain where the impression occurred. For mobile applications, this can be the URL of the app's location in the app store
Field type dimension
Data type string.text.value
top_level_category
Field label Top level category
Description The name and ID of the top content category assigned to the domain
Field type dimension
Data type string.text.value
top_level_category_name
Field label Top level category name
Description The name of the top content category assigned to the domain
Field type dimension
Data type string.text.value
top_level_category_id
Field label Top level category ID
Description The ID of the top content category assigned to the domain
Field type dimension
Data type string.text.value
second_level_category
Field label Second level category
Description The ID and name of the second-level content category assigned to the domain
Field type dimension
Data type string.text.value
second_level_category_name
Field label Second level category name
Description The name of the second-level content category assigned to the domain
Field type dimension
Data type string.text.value
second_level_category_id
Field label Second level category ID
Description The ID and name of the second-level content category assigned to the domain
Field type dimension
Data type string.text.value

GEO

country_name
Field label Country name
Description The name of the user's country
Field type dimension
Data type string.geo.country
country_code
Field label Country code
Description The country code of the user's location
Field type dimension
Data type string.geo.country.twolettercode
country_id
Field label Country ID
Description The country ID of the user's location. 250 is shown in cases where the country isn't known or if the country doesn't map correctly to a location in Xandr's database
Field type dimension
Data type string.geo.country
region_name
Field label Region name
Description The name of the region of the user's location
Field type dimension
Data type string.geo.region
region_code
Field label Region code
Description The region code of the user's location
Field type dimension
Data type string.geo.region
region_id
Field label Region ID
Description The region ID of the user's location. 4291 is shown in cases where the region isn't known or if the region doesn't map correctly to a location in Xandr's database
Field type dimension
Data type string.geo.region
dma_name
Field label DMA name
Description The name of the user's designated market area location
Field type dimension
Data type string.text.value
dma_id
Field label DMA ID
Description The ID of the user's designated market area location
Field type dimension
Data type string.text.value
postal_code
Field label Postal code
Description The postal code of the user's location
Field type dimension
Data type string.text.value
city_name
Field label City name
Description The name of the user's city location
Field type dimension
Data type string.geo.city
city_id
Field label City ID
Description The ID of the user's city location
Field type dimension
Data type string.text.value

INSERTION ORDER

insertion_order_name
Field label Insertion order name
Description The name of the insertion order
Field type dimension
Data type string.text.value
insertion_order_id
Field label Insertion order ID
Description The unique identification number of the insertion order
Field type dimension
Data type string.text.value
insertion_order_code
Field label Insertion order code
Description The custom code for the insertion order
Field type dimension
Data type string.text.value

LINE ITEM

line_item_name
Field label Line item name
Description The name of the line item
Field type dimension
Data type string.text.value
line_item_id
Field label Line item ID
Description The unique identification number of the line item
Field type dimension
Data type string.text.value
line_item_code
Field label Line item code
Description The custom code for the line item
Field type dimension
Data type string.text.value

MEDIA COST

cpm_media
Field label CPM (Media cost)
Description Media cost per 1000 impressions. Calculated as Media cost / Impressions * 1000
Field type metric
Data type float.currency.value
cpc_media
Field label CPC (Media cost)
Description Media cost per click. Calculated as Media cost / Clicks
Field type metric
Data type float.currency.value
cpa_media
Field label CPA (Media cost)
Description The advertiser spend per conversion/acquisition. Calculated as Media cost / Conversions
Field type metric
Data type float.currency.value
media_cost
Field label Media cost
Description The media cost for the buyer
Field type metric
Data type float.currency.value
media_cost_eur
Field label Media cost (EUR)
Description The media cost for the buyer, converted to Euros
Field type metric
Data type float.currency.value
Services Currency conversion
media_cost_usd
Field label Media cost (USD)
Description The media cost for the buyer, converted to US dollars
Field type metric
Data type float.currency.value
Services Currency conversion
media_cost_gbp
Field label Media cost (GBP)
Description The media cost for the buyer, converted to British pounds
Field type metric
Data type float.currency.value
Services Currency conversion
media_cost_advertiser_currency
Field label Media cost (advertiser currency)
Description The media cost for the buyer, in the advertiser's preferred currency
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

SPLIT

split_name
Field label Split name
Description The name of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items
Field type dimension
Data type string.text.value
split_id
Field label Split ID
Description The ID of the split that purchased the impressions in this data set. Splits are only applicable to augmented line items
Field type dimension
Data type string.text.value

SUPPLIER

publisher_name
Field label Publisher name
Description The name of the publisher
Field type dimension
Data type string.text.value
publisher_id
Field label Publisher ID
Description The unique identification number of the publisher
Field type dimension
Data type string.text.value
publisher_code
Field label Publisher code
Description The custom code for the publisher
Field type dimension
Data type string.text.value
supply_type
Field label Supply type
Description The type of inventory
Field type dimension
Data type string.text.value
venue
Field label Venue
Description The name of the cluster of domain, site, tag, and user country that Xandr' optimization system uses to determine bid valuations. A campaign cannot target a venue explicitly
Field type dimension
Data type string.text.value

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

VIDEO

videos_served
Field label Videos served
Description The total number of video responses served to the player. An ad response occurs when the VAST document (XML) is served in response to a request. An ad response doesn't necessarily indicate a successful impression. For an impression, the first frame of the video must be served
Field type metric
Data type int.number.value
video_starts
Field label Video starts
Description The total number of times the first segment of the video creative was downloaded and started
Field type metric
Data type int.number.value
video_start_rate
Field label Video start rate
Description The total number of times the first segment of the video creative was downloaded and started
Field type metric
Data type float.number.percentage
video_completions
Field label Video completions
Description The total number of times the video creatives played for the entire duration
Field type metric
Data type int.number.value
video_completion_rate
Field label Video completion rate
Description The ratio of video completions to impressions, expressed as a percentage. Calculated by Video completions / Impressions
Field type metric
Data type float.number.ratio
video_complete_25
Field label 25% video complete
Description The total number of times the video creatives completed 25% of the entire duration
Field type metric
Data type int.number.value
video_complete_50
Field label 50% video complete
Description The total number of times the video creatives completed 50% of the entire duration
Field type metric
Data type int.number.value
video_complete_75
Field label 75% video complete
Description The total number of times the video creatives completed 75% of the entire duration
Field type metric
Data type int.number.value
video_skips
Field label Video skips
Description The total number of times a user skipped the video. Use this metric for reporting when buying skippable inventory
Field type metric
Data type int.number.value
video_skip_rate
Field label Video skip rate
Description The percentage of times the user opted to skip the video
Field type metric
Data type float.number.ratio
video_errors
Field label Video errors
Description The total number of times a video error occurred
Field type metric
Data type int.number.value
cost_per_video_complete
Field label Cost per video complete
Description The cost per video completion
Field type metric
Data type float.currency.value
revenue_per_video_complete
Field label Revenue per video complete
Description The revenue per video completion
Field type metric
Data type float.currency.value