Hi Oliver, what is missing is the functionality to segment the shopping_performance_view report by the product_group_view.resource_name or the criterion_id of the product_group. It would have to be a segment, because a product can be assigned to different product groups in the reporting period, since these are basically just a kind of filter, not a fixed structure, such as ad groups.
I think you could, however, reverse engineer the *current* structure of your product_groups (using the attributed ad_group_criterion resource to the product_group_view) and then check, which combination of segments.product_brand, segments.product_channel etc. associated to a segments.product_item_id of the shopping_performance_view would match with that structure. But that would be a really messy job - and you still wouldn't know if a reported product_item_id in the shopping_performance_view is even still in the shopping feed. So you would have to check that too (which is currently not possible via the Google Ads API). Instead you'd have to use the Content API for Shopping <https://developers.google.com/shopping-content/guides/quickstart> for this job. Regards Mat Oliver schrieb am Mittwoch, 29. Dezember 2021 um 09:09:41 UTC+1: > Hi Aryeh, > > The scenario you're talking about works only if the product groups are > subdivided by item ID. This way, each product group represents one product > and hence why you see product_item_id in the data returned from > product_group_view. > > However, subdividing by item ID is not the only way of subdividing product > groups. In fact, it's not common at all. Product groups can also be > sub-divided by brand, type, etc. in which case the product_item_id will *not > *be available in the data returned from product_group_view. > > Has anyone else tried to solve this problem before? Your contribution is > much appreciated. > > Oliver > > On Tuesday, December 28, 2021 at 9:45:47 PM UTC adsapi wrote: > >> Hi Oliver, >> >> 'product_item_id' will give the product Id, every product is also a >> product group. A real group won't have a product Id. I tested this and it >> works. >> >> >> If there is any UI screen that has what you are looking for, could you >> privately send us a full screen screenshot? >> >> Regards, >> >> [image: Google Logo] >> Aryeh Baker >> Google Ads API Team >> >> >> ref:_00D1U1174p._5004Q2TlP6J:ref >> > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/c695307d-5a8d-4649-8d9f-2153edb9b463n%40googlegroups.com.
