Mantenha tudo organizado com as coleções
Salve e categorize o conteúdo com base nas suas preferências.
Tabela de competitividade de preço do Google Merchant Center
Visão geral
Os dados de competitividade de preço no BigQuery ajudam os comerciantes a entender como outros comerciantes estão definindo o preço do mesmo produto. Quando os dados de relatórios do Google Merchant Center são transferidos para o BigQuery, o formato da tabela PriceCompetitiveness_ apresenta um benchmark de preço diário por país e por produto. A tabela de competitividade do preço também contém vários outros atributos do produto para ajudar você a entender a competitividade dos seus preços dentro de uma categoria ou marca, por exemplo.
Os dados são gravados em uma tabela chamada PriceCompetitiveness_MERCHANT_ID quando você usa um ID do comerciante individual ou PriceCompetitiveness_AGGREGATOR_ID quando usa uma conta MCA.
Esquema
As tabelas PriceCompetitiveness_ têm o seguinte esquema:
[[["Fácil de entender","easyToUnderstand","thumb-up"],["Meu problema foi resolvido","solvedMyProblem","thumb-up"],["Outro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Informações incorretas ou exemplo de código","incorrectInformationOrSampleCode","thumb-down"],["Não contém as informações/amostras de que eu preciso","missingTheInformationSamplesINeed","thumb-down"],["Problema na tradução","translationIssue","thumb-down"],["Outro","otherDown","thumb-down"]],["Última atualização 2025-09-04 UTC."],[[["\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:"]]
