Google Merchant Center Best Sellers table
Overview
You can use the Best Sellers report to view the best-selling products and brands on Google Shopping and in Shopping Ads. You can use the information from this report to understand which products are performing well on Google, and whether you carry them.
When you import select Best Sellers as one of the reports that are relevant to your transfer, five tables are created:
BestSellersBrandWeekly_MERCHANT_IDBestSellersBrandMonthly_MERCHANT_IDBestSellersProductClusterWeekly_MERCHANT_IDBestSellersProductClusterMonthly_MERCHANT_IDBestSellersEntityProductMapping_MERCHANT_ID
The Best Sellers tables follow the monthly or weekly best seller reports, both product and brand, from Google Merchant Center. The latest monthly or weekly snapshot is updated daily. Since data is updated at the start of each week or month, some data might be repeated several days in a row.
The mapping table BestSellersEntityProductMapping_ contains
ranking entity IDs from the
BestSellersProductCluster<Weekly/Monthly>_ tables and their
corresponding product IDs from the merchant's inventory. This table is meant for
joining the Best Sellers data with information in other tables exported by the
Merchant Center transfer, which contain the same format of product ID (Products,
Local Inventories, Regional Inventories, Price Insights, Price Competitiveness,
Product Targeting).
BestSellersProductCluster<Weekly/Monthly>_ tables
| Column | BigQuery data type | Description | Example data |
|---|---|---|---|
country_code |
STRING |
Country in which the products are sold. | CH |
report_category_id |
INTEGER |
Google product category id of the sold products. | 1234 |
title |
STRING |
Title of the best selling product cluster. | TN2351 black USB |
brand |
STRING |
Brand of the best selling product cluster. Set to null when no brand exists. | Brand Name |
category_l1 |
STRING |
Google product category of the best selling product cluster. Set to an empty string when no category exists. | Animals & Pet Supplies |
category_l2 |
STRING |
Google product category of the best selling product cluster. Set to an empty string when no category exists. | Pet Supplies |
category_l3 |
STRING |
Google product category of the best selling product cluster. Set to an empty string when no category exists. | Dog Supplies |
category_l4 |
STRING |
Google product category of the best selling product cluster. Set to an empty string when no category exists. | Dog Beds |
category_l5 |
STRING |
Google product category of the best selling product cluster. | |
variant_gtins |
STRING |
GTINs of products from your inventory corresponding to this product cluster, each separated by a space. | 3234567890126 3234567890131 |
product_inventory_status |
STRING |
Status of this product in your inventory. | IN_STOCK, NOT_IN_INVENTORY, OUT_OF_STOCK |
brand_inventory_status |
STRING |
Status of this brand in your inventory, based on the status of products from this brand. Set to UNKNOWN when no brand exists. |
IN_STOCK, NOT_IN_INVENTORY, OUT_OF_STOCK |
entity_id |
STRING |
Identifier of this ranked Best Sellers entry. This column is used for
joining with other tables, using the BestSellersEntityProductMapping
table. |
ab12345cdef6789gh |
rank |
INTEGER |
Rank of the product (the lower, the more sold the product). | 5 |
previous_rank |
INTEGER |
Rank of the product in the previous period (week or month). | 5 |
relative_demand |
STRING |
Product's estimated demand in relation to the product with the highest rank in the same category and country. | VERY_HIGH, HIGH, MEDIUM, LOW, VERY_LOW |
previous_relative_demand |
STRING |
Relative demand value for this product compared to the previous period (week or month). Set to null when no previous demand exists. |
VERY_HIGH, HIGH, MEDIUM, LOW, VERY_LOW |
relative_demand_change |
STRING |
How the relative demand changed for this product compared to the previous period (week or month). Set to UNKNOWN when no previous demand exists. |
FLAT, SINKER, RISER |
BestSellersBrand<Weekly/Monthly>_ tables
| Column | BigQuery data type | Description | Example data |
|---|---|---|---|
brand |
STRING |
Best selling brand. | Brand Name |
category_id |
INTEGER |
Google product category ID of the best selling brand. | 1234 |
country_code |
STRING |
Country in which the best selling brand has been sold. | CH |
rank |
INTEGER |
Rank of the best selling brand (the lower the more sold). | 5 |
previous_rank |
INTEGER |
Rank of the best selling brand in the previous period (week or month). Set to 0 when no previous rank exists. |
5 |
relative_demand |
STRING |
Product's estimated demand in relation to the product with the highest rank in the same category and country. | VERY_HIGH, HIGH, MEDIUM, LOW, VERY_LOW |
previous_relative_demand |
STRING |
Relative demand in the previous period (week or month). Set to null when no previous demand exists. |
VERY_HIGH, HIGH, MEDIUM, LOW, VERY_LOW |
relative_demand_change |
STRING |
Change in demand compared to the previous period (week or month). Set to UNKNOWN when no previous rank exists. |
FLAT, SINKER, RISER |
BestSellersEntityProductMapping_ table
| Column | BigQuery data type | Description | Example data |
|---|---|---|---|
product_id |
STRING |
REST ID of the product in the form: channel:content_language:feed_label:offer_id. This ID will always reflect the latest state of the product at the time the data is exported to BigQuery. This is the join key with all other tables containing the product ID in this format. |
online:en:AU:666840730 |
entity_id |
STRING |
Identifier of the ranked Best Sellers entry. This is the join key with the BestSellersProductCluster<Weekly/Monthly>_ tables. |
ab12345cdef6789gh |