Google Merchant Center Price Competitiveness table

Overview

Price competitiveness data in BigQuery helps merchants understand how other merchants are pricing the same product. When your Google Merchant Center reporting data is transferred to BigQuery, the format of the PriceCompetitiveness_ table provides a daily price benchmark per country and per product. The price competitiveness table also contains several other attributes of the product to help you to understand the competitiveness of your pricing within a category or brand for example.

The data is written to a table named PriceCompetitiveness_MERCHANT_ID if you are using an individual Merchant ID, or PriceCompetitiveness_AGGREGATOR_ID if you're using an MCA account.

Schema

The PriceCompetitiveness_ tables have the following schema:

Column BigQuery data type Description Example data
aggregator_id INTEGER ID of the Multi 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 the products 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 provided id 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 their GTIN. For more details, see Help 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.