Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Anda dapat menggunakan tabel
ProductView
layanan Reports untuk menampilkan tampilan yang difilter dari data produk Anda, termasuk status produk.
Misalnya, Anda dapat membuat kueri ProductView untuk melakukan hal berikut:
Mencantumkan produk yang bermasalah, sehingga Anda dapat menyelesaikannya.
Dapatkan daftar produk baru Anda, sehingga Anda dapat memverifikasi penayangan.
Untuk melihat detail lengkap semua produk Anda, gunakan
products.list.
Anda harus menyertakan kolom product_view.id dalam klausa SELECT dari
kueri Anda. product_view.id memiliki nilai yang sama dengan REST
ID produk.
Anda dapat memfilter berdasarkan semua kolom yang tersedia, kecuali kolom berikut:
product_view.expiration_date
product_view.item_issues
Anda dapat mengurutkan respons berdasarkan semua kolom yang tersedia, kecuali kolom berikut:
product_view.gtin
product_view.item_issues
Anda dapat menggunakan kolom berikut untuk melihat potensi performa produk Anda:
product_view.click_potential
product_view.click_potential_rank
Berikut contoh yang menampilkan semua kolom yang tersedia untuk produk Anda dengan
status NOT_ELIGIBLE_OR_DISAPPROVED. Untuk membuat permintaan, teruskan pernyataan Bahasa Kueri Merchant Center berikut ke metode reports.search:
Klik Run untuk mencoba contoh di API Explorer. Setelah Anda mengklik
Run, perbarui placeholder ID penjual dengan ID penjual Anda sendiri di
URL permintaan. Anda dapat mengubah kueri. Seluruh kueri harus tetap berada dalam satu baris agar dapat berfungsi dengan API Explorer.
Lihat referensi ProductView untuk mengetahui informasi selengkapnya tentang kolom dan perilaku tertentu.
Lihat Metrik performa untuk mempelajari cara mengambil data performa produk Anda dengan layanan Reports.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Informasi yang saya butuhkan tidak ada","missingTheInformationINeed","thumb-down"],["Terlalu rumit/langkahnya terlalu banyak","tooComplicatedTooManySteps","thumb-down"],["Sudah usang","outOfDate","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Masalah kode / contoh","samplesCodeIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-08-13 UTC."],[[["\u003cp\u003eThe Merchant API is the new version of the Content API for Shopping and represents the future of product data integration.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eProductView\u003c/code\u003e table within the \u003ccode\u003eReports\u003c/code\u003e service allows you to filter and view your product data, including statuses and performance potential.\u003c/p\u003e\n"],["\u003cp\u003eYou can query \u003ccode\u003eProductView\u003c/code\u003e to identify and resolve product issues, verify new product serving, and gain insights into click potential.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003ereports.search\u003c/code\u003e method, coupled with Merchant Center Query Language, enables you to retrieve specific product data based on your chosen criteria.\u003c/p\u003e\n"],["\u003cp\u003eRefer to the provided resources for detailed information on \u003ccode\u003eProductView\u003c/code\u003e fields, performance metrics, and utilizing the \u003ccode\u003eReports\u003c/code\u003e service effectively.\u003c/p\u003e\n"]]],["The beta version of the Merchant API, the new Content API for Shopping, is introduced. You can use the `ProductView` table within the `Reports` service to filter and view product data, including statuses, or list products with issues and new products. Queries must include the `product_view.id`. Filtering and sorting can be applied to most fields, excluding `product_view.expiration_date`, `product_view.item_issues`, and `product_view.gtin`. Performance potential can be viewed via `product_view.click_potential`.\n"],null,["# Filter products\n\nYou can use the\n[`ProductView`](/shopping-content/reference/rest/v2.1/reports/search#productview)\ntable of the `Reports` service to show a filtered view of your product data,\nincluding product statuses.\n\nFor example, you can query `ProductView` to do the following:\n\n- List products that have issues, so you can resolve them.\n- Get a list of your new products, so you can verify serving.\n\nTo view full details of all your products, use\n[`products.list`](/shopping-content/reference/rest/v2.1/products/list).\n\nYou must include the `product_view.id` field in the `SELECT` clause of your\nquery. The `product_view.id` has the same value as the product's [REST\nID](/shopping-content/guides/products/product-id).\n\nYou can filter based on all the [available\nfields](/shopping-content/reference/rest/v2.1/reports/search#productview) except the following:\n\n- `product_view.expiration_date`\n- `product_view.item_issues`\n\nYou can sort the response based on all the available fields except the following:\n\n- `product_view.gtin`\n- `product_view.item_issues`\n\nYou can use the following fields to view the performance potential of your\nproducts:\n\n- `product_view.click_potential`\n- `product_view.click_potential_rank`\n\nHere's an example that returns all the available fields for your products with\nthe status `NOT_ELIGIBLE_OR_DISAPPROVED`. To make the request, pass the\nfollowing Merchant Center Query Language statement to the\n[`reports.search`](/shopping-content/reference/rest/v2.1/reports/search)\nmethod: \n\n SELECT\n product_view.id,\n product_view.offer_id,\n product_view.title,\n product_view.brand,\n product_view.currency_code,\n product_view.price_micros,\n product_view.language_code,\n product_view.condition,\n product_view.channel,\n product_view.availability,\n product_view.shipping_label,\n product_view.gtin,\n product_view.item_group_id,\n product_view.creation_time,\n product_view.expiration_date,\n product_view.aggregated_destination_status,\n product_view.item_issues\n product_view.click_potential\n product_view.click_potential_rank\n FROM ProductView\n WHERE product_view.aggregated_destination_status = 'NOT_ELIGIBLE_OR_DISAPPROVED'\n\n[Run](https://developers.google.com/shopping-content/reference/rest/v2.1/reports/search?apix=true&apix_params=%7B%22merchantId%22%3A0%2C%22resource%22%3A%7B%22query%22%3A%22SELECT%20%20product_view.id%2C%20%20product_view.offer_id%2C%20%20product_view.title%2C%20%20product_view.brand%2C%20%20product_view.currency_code%2C%20%20product_view.price_micros%2C%20%20product_view.language_code%2C%20%20product_view.condition%2C%20%20product_view.channel%2C%20%20product_view.availability%2C%20%20product_view.shipping_label%2C%20%20product_view.gtin%2C%20%20product_view.item_group_id%2C%20%20product_view.creation_time%2C%20%20product_view.expiration_date%2C%20%20product_view.aggregated_destination_status%2C%20%20product_view.item_issues%20FROM%20ProductView%20WHERE%20product_view.aggregated_destination_status%20%3D%20%27NOT_ELIGIBLE_OR_DISAPPROVED%27%22%7D%7D)\n\nClick **Run** to try the sample in the **API Explorer** . After you click\n**Run** , update the merchant ID placeholder to your own merchant ID in the\nrequest URL. You can modify the query. The full query must remain on one line to\nwork with the **API explorer**.\n\nSee the [`ProductView`](/shopping-content/reference/rest/v2.1/reports/search#productview) reference for\nmore information on specific fields and behavior.\n\nSee [Performance metrics](/shopping-content/guides/reports/metrics) to learn how\nto retrieve performance data for your products with the `Reports` service."]]
