Missing filtering from shopping_performance_view and cannot find relationship with product_group_view

[Iván López]

Hello,

I am trying to get the not excluded products from and ad_group with shopping_performance_view, in the UI I can filter by the Product Status (Attached Image1), so I can get, for example, product only "ready to serve". But I cannot find a way to get this info at product level (not product group level). How can i get it?

I know that every product group (listing group in API) is an ad_group_criterion where I can see through ad_group_criterion.negative if it is excluded or not. And I know that a Product belong to a product group. But I cannot find the way to do the following. I A have a product from the shopping_performance_view, how can I get the product group this product belongs to? In order to see if its product groups i excluded or not?

I know that every ad_group_criteiron has a filed "paren_ad_group_criteiron" but if I need to know the product group when I only have the information at product level (from shopping_performance_view), how can I get this?

Moreover, if I have an specific product group, how can I get all the products that belongs to that product group? If the product are not separated as a product group of 1 product, the do not have de parent_ad_group_criterion field and I cannot get this info.

Is there anyway to know these things through the API? The most important for me is the issue about info I can get through the UI and not through the API (attached image).

Thank you

[Google Ads API Forum Advisor]

Hi Iván,

Thank you for reaching out to our API support team. You may refer below for my responses to the questions that you sent over :

I have a product from the shopping_performance_view, how can I get the product group this product belongs to? In order to see if its product groups i excluded or not?

You can try the query below to determine which listing group or parent the product item belongs to :

• SELECT ad_group_criterion.negative, ad_group_criterion.listing_group.type, ad_group_criterion.listing_group.parent_ad_group_criterion FROM ad_group_criterion WHERE ad_group_criterion.listing_group.case_value.product_item_id.value = '123456789'

Moreover, if I have an specific product group, how can I get all the products that belongs to that product group? 

If you already know the criterion Id of your Product Group, you can then try the query below :

• SELECT ad_group_criterion.listing_group.case_value.product_item_id.value FROM ad_group_criterion WHERE ad_group_criterion.criterion_id IN  ('987654321')

If the product are not separated as a product group of 1 product, the do not have de parent_ad_group_criterion field and I cannot get this info.

For this item, could you further elaborate the scenario?

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2f33oo:ref