PriceCompetitivenessProductView

PriceCompetitivenessProductView

Fields available for query in price_competitiveness_product_view table.

Price competitiveness report.

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

Fields
price	Price Current price of the product.
benchmark_price	Price Latest available price benchmark for the product's catalog in the benchmark country.
report_country_code	string Country of the price benchmark. Represented in the ISO 3166 format. Required in the SELECT clause.
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 .