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:
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'
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.