You can use the
[`ProductView`](https://developers.google.com/shopping-content/reference/rest/v2.1/reports/search#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`](https://developers.google.com/shopping-content/reference/rest/v2.1/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](https://developers.google.com/shopping-content/guides/products/product-id).

You can filter based on all the [available
fields](https://developers.google.com/shopping-content/reference/rest/v2.1/reports/search#productview) 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`](https://developers.google.com/shopping-content/reference/rest/v2.1/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
      product_view.click_potential
      product_view.click_potential_rank
    FROM ProductView
    WHERE product_view.aggregated_destination_status = 'NOT_ELIGIBLE_OR_DISAPPROVED'

[Run](https://developers.google.com/shopping-content/reference/rest/v2.1/reports/search?apix=true&apix_params=%7B%22merchantId%22:0,%22resource%22:%7B%22query%22:%22SELECT++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+%3D+'NOT_ELIGIBLE_OR_DISAPPROVED'%22%7D%7D)

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`](https://developers.google.com/shopping-content/reference/rest/v2.1/reports/search#productview) reference for
more information on specific fields and behavior.

See [Performance metrics](https://developers.google.com/shopping-content/guides/reports/metrics) to learn how
to retrieve performance data for your products with the `Reports` service.