Stay organized with collections
Save and categorize content based on your preferences.
Google Merchant Center product inventory table
Overview
Best sellers data helps merchants understand the most popular brands and
products in Shopping ads and unpaid listings. For more information about best
sellers, see the description in Supported reports.
The data is written to a table named BestSellers_TopProducts_Inventory_MERCHANT_ID.
Schema
The BestSellers_TopProducts_Inventory_ table has the following schema:
Column
BigQuery data type
Description
rank_id
STRING
Rank identifier to join against the Top Products table
product_id
STRING
Content API's REST ID of the product in the form
channel:content_language:feed_label:offer_id.
merchant_Id
INTEGER
Merchant account ID.
aggregator_id
INTEGER
Aggregator account ID for multi-client accounts.
Example
The example below demonstrates how the BestSellers_TopProducts_Inventory_ table
provides a mapping to your products for all target countries in the Products_
table.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[[["\u003cp\u003eThe Product Inventory table in Google Merchant Center will be deprecated on September 1, 2025, and users are advised to switch to the new best sellers report.\u003c/p\u003e\n"],["\u003cp\u003eThe best sellers report data helps merchants to identify the most popular brands and products in Shopping ads and unpaid listings.\u003c/p\u003e\n"],["\u003cp\u003eThe data from this table is stored in the \u003ccode\u003eBestSellers_TopProducts_Inventory_\u003c/code\u003e\u003cvar translate=no\u003eMERCHANT_ID\u003c/var\u003e table, which includes identifiers to link products with their rankings.\u003c/p\u003e\n"],["\u003cp\u003eThe table includes the ranking id, product id, merchant id, and aggregator id.\u003c/p\u003e\n"],["\u003cp\u003eThe provided example demonstrates how the \u003ccode\u003eBestSellers_TopProducts_Inventory_\u003c/code\u003e table links product rankings to product IDs across different countries.\u003c/p\u003e\n"]]],[],null,[]]
