您可以使用畅销商品报告查看 Google 购物和购物广告中的畅销商品和品牌。您可以使用此报告中的信息来了解哪些商品在 Google 上卖得好,以及您是否销售这些商品。
选择畅销商品报告进行传输会创建五个表。对于给定的商家 ID,该报告会创建以下表:
BestSellersBrandWeekly_MERCHANT_ID
BestSellersBrandMonthly_MERCHANT_ID
BestSellersProductClusterWeekly_MERCHANT_ID
BestSellersProductClusterMonthly_MERCHANT_ID
BestSellersEntityProductMapping_MERCHANT_ID
对于 MCA 账号,该报告会生成以下表:
BestSellersBrandWeekly_AGGREGATOR_ID
BestSellersBrandMonthly_AGGREGATOR_ID
BestSellersProductClusterWeekly_AGGREGATOR_ID
BestSellersProductClusterMonthly_AGGREGATOR_ID
BestSellersEntityProductMapping_AGGREGATOR_ID
畅销商品表基于 Google Merchant Center 中的每月或每周畅销商品报告,包括畅销商品和畅销品牌。最新的每月或每周快照每天更新一次。由于数据会在每周或每月的开头进行更新,因此某些数据可能会连续重复几天。您可以期待在每周或每月看到已更新的上一周期热门商品数据。指标中包含的新数据最长可能需要两周才能提供给您。
映射表 BestSellersEntityProductMapping_ 包含 BestSellersProductCluster<Weekly/Monthly>_ 表中的排名实体 ID 及其商家商品目录中的对应商品 ID。在 MCA 级别生成时,该表包含所有子账号的映射数据。此表用于将畅销商品数据与通过 Merchant Center 传输导出的其他表中的信息(商品、本地商品目录、区域商品目录、价格分析、价格竞争力、商品定位)进行联接,这些信息采用相同的商品 ID 格式。
[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC):2025-08-17。"],[[["\u003cp\u003eThe Best Sellers report in Google Merchant Center provides data on top-performing products and brands across Google Shopping and Shopping Ads.\u003c/p\u003e\n"],["\u003cp\u003eFive tables are generated upon importing the \u003ccode\u003eBest Sellers\u003c/code\u003e report, including weekly and monthly tables for both brands and product clusters, as well as a mapping table, with the latest data updated daily.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eBestSellersEntityProductMapping_\u003c/code\u003e table connects best seller ranking entity IDs with corresponding product IDs in the merchant's inventory for joining with other tables.\u003c/p\u003e\n"],["\u003cp\u003e\u003ccode\u003eBestSellersProductCluster<Weekly/Monthly>_\u003c/code\u003e tables detail top-selling product clusters, including data on country, category, title, brand, GTINs, inventory status, demand, pricing and rank.\u003c/p\u003e\n"],["\u003cp\u003e\u003ccode\u003eBestSellersBrand<Weekly/Monthly>_\u003c/code\u003e tables list best-selling brands, their category IDs, country of sale, rank, demand, and changes in demand.\u003c/p\u003e\n"]]],[],null,["# Google Merchant Center best sellers table\n=========================================\n\nOverview\n--------\n\nYou can use the best sellers report to view the best-selling products and brands\non Google Shopping and in Shopping Ads. You can use the information from this\nreport to understand which products are performing well on Google, and whether\nyou carry them.\n\nSelecting the best sellers report for your transfer creates five tables.\nFor a given merchant ID, the report creates the following tables:\n\n- `BestSellersBrandWeekly_`\u003cvar translate=\"no\"\u003eMERCHANT_ID\u003c/var\u003e\n- `BestSellersBrandMonthly_`\u003cvar translate=\"no\"\u003eMERCHANT_ID\u003c/var\u003e\n- `BestSellersProductClusterWeekly_`\u003cvar translate=\"no\"\u003eMERCHANT_ID\u003c/var\u003e\n- `BestSellersProductClusterMonthly_`\u003cvar translate=\"no\"\u003eMERCHANT_ID\u003c/var\u003e\n- `BestSellersEntityProductMapping_`\u003cvar translate=\"no\"\u003eMERCHANT_ID\u003c/var\u003e\n\nFor an MCA account, the report generates the following tables:\n\n- `BestSellersBrandWeekly_`\u003cvar translate=\"no\"\u003eAGGREGATOR_ID\u003c/var\u003e\n- `BestSellersBrandMonthly_`\u003cvar translate=\"no\"\u003eAGGREGATOR_ID\u003c/var\u003e\n- `BestSellersProductClusterWeekly_`\u003cvar translate=\"no\"\u003eAGGREGATOR_ID\u003c/var\u003e\n- `BestSellersProductClusterMonthly_`\u003cvar translate=\"no\"\u003eAGGREGATOR_ID\u003c/var\u003e\n- `BestSellersEntityProductMapping_`\u003cvar translate=\"no\"\u003eAGGREGATOR_ID\u003c/var\u003e\n\nThe best sellers tables follow the monthly or weekly best seller reports, both\nproduct and brand, from\n[Google Merchant Center](https://support.google.com/merchants/answer/9488679).\nThe latest monthly or weekly snapshot is updated daily. Since data is updated at\nthe start of each week or month, some data might be repeated several days in a\nrow. You can expect updated popular products data every week or month for the\nprevious period. The new data included in your metrics might not be available\nfor up to two weeks.\n\nThe mapping table `BestSellersEntityProductMapping_` contains\nranking entity IDs from the\n`BestSellersProductCluster\u003cWeekly/Monthly\u003e_` tables and their\ncorresponding product IDs from the merchant's inventory. When generated at the\nMCA level, the table contains mapping data for all of the subaccounts. This\ntable is meant for joining the best sellers data with information in other\ntables exported by the Merchant Center transfer, which have the\nsame format of product ID (Products, Local Inventories, Regional Inventories,\nPrice Insights, Price Competitiveness, Product Targeting).\n\nWhile brands are ranked across many different categories, all products in the\n`Products_` table are in leaf categories. To join brands and products on\nnon-leaf categories, use the `google_product_category_ids` field.\n| **Note:** To access best sellers data, you must meet the [eligibility requirements for market insights](https://support.google.com/merchants/answer/9712881).\n\n`BestSellersProductCluster\u003cWeekly/Monthly\u003e_` tables\n---------------------------------------------------\n\n| **Note:** These tables don't have primary keys.\n\n`BestSellersBrand\u003cWeekly/Monthly\u003e_` tables\n------------------------------------------\n\n| **Note:** These tables don't have primary keys.\n\n`BestSellersEntityProductMapping_` table\n----------------------------------------"]]