BigQuery tables behind Looker studio dashboard for the Performance Max breakdown report v2 | 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 Performance Max campaigns in Google Ads, broken down by placement (display, shopping, video, search, and other).

This query retrieves and summarises Performance Max campaign data, focusing on total cost, impressions, clicks, conversions, and conversion value for each placement type, starting from 1 January 2023. It groups the data by campaign name and placement to provide a clear summary of performance metrics across different campaigns and placements:

SELECT 
  campaign__name, 
  placement, 
  SUM(cost) AS total_cost, 
  SUM(metrics__impressions) AS total_impressions, 
  SUM(metrics__clicks) AS total_clicks, 
  SUM(metrics__conversions) AS total_conversions,     SUM(metrics__conversions_value) AS total_conversion_value 
FROM `project.dataset.pmax_breakdown_report_v2_{table_suffix}` 
WHERE date >= '2023-01-01' 
GROUP BY 
  campaign__name, 
  placement 
ORDER BY 
  campaign__name, 
  placement

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

Table 1: pmax_breakdown_report_v2_{table_suffix}

Full name	Type	Description
date	DATE	The date of the record.
customer__id	STRING	The ID of the customer.
customer__currency_code	STRING	The currency code used by the customer.
customer__descriptive_name	STRING	The descriptive name of the customer.
campaign__name	STRING	The name of the campaign.
campaign__id	STRING	The ID of the campaign.
custom_currency	STRING	The custom currency used for unified currency calculations.
placement	STRING	The type of placement (e.g., display, shopping, video, search, other).
cost	FLOAT	The cost of the ads.
metrics__impressions	FLOAT	The number of impressions.
metrics__clicks	FLOAT	The number of clicks.
cpm	FLOAT	The cost per thousand impressions (CPM).
video_views	FLOAT	The number of video views.
video_cpv	FLOAT	The cost per video view (CPV).
metrics__conversions	FLOAT	The number of conversions.
metrics__conversions_value	FLOAT	The value of conversions.
cpa	FLOAT	The cost per acquisition (CPA).
campaign_total_cost	FLOAT	The total cost of the campaign.
campaign_total_impressions	FLOAT	The total number of impressions for the campaign.
campaign_total_clicks	FLOAT	The total number of clicks for the campaign.
campaign_total_metrics__conversions	FLOAT	The total number of conversions for the campaign.
campaign_total_metrics__conversions_value	FLOAT	The total conversion value for the campaign.
custom_cost	FLOAT	The custom cost in unified currency.
custom_cpm	FLOAT	The custom cost per thousand impressions (CPM) in unified currency.
custom_cpv	FLOAT	The custom cost per video view (CPV) in unified currency.
custom_conversion_value	FLOAT	The custom conversion value in unified currency.
custom_cpa	FLOAT	The custom cost per acquisition (CPA) in unified currency.
custom_campaign_total_cost	FLOAT	The custom total cost of the campaign in unified currency.
custom_campaign_total_conversion_value	FLOAT	The custom total conversion value of the campaign in unified currency.
percentage_spend	FLOAT	The percentage of the total spend.

Table 2: pmax_breakdown_v2_assets_{table_suffix}

Full name	Type	Description
date	DATE	The date of the record.
campaign__name	STRING	The name of the campaign.
campaign__id	STRING	The ID of the campaign.
asset__resource_name	STRING	The resource name of the asset.
customer__id	STRING	The ID of the customer.
customer__currency_code	STRING	The currency code used by the customer.
customer__descriptive_name	STRING	The descriptive name of the customer.
custom_currency	STRING	The custom currency used for unified currency calculations.
asset__type	STRING	The type of asset (e.g., image, video, text).
asset_group_asset__field_type	STRING	The field type of the asset group asset.
asset_group_asset__asset	STRING	The asset group asset.
asset__discovery_carousel_card_asset__headline	STRING	The headline of the discovery carousel card asset.
asset__name	STRING	The name of the asset.
asset__text_asset__text	STRING	The text content of the text asset.
asset__image_asset__full_size__url	STRING	The URL of the full-size image asset.
asset__youtube_video_asset__youtube_video_title	STRING	The title of the YouTube video asset.
asset__youtube_video_asset__youtube_video_id	STRING	The ID of the YouTube video asset.
asset__dynamic_custom_asset__image_url	STRING	The URL of the image in the dynamic custom asset.
asset_group_asset__status	STRING	The status of the asset group asset (e.g., enabled, paused).
asset_group_asset__performance_label	STRING	The performance label of the asset group asset.
campaign__advertising_channel_type	STRING	The advertising channel type of the campaign (e.g., search, display).
cost	FLOAT	The cost of the ads.
metrics__impressions	FLOAT	The number of impressions.
metrics__video_views	FLOAT	The number of video views.
metrics__clicks	FLOAT	The number of clicks.
metrics__conversions	FLOAT	The number of conversions.
metrics__conversions_value	FLOAT	The value of conversions.
custom_cost	FLOAT	The custom cost in unified currency.
custom_conversion_value	FLOAT	The custom conversion value in unified currency.

Table 3: pmax_breakdown_v2_conv_{table_suffix}

Full name	Type	Description
date	DATE	The date of the record.
customer__id	STRING	The ID of the customer.
customer__currency_code	STRING	The currency code used by the customer.
customer__descriptive_name	STRING	The descriptive name of the customer.
campaign__name	STRING	The name of the campaign.
campaign__id	STRING	The ID of the campaign.
custom_currency	STRING	The custom currency used for unified currency calculations.
placement	STRING	The type of placement (e.g., display, shopping, video, search, other).
segments__conversion_action_name	STRING	The name of the conversion action segment.
metrics__all_conversions	FLOAT	The total number of all conversions.
metrics__all_conversions_value	FLOAT	The total value of all conversions.
metrics__cross_device_conversions	FLOAT	The total number of cross-device conversions.
campaign_total_all_conversions	FLOAT	The total number of all conversions for the campaign.
campaign_total_all_conversions_value	FLOAT	The total value of all conversions for the campaign.
campaign_total_cross_device_conversions	FLOAT	The total number of cross-device conversions for the campaign.
custom_cost	FLOAT	The custom cost in unified currency.
custom_conversion_value	FLOAT	The custom conversion value in unified currency.

Table 4: pmax_breakdown_v2_placements_{table_suffix}

Full name	Type	Description
date	DATE	The date of the record.
segments__date	STRING	The segmented date as a string.
customer__currency_code	STRING	The currency code used by the customer.
customer__descriptive_name	STRING	The descriptive name of the customer.
customer__time_zone	STRING	The time zone of the customer.
customer__id	STRING	The ID of the customer.
custom_currency	STRING	The custom currency used for unified currency calculations.
campaign__name	STRING	The name of the campaign.
campaign__id	STRING	The ID of the campaign.
campaign__advertising_channel_type	STRING	The advertising channel type of the campaign (e.g., search, display).
detail_placement_view__display_name	STRING	The display name of the placement.
detail_placement_view__placement	STRING	The placement of the ad (e.g., website, app).
detail_placement_view__target_url	STRING	The target URL of the placement.
detail_placement_view__group_placement_target_url	STRING	The group placement target URL.
detail_placement_view__placement_type	STRING	The type of placement (e.g., video, display).
metrics__impressions	FLOAT	The number of impressions.
metrics__clicks	FLOAT	The number of clicks.
metrics__conversions	FLOAT	The number of conversions.
metrics__video_views	FLOAT	The number of video views.
metrics__video_view_rate	FLOAT	The video view rate.
metrics__interactions	FLOAT	The number of interactions.
metrics__view_through_conversions	FLOAT	The number of view-through conversions.
cost	FLOAT	The cost of the ads.
metrics__active_view_impressions	FLOAT	The number of active view impressions.
metrics__engagements	FLOAT	The number of engagements.
custom_cost	FLOAT	The custom cost in unified currency.
custom_conversion_value	FLOAT	The custom conversion value in unified currency.

Table 5: pmax_breakdown_v2_products_{table_suffix}

Full name	Type	Description
date	DATE	The date of the record.
customer__id	STRING	The ID of the customer.
customer__descriptive_name	STRING	The descriptive name of the customer.
segments__product_merchant_id	STRING	The ID of the product merchant segment.
customer__currency_code	STRING	The currency code used by the customer.
custom_currency	STRING	The custom currency used for unified currency calculations.
segments__product_item_id	STRING	The ID of the product item segment.
campaign__id	STRING	The ID of the campaign.
campaign__name	STRING	The name of the campaign.
title	STRING	The title of the product.
image_link	STRING	The link to the product image.
link	STRING	The link to the product page.
brand	STRING	The brand of the product.
product_type	STRING	The type of the product.
ProductTypeL1	STRING	The first level of product type classification.
ProductTypeL2	STRING	The second level of product type classification.
ProductTypeL3	STRING	The third level of product type classification.
ProductTypeL4	STRING	The fourth level of product type classification.
ProductTypeL5	STRING	The fifth level of product type classification.
metrics__clicks	FLOAT	The number of clicks.
metrics__conversions	FLOAT	The number of conversions.
custom_cost	FLOAT	The custom cost in unified currency.
custom_conversion_value	FLOAT	The custom conversion value in unified currency.

BigQuery tables behind Looker studio for the Creative insights report

BigQuery tables behind Looker studio for the DV360 performance report

BigQuery tables behind Looker studio dashboard for the Facebook visual creative report

BigQuery tables behind Looker studio dashboard for the Google Ads keyword quality score dashboard

BigQuery tables behind Looker studio dashboard for the Shopping insights report v2