Google Merchant Center Price Competitiveness table

Overview

Price competitiveness data in BigQuery helps merchants understand howother merchants are pricing the same product. When your Google Merchant Centerreporting data is transferred to BigQuery, the format of thePriceCompetitiveness_ table provides a daily price benchmark per country andper product. The price competitiveness table also contains several otherattributes of the product to help you to understand the competitiveness of yourpricing within a category or brand for example.

The data is written to a table namedPriceCompetitiveness_MERCHANT_IDif you are using an individual Merchant ID, orPriceCompetitiveness_AGGREGATOR_ID if you'reusing an MCA account.

Note: To access price competitiveness data, you must meet theeligibility requirements for market insights.

Schema

ThePriceCompetitiveness_ tables have the following schema:

Column	BigQuery data type	Description	Example data
aggregator_id	INTEGER	ID of theMulti Client Account (MCA) if the merchant is part of an MCA. Null otherwise.	12345
merchant_id	INTEGER	Google Merchant Center account ID. This field is a primary key.	1234
id	STRING	Content API REST ID of the product in the form:channel:content_language:feed_label:offer_id, similar to the way it's defined in theproducts table schema. This field is a primary key.	online:en:AU:666840730
title	STRING	Title of the product.	TN2351 black USB
brand	STRING	Brand of the product.	Brand Name
offer_id	STRING	Merchant providedid of the product.	tddy123uk
benchmark_price	RECORD	Average click-weighted price for a given product across all merchants who advertise that same product on Shopping ads. Products are matched based on theirGTIN. For more details, seeHelp Center article about the price competitiveness report.
benchmark_price.amount_micros	INTEGER	Price of the item, in micros (1 is represented as 1000000).	1000000
benchmark_price.currency_code	STRING	Currency of the price of the item.	USD
price	RECORD	Price of this product.
price.amount_micros	STRING	Price of the item, in micros (1 is represented as 1000000).	1000000
price.currency_code	INTEGER	Currency of the price of the item.	USD
report_country_code	STRING	Country code where the user performed the query on Google.	CH, US
product_type_l1	STRING	Product type attribute of the product.
product_type_l2	STRING	Product type attribute of the product.
product_type_l3	STRING	Product type attribute of the product.
product_type_l4	STRING	Product type attribute of the product.
product_type_l5	STRING	Product type attribute of the product.
category_l1	STRING	Google product category of the product.	Animals & Pet Supplies
category_l2	STRING	Google product category of the product.	Pet Supplies
category_l3	STRING	Google product category of the product.	Dog Supplies
category_l4	STRING	Google product category of the product.	Dog Beds
category_l5	STRING	Google product category of the product.