The new Search Ads 360 Reporting API is now available. Join the searchads-api-announcements Google group to stay up to date on upcoming enhancements and releases.

cart_data_sales_view

Cart data sales view.

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 cart_data_sales_view. However, when you specify cart_data_sales_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 cart_data_sales_view is specified in the FROM clause.

Is cart_data_sales_view specified in the FROM clause of your query?

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_sold_bidding_category_level1
product_sold_bidding_category_level2
product_sold_bidding_category_level3
product_sold_bidding_category_level4
product_sold_bidding_category_level5
product_sold_brand
product_sold_condition
product_sold_custom_attribute0
product_sold_custom_attribute1
product_sold_custom_attribute2
product_sold_custom_attribute3
product_sold_custom_attribute4
product_sold_item_id
product_sold_title
product_sold_type_l1
product_sold_type_l2
product_sold_type_l3
product_sold_type_l4
product_sold_type_l5
product_store_id
product_title
product_type_l1
product_type_l2
product_type_l3
product_type_l4
product_type_l5
quarter
week
year

Metrics
client_account_cross_sell_cost_of_goods_sold_micros
client_account_cross_sell_gross_profit_micros
client_account_cross_sell_revenue_micros
client_account_cross_sell_units_sold
client_account_lead_cost_of_goods_sold_micros
client_account_lead_gross_profit_micros
client_account_lead_revenue_micros
client_account_lead_units_sold
cross_sell_cost_of_goods_sold_micros
cross_sell_gross_profit_micros
cross_sell_revenue_micros
cross_sell_units_sold
lead_cost_of_goods_sold_micros
lead_gross_profit_micros
lead_revenue_micros
lead_units_sold

cart_data_sales_view.resource_name
Field description	The resource name of the Cart data sales view. Cart data sales view resource names have the form: `customers/{customer_id}/cartDataSalesView`
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_sold_bidding_category_level1
Field description	Bidding category (level 1) of the product sold.
Category	`SEGMENT`
Data Type	`RESOURCE_NAME`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	False
Repeated	False

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

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

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

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

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

segments.product_sold_condition
Field description	Condition of the product sold.
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_sold_custom_attribute0
Field description	Custom attribute 0 of the product sold.
Category	`SEGMENT`
Data Type	`STRING`
Type URL	`N/A`
Filterable	True
Selectable	True
Sortable	True
Repeated	False

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

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

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

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

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

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

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

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

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

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

segments.product_sold_type_l5
Field description	Type (level 5) of the product sold.
Category	`SEGMENT`
Data Type	`STRING`
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.client_account_cross_sell_cost_of_goods_sold_micros
Field description	Client account 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. 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.client_account_cross_sell_gross_profit_micros
Field description	Client account 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. 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.client_account_cross_sell_revenue_micros
Field description	Client account 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. 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.client_account_cross_sell_units_sold
Field description	Client account 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.client_account_lead_cost_of_goods_sold_micros
Field description	Client account 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. 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.client_account_lead_gross_profit_micros
Field description	Client account 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. 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.client_account_lead_revenue_micros
Field description	Client account 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. 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.client_account_lead_units_sold
Field description	Client account 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.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. 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.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. 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.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. 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.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.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. 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.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. 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.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. 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.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

cart_data_sales_view

Fields/Segments/Metrics

cart_data_sales_view.resource_name

segments.ad_network_type

segments.conversion_action

segments.conversion_action_category

segments.conversion_action_name

segments.date

segments.day_of_week

segments.device

segments.month

segments.product_bidding_category_level1

segments.product_bidding_category_level2

segments.product_bidding_category_level3

segments.product_bidding_category_level4

segments.product_bidding_category_level5

segments.product_brand

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_item_id

segments.product_language

segments.product_sold_bidding_category_level1

segments.product_sold_bidding_category_level2

segments.product_sold_bidding_category_level3

segments.product_sold_bidding_category_level4

segments.product_sold_bidding_category_level5

segments.product_sold_brand

segments.product_sold_condition

segments.product_sold_custom_attribute0

segments.product_sold_custom_attribute1

segments.product_sold_custom_attribute2

segments.product_sold_custom_attribute3

segments.product_sold_custom_attribute4

segments.product_sold_item_id

segments.product_sold_title

segments.product_sold_type_l1

segments.product_sold_type_l2

segments.product_sold_type_l3

segments.product_sold_type_l4

segments.product_sold_type_l5

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.client_account_cross_sell_cost_of_goods_sold_micros

metrics.client_account_cross_sell_gross_profit_micros

metrics.client_account_cross_sell_revenue_micros

metrics.client_account_cross_sell_units_sold

metrics.client_account_lead_cost_of_goods_sold_micros

metrics.client_account_lead_gross_profit_micros

metrics.client_account_lead_revenue_micros

metrics.client_account_lead_units_sold

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.lead_cost_of_goods_sold_micros

metrics.lead_gross_profit_micros

metrics.lead_revenue_micros

metrics.lead_units_sold