BigQuery 中的“价格竞争力”数据可帮助商家了解其他商家对同一商品的定价。当您的 Google Merchant Center 报告数据转移到 BigQuery 时,PriceCompetitiveness_ 表的格式会提供每个国家/地区和每件商品的每日价格基准。价格竞争力表还包含商品的一些其他属性,以帮助您了解您的价格在某个维度的竞争力,例如某个类别或品牌。
[[["易于理解","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 Google Merchant Center Price Competitiveness table in BigQuery provides daily price benchmarks per country and product, allowing merchants to compare their pricing against other merchants.\u003c/p\u003e\n"],["\u003cp\u003eThe table, named \u003ccode\u003ePriceCompetitiveness_MERCHANT_ID\u003c/code\u003e or \u003ccode\u003ePriceCompetitiveness_AGGREGATOR_ID\u003c/code\u003e, contains detailed product attributes like brand, category, and product type, facilitating a deeper understanding of pricing within specific segments.\u003c/p\u003e\n"],["\u003cp\u003eAccess to this price competitiveness data requires meeting specific eligibility requirements for market insights.\u003c/p\u003e\n"],["\u003cp\u003eKey data points include the merchant's product price, a benchmark price, currency codes, and various product identifiers and categories.\u003c/p\u003e\n"],["\u003cp\u003eThe table utilizes a schema with fields like \u003ccode\u003emerchant_id\u003c/code\u003e, \u003ccode\u003eid\u003c/code\u003e, \u003ccode\u003ebenchmark_price\u003c/code\u003e, and \u003ccode\u003eprice\u003c/code\u003e to detail the competitiveness of each product.\u003c/p\u003e\n"]]],[],null,["# Google Merchant Center Price Competitiveness table\n==================================================\n\nOverview\n--------\n\nPrice competitiveness data in BigQuery helps merchants understand how\nother merchants are pricing the same product. When your Google Merchant Center\nreporting data is transferred to BigQuery, the format of the\n`PriceCompetitiveness_` table provides a daily price benchmark per country and\nper product. The price competitiveness table also contains several other\nattributes of the product to help you to understand the competitiveness of your\npricing within a category or brand for example.\n\nThe data is written to a table named\n`PriceCompetitiveness_`\u003cvar translate=\"no\"\u003eMERCHANT_ID\u003c/var\u003e\nif you are using an individual Merchant ID, or\n`PriceCompetitiveness_`\u003cvar translate=\"no\"\u003eAGGREGATOR_ID\u003c/var\u003e if you're\nusing an MCA account.\n| **Note:** To access price competitiveness data, you must meet the [eligibility requirements for market insights](https://support.google.com/merchants/answer/9712881).\n\nSchema\n------\n\nThe `PriceCompetitiveness_` tables have the following schema:"]]