shopping_performance_view

Shopping performance view. Provides Shopping campaign statistics aggregated at several product dimension levels. Product dimension values from Merchant Center such as brand, category, custom attributes, product condition and product type will reflect the state of each dimension as of the date and time when the corresponding event was recorded.

Attributed resources
customer

Fields from the above resources may be selected along with this resource in your SELECT and WHERE clauses. These fields will not segment metrics in your SELECT clause.

Segmenting resources
ad_group
campaign

Fields from the above resources, when selected along with this resource in your SELECT and WHERE clauses, will segment metrics.

Fields/Segments/Metrics

This page shows all metrics and segments that can be put in the same SELECT clause as the fields of shopping_performance_view. However, when you specify shopping_performance_view in the FROM clause, some metrics and segments cannot be used. Use the following filter to show only the fields that can be used when shopping_performance_view is specified in the FROM clause.

Is shopping_performance_view specified in the FROM clause of your query?

No Yes, it is

Resource fields resource_name

Segments ad_network_type conversion_action conversion_action_category conversion_action_name date day_of_week device month product_bidding_category_level1 product_bidding_category_level2 product_bidding_category_level3 product_bidding_category_level4 product_bidding_category_level5 product_brand product_channel product_channel_exclusivity product_condition product_country product_custom_attribute0 product_custom_attribute1 product_custom_attribute2 product_custom_attribute3 product_custom_attribute4 product_item_id product_language product_store_id product_title product_type_l1 product_type_l2 product_type_l3 product_type_l4 product_type_l5 quarter week year

Metrics all_conversions all_conversions_by_conversion_date all_conversions_from_interactions_rate all_conversions_value all_conversions_value_by_conversion_date average_cpc clicks client_account_conversions client_account_conversions_value conversions conversions_from_interactions_rate conversions_value cost_micros cost_per_all_conversions cost_per_conversion cross_device_conversions cross_device_conversions_by_conversion_date cross_device_conversions_value cross_device_conversions_value_by_conversion_date ctr impressions search_absolute_top_impression_share search_click_share search_impression_share value_per_all_conversions value_per_conversion

shopping_performance_view.resource_name Field description The resource name of the Shopping performance view. Shopping performance view resource names have the form: customers/{customer_id}/shoppingPerformanceView Category ATTRIBUTE Data Type RESOURCE_NAME Type URL N/A Filterable False Selectable True Sortable False Repeated False

segments.ad_network_type Field description Ad network type. Category SEGMENT Data Type ENUM CONTENT MIXED SEARCH SEARCH_PARTNERS UNKNOWN UNSPECIFIED YOUTUBE_SEARCH YOUTUBE_WATCH Type URL google.ads.searchads360.v0.enums.AdNetworkTypeEnum.AdNetworkType Filterable True Selectable True Sortable True Repeated False

segments.conversion_action Field description Resource name of the conversion action. Category SEGMENT Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.conversion_action_category Field description Conversion action category. Category SEGMENT Data Type ENUM ADD_TO_CART BEGIN_CHECKOUT BOOK_APPOINTMENT CONTACT CONVERTED_LEAD DEFAULT DOWNLOAD ENGAGEMENT GET_DIRECTIONS IMPORTED_LEAD LEAD OUTBOUND_CLICK PAGE_VIEW PHONE_CALL_LEAD PURCHASE QUALIFIED_LEAD REQUEST_QUOTE SIGNUP STORE_SALE STORE_VISIT SUBMIT_LEAD_FORM SUBSCRIBE_PAID UNKNOWN UNSPECIFIED Type URL google.ads.searchads360.v0.enums.ConversionActionCategoryEnum.ConversionActionCategory Filterable True Selectable True Sortable True Repeated False

segments.conversion_action_name Field description Conversion action name. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.date Field description Date to which metrics apply. yyyy-MM-dd format, for example, 2018-04-17. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.day_of_week Field description Day of the week, for example, MONDAY. Category SEGMENT Data Type ENUM FRIDAY MONDAY SATURDAY SUNDAY THURSDAY TUESDAY UNKNOWN UNSPECIFIED WEDNESDAY Type URL google.ads.searchads360.v0.enums.DayOfWeekEnum.DayOfWeek Filterable True Selectable True Sortable True Repeated False

segments.device Field description Device to which metrics apply. Category SEGMENT Data Type ENUM CONNECTED_TV DESKTOP MOBILE OTHER TABLET UNKNOWN UNSPECIFIED Type URL google.ads.searchads360.v0.enums.DeviceEnum.Device Filterable True Selectable True Sortable True Repeated False

segments.month Field description Month as represented by the date of the first day of a month. Formatted as yyyy-MM-dd. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.product_bidding_category_level1 Field description Bidding category (level 1) of the product. Category SEGMENT Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

segments.product_bidding_category_level2 Field description Bidding category (level 2) of the product. Category SEGMENT Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

segments.product_bidding_category_level3 Field description Bidding category (level 3) of the product. Category SEGMENT Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

segments.product_bidding_category_level4 Field description Bidding category (level 4) of the product. Category SEGMENT Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

segments.product_bidding_category_level5 Field description Bidding category (level 5) of the product. Category SEGMENT Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable False Repeated False

segments.product_brand Field description Brand of the product. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.product_channel Field description Channel of the product. Category SEGMENT Data Type ENUM LOCAL ONLINE UNKNOWN UNSPECIFIED Type URL google.ads.searchads360.v0.enums.ProductChannelEnum.ProductChannel Filterable True Selectable True Sortable True Repeated False

segments.product_channel_exclusivity Field description Channel exclusivity of the product. Category SEGMENT Data Type ENUM MULTI_CHANNEL SINGLE_CHANNEL UNKNOWN UNSPECIFIED Type URL google.ads.searchads360.v0.enums.ProductChannelExclusivityEnum.ProductChannelExclusivity Filterable True Selectable True Sortable True Repeated False

segments.product_condition Field description Condition of the product. Category SEGMENT Data Type ENUM NEW OLD REFURBISHED UNKNOWN UNSPECIFIED USED Type URL google.ads.searchads360.v0.enums.ProductConditionEnum.ProductCondition Filterable True Selectable True Sortable True Repeated False

segments.product_country Field description Resource name of the geo target constant for the country of sale of the product. Category SEGMENT Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.product_custom_attribute0 Field description Custom attribute 0 of the product. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.product_custom_attribute1 Field description Custom attribute 1 of the product. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.product_custom_attribute2 Field description Custom attribute 2 of the product. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.product_custom_attribute3 Field description Custom attribute 3 of the product. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.product_custom_attribute4 Field description Custom attribute 4 of the product. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.product_item_id Field description Item ID of the product. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.product_language Field description Resource name of the language constant for the language of the product. Category SEGMENT Data Type RESOURCE_NAME Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.product_store_id Field description Store ID of the product. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.product_title Field description Title of the product. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.product_type_l1 Field description Type (level 1) of the product. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.product_type_l2 Field description Type (level 2) of the product. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.product_type_l3 Field description Type (level 3) of the product. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.product_type_l4 Field description Type (level 4) of the product. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.product_type_l5 Field description Type (level 5) of the product. Category SEGMENT Data Type STRING Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.quarter Field description Quarter as represented by the date of the first day of a quarter. Uses the calendar year for quarters, for example, the second quarter of 2018 starts on 2018-04-01. Formatted as yyyy-MM-dd. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.week Field description Week as defined as Monday through Sunday, and represented by the date of Monday. Formatted as yyyy-MM-dd. Category SEGMENT Data Type DATE Type URL N/A Filterable True Selectable True Sortable True Repeated False

segments.year Field description Year, formatted as yyyy. Category SEGMENT Data Type INT32 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions Field description The total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_by_conversion_date Field description The total number of conversions. This includes all conversions regardless of the value of include_in_conversions_metric. When this column is selected with date, the values in date column means the conversion date. Details for the by_conversion_date columns are available at https://support.google.com/sa360/answer/9250611. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_from_interactions_rate Field description All conversions from interactions (as oppose to view through conversions) divided by the number of ad interactions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_value Field description The value of all conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.all_conversions_value_by_conversion_date Field description The value of all conversions. When this column is selected with date, the values in date column means the conversion date. Details for the by_conversion_date columns are available at https://support.google.com/sa360/answer/9250611. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.average_cpc Field description The total cost of all clicks divided by the total number of clicks received. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.clicks Field description The number of clicks. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.client_account_conversions Field description The number of client account conversions. This only includes conversion actions which include_in_client_account_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.client_account_conversions_value Field description The value of client account conversions. This only includes conversion actions which include_in_client_account_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.conversions Field description The number of conversions. This only includes conversion actions which include_in_conversions_metric attribute is set to true. If you use conversion-based bidding, your bid strategies will optimize for these conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.conversions_from_interactions_rate Field description Average biddable conversions (from interaction) per conversion eligible interaction. Shows how often, on average, an ad interaction leads to a biddable conversion. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.conversions_value Field description The sum of conversion values for the conversions included in the "conversions" field. This metric is useful only if you entered a value for your conversion actions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.cost_micros Field description The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. This metric is a monetary value and returned in the customer's currency by default. See the metrics_currency parameter at https://developers.google.com/search-ads/reporting/query/query-structure#parameters_clause Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.cost_per_all_conversions Field description The cost of ad interactions divided by all conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.cost_per_conversion Field description Average conversion eligible cost per biddable conversion. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.cross_device_conversions Field description Conversions from when a customer clicks on an ad on one device, then converts on a different device or browser. Cross-device conversions are already included in all_conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.cross_device_conversions_by_conversion_date Field description The number of cross-device conversions by conversion date. Details for the by_conversion_date columns are available at https://support.google.com/sa360/answer/9250611. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.cross_device_conversions_value Field description The sum of the value of cross-device conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.cross_device_conversions_value_by_conversion_date Field description The sum of cross-device conversions value by conversion date. Details for the by_conversion_date columns are available at https://support.google.com/sa360/answer/9250611. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.ctr Field description The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions). Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.impressions Field description Count of how often your ad has appeared on a search results page or website on the Google Network. Category METRIC Data Type INT64 Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.search_absolute_top_impression_share Field description The percentage of the customer's Shopping or Search ad impressions that are shown in the most prominent Shopping position. See https://support.google.com/sa360/answer/9566729 for details. Any value below 0.1 is reported as 0.0999. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.search_click_share Field description The number of clicks you've received on the Search Network divided by the estimated number of clicks you were eligible to receive. Note: Search click share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.search_impression_share Field description The impressions you've received on the Search Network divided by the estimated number of impressions you were eligible to receive. Note: Search impression share is reported in the range of 0.1 to 1. Any value below 0.1 is reported as 0.0999. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.value_per_all_conversions Field description The value of all conversions divided by the number of all conversions. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False

metrics.value_per_conversion Field description The value of biddable conversion divided by the number of biddable conversions. Shows how much, on average, each of the biddable conversions is worth. Category METRIC Data Type DOUBLE Type URL N/A Filterable True Selectable True Sortable True Repeated False