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_ID
  • BestSellersBrandMonthly_MERCHANT_ID
  • BestSellersProductClusterWeekly_MERCHANT_ID
  • BestSellersProductClusterMonthly_MERCHANT_ID
  • BestSellersEntityProductMapping_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