How to get a report of available products

[The Garden Shop Maya]

Hi! Is there a way to get a report or list of all available products uploaded in merchant center using the Google Ads API?

[Google Ads API Forum Advisor]

Hi,

The list of products from Merchant Center can be retrieved via Content API but not Google Ads API.

Products.list call: https://developers.google.com/shopping-content/reference/rest/v2.1/products/list

Thanks,

Lakshmi Prathipati Google Ads API Team

ref:_00D1U1174p._5004Q2JWk4S:ref

[The Garden Shop Maya]

Thanks for your response. I got a list of products using the following query:

SELECT segments.product_title, segments.product_item_id FROM shopping_performance_view

This returns a list of products which is what I was looking for, but many of them seem to be duplicated or not active. Is there a way to filter this query in order to get only the active products?

I'm trying to get the products without having direct access to the merchant account. I know this can be done as some time ago I received an invitation from a company to try their platform to manage my shopping ads. This platform only requested access to my Ads account, and it automatically generated product groups for individual products, so they got product-specific information directly from my ads account.

Thank you in advance.

[Google Ads API Forum Advisor]

Hello,

The shopping_performance_view does not support a segment or attribute for filtering product status, nor is it available elsewhere in the API. However, I will submit a feature request on your behalf. New features will be announced on the Ads Developer blog.

Regards,
Matt
Google Ads API Team

Matt Google Ads API Team

ref:_00D1U1174p._5004Q2JWk4S:ref