Introduction

Datasources and destinations

Fields listing for Vistar Media

EXPLORE YOUR DATA

Metrics & dimensions

Find the fields you need for your next report.

11 metrics46 dimensions

57 fields

All fields
FieldDetails
Advertiser eCPM
Advertiser eCPM.
Field IDadvertiser_ecpm
MetricNUMBER
Advertiser Name
Advertiser name returned by the exchange report.
Field IDadvertiser_name
DimensionTEXT
AU Postal Area
Australian postal area.
Field IDau_postal_area
DimensionTEXT
AU State
Australian state.
Field IDau_state
DimensionTEXT
Buy Type
Vistar buy type.
Field IDbuy_type
DimensionTEXT
CA Economic Region
Canadian economic region.
Field IDca_economic_region
DimensionTEXT
CA Forward Sortation Area
Canadian forward sortation area.
Field IDca_forward_sortation_area
DimensionTEXT
CA Province
Canadian province.
Field IDca_province
DimensionTEXT
Campaign ID
Campaign identifier.
Field IDcampaign_id
DimensionTEXT
Campaign Name
Campaign name.
Field IDcampaign
DimensionTEXT
Campaign Pixel
Campaign pixel value returned by Vistar, when available.
Field IDcampaign_pixel
DimensionTEXT
Client Audience Fees
Client audience fees.
Field IDclient_audience_fees
MetricNUMBER
Client Cost
Client cost.
Field IDclient_cost
MetricNUMBER
Client eCPM
Client eCPM.
Field IDclient_ecpm
MetricNUMBER
Client Measurement Fees
Client measurement fees.
Field IDclient_measurement_fees
MetricNUMBER
Client Profit
Client profit.
Field IDclient_profit
MetricNUMBER
Client Revenue
Client revenue.
Field IDclient_revenue
MetricNUMBER
Contract Number
Contract number returned for the insertion order, when available.
Field IDcontract_number
DimensionTEXT
Creative ID
Creative identifier.
Field IDcreative
DimensionTEXT
Creative Name
Creative name.
Field IDcreative_name
DimensionTEXT
Creative Pixel
Creative pixel value returned by Vistar, when available.
Field IDcreative_pixel
DimensionTEXT
Data eCPM
Data eCPM.
Field IDdata_ecpm
MetricNUMBER
Date
Year, month, and day.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY
DimensionYEAR_MONTH_DAY
Day of the month
Day of the year
Field ID_NORMALIZED_DATE_FIELD_DAY
DimensionDAY
Day of the week
Week of the year
Field ID_NORMALIZED_DATE_FIELD_DAY_OF_WEEK
DimensionDAY_OF_WEEK
Deal
Deal.
Field IDdeal
DimensionTEXT
Deal ID
Deal identifier.
Field IDdeal_id
DimensionTEXT
GB Conurbation
United Kingdom conurbation.
Field IDgb_conurbation
DimensionTEXT
GB Postcode Sector
United Kingdom postcode sector.
Field IDgb_postcode_sector
DimensionTEXT
GB Town
United Kingdom town.
Field IDgb_town
DimensionTEXT
GB TV Area
United Kingdom television area.
Field IDgb_tv_area
DimensionTEXT
Hour of the day
Hour of the day
Field ID_NORMALIZED_DATE_FIELD_HOUR
DimensionHOUR
Impressions
Number of impressions.
Field IDimpressions
MetricNUMBER
Insertion Order
Insertion order.
Field IDinsertion_order
DimensionTEXT
Insertion Order Name
Insertion order name.
Field IDinsertion_order_name
DimensionTEXT
Latitude
Latitude of the screen where the ad played.
Field IDlatitude
DimensionNUMBER
Longitude
Longitude of the screen where the ad played.
Field IDlongitude
DimensionNUMBER
Media Cost
Media cost.
Field IDmedia_cost
MetricNUMBER
Media eCPM
Media eCPM.
Field IDmedia_ecpm
MetricNUMBER
Media Owner Display Name
Media owner display name.
Field IDmedia_owner_display_name
DimensionTEXT
Month and day
Month and day
Field ID_NORMALIZED_DATE_FIELD_MONTH_DAY
DimensionMONTH_DAY
Month of the year
Month of the year
Field ID_NORMALIZED_DATE_FIELD_MONTH
DimensionMONTH
Partner Venue ID
Partner venue identifier.
Field IDpartner_venue_id
DimensionTEXT
Quarter of the year
Quarter of the year
Field ID_NORMALIZED_DATE_FIELD_QUARTER
DimensionQUARTER
Report Date
Reporting day in the requested timezone.
Field IDdate
DimensionYEAR_MONTH_DAY
Report Month
Reporting year and month in the requested timezone, grouped natively by Vistar.
Field IDmonth
DimensionYEAR_MONTH
US DMA
United States designated market area.
Field IDus_dma
DimensionTEXT
US State
United States state.
Field IDus_state
DimensionTEXT
US ZIP
United States ZIP code.
Field IDus_zip
DimensionTEXT
Venue Type
Venue type.
Field IDvenue_type
DimensionTEXT
Week of the year
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK
DimensionWEEK
Week of the year (start Sunday)
Week of the year
Field ID_NORMALIZED_DATE_FIELD_WEEK_START_SUNDAY
DimensionWEEK
Year
Year such as 2017.
Field ID_NORMALIZED_DATE_FIELD_YEAR
DimensionYEAR
Year month
Year and month.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH
DimensionYEAR_MONTH
Year month day hour
Year, month, day, and hour.
Field ID_NORMALIZED_DATE_FIELD_YEAR_MONTH_DAY_HOUR
DimensionYEAR_MONTH_DAY_HOUR
Year Quarter
Year and quarter.
Field ID_NORMALIZED_DATE_FIELD_YEAR_QUARTER
DimensionYEAR_QUARTER
Year week
Year and week.
Field ID_NORMALIZED_DATE_FIELD_YEAR_WEEK
DimensionYEAR_WEEK

Explore destinations for your data