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

Yahoo DSP Standard Data Warehouse Schema

Table: CAMPAIGN

advertiser
The name of the advertiser
Display NameAdvertiser
Typedimension
Data Typestring.text.value
advertiser_currency
The currency used by the advertiser
Display NameAdvertiser currency
Typedimension
Data Typestring.currency.code
advertiser_id
The unique identifier of the advertiser
Display NameAdvertiser ID
Typedimension
Data Typestring.text.value
campaign_name
The name of the campaign
Display NameCampaign
Typedimension
Data Typestring.text.value
campaign_id
The unique identifier of the campaign
Display NameCampaign ID
Typedimension
Data Typestring.text.value
click_conversions
The amount of times a user clicks on an ad impression, and eventually converts on the advertiser’s site who served the ad
Display NameClick-through conversions
Typemetric
Data Typeint.number.value
clicks
The amount of times an ad has been clicked
Display NameClicks
Typemetric
Data Typeint.number.value
conversion_value
The ROAS conversion value
Display NameConversion value
Typemetric
Data Typefloat.currency.value
conversions
The total amount of conversions
Display NameConversions
Typemetric
Data Typeint.number.value
cost
Display NameCost
Typemetric
Data Typefloat.currency.value
cross_device_conversions
The amount of cross-device conversions
Display NameCross-device conversions
Typemetric
Data Typeint.number.value
data_source_name
The name of the source for this data, as listed on supermetrics.com/docs
Display NameData source
Typedimension
Data Typestring.text.value
date
Display NameDate
Typedimension
Data Typestring.time.date
estimated_billable_amount
The costs and fees associated with lines or campaigns
Display NameEstimated billable amount
Typemetric
Data Typefloat.currency.value
impressions
The total amount of times an ad has been displayed
Display NameImpressions
Typemetric
Data Typeint.number.value
measurable_impressions
Tracks the number of impressions measured for viewability. Note that not all impressions may be measured because of technical limitations or publisher page design
Display NameMeasurable impressions
Typemetric
Data Typeint.number.value
moat_measurable_impressions
Moat measurable impressions for display metrics
Display NameMoat measurable impressions
Typemetric
Data Typeint.number.value
moat_viewable_impressions
Moat viewable impressions
Display NameMoat viewable impressions
Typemetric
Data Typeint.number.value
non_viewable_impressions
The number of impressions that were not viewable
Display NameNon-viewable impressions
Typemetric
Data Typeint.number.value
order_management_fee
The order management fee
Display NameOrder management fee
Typemetric
Data Typefloat.currency.value
profit
The total profit of the network
Display NameNetwork profit
Typemetric
Data Typefloat.currency.value
publisher_earnings
The amount paid to publishers
Display NamePublisher earnings
Typemetric
Data Typefloat.currency.value
seat_data_fee
The seat data fee
Display NameSeat data fee
Typemetric
Data Typefloat.currency.value
seat_management_fee
The seam management fee
Display NameSeat management fee
Typemetric
Data Typefloat.currency.value
seat_tech_fee
The seat tech fee
Display NameSeat tech fee
Typemetric
Data Typefloat.currency.value
third_party_data_fees
Third party data fees
Display NameThird party data fees
Typemetric
Data Typefloat.currency.value
unique_viewers
The number of unique users
Display NameUnique Viewers
Typemetric
Data Typeint.number.value
video_completions
Video views that resulted in 100% completion
Display NameCompleted views
Typemetric
Data Typeint.number.value
video_completions_25
Number of video starts that resulted in at least a 25% completed video
Display NameVideo views 25%
Typemetric
Data Typeint.number.value
video_completions_50
Number of video starts that resulted in at least a 50% completed video
Display NameVideo views 50%
Typemetric
Data Typeint.number.value
video_completions_75
Number of video starts that resulted in at least a 75% completed video
Display NameVideo views 75%
Typemetric
Data Typeint.number.value
video_views
The amount of times a video was started
Display NameVideo view starts
Typemetric
Data Typeint.number.value
view_conversions
The amount of times a user views an ad impression
Display NameView-through conversions
Typemetric
Data Typeint.number.value
viewable_impressions
The total amount of times an ad has been displayed while in view
Display NameViewable impressions
Typemetric
Data Typeint.number.value
yahoo_data_fees
The Yahoo data fees
Display NameYahoo data fees
Typemetric
Data Typefloat.currency.value

Table: AD

ad_name
The name of the ad
Display NameAd
Typedimension
Data Typestring.text.value
ad_id
The unique identifier of the ad
Display NameAd ID
Typedimension
Data Typestring.text.value
advertiser
The name of the advertiser
Display NameAdvertiser
Typedimension
Data Typestring.text.value
advertiser_currency
The currency used by the advertiser
Display NameAdvertiser currency
Typedimension
Data Typestring.currency.code
advertiser_id
The unique identifier of the advertiser
Display NameAdvertiser ID
Typedimension
Data Typestring.text.value
campaign_name
The name of the campaign
Display NameCampaign
Typedimension
Data Typestring.text.value
campaign_id
The unique identifier of the campaign
Display NameCampaign ID
Typedimension
Data Typestring.text.value
click_conversions
The amount of times a user clicks on an ad impression, and eventually converts on the advertiser’s site who served the ad
Display NameClick-through conversions
Typemetric
Data Typeint.number.value
clicks
The amount of times an ad has been clicked
Display NameClicks
Typemetric
Data Typeint.number.value
conversion_value
The ROAS conversion value
Display NameConversion value
Typemetric
Data Typefloat.currency.value
conversions
The total amount of conversions
Display NameConversions
Typemetric
Data Typeint.number.value
cost
Display NameCost
Typemetric
Data Typefloat.currency.value
creative_name
The name of the creative
Display NameCreative
Typedimension
Data Typestring.text.value
creative_id
The unique identifier of the creative
Display NameCreative ID
Typedimension
Data Typestring.text.value
cross_device_conversions
The amount of cross-device conversions
Display NameCross-device conversions
Typemetric
Data Typeint.number.value
data_source_name
The name of the source for this data, as listed on supermetrics.com/docs
Display NameData source
Typedimension
Data Typestring.text.value
date
Display NameDate
Typedimension
Data Typestring.time.date
estimated_billable_amount
The costs and fees associated with lines or campaigns
Display NameEstimated billable amount
Typemetric
Data Typefloat.currency.value
impressions
The total amount of times an ad has been displayed
Display NameImpressions
Typemetric
Data Typeint.number.value
layout_name
The name of the layout expressed in terms of its dimensions
Display NameLayout
Typedimension
Data Typestring.text.value
line_name
The name of the line
Display NameLine
Typedimension
Data Typestring.text.value
line_id
The unique identifier of the line
Display NameLine ID
Typedimension
Data Typestring.text.value
measurable_impressions
Tracks the number of impressions measured for viewability. Note that not all impressions may be measured because of technical limitations or publisher page design
Display NameMeasurable impressions
Typemetric
Data Typeint.number.value
media_type
The media type of the creative
Display NameMedia type
Typedimension
Data Typestring.text.value
moat_measurable_impressions
Moat measurable impressions for display metrics
Display NameMoat measurable impressions
Typemetric
Data Typeint.number.value
moat_viewable_impressions
Moat viewable impressions
Display NameMoat viewable impressions
Typemetric
Data Typeint.number.value
non_viewable_impressions
The number of impressions that were not viewable
Display NameNon-viewable impressions
Typemetric
Data Typeint.number.value
order_management_fee
The order management fee
Display NameOrder management fee
Typemetric
Data Typefloat.currency.value
profit
The total profit of the network
Display NameNetwork profit
Typemetric
Data Typefloat.currency.value
publisher_earnings
The amount paid to publishers
Display NamePublisher earnings
Typemetric
Data Typefloat.currency.value
seat_data_fee
The seat data fee
Display NameSeat data fee
Typemetric
Data Typefloat.currency.value
seat_management_fee
The seam management fee
Display NameSeat management fee
Typemetric
Data Typefloat.currency.value
seat_tech_fee
The seat tech fee
Display NameSeat tech fee
Typemetric
Data Typefloat.currency.value
third_party_data_fees
Third party data fees
Display NameThird party data fees
Typemetric
Data Typefloat.currency.value
video_completions
Video views that resulted in 100% completion
Display NameCompleted views
Typemetric
Data Typeint.number.value
video_completions_25
Number of video starts that resulted in at least a 25% completed video
Display NameVideo views 25%
Typemetric
Data Typeint.number.value
video_completions_50
Number of video starts that resulted in at least a 50% completed video
Display NameVideo views 50%
Typemetric
Data Typeint.number.value
video_completions_75
Number of video starts that resulted in at least a 75% completed video
Display NameVideo views 75%
Typemetric
Data Typeint.number.value
video_views
The amount of times a video was started
Display NameVideo view starts
Typemetric
Data Typeint.number.value
view_conversions
The amount of times a user views an ad impression
Display NameView-through conversions
Typemetric
Data Typeint.number.value
viewable_impressions
The total amount of times an ad has been displayed while in view
Display NameViewable impressions
Typemetric
Data Typeint.number.value
yahoo_data_fees
The Yahoo data fees
Display NameYahoo data fees
Typemetric
Data Typefloat.currency.value

Table: PUBLISHER

ad_name
The name of the ad
Display NameAd
Typedimension
Data Typestring.text.value
ad_id
The unique identifier of the ad
Display NameAd ID
Typedimension
Data Typestring.text.value
click_conversions
The amount of times a user clicks on an ad impression, and eventually converts on the advertiser’s site who served the ad
Display NameClick-through conversions
Typemetric
Data Typeint.number.value
clicks
The amount of times an ad has been clicked
Display NameClicks
Typemetric
Data Typeint.number.value
conversion_value
The ROAS conversion value
Display NameConversion value
Typemetric
Data Typefloat.currency.value
conversions
The total amount of conversions
Display NameConversions
Typemetric
Data Typeint.number.value
cost
Display NameCost
Typemetric
Data Typefloat.currency.value
cross_device_conversions
The amount of cross-device conversions
Display NameCross-device conversions
Typemetric
Data Typeint.number.value
data_source_name
The name of the source for this data, as listed on supermetrics.com/docs
Display NameData source
Typedimension
Data Typestring.text.value
date
Display NameDate
Typedimension
Data Typestring.time.date
estimated_billable_amount
The costs and fees associated with lines or campaigns
Display NameEstimated billable amount
Typemetric
Data Typefloat.currency.value
impressions
The total amount of times an ad has been displayed
Display NameImpressions
Typemetric
Data Typeint.number.value
measurable_impressions
Tracks the number of impressions measured for viewability. Note that not all impressions may be measured because of technical limitations or publisher page design
Display NameMeasurable impressions
Typemetric
Data Typeint.number.value
moat_measurable_impressions
Moat measurable impressions for display metrics
Display NameMoat measurable impressions
Typemetric
Data Typeint.number.value
moat_viewable_impressions
Moat viewable impressions
Display NameMoat viewable impressions
Typemetric
Data Typeint.number.value
non_viewable_impressions
The number of impressions that were not viewable
Display NameNon-viewable impressions
Typemetric
Data Typeint.number.value
order_management_fee
The order management fee
Display NameOrder management fee
Typemetric
Data Typefloat.currency.value
profit
The total profit of the network
Display NameNetwork profit
Typemetric
Data Typefloat.currency.value
publisher_earnings
The amount paid to publishers
Display NamePublisher earnings
Typemetric
Data Typefloat.currency.value
publisher_id
The unique identifier of the publisher
Display NamePublisher ID
Typedimension
Data Typestring.text.value
publisher_name
The name of the publisher
Display NamePublisher
Typedimension
Data Typestring.text.value
seat_data_fee
The seat data fee
Display NameSeat data fee
Typemetric
Data Typefloat.currency.value
seat_management_fee
The seam management fee
Display NameSeat management fee
Typemetric
Data Typefloat.currency.value
seat_tech_fee
The seat tech fee
Display NameSeat tech fee
Typemetric
Data Typefloat.currency.value
third_party_data_fees
Third party data fees
Display NameThird party data fees
Typemetric
Data Typefloat.currency.value
video_completions
Video views that resulted in 100% completion
Display NameCompleted views
Typemetric
Data Typeint.number.value
video_completions_25
Number of video starts that resulted in at least a 25% completed video
Display NameVideo views 25%
Typemetric
Data Typeint.number.value
video_completions_50
Number of video starts that resulted in at least a 50% completed video
Display NameVideo views 50%
Typemetric
Data Typeint.number.value
video_completions_75
Number of video starts that resulted in at least a 75% completed video
Display NameVideo views 75%
Typemetric
Data Typeint.number.value
video_views
The amount of times a video was started
Display NameVideo view starts
Typemetric
Data Typeint.number.value
view_conversions
The amount of times a user views an ad impression
Display NameView-through conversions
Typemetric
Data Typeint.number.value
viewable_impressions
The total amount of times an ad has been displayed while in view
Display NameViewable impressions
Typemetric
Data Typeint.number.value
yahoo_data_fees
The Yahoo data fees
Display NameYahoo data fees
Typemetric
Data Typefloat.currency.value