You can use the best sellers report to view the best-selling products 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 currently carry them.
See About the best seller report for more information.
Your account must meet minimum eligibility requirements, and you must ensure that your use, or any third party's use, of Market Insights data exported from your Merchant Center account complies with the Merchant Center terms and conditions.
Query
BestSellersProductClusterView
to view the best-selling products on Google.
Here's a sample you can use to view best-selling products. To make the request, pass the following Merchant Center Query Language statement to the reports.search
method:
SELECT best_sellers.report_date, best_sellers.report_granularity, best_sellers.country_code, best_sellers.category_id, best_sellers.rank, best_sellers.previous_rank, best_sellers.relative_demand, best_sellers.previous_relative_demand, best_sellers.relative_demand_change, product_cluster.title, product_cluster.brand, product_cluster.category_l1, product_cluster.category_l2, product_cluster.category_l3, product_cluster.variant_gtins, product_cluster.inventory_status, product_cluster.brand_inventory_status FROM BestSellersProductClusterView WHERE best_sellers.report_date = '2022-10-10' AND best_sellers.report_granularity = 'WEEKLY' AND best_sellers.country_code = 'US' AND best_sellers.category_id = 166 ORDER BY best_sellers.rank
You can change the values in the WHERE
clause to customize the report for
other dates, granularities, countries, and categories.
Click Run to try the sample in the API Explorer. After you click Run, update the merchant ID placeholder to your own merchant ID in the request URL. You can modify the query. The full query must remain on one line to work with the API explorer.
Here's a sample response from the preceding query:
{
"results": [
{
"bestSellers": {
"reportDate": "2022-10-10",
"reportGranularity": "WEEKLY",
"countryCode": "US",
"categoryId": "166"
"rank": "1",
"previousRank": "1",
"relativeDemand": "VERY_HIGH",
"previousRelativeDemand": "VERY_HIGH",
"relativeDemandChange": "FLAT"
}
"productCluster": {
"title": "Ugg Shoes Ugg Tasman",
"brand": "UGG",
"categoryL1": "Apparel & Accessories",
"categoryL2": "Shoes",
"categoryL3": "",
"variantGtins":
["00737872992873", "00737872992880", "00737872992866"],
"inventoryStatus": "NOT_IN_INVENTORY",
"brandInventoryStatus": "NOT_IN_INVENTORY"
}
},
{
"bestSellers": {
"reportDate": "2022-10-10",
"reportGranularity": "WEEKLY",
"countryCode": "US",
"categoryId": "166"
"rank": "2",
"previousRank": "8",
"relativeDemand": "VERY_HIGH",
"previousRelativeDemand": "HIGH",
"relativeDemandChange": "RISER"
}
"productCluster": {
"title": "UGG Women's s Classic Mini",
"brand": "UGG",
"categoryL1": "Apparel & Accessories",
"categoryL2": "Shoes",
"categoryL3": "",
"variantGtins":
["00194715081314", "00194715081246", "00194715081321"],
"inventoryStatus": "NOT_IN_INVENTORY",
"brandInventoryStatus": "NOT_IN_INVENTORY"
}
},
{
"bestSellers": {
"reportDate": "2022-10-10",
"reportGranularity": "WEEKLY",
"countryCode": "US",
"categoryId": "166"
"rank": "3",
"previousRank": "2",
"relativeDemand": "VERY_HIGH",
"previousRelativeDemand": "VERY_HIGH",
"relativeDemandChange": "FLAT"
}
"productCluster": {
"title": "Crocs Classic",
"brand": "Crocs",
"categoryL1": "Apparel & Accessories",
"categoryL2": "Shoes",
"categoryL3": "",
"variantGtins":
["00887350811209", "00191448903852", "00191448769090"],
"inventoryStatus": "NOT_IN_INVENTORY",
"brandInventoryStatus": "OUT_OF_STOCK"
}
}
]
}