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