Google Merchant Center product inventory table

Overview

Caution: BigQuery will no longer support the report that exports theProduct Inventory table on September 1, 2025. We recommend that you migrate touse thenew best sellers reportinstead. For more information about migrating to the new report, seeMigrate the best sellers report.

Best sellers data helps merchants understand the most popular brands andproducts in Shopping ads and unpaid listings. For more information about bestsellers, see the description inSupported reports.

The data is written to a table namedBestSellers_TopProducts_Inventory_MERCHANT_ID.

Schema

TheBestSellers_TopProducts_Inventory_ table has the following schema:

Column	BigQuery data type	Description
rank_id	STRING	Rank identifier to join against theTop Products table
product_id	STRING	Content API's REST ID of the product in the formchannel: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 theBestSellers_TopProducts_Inventory_ tableprovides a mapping to your products for all target countries in theProducts_table.

Top Products

product_title	rank_id:	ranking_country	ranking_category	rank
Example Backpack	2020-03-14:AU:5181:40:product	AU	5181	40

Product inventory table

rank_id	product_id
2020-03-14:AU:5181:40:product	online:en:AU:666840730
2020-03-14:AU:5181:40:product	online:en:AU:666840730