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,
(SELECTnameFROMtop_products.product_titleWHERElocale='en-US')ASproduct_title,
brand,
price_range
FROM
dataset.BestSellers_TopProducts_merchant_idAStop_products
WHERE
_PARTITIONDATE='YYYY-MM-DD'AND
ranking_category=267/*Smartphones*/AND
ranking_country='US'
ORDERBY
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.

WITHlatest_top_productsAS
(
SELECT
*
FROM
dataset.BestSellers_TopProducts_merchant_id
WHERE
_PARTITIONDATE='YYYY-MM-DD'
),
latest_top_products_inventoryAS
(
SELECT
*
FROM
dataset.BestSellers_TopProducts_Inventory_merchant_id
WHERE
_PARTITIONDATE='YYYY-MM-DD'
)
SELECT
top_products.rank,
inventory.product_id,
(SELECTANY_VALUE(name)FROMtop_products.product_title)ASproduct_title,
top_products.brand,
top_products.gtins
FROM
latest_top_productsAStop_products
INNERJOIN
latest_top_products_inventoryASinventory
USING(rank_id)