Product filtering in the Reports service is available to selected merchants. Submit the interest form to request access.

Filter products

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

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:

SELECT
  product_view.id,
  product_view.offer_id,
  product_view.title,
  product_view.brand,
  product_view.currency_code,
  product_view.price_micros,
  product_view.language_code,
  product_view.condition,
  product_view.channel,
  product_view.availability,
  product_view.shipping_label,
  product_view.gtin,
  product_view.item_group_id,
  product_view.creation_time,
  product_view.expiration_date,
  product_view.aggregated_destination_status,
  product_view.item_issues
FROM ProductView
WHERE product_view.aggregated_destination_status = 'NOT_ELIGIBLE_OR_DISAPPROVED'

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.