Tabela das principais marcas do Google Merchant Center
Visão geral
Os dados de mais vendidos ajudam os comerciantes a entender as marcas e produtos mais conhecidos nos anúncios do Shopping e listagens não pagas. Para mais informações sobre os mais vendidos, consulte a descrição em Relatórios suportados.
Caso esteja usando um ID do comerciante individual, os dados serão gravados em uma tabela chamada BestSellers_TopBrands_MERCHANT_ID. Se você estiver usando uma conta de múltiplos clientes (MCA), os dados serão gravados em uma tabela chamada BestSellers_TopBrands_AGGREGATOR_ID.
Esquema
A tabela BestSellers_TopBrands_ tem o seguinte esquema:
Coluna
Tipo de dados BigQuery
Descrição
Dados de exemplo
rank_timestamp
TIMESTAMP
Data e hora em que a classificação foi publicada.
2020-05-30 00:00:00 UTC
rank_id
STRING
Identificador exclusivo da classificação.
2020-05-30:FR:264:120:brand
rank
INTEGER
A classificação de popularidade da marca em anúncios do Shopping e listagens não pagas para ranking_country e ranking_category.
Essa informação tem como base o número estimado de itens vendidos. A classificação é atualizada diariamente. Os dados incluídos nas métricas podem ficar atrasados em até dois dias.
[[["Fácil de entender","easyToUnderstand","thumb-up"],["Meu problema foi resolvido","solvedMyProblem","thumb-up"],["Outro","otherUp","thumb-up"]],[["Não contém as informações de que eu preciso","missingTheInformationINeed","thumb-down"],["Muito complicado / etapas demais","tooComplicatedTooManySteps","thumb-down"],["Desatualizado","outOfDate","thumb-down"],["Problema na tradução","translationIssue","thumb-down"],["Problema com as amostras / o código","samplesCodeIssue","thumb-down"],["Outro","otherDown","thumb-down"]],["Última atualização 2025-01-14 UTC."],[[["\u003cp\u003eThe BigQuery report exporting the Top brands table will be discontinued on September 1, 2025, and users should migrate to the new best sellers report.\u003c/p\u003e\n"],["\u003cp\u003eBest sellers data provides insights into the most popular brands and products within Shopping ads and unpaid listings.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eBestSellers_TopBrands_\u003c/code\u003e table contains detailed information, including rank, previous rank, ranking country, and category, along with relative demand and brand information.\u003c/p\u003e\n"],["\u003cp\u003eSQL queries can be used to retrieve top brands for specific categories and countries, and to find products in your inventory from top brands.\u003c/p\u003e\n"],["\u003cp\u003eThe popularity ranking of a brand is based on the estimated number of products sold, updating daily with a possible 2-day delay in metrics.\u003c/p\u003e\n"]]],[],null,["# Google Merchant Center top brands table\n=======================================\n\nOverview\n--------\n\n| **Caution:** BigQuery will no longer support the report that exports the Top brands table on September 1, 2025. We recommend that you migrate to use the [new best sellers report](/bigquery/docs/merchant-center-best-sellers-schema) instead. For more information about migrating to the new report, see [Migrate the best sellers report](/bigquery/docs/merchant-center-best-sellers-migration).\n\nBest sellers data helps merchants understand the most popular brands and\nproducts in Shopping ads and unpaid listings. For more information about best\nsellers, see the description in [Supported reports](/bigquery/docs/merchant-center-transfer#supported_reports).\n\nThe data is written to a table named `BestSellers_TopBrands_`\u003cvar translate=\"no\"\u003eMERCHANT_ID\u003c/var\u003e.\n\nSchema\n------\n\nThe `BestSellers_TopBrands_` table has the following schema:\n\nQuery examples\n--------------\n\n### Top brands for a given category and country\n\nThe following SQL query returns top brands for the `Smartphones` category in\nthe US. \n\n```googlesql\nSELECT\n rank,\n previous_rank,\n brand\nFROM\n dataset.BestSellers_TopBrands_\u003cvar translate=\"no\"\u003emerchant_id\u003c/var\u003e\nWHERE\n _PARTITIONDATE = '\u003cvar translate=\"no\"\u003eYYYY-MM-DD\u003c/var\u003e' AND\n ranking_category = 267 /*Smartphones*/ AND\n ranking_country = 'US'\nORDER BY\n rank\n```\n| **Note:** For more information about product categories, including a full list of category codes, see [Definition: `google_product_category`](https://support.google.com/merchants/answer/6324436).\n\n### Products of top brands in your inventory\n\nThe following SQL query returns a list of products in your inventory from top\nbrands, listed by category and country. \n\n```googlesql\n WITH latest_top_brands AS\n (\n SELECT\n *\n FROM\n dataset.BestSellers_TopBrands_\u003cvar translate=\"no\"\u003emerchant_id\u003c/var\u003e\n WHERE\n _PARTITIONDATE = '\u003cvar translate=\"no\"\u003eYYYY-MM-DD\u003c/var\u003e'\n ),\n latest_products AS\n (\n SELECT\n product.*,\n product_category_id\n FROM\n dataset.Products_\u003cvar translate=\"no\"\u003emerchant_id\u003c/var\u003e AS product,\n UNNEST(product.google_product_category_ids) AS product_category_id,\n UNNEST(destinations) AS destination,\n UNNEST(destination.approved_countries) AS approved_country\n WHERE\n _PARTITIONDATE = '\u003cvar translate=\"no\"\u003eYYYY-MM-DD\u003c/var\u003e'\n )\n SELECT\n top_brands.brand,\n (SELECT name FROM top_brands.ranking_category_path\n WHERE locale = 'en-US') AS ranking_category,\n top_brands.ranking_country,\n top_brands.rank,\n products.product_id,\n products.title\n FROM\n latest_top_brands AS top_brands\n INNER JOIN\n latest_products AS products\n ON top_brands.google_brand_id = products.google_brand_id AND\n top_brands.ranking_category = product_category_id AND\n top_brands.ranking_country = products.approved_country\n```\n| **Note:** For more information about product categories, including a full list of category codes, see [Definition: `google_product_category`](https://support.google.com/merchants/answer/6324436)."]]
