Nielsen Digital Ad Ratings fields

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

Supermetrics brings all your Nielsen Digital Ad Ratings data into Google Sheets, Excel, BigQuery, Snowflake, Redshift, Azure

Early Access5 metrics48 dimensions

ADVERTISER

advertiser_id
Field label Advertiser ID
Description Unique identifier for the advertiser
Field type dimension
Data type string.text.value
advertiser_name
Field label Advertiser name
Description Name of the advertiser
Field type dimension
Data type string.text.value

AUDIENCE

demographics
Field label Demo segment
Description The demographics of the audience reached by the campaign
Field type dimension
Data type string.text.value
country
Field label Country
Description Country code
Field type dimension
Data type string.geo.country.twolettercode
primary_country
Field label Primary country
Description Country code for the primary country of the campaign
Field type dimension
Data type string.geo.country.twolettercode

BRAND

brand_id
Field label Brand ID
Description Unique identifier for the brand
Field type dimension
Data type string.text.value
brand_name
Field label Brand name
Description Name of the brand
Field type dimension
Data type string.text.value

CAMPAIGN

campaign_id
Field label Campaign ID
Description Unique identifier for the campaign
Field type dimension
Data type string.text.value
campaign_name
Field label Campaign name
Description Name of the campaign
Field type dimension
Data type string.text.value
campaign_status
Field label Campaign status
Description The status of the campaign (e.g., active, inactive, paused)
Field type dimension
Data type string.text.value
campaign_type
Field label Campaign type
Description The type of the campaign
Field type dimension
Data type string.text.value
campaign_target_demo
Field label Campaign target demo
Description The target demographics for the campaign
Field type dimension
Data type string.text.value
campaign_start_date
Field label Campaign start date
Description The start date of the campaign
Field type dimension
Data type string.time.date
campaign_end_date
Field label Campaign end date
Description The end date of the campaign
Field type dimension
Data type string.time.date
platform
Field label Platform
Description The platform on which the campaign is running (e.g., display, video, social)
Field type dimension
Data type string.text.value
reporting_frequency
Field label 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
reportable_status
Field label Reportable status
Description Reportable status of the campaign
Field type dimension
Data type string.text.value
dar_campaign_id
Field label DAR campaign ID
Description Unique identifier for the DAR campaign
Field type dimension
Data type string.text.value
dar_parent_campaign_id
Field label DAR parent campaign ID
Description Unique identifier for the parent DAR campaign
Field type dimension
Data type string.text.value
tv_rating_stream
Field label TV rating stream
Description Type of TV viewing being measured
Field type dimension
Data type string.text.value
tv_data_source
Field label TV data source
Description Source of the TV viewership data
Field type dimension
Data type string.text.value
delivery_type
Field label Delivery type
Field type dimension
Data type string.text.value
release_status
Field label Release status
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

PERFORMANCE

tracked_ads
Field label 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
Field label Unique audience
Description The unique count of individuals exposed to the Ad campaign
Field type metric
Data type int.number.value
average_frequency
Field label Average frequency
Description Average number of times each unique audience member was exposed to the ads in the campaign
Field type metric
Data type float.number.ratio
demo_effrate
Field label Demo efficiency rate
Description The rate at which served, measured Tracked Ads are delivered to a given demo. This metric is only applicable to Connected Devices
Field type metric
Data type float.number.ratio
target_demoeffrate
Field label Target demo efficiency rate
Description The rate at which served, measured Tracked Ads are delivered to the target demo. This metric is only applicable to Connected Devices
Field type metric
Data type float.number.ratio

PLACEMENT

ad_server_name
Field label Ad server name
Description The name of the ad server used to deliver the campaign
Field type dimension
Data type string.text.value
placement_id
Field label Placement ID
Description Unique identifier for the placement
Field type dimension
Data type string.text.value
placement_name
Field label Placement name
Description Name for the placement
Field type dimension
Data type string.text.value
placement_status
Field label Placement status
Description Status of the placement
Field type dimension
Data type string.text.value
tag_placement_id
Field label Placement tag ID
Description Unique identifier for the tag placement
Field type dimension
Data type string.text.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

SITE

publisher_id
Field label Publisher ID
Description Unique identifier for the publisher
Field type dimension
Data type string.text.value
is_network
Field label Is network
Description Defines whether the publisher is a network
Field type dimension
Data type bool
site_id
Field label Site ID
Description Unique identifier for the site
Field type dimension
Data type string.text.value
site_name
Field label Site name
Description Name of the site
Field type dimension
Data type string.text.value
site_url
Field label Site URL
Description URL of the site
Field type dimension
Data type string.text.url
ad_network_flag
Field label Ad network flag
Description Indicates if the ad impression served through an ad network
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
start_date
Field label Start date
Description The start date for the data exposure
Field type dimension
Data type string.time.date
end_date
Field label End date
Description The end date for the data exposure
Field type dimension
Data type string.time.date