Identify top products

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 accept the Market Insights Terms of Service before you can access this report. See the Market Insights policy for more information.

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.

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"
      }
    }
  ]
}