BigQuery tables behind Looker studio for the DV360 performance report | Learning Center

If you want to work with the data output directly in BigQuery, getting started is straightforward. Below is an example query to analyse performance metrics from your DV360 campaigns.

This query retrieves and summarises DV360 performance data, focusing on total impressions, clicks, and advertiser revenue (cost) for each advertiser and insertion order, starting from 1 January 2023. It groups the data by advertiser name, device type, and insertion order to provide a clear summary of performance metrics across different advertisers, devices, and insertion orders:

SELECT 
  filter_advertiser_name, 
  filter_device_type, 
  filter_insertion_order_name, 
  SUM(metric_impressions) AS total_impressions, 
  SUM(metric_clicks) AS total_clicks, 
  SUM(metric_revenue_advertiser) AS total_advertiser_cost 
FROM `project.dataset.dv360_performance_report__base_report_{table_suffix}` WHERE date >= '2023-01-01' 
GROUP BY 
  filter_advertiser_name, 
  filter_device_type, 
  filter_insertion_order_name 
ORDER BY 
  filter_advertiser_name, 
  filter_device_type, 
  filter_insertion_order_name;

Below is the detailed schema of the output tables in BigQuery:

Table 1: dv360_performance_report__base_report_{table_suffix}

Full name	Type	Description
date	DATE	The date of the record.
filter_date	STRING	A string representation of the date filter.
filter_media_plan	STRING	The ID of the media plan.
filter_media_plan_name	STRING	The name of the media plan.
filter_partner	STRING	The ID of the partner.
filter_partner_name	STRING	The name of the partner.
filter_advertiser	STRING	The ID of the advertiser.
filter_advertiser_name	STRING	The name of the advertiser.
filter_insertion_order_name	STRING	The name of the insertion order.
filter_insertion_order	STRING	The ID of the insertion order.
filter_line_item_name	STRING	The name of the line item.
filter_line_item	STRING	The ID of the line item.
filter_device_type	STRING	The type of device (e.g., mobile, desktop).
filter_partner_currency	STRING	The currency used by the partner.
filter_advertiser_currency	STRING	The currency used by the advertiser.
metric_impressions	FLOAT	The number of impressions.
metric_clicks	FLOAT	The number of clicks.
metric_active_view_viewable_impressions	FLOAT	The number of viewable impressions.
metric_revenue_partner	FLOAT	The revenue for the partner.
metric_revenue_advertiser	FLOAT	The revenue for the advertiser (cost).
metric_total_conversions	FLOAT	The total number of conversions.
metric_last_clicks	FLOAT	The number of last clicks.
metric_last_impressions	FLOAT	The number of last impressions.
metric_rich_media_video_plays	FLOAT	The number of rich media video plays.
metric_rich_media_video_first_quartile_completes	FLOAT	The number of rich media video first quartile completions.
metric_rich_media_video_midpoints	FLOAT	The number of rich media video midpoints.
metric_rich_media_video_third_quartile_completes	FLOAT	The number of rich media video third quartile completions.
metric_rich_media_video_completions	FLOAT	The number of rich media video completions.
metric_video_completion_rate	FLOAT	The video completion rate.
metric_rich_media_video_full_screens	FLOAT	The number of rich media video full screens.
metric_rich_media_video_mutes	FLOAT	The number of rich media video mutes.
metric_rich_media_video_pauses	FLOAT	The number of rich media video pauses.
metric_rich_media_video_skips	FLOAT	The number of rich media video skips.
metric_video_companion_clicks	FLOAT	The number of video companion clicks.
metric_video_companion_impressions	FLOAT	The number of video companion impressions.
metric_trueview_view_rate	FLOAT	The TrueView view rate.
metric_trueview_views	FLOAT	The number of TrueView views.
metric_cm360_post_click_revenue	FLOAT	The post-click revenue in CM360.
metric_cm360_post_view_revenue	FLOAT	The post-view revenue in CM360.
conversion_value	FLOAT	The conversion value.
currency_variable	FLOAT	The currency variable for conversion calculations.
reverse_currency_variable	FLOAT	The reverse currency variable for conversion calculations.
cost_last_year	FLOAT	The cost from the previous year.
conversions_last_year	FLOAT	The number of conversions from the previous year.
post_click_revenue_last_year	FLOAT	The post-click revenue from the previous year.
post_view_revenue_last_year	FLOAT	The post-view revenue from the previous year.
conversion_value_last_year	FLOAT	The conversion value from the previous year.
li_avg_impr_frequency_90d	FLOAT	The average impression frequency for the last 90 days for the line item.
io_avg_impr_frequency_90d	FLOAT	The average impression frequency for the last 90 days for the insertion order.
creative_performance	RECORD	The performance data for creatives.
floodlights	RECORD	The performance data for floodlight activities.
countries	RECORD	The performance data by country.
custom_currency	STRING	The custom currency used for unified currency calculations.
channel_grouping	STRING	The grouping of marketing channels.
market_name	STRING	The name of the market.
io_est_view_impr_reach	FLOAT	The estimated viewable impression reach for the insertion order.
io_est_impr_reach	FLOAT	The estimated impression reach for the insertion order.
li_est_view_impr_reach	FLOAT	The estimated viewable impression reach for the line item.
li_est_impr_reach	FLOAT	The estimated impression reach for the line item.
custom_cost_last_year	FLOAT	The custom cost from the previous year.
custom_conversion_value_last_year	FLOAT	The custom conversion value from the previous year.
custom_post_click_revenue_last_year	FLOAT	The custom post-click revenue from the previous year.
custom_post_view_revenue_last_year	FLOAT	The custom post-view revenue from the previous year.
custom_cost	FLOAT	The custom cost in unified currency.
custom_post_click_revenue	FLOAT	The custom post-click revenue in unified currency.
custom_post_view_revenue	FLOAT	The custom post-view revenue in unified currency.
custom_conversion_value	FLOAT	The custom conversion value in unified currency.
creative_performance.filter_creative	STRING	The filter for creative performance.
creative_performance.filter_creative_id	STRING	The ID of the creative.
creative_performance.filter_creative_size	STRING	The size of the creative.
creative_performance.filter_creative_type	STRING	The type of creative.
creative_performance.filter_creative_height	STRING	The height of the creative.
creative_performance.filter_creative_width	STRING	The width of the creative.
creative_performance.filter_companion_creative_id	STRING	The ID of the companion creative.
creative_performance.filter_companion_creative_name	STRING	The name of the companion creative.
creative_performance.filter_creative_source	STRING	The source of the creative.
creative_performance.filter_creative_status	STRING	The status of the creative.
creative_performance.filter_video_companion_creative_size	STRING	The size of the video companion creative.
creative_performance.filter_ad_type	STRING	The type of ad.
creative_performance.filter_ad_position	STRING	The position of the ad.
creative_performance.filter_position_in_content	STRING	The position in content.
creative_performance.filter_page_layout	STRING	The layout of the page.
creative_performance.filter_inventory_commitment_type	STRING	The type of inventory commitment.
creative_performance.filter_device_type	STRING	The type of device for creative performance.
creative_performance.metric_impressions	FLOAT	The number of impressions for creative performance.
creative_performance.metric_clicks	FLOAT	The number of clicks for creative performance.
creative_performance.metric_active_view_viewable_impressions	FLOAT	The number of viewable impressions for creative performance.
creative_performance.metric_revenue_partner	FLOAT	The revenue for the partner from creative performance.
creative_performance.metric_revenue_advertiser	FLOAT	The revenue for the advertiser (cost) from creative performance.
creative_performance.metric_total_conversions	FLOAT	The total number of conversions from creative performance.
creative_performance.metric_last_clicks	FLOAT	The number of last clicks from creative performance.
creative_performance.metric_last_impressions	FLOAT	The number of last impressions from creative performance.
creative_performance.metric_rich_media_video_plays	FLOAT	The number of rich media video plays from creative performance.
creative_performance.metric_rich_media_video_first_quartile_completes	FLOAT	The number of rich media video first quartile completions from creative performance.
creative_performance.metric_rich_media_video_midpoints	FLOAT	The number of rich media video midpoints from creative performance.
creative_performance.metric_rich_media_video_third_quartile_completes	FLOAT	The number of rich media video third quartile completions from creative performance.
creative_performance.metric_rich_media_video_completions	FLOAT	The number of rich media video completions from creative performance.
creative_performance.metric_video_completion_rate	FLOAT	The video completion rate from creative performance.
creative_performance.metric_rich_media_video_full_screens	FLOAT	The number of rich media video full screens from creative performance.
creative_performance.metric_rich_media_video_mutes	FLOAT	The number of rich media video mutes from creative performance.
creative_performance.metric_rich_media_video_pauses	FLOAT	The number of rich media video pauses from creative performance.
creative_performance.metric_rich_media_video_skips	FLOAT	The number of rich media video skips from creative performance.
creative_performance.metric_video_companion_clicks	FLOAT	The number of video companion clicks from creative performance.
creative_performance.metric_video_companion_impressions	FLOAT	The number of video companion impressions from creative performance.
creative_performance.metric_companion_clicks_audio	FLOAT	The number of audio companion clicks from creative performance.
creative_performance.metric_companion_impressions_audio	FLOAT	The number of audio companion impressions from creative performance.
creative_performance.metric_trueview_view_rate	FLOAT	The TrueView view rate from creative performance.
creative_performance.metric_trueview_views	FLOAT	The number of TrueView views from creative performance.
creative_performance.metric_cm360_post_click_revenue	FLOAT	The post-click revenue in CM360 from creative performance.
creative_performance.metric_cm360_post_view_revenue	FLOAT	The post-view revenue in CM360 from creative performance.
creative_performance.conversion_value	FLOAT	The conversion value from creative performance.
creative_performance.custom_post_click_revenue	FLOAT	The custom post-click revenue from creative performance.
creative_performance.custom_post_view_revenue	FLOAT	The custom post-view revenue from creative performance.
creative_performance.custom_conversion_value	FLOAT	The custom conversion value from creative performance.
creative_performance.custom_cost	FLOAT	The custom cost from creative performance.
floodlights.filter_floodlight_activity	STRING	The filter for floodlight activity.
floodlights.filter_floodlight_activity_id	STRING	The ID of the floodlight activity.
floodlights.metric_total_conversions	FLOAT	The total number of conversions from floodlight activity.
floodlights.metric_last_clicks	FLOAT	The number of last clicks from floodlight activity.
floodlights.metric_last_impressions	FLOAT	The number of last impressions from floodlight activity.
floodlights.metric_cm360_post_click_revenue	FLOAT	The post-click revenue in CM360 from floodlight activity.
floodlights.metric_cm360_post_view_revenue	FLOAT	The post-view revenue in CM360 from floodlight activity.
floodlights.custom_post_click_revenue	FLOAT	The custom post-click revenue from floodlight activity.
floodlights.custom_post_view_revenue	FLOAT	The custom post-view revenue from floodlight activity.
floodlights.conversion_value	FLOAT	The conversion value from floodlight activity.
floodlights.custom_conversion_value	FLOAT	The custom conversion value from floodlight activity.
countries.filter_country	STRING	The filter for country performance.
countries.metric_impressions	FLOAT	The number of impressions from country performance.
countries.metric_clicks	FLOAT	The number of clicks from country performance.
countries.metric_active_view_viewable_impressions	FLOAT	The number of viewable impressions from country performance.
countries.metric_revenue_partner	FLOAT	The revenue for the partner from country performance.
countries.metric_revenue_advertiser	FLOAT	The revenue for the advertiser (cost) from country performance.
countries.metric_total_conversions	FLOAT	The total number of conversions from country performance.
countries.metric_last_clicks	FLOAT	The number of last clicks from country performance.
countries.metric_last_impressions	FLOAT	The number of last impressions from country performance.
countries.custom_post_click_revenue	FLOAT	The custom post-click revenue from country performance.
countries.custom_post_view_revenue	FLOAT	The custom post-view revenue from country performance.
countries.conversion_value	FLOAT	The conversion value from country performance.
countries.custom_conversion_value	FLOAT	The custom conversion value from country performance.
countries.custom_cost	FLOAT	The custom cost from country performance.

Table 2: dv360_performance_report__app_url_report_{table_suffix}

Full name	Type	Description
filter_media_plan	STRING	The media plan filter applied to the report.
filter_media_plan_name	STRING	The name of the media plan filter.
filter_partner	STRING	The partner filter applied to the report.
filter_partner_name	STRING	The name of the partner filter.
filter_advertiser	STRING	The advertiser filter applied to the report.
filter_advertiser_name	STRING	The name of the advertiser filter.
filter_insertion_order_name	STRING	The name of the insertion order filter.
filter_insertion_order	STRING	The insertion order filter applied to the report.
filter_line_item_name	STRING	The name of the line item filter.
filter_line_item	STRING	The line item filter applied to the report.
filter_country	STRING	The country filter applied to the report.
filter_partner_currency	STRING	The currency used by the partner.
filter_advertiser_currency	STRING	The currency used by the advertiser.
filter_inventory_commitment_type	STRING	The type of inventory commitment.
filter_app_url	STRING	The app URL filter applied to the report.
filter_site_id	STRING	The site ID filter applied to the report.
filter_inventory_source_type	STRING	The type of inventory source.
filter_device_type	STRING	The device type filter applied to the report.
currency_variable	FLOAT	The currency variable for financial metrics.
metric_impressions	FLOAT	The number of impressions.
metric_clicks	FLOAT	The number of clicks.
metric_active_view_viewable_impressions	FLOAT	The number of viewable impressions as measured by Active View.
metric_revenue_partner	FLOAT	The revenue attributed to the partner.
metric_revenue_advertiser	FLOAT	The revenue attributed to the advertiser.
metric_total_conversions	FLOAT	The total number of conversions.
metric_last_clicks	FLOAT	The number of last-click conversions.
metric_last_impressions	FLOAT	The number of last-impression conversions.
metric_rich_media_video_plays	FLOAT	The number of rich media video plays.
metric_rich_media_video_completions	FLOAT	The number of rich media video completions.
metric_video_completion_rate	FLOAT	The video completion rate.
metric_video_companion_clicks	FLOAT	The number of video companion clicks.
metric_video_companion_impressions	FLOAT	The number of video companion impressions.
metric_companion_clicks_audio	FLOAT	The number of companion clicks for audio.
metric_companion_impressions_audio	FLOAT	The number of companion impressions for audio.
metric_trueview_view_rate	FLOAT	The TrueView view rate.
metric_trueview_views	FLOAT	The number of TrueView views.
metric_cm360_post_click_revenue	FLOAT	The post-click revenue measured by Campaign Manager 360.
metric_cm360_post_view_revenue	FLOAT	The post-view revenue measured by Campaign Manager 360.
custom_currency	STRING	The custom currency used for unified financial metrics.
min_date	DATE	The minimum date of the data in the report.
max_date	DATE	The maximum date of the data in the report.
custom_post_click_revenue	FLOAT	The custom post-click revenue.
custom_post_view_revenue	FLOAT	The custom post-view revenue.
custom_cost	FLOAT	The custom cost metric.
conversion_value	FLOAT	The value of conversions.
custom_conversion_value	FLOAT	The custom conversion value.
channel_grouping	STRING	The grouping of marketing channels.
market_name	STRING	The name of the market.

Table 3: dv360_performance_report__audience_report_{table_suffix}

Full name	Type	Description
date	DATE	The date of the record.
filter_partner	STRING	The identifier for the partner associated with the audience data.
filter_advertiser	STRING	The identifier for the advertiser associated with the audience data.
filter_advertiser_name	STRING	The name of the advertiser associated with the audience data.
filter_advertiser_currency	STRING	The currency code used by the advertiser (e.g., USD, EUR).
filter_insertion_order_name	STRING	The name of the insertion order associated with the audience data.
filter_insertion_order	STRING	The identifier for the insertion order associated with the audience data.
filter_line_item	STRING	The identifier for the line item associated with the audience data.
filter_line_item_name	STRING	The name of the line item associated with the audience data.
targeted_audience_list	STRING	The name or identifier of the targeted audience list used in the campaign.
audience_category	STRING	The category of the audience, reflecting broad groups like "In-Market Category," "Affinity Category," etc., that help in targeting specific user interests.
audience_type	STRING	The specific type within the category, such as "Business Services," "Software," or "Employment," representing a more refined classification.
audience_segment	STRING	The specific segment within the type, like "Business Technology," "Accounting Software," or "Business Financial Services," indicating highly targeted user segments.
metric_impressions	FLOAT	The number of impressions generated by the audience segment.
metric_clicks	FLOAT	The number of clicks generated by the audience segment.
metric_total_conversions	FLOAT	The total number of conversions generated by the audience segment.
metric_active_view_viewable_impressions	FLOAT	The number of viewable impressions according to Active View standards.
metric_revenue_partner	FLOAT	The revenue attributed to the partner from the audience segment.
metric_revenue_advertiser	FLOAT	The revenue attributed to the advertiser from the audience segment.
metric_last_clicks	FLOAT	The number of last-click interactions attributed to the audience segment.
metric_last_impressions	FLOAT	The number of last-impression interactions attributed to the audience segment.
metric_cm360_post_click_revenue	FLOAT	The post-click revenue attributed through Campaign Manager 360 from the audience segment.
metric_cm360_post_view_revenue	FLOAT	The post-view revenue attributed through Campaign Manager 360 from the audience segment.
currency_variable	FLOAT	The conversion rate between the currency used by the advertiser and a variable or base currency, if applicable.
conversion_value	FLOAT	The total conversion value generated by the audience segment.
custom_post_click_revenue	FLOAT	The custom-calculated post-click revenue from the audience segment, according to specific reporting needs.
custom_post_view_revenue	FLOAT	The custom-calculated post-view revenue from the audience segment, according to specific reporting needs.
custom_conversion_value	FLOAT	The custom-calculated conversion value from the audience segment, according to specific reporting needs.
custom_cost	FLOAT	The custom-calculated cost associated with the audience segment, according to specific reporting needs.
channel_grouping	STRING	The grouping of channels used in the campaign, such as display, video, or native.
market_name	STRING	The name of the market or geographic region targeted by the campaign.

Table 4: dv360_performance_report_brand_safety_{table_suffix}

Full name	Type	Description
run_date	TIMESTAMP	The exact date and time when the report was generated.
run_id	STRING	A unique identifier for the report run, used for tracking and auditing purposes.
date	DATE	The date of the record.
filter_date	STRING	The filter applied to specify the date range for the data, typically in a string format (e.g., "last 7 days," "month to date").
filter_partner	STRING	The identifier for the partner associated with the brand safety data.
filter_partner_name	STRING	The name of the partner associated with the brand safety data.
filter_advertiser	STRING	The identifier for the advertiser associated with the brand safety data.
filter_advertiser_name	STRING	The name of the advertiser associated with the brand safety data.
filter_insertion_order_name	STRING	The name of the insertion order associated with the brand safety data.
filter_insertion_order	STRING	The identifier for the insertion order associated with the brand safety data.
filter_line_item_name	STRING	The name of the line item associated with the brand safety data.
filter_line_item	STRING	The identifier for the line item associated with the brand safety data.
filter_digital_content_label	STRING	The label assigned to the type of digital content, indicating its appropriateness, such as "DL-G" (General Audience), "DL-PG" (Parental Guidance), etc.
filter_sensitive_category	STRING	The sensitive category indicating the type of content that may not be suitable for certain brands, such as "None Detected," "Politics," or "Religion."
metric_verifiable_impressions	FLOAT	The number of impressions that were verified as brand-safe according to defined criteria.
channel_grouping	STRING	The grouping of channels through which the content was delivered, such as display, video, or native.
market_name	STRING	The name of the market or geographic region targeted by the campaign.

BigQuery tables behind Looker studio dashboard for the Channel grouping performance report v2

BigQuery tables behind Looker studio for the Creative insights report

BigQuery tables behind Looker studio dashboard for the Performance Max breakdown report v2

BigQuery tables behind Looker studio dashboard for the Search synergies report

BigQuery tables behind Looker studio dashboard for the Precis starter report