Stay organized with collections
Save and categorize content based on your preferences.
You can use the
ProductView
table of the Reports service to show a filtered view of your product data,
including product statuses.
For example, you can query ProductView to do the following:
List products that have issues, so you can resolve them.
Get a list of your new products, so you can verify serving.
To view full details of all your products, use
products.list.
You must include the product_view.id field in the SELECT clause of your
query. The product_view.id has the same value as the product's REST
ID.
You can filter based on all the available
fields except the following:
product_view.expiration_date
product_view.item_issues
You can sort the response based on all the available fields except the following:
product_view.gtin
product_view.item_issues
You can use the following fields to view the performance potential of your
products:
product_view.click_potential
product_view.click_potential_rank
Here's an example that returns all the available fields for your products with
the status NOT_ELIGIBLE_OR_DISAPPROVED. To make the request, pass the
following Merchant Center Query Language statement to the
reports.search
method:
Click Run to try the sample in the API Explorer. After you click
Run, update the merchant ID placeholder to your own merchant ID in the
request URL. You can modify the query. The full query must remain on one line to
work with the API explorer.
See the ProductView reference for
more information on specific fields and behavior.
See Performance metrics to learn how
to retrieve performance data for your products with the Reports service.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 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."]]