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. |
