Xandr data warehouse table groups

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

Table: CREATIVE

advertiser_code
Display name Advertiser code
Description The custom code for the advertiser
Field type dimension
Data type string.text.value
advertiser_currency
Display name Advertiser currency
Description The currency used by the advertiser
Field type dimension
Data type string.currency.code
advertiser_id
Display name Advertiser ID
Description The unique identification number for each advertiser
Field type dimension
Data type string.text.value
advertiser_name
Display name Advertiser name
Description The name for each advertiser
Field type dimension
Data type string.text.value
campaign_code
Display name Campaign code
Description The custom code for the campaign
Field type dimension
Data type string.text.value
campaign_id
Display name Campaign ID
Description The unique identification number of the campaign
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Description The total number of clicks across all impressions
Field type metric
Data type int.number.value
conversions
Display name Conversions
Description The total number of post view and post click conversions
Field type metric
Data type int.number.value
cost
Display name Cost
Description The total cost
Field type metric
Data type float.currency.value
cost_advertiser_currency
Display name Cost (advertiser currency)
Description The total cost in the advertiser's preferred currency
Field type metric
Data type float.currency.value
creative_id
Display name Creative ID
Description The unique identification number of the creative
Field type dimension
Data type string.text.value
creative_name
Display name Creative name
Description The display name of the creative
Field type dimension
Data type string.text.value
dataSourceName
Display name 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
date
Display name Date
Field type dimension
Data type string.time.date
deal_code
Display name Deal code
Description The custom code for the deal
Field type dimension
Data type string.text.value
deal_id
Display name Deal ID
Description The ID of the deal
Field type dimension
Data type string.text.value
deal_name
Display name Deal name
Description The name of the deal
Field type dimension
Data type string.text.value
impressions
Display name Impressions
Description The total number of impressions served
Field type metric
Data type int.number.value
insertion_order_code
Display name Insertion order code
Description The custom code for the insertion order
Field type dimension
Data type string.text.value
insertion_order_id
Display name Insertion order ID
Description The unique identification number of the insertion order
Field type dimension
Data type string.text.value
insertion_order_name
Display name Insertion order name
Description The name of the insertion order
Field type dimension
Data type string.text.value
line_item_code
Display name Line item code
Description The custom code for the line item
Field type dimension
Data type string.text.value
line_item_id
Display name Line item ID
Description The unique identification number of the line item
Field type dimension
Data type string.text.value
line_item_name
Display name Line item name
Description The name of the line item
Field type dimension
Data type string.text.value
media_cost
Display name Media cost
Description The media cost for the buyer
Field type metric
Data type float.currency.value
media_type
Display name Media type
Description The general display style of the creative
Field type dimension
Data type string.text.value
placement_id
Display name Placement ID
Description The unique identification number of the placement
Field type dimension
Data type string.text.value
placement_name
Display name Placement name
Description The name of the placement
Field type dimension
Data type string.text.value
post_click_conversions
Display name Post click conversions
Description The total number of recorded post click conversions
Field type metric
Data type int.number.value
post_view_conversions
Display name Post view conversions
Description The total number of recorded post view conversions
Field type metric
Data type int.number.value
publisher_code
Display name Publisher code
Description The custom code for the publisher
Field type dimension
Data type string.text.value
publisher_id
Display name Publisher ID
Description The unique identification number of the publisher
Field type dimension
Data type string.text.value
publisher_name
Display name Publisher name
Description The name of the publisher
Field type dimension
Data type string.text.value
split_id
Display name 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
split_name
Display name 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
supply_type
Display name Supply type
Description The type of inventory
Field type dimension
Data type string.text.value
venue
Display name 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
video_complete_25
Display name 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
Display name 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
Display name 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_completions
Display name 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_errors
Display name Video errors
Description The total number of times a video error occurred
Field type metric
Data type int.number.value
video_skips
Display name 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_starts
Display name 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
videos_served
Display name 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

Table: GEO

advertiser_code
Display name Advertiser code
Description The custom code for the advertiser
Field type dimension
Data type string.text.value
advertiser_currency
Display name Advertiser currency
Description The currency used by the advertiser
Field type dimension
Data type string.currency.code
advertiser_id
Display name Advertiser ID
Description The unique identification number for each advertiser
Field type dimension
Data type string.text.value
advertiser_name
Display name Advertiser name
Description The name for each advertiser
Field type dimension
Data type string.text.value
campaign_code
Display name Campaign code
Description The custom code for the campaign
Field type dimension
Data type string.text.value
campaign_id
Display name Campaign ID
Description The unique identification number of the campaign
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
city_id
Display name City ID
Description The ID of the user's city location
Field type dimension
Data type string.text.value
city_name
Display name City name
Description The name of the user's city location
Field type dimension
Data type string.geo.city
clicks
Display name Clicks
Description The total number of clicks across all impressions
Field type metric
Data type int.number.value
conversions
Display name Conversions
Description The total number of post view and post click conversions
Field type metric
Data type int.number.value
cost
Display name Cost
Description The total cost
Field type metric
Data type float.currency.value
cost_advertiser_currency
Display name Cost (advertiser currency)
Description The total cost in the advertiser's preferred currency
Field type metric
Data type float.currency.value
country_code
Display name Country code
Description The country code of the user's location
Field type dimension
Data type string.geo.country.twolettercode
country_id
Display name 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
country_name
Display name Country name
Description The name of the user's country
Field type dimension
Data type string.geo.country
dataSourceName
Display name 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
date
Display name Date
Field type dimension
Data type string.time.date
dma_id
Display name DMA ID
Description The ID of the user's designated market area location
Field type dimension
Data type string.text.value
dma_name
Display name DMA name
Description The name of the user's designated market area location
Field type dimension
Data type string.text.value
impressions
Display name Impressions
Description The total number of impressions served
Field type metric
Data type int.number.value
insertion_order_code
Display name Insertion order code
Description The custom code for the insertion order
Field type dimension
Data type string.text.value
insertion_order_id
Display name Insertion order ID
Description The unique identification number of the insertion order
Field type dimension
Data type string.text.value
insertion_order_name
Display name Insertion order name
Description The name of the insertion order
Field type dimension
Data type string.text.value
line_item_code
Display name Line item code
Description The custom code for the line item
Field type dimension
Data type string.text.value
line_item_id
Display name Line item ID
Description The unique identification number of the line item
Field type dimension
Data type string.text.value
line_item_name
Display name Line item name
Description The name of the line item
Field type dimension
Data type string.text.value
post_click_conversions
Display name Post click conversions
Description The total number of recorded post click conversions
Field type metric
Data type int.number.value
post_view_conversions
Display name Post view conversions
Description The total number of recorded post view conversions
Field type metric
Data type int.number.value
postal_code
Display name Postal code
Description The postal code of the user's location
Field type dimension
Data type string.text.value
region_code
Display name Region code
Description The region code of the user's location
Field type dimension
Data type string.geo.region
region_id
Display name 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
region_name
Display name Region name
Description The name of the region of the user's location
Field type dimension
Data type string.geo.region
split_id
Display name 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
split_name
Display name 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
video_complete_25
Display name 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
Display name 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
Display name 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_completions
Display name 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_errors
Display name Video errors
Description The total number of times a video error occurred
Field type metric
Data type int.number.value
video_skips
Display name 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_starts
Display name 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
videos_served
Display name 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

Table: SITE_DOMAIN

advertiser_code
Display name Advertiser code
Description The custom code for the advertiser
Field type dimension
Data type string.text.value
advertiser_currency
Display name Advertiser currency
Description The currency used by the advertiser
Field type dimension
Data type string.currency.code
advertiser_id
Display name Advertiser ID
Description The unique identification number for each advertiser
Field type dimension
Data type string.text.value
advertiser_name
Display name Advertiser name
Description The name for each advertiser
Field type dimension
Data type string.text.value
age_bucket
Display name Age bucket
Description The bucket for the age of the user
Field type dimension
Data type string.text.value
age_bucket_id
Display name Age bucket ID
Description The ID of the age bucket
Field type dimension
Data type string.text.value
campaign_code
Display name Campaign code
Description The custom code for the campaign
Field type dimension
Data type string.text.value
campaign_id
Display name Campaign ID
Description The unique identification number of the campaign
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign name
Description The name of the campaign
Field type dimension
Data type string.text.value
clicks
Display name Clicks
Description The total number of clicks across all impressions
Field type metric
Data type int.number.value
conversions
Display name Conversions
Description The total number of post view and post click conversions
Field type metric
Data type int.number.value
dataSourceName
Display name 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
date
Display name Date
Field type dimension
Data type string.time.date
deal_code
Display name Deal code
Description The custom code for the deal
Field type dimension
Data type string.text.value
deal_id
Display name Deal ID
Description The ID of the deal
Field type dimension
Data type string.text.value
deal_name
Display name Deal name
Description The name of the deal
Field type dimension
Data type string.text.value
device_supply_type
Display name 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
gender
Display name Gender
Description The gender of the user
Field type dimension
Data type string.person.gender
impressions
Display name Impressions
Description The total number of impressions served
Field type metric
Data type int.number.value
insertion_order_id
Display name Insertion order ID
Description The unique identification number of the insertion order
Field type dimension
Data type string.text.value
insertion_order_name
Display name Insertion order name
Description The name of the insertion order
Field type dimension
Data type string.text.value
line_item_id
Display name Line item ID
Description The unique identification number of the line item
Field type dimension
Data type string.text.value
line_item_name
Display name Line item name
Description The name of the line item
Field type dimension
Data type string.text.value
media_cost
Display name Media cost
Description The media cost for the buyer
Field type metric
Data type float.currency.value
media_cost_advertiser_currency
Display name 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
mobile_application_id
Display name 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
mobile_application_name
Display name 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
operating_system_family_id
Display name Operating system family ID
Description The ID of the operating system family of the device
Field type dimension
Data type string.text.value
operating_system_family_name
Display name 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_id
Display name Operating system ID
Description The ID of the operating system of the device
Field type dimension
Data type string.text.value
operating_system_name
Display name Operating system name
Description The name of the operating system of the device
Field type dimension
Data type string.text.value
post_click_conversions
Display name Post click conversions
Description The total number of recorded post click conversions
Field type metric
Data type int.number.value
post_view_conversions
Display name Post view conversions
Description The total number of recorded post view conversions
Field type metric
Data type int.number.value
second_level_category
Display name 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_id
Display name 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
second_level_category_name
Display name 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
site_domain
Display name 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
split_id
Display name 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
split_name
Display name 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
top_level_category
Display name 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_id
Display name Top level category ID
Description The ID of the top content category assigned to the domain
Field type dimension
Data type string.text.value
top_level_category_name
Display name Top level category name
Description The name of the top content category assigned to the domain
Field type dimension
Data type string.text.value