Nielsen Digital Ad Ratings data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

Table: AUDIENCE_PROFILE

advertiser_id
Display name Advertiser ID
Description Unique identifier for the advertiser
Field type dimension
Data type string.text.value
advertiser_name
Display name Advertiser name
Description Name of the advertiser
Field type dimension
Data type string.text.value
brand_id
Display name Brand ID
Description Unique identifier for the brand
Field type dimension
Data type string.text.value
brand_name
Display name Brand name
Description Name of the brand
Field type dimension
Data type string.text.value
campaign_end_date
Display name Campaign end date
Description The end date of the campaign
Field type dimension
Data type string.time.date
campaign_id
Display name Campaign ID
Description Unique identifier for the campaign
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_start_date
Display name Campaign start date
Description The start date of the campaign
Field type dimension
Data type string.time.date
campaign_status
Display name Campaign status
Description The status of the campaign (e.g., active, inactive, paused)
Field type dimension
Data type string.text.value
campaign_target_demo
Display name Campaign target demo
Description The target demographics for the campaign
Field type dimension
Data type string.text.value
campaign_type
Display name Campaign type
Description The type of the campaign
Field type dimension
Data type string.text.value
country
Display name Country
Description Country code
Field type dimension
Data type string.geo.country.twolettercode
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
demographics
Display name Demo segment
Description The demographics of the audience reached by the campaign
Field type dimension
Data type string.text.value
platform
Display name Platform
Description The platform on which the campaign is running (e.g., display, video, social)
Field type dimension
Data type string.text.value
reportable_status
Display name Reportable status
Description Reportable status of the campaign
Field type dimension
Data type string.text.value
reporting_frequency
Display name Reporting frequency
Description The frequency at which campaign performance data is reported (e.g., daily, weekly, monthly)
Field type dimension
Data type string.text.value
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
tracked_ads
Display name Tracked ads
Description The count of individual ad exposures. This number is filtered for invalid traffic
Field type metric
Data type int.number.value
unique_audience
Display name Unique audience
Description The unique count of individuals exposed to the Ad campaign
Field type metric
Data type int.number.value

Table: SITE

advertiser_id
Display name Advertiser ID
Description Unique identifier for the advertiser
Field type dimension
Data type string.text.value
advertiser_name
Display name Advertiser name
Description Name of the advertiser
Field type dimension
Data type string.text.value
brand_id
Display name Brand ID
Description Unique identifier for the brand
Field type dimension
Data type string.text.value
brand_name
Display name Brand name
Description Name of the brand
Field type dimension
Data type string.text.value
campaign_end_date
Display name Campaign end date
Description The end date of the campaign
Field type dimension
Data type string.time.date
campaign_id
Display name Campaign ID
Description Unique identifier for the campaign
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_start_date
Display name Campaign start date
Description The start date of the campaign
Field type dimension
Data type string.time.date
campaign_status
Display name Campaign status
Description The status of the campaign (e.g., active, inactive, paused)
Field type dimension
Data type string.text.value
campaign_target_demo
Display name Campaign target demo
Description The target demographics for the campaign
Field type dimension
Data type string.text.value
campaign_type
Display name Campaign type
Description The type of the campaign
Field type dimension
Data type string.text.value
country
Display name Country
Description Country code
Field type dimension
Data type string.geo.country.twolettercode
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
demographics
Display name Demo segment
Description The demographics of the audience reached by the campaign
Field type dimension
Data type string.text.value
platform
Display name Platform
Description The platform on which the campaign is running (e.g., display, video, social)
Field type dimension
Data type string.text.value
reportable_status
Display name Reportable status
Description Reportable status of the campaign
Field type dimension
Data type string.text.value
reporting_frequency
Display name Reporting frequency
Description The frequency at which campaign performance data is reported (e.g., daily, weekly, monthly)
Field type dimension
Data type string.text.value
site_id
Display name Site ID
Description Unique identifier for the site
Field type dimension
Data type string.text.value
site_name
Display name Site name
Description Name of the site
Field type dimension
Data type string.text.value
site_url
Display name Site URL
Description URL of the site
Field type dimension
Data type string.text.url
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
tracked_ads
Display name Tracked ads
Description The count of individual ad exposures. This number is filtered for invalid traffic
Field type metric
Data type int.number.value
unique_audience
Display name Unique audience
Description The unique count of individuals exposed to the Ad campaign
Field type metric
Data type int.number.value

Table: PLACEMENT

ad_server_name
Display name Ad server name
Description The name of the ad server used to deliver the campaign
Field type dimension
Data type string.text.value
advertiser_id
Display name Advertiser ID
Description Unique identifier for the advertiser
Field type dimension
Data type string.text.value
advertiser_name
Display name Advertiser name
Description Name of the advertiser
Field type dimension
Data type string.text.value
brand_id
Display name Brand ID
Description Unique identifier for the brand
Field type dimension
Data type string.text.value
brand_name
Display name Brand name
Description Name of the brand
Field type dimension
Data type string.text.value
campaign_end_date
Display name Campaign end date
Description The end date of the campaign
Field type dimension
Data type string.time.date
campaign_id
Display name Campaign ID
Description Unique identifier for the campaign
Field type dimension
Data type string.text.value
campaign_name
Display name Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_start_date
Display name Campaign start date
Description The start date of the campaign
Field type dimension
Data type string.time.date
campaign_status
Display name Campaign status
Description The status of the campaign (e.g., active, inactive, paused)
Field type dimension
Data type string.text.value
campaign_target_demo
Display name Campaign target demo
Description The target demographics for the campaign
Field type dimension
Data type string.text.value
campaign_type
Display name Campaign type
Description The type of the campaign
Field type dimension
Data type string.text.value
country
Display name Country
Description Country code
Field type dimension
Data type string.geo.country.twolettercode
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
demographics
Display name Demo segment
Description The demographics of the audience reached by the campaign
Field type dimension
Data type string.text.value
placement_id
Display name Placement ID
Description Unique identifier for the placement
Field type dimension
Data type string.text.value
placement_name
Display name Placement name
Description Name for the placement
Field type dimension
Data type string.text.value
platform
Display name Platform
Description The platform on which the campaign is running (e.g., display, video, social)
Field type dimension
Data type string.text.value
reportable_status
Display name Reportable status
Description Reportable status of the campaign
Field type dimension
Data type string.text.value
reporting_frequency
Display name Reporting frequency
Description The frequency at which campaign performance data is reported (e.g., daily, weekly, monthly)
Field type dimension
Data type string.text.value
site_id
Display name Site ID
Description Unique identifier for the site
Field type dimension
Data type string.text.value
site_name
Display name Site name
Description Name of the site
Field type dimension
Data type string.text.value
site_url
Display name Site URL
Description URL of the site
Field type dimension
Data type string.text.url
tag_placement_id
Display name Placement tag ID
Description Unique identifier for the tag placement
Field type dimension
Data type string.text.value
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
tracked_ads
Display name Tracked ads
Description The count of individual ad exposures. This number is filtered for invalid traffic
Field type metric
Data type int.number.value
unique_audience
Display name Unique audience
Description The unique count of individuals exposed to the Ad campaign
Field type metric
Data type int.number.value

Table: POPULATION

country
Display name Country
Description Country code
Field type dimension
Data type string.geo.country.twolettercode
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
demographics
Display name Demo segment
Description The demographics of the audience reached by the campaign
Field type dimension
Data type string.text.value
end_date
Display name End date
Description The end date for the data exposure
Field type dimension
Data type string.time.date
start_date
Display name Start date
Description The start date for the data exposure
Field type dimension
Data type string.time.date