PriceInsightsProductView

PriceInsightsProductView

Fields available for query in price_insights_product_view table.

Price insights report.

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

Fields
price	Price Current price of the product.
suggested_price	Price Latest suggested price for the product.
effectiveness	Effectiveness The predicted effectiveness of applying the price suggestion, bucketed.
id	string REST ID of the product, in the form of channel~languageCode~feedLabel~offerId . Can be used to join data with the product_view table. Required in the SELECT clause.
offer_id	string Merchant-provided id of the product.
title	string Title of the product.
brand	string Brand of the product.
category_l1	string Product category (1st level) in Google's product taxonomy .
category_l2	string Product category (2nd level) in Google's product taxonomy .
category_l3	string Product category (3rd level) in Google's product taxonomy .
category_l4	string Product category (4th level) in Google's product taxonomy .
category_l5	string Product category (5th level) in Google's product taxonomy .
product_type_l1	string Product type (1st level) in merchant's own product taxonomy .
product_type_l2	string Product type (2nd level) in merchant's own product taxonomy .
product_type_l3	string Product type (3rd level) in merchant's own product taxonomy .
product_type_l4	string Product type (4th level) in merchant's own product taxonomy .
product_type_l5	string Product type (5th level) in merchant's own product taxonomy .
predicted_impressions_change_fraction	double Predicted change in impressions as a fraction after introducing the suggested price compared to current active price. For example, 0.05 is a 5% predicted increase in impressions.
predicted_clicks_change_fraction	double Predicted change in clicks as a fraction after introducing the suggested price compared to current active price. For example, 0.05 is a 5% predicted increase in clicks.
predicted_conversions_change_fraction	double Predicted change in conversions as a fraction after introducing the suggested price compared to current active price. For example, 0.05 is a 5% predicted increase in conversions).