Google Merchant Center top products

Overview

Best sellers data helps merchants understand the most popular brands and products in Shopping ads. For more information about best sellers, see the description in Supported Reports.

The data is written to a table named BestSellers_TopProducts_MERCHANT_ID.

Schema

The BestSellers_TopProducts_ table has the following schema:

Understanding the data

• Ranking categories are subject to change over time.
• The Google product category in the BestSellers_TopProducts_Inventory_ table might be different from the Google Product Category in the Products_ table. The Products_ table surfaces a retailer provided value of Google product category.
• For products in your inventory, the price range in BestSellers_TopProducts_ might differ from the Products_PriceBenchmarks_ table. Price benchmarks metrics are calculated over a different time period. The price ranges in BestSellers_TopProducts_ reflect prices of different variants of the product, whereas the price ranges in Products_PriceBenchmarks_ only refer to a single variant.
• Some products in your inventory might not have a rank for each category in the path. We limit the number of products per category to 10,000, and in some sub-categories we don't publish any ranking.

Example

Products might have a rank for each category within the product category path. For example, a Google Pixel 4 phone is classified as Electronics > Communications > Telephony > Mobile Phones. The Pixel 4 will have a separate ranking for Electronics, Communications, Telephony, and Mobile Phones. Use ranking_category_path in addition to ranking_country to determine the depth of category that you want to see a ranking for.

In the example below, an ExampleBrand Backpack contains a separate ranking for both the Luggage & Bags and Backpacks categories. Select "Backpacks" and "AU" to see what its ranking is in Australia in the Backpacks category.

Ranking for Luggage & Bags

Ranking for Luggage & Bags > Backpacks

Query examples

Top products for a given category and country

The following SQL query returns top products for the Smartphones category in the US.

SELECT
  rank,
  previous_rank,
  relative_demand.bucket,
  (SELECT name FROM top_products.product_title WHERE locale = 'en-US') AS product_title,
  brand,
  price_range
FROM
  dataset.BestSellers_TopProducts_merchant_id AS top_products
WHERE
  _PARTITIONDATE = 'YYYY-MM-DD' AND
  ranking_category = 267 /*Smartphones*/ AND
  ranking_country = 'US'
ORDER BY
  rank

Top products in your inventory

The following SQL query joins BestSellers_TopProducts_Inventory_ and BestSellers_TopProducts_ data to return a list of top products you have in your inventory.

WITH latest_top_products AS
(
  SELECT
    *
  FROM
    dataset.BestSellers_TopProducts_merchant_id
  WHERE
    _PARTITIONDATE = 'YYYY-MM-DD'
),
latest_top_products_inventory AS
(
  SELECT
    *
  FROM
    dataset.BestSellers_TopProducts_Inventory_merchant_id
  WHERE
    _PARTITIONDATE = 'YYYY-MM-DD'
)
SELECT
  top_products.rank,
  inventory.product_id,
  (SELECT ANY_VALUE(name) FROM top_products.product_title) AS product_title,
  top_products.brand,
  top_products.gtins
FROM
  latest_top_products AS top_products
INNER JOIN
  latest_top_products_inventory AS inventory
USING (rank_id)