Identify top products

AI-generated Key Takeaways

• The Merchant API is the new version of the Content API for Shopping and represents the future of product data integration.

• Use the BestSellersProductClusterView query and the reports.search method to retrieve a report of the best-selling products on Google Shopping.

• The report provides insights into product rankings, demand levels, and inventory status, allowing merchants to make informed decisions about their product offerings.

• Customize the report by specifying the date, granularity, country, and category in the query's WHERE clause.

• Review the provided sample query and response to understand the structure and data available in the best sellers report.

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.

Run

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