ProductPerformanceView

ProductPerformanceView

Fields available for query in product_performance_view table.

Product performance data for your account, including performance metrics (for example, clicks ) and dimensions according to which performance metrics are segmented (for example, offer_id ). Values of product dimensions, such as offer_id , reflect the state of a product at the time of the impression.

Segment fields cannot be selected in queries without also selecting at least one metric field.

Values are only set for fields requested explicitly in the request's search query.

Fields
date	Date Date in the Merchant Center account timezone to which metrics apply. Segment. Condition on date is required in the WHERE clause.
week	Date First day of the week (Monday) of the metrics date in the Merchant Center account timezone. Segment.
conversion_value	Price Value of conversions attributed to the product, reported on the conversion date. Metric. Available only for the FREE traffic source.
marketing_method	MarketingMethodEnum Marketing method to which metrics apply. Segment.
customer_country_code	string Code of the country where the customer is located at the time of the event. Represented in the ISO 3166 format. Segment. If the customer country cannot be determined, a special 'ZZ' code is returned.
store_type	StoreTypeEnum Store type to which metrics apply. Can be ONLINE_STORE or LOCAL_STORES . Segment. For LOCAL_STORES store type, further segmentation by a specific store is not available.
offer_id	string Merchant-provided id of the product. Segment.
title	string Title of the product. Segment.
brand	string Brand of the product. Segment.
category_l1	string Product category (1st level) in Google's product taxonomy. Segment.
category_l2	string Product category (2nd level) in Google's product taxonomy. Segment.
category_l3	string Product category (3rd level) in Google's product taxonomy. Segment.
category_l4	string Product category (4th level) in Google's product taxonomy. Segment.
category_l5	string Product category (5th level) in Google's product taxonomy. Segment.
product_type_l1	string Product type (1st level) in merchant's own product taxonomy. Segment.
product_type_l2	string Product type (2nd level) in merchant's own product taxonomy. Segment.
product_type_l3	string Product type (3rd level) in merchant's own product taxonomy. Segment.
product_type_l4	string Product type (4th level) in merchant's own product taxonomy. Segment.
product_type_l5	string Product type (5th level) in merchant's own product taxonomy. Segment.
custom_label0	string Custom label 0 for custom grouping of products. Segment.
custom_label1	string Custom label 1 for custom grouping of products. Segment.
custom_label2	string Custom label 2 for custom grouping of products. Segment.
custom_label3	string Custom label 3 for custom grouping of products. Segment.
custom_label4	string Custom label 4 for custom grouping of products. Segment.
clicks	int64 Number of clicks. Metric.
impressions	int64 Number of times merchant's products are shown. Metric.
click_through_rate	double Click-through rate - the number of clicks merchant's products receive (clicks) divided by the number of times the products are shown (impressions). Metric.
conversions	double Number of conversions attributed to the product, reported on the conversion date. Depending on the attribution model, a conversion might be distributed across multiple clicks, where each click gets its own credit assigned. This metric is a sum of all such credits. Metric. Available only for the FREE traffic source.
conversion_rate	double Number of conversions divided by the number of clicks, reported on the impression date. Metric. Available only for the FREE traffic source.