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?

Resource fields
resource_name

Segments
ad_network_type
click_type
conversion_action
conversion_action_category
conversion_action_name
date
day_of_week
device
external_conversion_source
month
product_aggregator_id
product_brand
product_category_level1
product_category_level2
product_category_level3
product_category_level4
product_category_level5
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_feed_label
product_item_id
product_language
product_merchant_id
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_from_interactions_rate
all_conversions_value
average_cart_size
average_cpc
average_order_value_micros
clicks
conversions
conversions_from_interactions_rate
conversions_value
cost_micros
cost_of_goods_sold_micros
cost_per_all_conversions
cost_per_conversion
cross_device_conversions
cross_device_conversions_value_micros
cross_sell_cost_of_goods_sold_micros
cross_sell_gross_profit_micros
cross_sell_revenue_micros
cross_sell_units_sold
ctr
gross_profit_margin
gross_profit_micros
impressions
lead_cost_of_goods_sold_micros
lead_gross_profit_micros
lead_revenue_micros
lead_units_sold
orders
revenue_micros
search_absolute_top_impression_share
search_click_share
search_impression_share
units_sold
value_per_all_conversions
value_per_conversion

shopping_performance_view.resource_name
Field description	Output only. 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 GOOGLE_TV MIXED SEARCH SEARCH_PARTNERS UNKNOWN UNSPECIFIED YOUTUBE`
Type URL	`google.ads.googleads.v17.enums.AdNetworkTypeEnum.AdNetworkType`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

segments.click_type
Field description	Click type.
Category	`SEGMENT`
Data Type	ENUM AD_IMAGE APP_DEEPLINK BREADCRUMBS BROADBAND_PLAN CALLS CALL_TRACKING CLICK_ON_ENGAGEMENT_AD CROSS_NETWORK GET_DIRECTIONS HOTEL_BOOK_ON_GOOGLE_ROOM_SELECTION HOTEL_PRICE LOCATION_EXPANSION LOCATION_FORMAT_CALL LOCATION_FORMAT_DIRECTIONS LOCATION_FORMAT_IMAGE LOCATION_FORMAT_LANDING_PAGE LOCATION_FORMAT_MAP LOCATION_FORMAT_STORE_INFO LOCATION_FORMAT_TEXT MOBILE_CALL_TRACKING OFFER_PRINTS OTHER PRICE_EXTENSION PRODUCT_AD_APP_DEEPLINK PRODUCT_EXTENSION_CLICKS PRODUCT_LISTING_ADS_COUPON PRODUCT_LISTING_AD_CLICKS PRODUCT_LISTING_AD_LOCAL PRODUCT_LISTING_AD_MULTICHANNEL_LOCAL PRODUCT_LISTING_AD_MULTICHANNEL_ONLINE PRODUCT_LISTING_AD_TRANSACTABLE PROMOTION_EXTENSION SHOPPING_COMPARISON_LISTING SHOWCASE_AD_CATEGORY_LINK SHOWCASE_AD_LOCAL_PRODUCT_LINK SHOWCASE_AD_LOCAL_STOREFRONT_LINK SHOWCASE_AD_ONLINE_PRODUCT_LINK SITELINKS STORE_LOCATOR SWIPEABLE_GALLERY_AD_HEADLINE SWIPEABLE_GALLERY_AD_SEE_MORE SWIPEABLE_GALLERY_AD_SITELINK_FIVE SWIPEABLE_GALLERY_AD_SITELINK_FOUR SWIPEABLE_GALLERY_AD_SITELINK_ONE SWIPEABLE_GALLERY_AD_SITELINK_THREE SWIPEABLE_GALLERY_AD_SITELINK_TWO SWIPEABLE_GALLERY_AD_SWIPES UNKNOWN UNSPECIFIED URL_CLICKS VIDEO_APP_STORE_CLICKS VIDEO_CALL_TO_ACTION_CLICKS VIDEO_CARD_ACTION_HEADLINE_CLICKS VIDEO_END_CAP_CLICKS VIDEO_WEBSITE_CLICKS VISUAL_SITELINKS WIRELESS_PLAN
Type URL	`google.ads.googleads.v17.enums.ClickTypeEnum.ClickType`
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 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.googleads.v17.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.googleads.v17.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.googleads.v17.enums.DeviceEnum.Device`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

segments.external_conversion_source
Field description	External conversion source.
Category	`SEGMENT`
Data Type	`ENUM AD_CALL_METRICS ANALYTICS ANALYTICS_SEARCH_ADS_360 ANDROID_FIRST_OPEN ANDROID_IN_APP APP_UNSPECIFIED CLICK_TO_CALL DISPLAY_AND_VIDEO_360_FLOODLIGHT FIREBASE FIREBASE_SEARCH_ADS_360 FLOODLIGHT GOOGLE_ATTRIBUTION GOOGLE_HOSTED GOOGLE_PLAY IOS_FIRST_OPEN IOS_IN_APP SALESFORCE SEARCH_ADS_360 STORE_SALES STORE_SALES_CRM STORE_SALES_DIRECT_UPLOAD STORE_SALES_PAYMENT_NETWORK STORE_VISITS THIRD_PARTY_APP_ANALYTICS UNKNOWN UNSPECIFIED UPLOAD UPLOAD_CALLS WEBPAGE WEBSITE_CALL_METRICS`
Type URL	`google.ads.googleads.v17.enums.ExternalConversionSourceEnum.ExternalConversionSource`
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_aggregator_id
Field description	Aggregator ID of the product.
Category	`SEGMENT`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
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_category_level1
Field description	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_category_level2
Field description	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_category_level3
Field description	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_category_level4
Field description	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_category_level5
Field description	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_channel
Field description	Channel of the product.
Category	`SEGMENT`
Data Type	`ENUM LOCAL ONLINE UNKNOWN UNSPECIFIED`
Type URL	`google.ads.googleads.v17.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.googleads.v17.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 REFURBISHED UNKNOWN UNSPECIFIED USED`
Type URL	`google.ads.googleads.v17.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_feed_label
Field description	Feed label 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_merchant_id
Field description	Merchant ID of the product.
Category	`SEGMENT`
Data Type	`INT64`
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_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.average_cart_size
Field description	Average cart size is the average number of products in each order attributed to your ads. How it works: You report conversions with cart data for completed purchases on your website. Average cart size is the total number of products sold divided by the total number of orders you received. Example: You received 2 orders, the first included 3 products and the second included 2. The average cart size is 2.5 products = (3+2)/2. This metric is only available if you report conversions with cart data.
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.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.average_order_value_micros
Field description	Average order value is the average revenue you made per order attributed to your ads. How it works: You report conversions with cart data for completed purchases on your website. Average order value is the total revenue from your orders divided by the total number of orders. Example: You received 3 orders which made $10, $15 and $20 worth of revenue. The average order value is $15 = ($10 + $15 + $20)/3. This metric is only available if you report conversions with cart data.
Category	`METRIC`
Data Type	`INT64`
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.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	Conversions from interactions divided by the number of ad interactions (such as clicks for text ads or views for video ads). 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_value
Field description	The value 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.cost_micros
Field description	The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.cost_of_goods_sold_micros
Field description	Cost of goods sold (COGS) is the total cost of the products you sold in orders attributed to your ads. How it works: You can add a cost of goods sold value to every product in Merchant Center. If you report conversions with cart data, the products you sold are matched with their cost of goods sold value and this can be used to calculate the gross profit you made on each order. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt. The hat has a cost of goods sold value of $3, the shirt has a cost of goods sold value of $5. The cost of goods sold for this order is $8 = $3 + $5. This metric is only available if you report conversions with cart data.
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	The cost of ad interactions divided by 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.cross_device_conversions
Field description	Conversions from when a customer clicks on a Google Ads 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_value_micros
Field description	The sum of the value of cross-device conversions, in micros.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.cross_sell_cost_of_goods_sold_micros
Field description	Cross-sell cost of goods sold (COGS) is the total cost of products sold as a result of advertising a different product. How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with before the purchase has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the order the customer places is a sold product. If these products don't match then this is considered cross-sell. Cross-sell cost of goods sold is the total cost of the products sold that weren't advertised. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt. The hat has a cost of goods sold value of $3, the shirt has a cost of goods sold value of $5. The cross-sell cost of goods sold for this order is $5. This metric is only available if you report conversions with cart data.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.cross_sell_gross_profit_micros
Field description	Cross-sell gross profit is the profit you made from products sold as a result of advertising a different product, minus cost of goods sold (COGS). How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with before the purchase has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the purchase is a sold product. If these products don't match then this is considered cross-sell. Cross-sell gross profit is the revenue you made from cross-sell attributed to your ads minus the cost of the goods sold. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt. The shirt is priced $20 and has a cost of goods sold value of $5. The cross-sell gross profit of this order is $15 = $20 - $5. This metric is only available if you report conversions with cart data.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.cross_sell_revenue_micros
Field description	Cross-sell revenue is the total amount you made from products sold as a result of advertising a different product. How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with before the purchase has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the order the customer places is a sold product. If these products don't match then this is considered cross-sell. Cross-sell revenue is the total value you made from cross-sell attributed to your ads. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt. The hat is priced $10 and the shirt is priced $20. The cross-sell revenue of this order is $20. This metric is only available if you report conversions with cart data.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.cross_sell_units_sold
Field description	Cross-sell units sold is the total number of products sold as a result of advertising a different product. How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with before the purchase has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the order the customer places is a sold product. If these products don't match then this is considered cross-sell. Cross-sell units sold is the total number of cross-sold products from all orders attributed to your ads. Example: Someone clicked on a Shopping ad for a hat then bought the same hat, a shirt and a jacket. The cross-sell units sold in this order is 2. This metric is only available if you report conversions with cart data.
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.gross_profit_margin
Field description	Gross profit margin is the percentage gross profit you made from orders attributed to your ads, after taking out the cost of goods sold (COGS). How it works: You report conversions with cart data for completed purchases on your website. Gross profit margin is the gross profit you made divided by your total revenue and multiplied by 100%. Gross profit margin calculations only include products that have a cost of goods sold value in Merchant Center. Example: Someone bought a hat and a shirt in an order on your website. The hat is priced $10 and has a cost of goods sold value of $3. The shirt is priced $20 but has no cost of goods sold value. Gross profit margin for this order will only take into account the hat because it has a cost of goods sold value, so it's 70% = ($10 - $3)/$10 x 100%. This metric is only available if you report conversions with cart data.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.gross_profit_micros
Field description	Gross profit is the profit you made from orders attributed to your ads minus the cost of goods sold (COGS). How it works: Gross profit is the revenue you made from sales attributed to your ads minus cost of goods sold. Gross profit calculations only include products that have a cost of goods sold value in Merchant Center. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt in an order from your website. The hat is priced $10 and the shirt is priced $20. The hat has a cost of goods sold value of $3, but the shirt has no cost of goods sold value. Gross profit for this order will only take into account the hat, so it's $7 = $10 - $3. This metric is only available if you report conversions with cart data.
Category	`METRIC`
Data Type	`INT64`
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.lead_cost_of_goods_sold_micros
Field description	Lead cost of goods sold (COGS) is the total cost of products sold as a result of advertising the same product. How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the order the customer places is a sold product. If the advertised and sold products match, then the cost of these goods is counted under lead cost of goods sold. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt. The hat has a cost of goods sold value of $3, the shirt has a cost of goods sold value of $5. The lead cost of goods sold for this order is $3. This metric is only available if you report conversions with cart data.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.lead_gross_profit_micros
Field description	Lead gross profit is the profit you made from products sold as a result of advertising the same product, minus cost of goods sold (COGS). How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with before the purchase has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the order the customer places is a sold product. If the advertised and sold products match, then the revenue you made from these sales minus the cost of goods sold is your lead gross profit. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt. The hat is priced $10 and has a cost of goods sold value of $3. The lead gross profit of this order is $7 = $10 - $3. This metric is only available if you report conversions with cart data.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.lead_revenue_micros
Field description	Lead revenue is the total amount you made from products sold as a result of advertising the same product. How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with before the purchase has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the order the customer places is a sold product. If the advertised and sold products match, then the total value you made from the sales of these products is shown under lead revenue. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt. The hat is priced $10 and the shirt is priced $20. The lead revenue of this order is $10. This metric is only available if you report conversions with cart data.
Category	`METRIC`
Data Type	`INT64`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.lead_units_sold
Field description	Lead units sold is the total number of products sold as a result of advertising the same product. How it works: You report conversions with cart data for completed purchases on your website. If the ad that was interacted with before the purchase has an associated product (see Shopping Ads) then this product is considered the advertised product. Any product included in the order the customer places is a sold product. If the advertised and sold products match, then the total number of these products sold is shown under lead units sold. Example: Someone clicked on a Shopping ad for a hat then bought the same hat, a shirt and a jacket. The lead units sold in this order is 1. This metric is only available if you report conversions with cart data.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.orders
Field description	Orders is the total number of purchase conversions you received attributed to your ads. How it works: You report conversions with cart data for completed purchases on your website. If a conversion is attributed to previous interactions with your ads (clicks for text or Shopping ads, views for video ads etc.) it's counted as an order. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt in an order on your website. Even though they bought 2 products, this would count as 1 order. This metric is only available if you report conversions with cart data.
Category	`METRIC`
Data Type	`DOUBLE`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

metrics.revenue_micros
Field description	Revenue is the total amount you made from orders attributed to your ads. How it works: You report conversions with cart data for completed purchases on your website. Revenue is the total value of all the orders you received attributed to your ads, minus any discount. Example: Someone clicked on a Shopping ad for a hat then bought the same hat and a shirt in an order from your website. The hat is priced $10 and the shirt is priced $20. The entire order has a $5 discount. The revenue from this order is $25 = ($10 + $20) - $5. This metric is only available if you report conversions with cart data.
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/google-ads/answer/7501826 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.units_sold
Field description	Units sold is the total number of products sold from orders attributed to your ads. How it works: You report conversions with cart data for completed purchases on your website. Units sold is the total number of products sold from all orders attributed to your ads. Example: Someone clicked on a Shopping ad for a hat then bought the same hat, a shirt and a jacket. The units sold in this order is 3. This metric is only available if you report conversions with cart data.
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 conversions divided by 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

shopping_performance_view

Fields/Segments/Metrics

shopping_performance_view.resource_name

segments.ad_network_type

segments.click_type

segments.conversion_action

segments.conversion_action_category

segments.conversion_action_name

segments.date

segments.day_of_week

segments.device

segments.external_conversion_source

segments.month

segments.product_aggregator_id

segments.product_brand

segments.product_category_level1

segments.product_category_level2

segments.product_category_level3

segments.product_category_level4

segments.product_category_level5

segments.product_channel

segments.product_channel_exclusivity

segments.product_condition

segments.product_country

segments.product_custom_attribute0

segments.product_custom_attribute1

segments.product_custom_attribute2

segments.product_custom_attribute3

segments.product_custom_attribute4

segments.product_feed_label

segments.product_item_id

segments.product_language

segments.product_merchant_id

segments.product_store_id

segments.product_title

segments.product_type_l1

segments.product_type_l2

segments.product_type_l3

segments.product_type_l4

segments.product_type_l5

segments.quarter

segments.week

segments.year

metrics.all_conversions

metrics.all_conversions_from_interactions_rate

metrics.all_conversions_value

metrics.average_cart_size

metrics.average_cpc

metrics.average_order_value_micros

metrics.clicks

metrics.conversions

metrics.conversions_from_interactions_rate

metrics.conversions_value

metrics.cost_micros

metrics.cost_of_goods_sold_micros

metrics.cost_per_all_conversions

metrics.cost_per_conversion

metrics.cross_device_conversions

metrics.cross_device_conversions_value_micros

metrics.cross_sell_cost_of_goods_sold_micros

metrics.cross_sell_gross_profit_micros

metrics.cross_sell_revenue_micros

metrics.cross_sell_units_sold

metrics.ctr

metrics.gross_profit_margin

metrics.gross_profit_micros

metrics.impressions

metrics.lead_cost_of_goods_sold_micros

metrics.lead_gross_profit_micros

metrics.lead_revenue_micros

metrics.lead_units_sold

metrics.orders

metrics.revenue_micros

metrics.search_absolute_top_impression_share

metrics.search_click_share

metrics.search_impression_share

metrics.units_sold

metrics.value_per_all_conversions

metrics.value_per_conversion