Google Merchant Center Best Sellers table schemas

Best Sellers table schemas

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, four tables are created:

  • BestSellersBrandWeekly_merchant_id
  • BestSellersBrandMonthly_merchant_id
  • BestSellersProductClusterWeekly_merchant_id
  • BestSellersProductClusterMonthly_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 BestSellersProductCluster<Weekly/Monthly>_ tables have the following schema:

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 of the sold products.
title STRING Title of the best selling product cluster.
brand STRING Brand of the best selling product cluster.
category_l1 STRING Google product category of the best selling product cluster.
category_l2 STRING Google product category of the best selling product cluster.
category_l3 STRING Google product category of the best selling product cluster.
category_l4 STRING Google product category of the best selling product cluster.
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.
product_inventory_status STRING Status of this product in your inventory. in_inventory, not_in_inventory, out_of_stock
bra:%s/nd_inventory_status STRING Status of this brand in your inventory, based on the status of products from this brand. in_stock, out_of_stock, not_in_inventory
rank INTEGER Rank of the product (the lower, the more sold the product).
previous_rank INTEGER Rank of the product in the previous period (week or month).
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). 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).

The BestSellersBrand<Weekly/Monthly>_ tables have the following schema:

Column BigQuery data type Description Example data
brand STRING best selling brand.
category_id INTEGER Google product category ID of the best selling brand.
country_code STRING Country in which the best selling brand has been sold.
rank INTEGER Rank of the best selling brand (the lower the more sold).
previous_rank INTEGER Rank of the best selling brand in the previous period (week or month).
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). very_high, high, medium, low, very_low
relative_demand_change STRING Change in demand compared to the previous period (week or month).