Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Tabel Daya Saing Harga Google Merchant Center
Ringkasan
Data daya saing harga di BigQuery membantu penjual memahami cara penjual lain menetapkan harga untuk produk yang sama. Saat data pelaporan Google Merchant Center Anda ditransfer ke BigQuery, format tabel PriceCompetitiveness_ akan memberikan tolok ukur harga harian per negara dan per produk. Tabel persaingan harga juga berisi beberapa atribut
lain produk untuk membantu Anda memahami persaingan harga
dalam kategori atau merek, misalnya.
Data ditulis ke tabel bernama
PriceCompetitiveness_MERCHANT_ID
jika Anda menggunakan ID Penjual perorangan, atau
PriceCompetitiveness_AGGREGATOR_ID jika Anda
menggunakan akun MCA.
Skema
Tabel PriceCompetitiveness_ memiliki skema berikut:
ID akun Google Merchant Center. Kolom ini adalah kunci utama.
1234
id
STRING
ID REST Content API produk dalam bentuk:
channel:content_language:feed_label:offer_id, mirip dengan
cara yang ditetapkan dalam
skema tabel produk. Kolom ini adalah kunci utama.
Harga rata-rata berdasarkan klik untuk produk tertentu di semua
penjual yang mengiklankan produk yang sama di iklan Shopping. Produk dicocokkan berdasarkan GTIN-nya. Untuk mengetahui detail selengkapnya, lihat
artikel Pusat Bantuan tentang laporan daya saing harga.
benchmark_price.amount_micros
INTEGER
Harga item, dalam mikro (1 direpresentasikan sebagai 1000000).
1000000
benchmark_price.currency_code
STRING
Mata uang harga item.
USD
price
RECORD
Harga produk ini.
price.amount_micros
STRING
Harga item, dalam mikro (1 direpresentasikan sebagai 1000000).
1000000
price.currency_code
INTEGER
Mata uang harga item.
USD
report_country_code
STRING
Kode negara tempat pengguna melakukan kueri di Google.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 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:"]]
