Yahoo DSP data warehouse table groups

  • Updated on Oct 6, 2025
  • Published on Aug 5, 2025
Prev Next

Table: CAMPAIGN

advertiser
Display name Advertiser
Description The name of 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 identifier of the advertiser
Field type dimension
Data type string.text.value
campaign
Display name Campaign
Description The name of the campaign
Field type dimension
Data type string.text.value
campaign_id
Display name Campaign ID
Description The unique identifier of the campaign
Field type dimension
Data type string.text.value
click_conversions
Display name Click-through conversions
Description The amount of times a user clicks on an ad impression, and eventually converts on the advertiser’s site who served the ad
Field type metric
Data type int.number.value
clicks
Display name Clicks
Description The amount of times an ad has been clicked
Field type metric
Data type int.number.value
conversion_value
Display name Conversion value
Description The ROAS conversion value
Field type metric
Data type float.currency.value
conversions
Display name Conversions
Description The total amount of conversions
Field type metric
Data type int.number.value
cost
Display name Cost
Field type metric
Data type float.currency.value
cross_device_conversions
Display name Cross-device conversions
Description The amount of cross-device 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
estimated_billable_amount
Display name Estimated billable amount
Description The costs and fees associated with lines or campaigns
Field type metric
Data type float.currency.value
impressions
Display name Impressions
Description The total amount of times an ad has been displayed
Field type metric
Data type int.number.value
measurable_impressions
Display name Measurable impressions
Description Tracks the number of impressions measured for viewability. Note that not all impressions may be measured because of technical limitations or publisher page design
Field type metric
Data type int.number.value
moat_measurable_impressions
Display name Moat measurable impressions
Description Moat measurable impressions for display metrics
Field type metric
Data type int.number.value
moat_viewable_impressions
Display name Moat viewable impressions
Description Moat viewable impressions
Field type metric
Data type int.number.value
non_viewable_impressions
Display name Non-viewable impressions
Description The number of impressions that were not viewable
Field type metric
Data type int.number.value
order_management_fee
Display name Order management fee
Description The order management fee
Field type metric
Data type float.currency.value
profit
Display name Network profit
Description The total profit of the network
Field type metric
Data type float.currency.value
publisher_earnings
Display name Publisher earnings
Description The amount paid to publishers
Field type metric
Data type float.currency.value
seat_data_fee
Display name Seat data fee
Description The seat data fee
Field type metric
Data type float.currency.value
seat_management_fee
Display name Seat management fee
Description The seam management fee
Field type metric
Data type float.currency.value
seat_tech_fee
Display name Seat tech fee
Description The seat tech fee
Field type metric
Data type float.currency.value
third_party_data_fees
Display name Third party data fees
Description Third party data fees
Field type metric
Data type float.currency.value
unique_viewers
Display name Unique Viewers
Description The number of unique users
Field type metric
Data type int.number.value
video_completions
Display name Completed views
Description Video views that resulted in 100% completion
Field type metric
Data type int.number.value
video_completions_25
Display name Video views 25%
Description Number of video starts that resulted in at least a 25% completed video
Field type metric
Data type int.number.value
video_completions_50
Display name Video views 50%
Description Number of video starts that resulted in at least a 50% completed video
Field type metric
Data type int.number.value
video_completions_75
Display name Video views 75%
Description Number of video starts that resulted in at least a 75% completed video
Field type metric
Data type int.number.value
video_views
Display name Video view starts
Description The amount of times a video was started
Field type metric
Data type int.number.value
view_conversions
Display name View-through conversions
Description The amount of times a user views an ad impression
Field type metric
Data type int.number.value
viewable_impressions
Display name Viewable impressions
Description The total amount of times an ad has been displayed while in view
Field type metric
Data type int.number.value
yahoo_data_fees
Display name Yahoo data fees
Description The Yahoo data fees
Field type metric
Data type float.currency.value

Table: AD

ad
Display name Ad
Description The name of the ad
Field type dimension
Data type string.text.value
ad_id
Display name Ad ID
Description The unique identifier of the ad
Field type dimension
Data type string.text.value
advertiser
Display name Advertiser
Description The name of 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 identifier of the advertiser
Field type dimension
Data type string.text.value
campaign
Display name Campaign
Description The name of the campaign
Field type dimension
Data type string.text.value
campaign_id
Display name Campaign ID
Description The unique identifier of the campaign
Field type dimension
Data type string.text.value
click_conversions
Display name Click-through conversions
Description The amount of times a user clicks on an ad impression, and eventually converts on the advertiser’s site who served the ad
Field type metric
Data type int.number.value
clicks
Display name Clicks
Description The amount of times an ad has been clicked
Field type metric
Data type int.number.value
conversion_value
Display name Conversion value
Description The ROAS conversion value
Field type metric
Data type float.currency.value
conversions
Display name Conversions
Description The total amount of conversions
Field type metric
Data type int.number.value
cost
Display name Cost
Field type metric
Data type float.currency.value
creative
Display name Creative
Description The name of the creative
Field type dimension
Data type string.text.value
creative_id
Display name Creative ID
Description The unique identifier of the creative
Field type dimension
Data type string.text.value
cross_device_conversions
Display name Cross-device conversions
Description The amount of cross-device 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
estimated_billable_amount
Display name Estimated billable amount
Description The costs and fees associated with lines or campaigns
Field type metric
Data type float.currency.value
impressions
Display name Impressions
Description The total amount of times an ad has been displayed
Field type metric
Data type int.number.value
layout
Display name Layout
Description The name of the layout expressed in terms of its dimensions
Field type dimension
Data type string.text.value
line
Display name Line
Description The name of the line
Field type dimension
Data type string.text.value
line_id
Display name Line ID
Description The unique identifier of the line
Field type dimension
Data type string.text.value
measurable_impressions
Display name Measurable impressions
Description Tracks the number of impressions measured for viewability. Note that not all impressions may be measured because of technical limitations or publisher page design
Field type metric
Data type int.number.value
media_type
Display name Media type
Description The media type of the creative
Field type dimension
Data type string.text.value
moat_measurable_impressions
Display name Moat measurable impressions
Description Moat measurable impressions for display metrics
Field type metric
Data type int.number.value
moat_viewable_impressions
Display name Moat viewable impressions
Description Moat viewable impressions
Field type metric
Data type int.number.value
non_viewable_impressions
Display name Non-viewable impressions
Description The number of impressions that were not viewable
Field type metric
Data type int.number.value
order_management_fee
Display name Order management fee
Description The order management fee
Field type metric
Data type float.currency.value
profit
Display name Network profit
Description The total profit of the network
Field type metric
Data type float.currency.value
publisher_earnings
Display name Publisher earnings
Description The amount paid to publishers
Field type metric
Data type float.currency.value
seat_data_fee
Display name Seat data fee
Description The seat data fee
Field type metric
Data type float.currency.value
seat_management_fee
Display name Seat management fee
Description The seam management fee
Field type metric
Data type float.currency.value
seat_tech_fee
Display name Seat tech fee
Description The seat tech fee
Field type metric
Data type float.currency.value
third_party_data_fees
Display name Third party data fees
Description Third party data fees
Field type metric
Data type float.currency.value
video_completions
Display name Completed views
Description Video views that resulted in 100% completion
Field type metric
Data type int.number.value
video_completions_25
Display name Video views 25%
Description Number of video starts that resulted in at least a 25% completed video
Field type metric
Data type int.number.value
video_completions_50
Display name Video views 50%
Description Number of video starts that resulted in at least a 50% completed video
Field type metric
Data type int.number.value
video_completions_75
Display name Video views 75%
Description Number of video starts that resulted in at least a 75% completed video
Field type metric
Data type int.number.value
video_views
Display name Video view starts
Description The amount of times a video was started
Field type metric
Data type int.number.value
view_conversions
Display name View-through conversions
Description The amount of times a user views an ad impression
Field type metric
Data type int.number.value
viewable_impressions
Display name Viewable impressions
Description The total amount of times an ad has been displayed while in view
Field type metric
Data type int.number.value
yahoo_data_fees
Display name Yahoo data fees
Description The Yahoo data fees
Field type metric
Data type float.currency.value

Table: PUBLISHER

ad
Display name Ad
Description The name of the ad
Field type dimension
Data type string.text.value
ad_id
Display name Ad ID
Description The unique identifier of the ad
Field type dimension
Data type string.text.value
click_conversions
Display name Click-through conversions
Description The amount of times a user clicks on an ad impression, and eventually converts on the advertiser’s site who served the ad
Field type metric
Data type int.number.value
clicks
Display name Clicks
Description The amount of times an ad has been clicked
Field type metric
Data type int.number.value
conversion_value
Display name Conversion value
Description The ROAS conversion value
Field type metric
Data type float.currency.value
conversions
Display name Conversions
Description The total amount of conversions
Field type metric
Data type int.number.value
cost
Display name Cost
Field type metric
Data type float.currency.value
cross_device_conversions
Display name Cross-device conversions
Description The amount of cross-device 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
estimated_billable_amount
Display name Estimated billable amount
Description The costs and fees associated with lines or campaigns
Field type metric
Data type float.currency.value
impressions
Display name Impressions
Description The total amount of times an ad has been displayed
Field type metric
Data type int.number.value
measurable_impressions
Display name Measurable impressions
Description Tracks the number of impressions measured for viewability. Note that not all impressions may be measured because of technical limitations or publisher page design
Field type metric
Data type int.number.value
moat_measurable_impressions
Display name Moat measurable impressions
Description Moat measurable impressions for display metrics
Field type metric
Data type int.number.value
moat_viewable_impressions
Display name Moat viewable impressions
Description Moat viewable impressions
Field type metric
Data type int.number.value
non_viewable_impressions
Display name Non-viewable impressions
Description The number of impressions that were not viewable
Field type metric
Data type int.number.value
order_management_fee
Display name Order management fee
Description The order management fee
Field type metric
Data type float.currency.value
profit
Display name Network profit
Description The total profit of the network
Field type metric
Data type float.currency.value
publisher_earnings
Display name Publisher earnings
Description The amount paid to publishers
Field type metric
Data type float.currency.value
publisher_id
Display name Publisher ID
Description The unique identifier of the publisher
Field type dimension
Data type string.text.value
publisher_name
Display name Publisher
Description The name of the publisher
Field type dimension
Data type string.text.value
seat_data_fee
Display name Seat data fee
Description The seat data fee
Field type metric
Data type float.currency.value
seat_management_fee
Display name Seat management fee
Description The seam management fee
Field type metric
Data type float.currency.value
seat_tech_fee
Display name Seat tech fee
Description The seat tech fee
Field type metric
Data type float.currency.value
third_party_data_fees
Display name Third party data fees
Description Third party data fees
Field type metric
Data type float.currency.value
video_completions
Display name Completed views
Description Video views that resulted in 100% completion
Field type metric
Data type int.number.value
video_completions_25
Display name Video views 25%
Description Number of video starts that resulted in at least a 25% completed video
Field type metric
Data type int.number.value
video_completions_50
Display name Video views 50%
Description Number of video starts that resulted in at least a 50% completed video
Field type metric
Data type int.number.value
video_completions_75
Display name Video views 75%
Description Number of video starts that resulted in at least a 75% completed video
Field type metric
Data type int.number.value
video_views
Display name Video view starts
Description The amount of times a video was started
Field type metric
Data type int.number.value
view_conversions
Display name View-through conversions
Description The amount of times a user views an ad impression
Field type metric
Data type int.number.value
viewable_impressions
Display name Viewable impressions
Description The total amount of times an ad has been displayed while in view
Field type metric
Data type int.number.value
yahoo_data_fees
Display name Yahoo data fees
Description The Yahoo data fees
Field type metric
Data type float.currency.value