Hi Sherwin, Thank you for looking into it.
I know about the possibility to include fields from the campaign resource in shopping_performance_view. Unfortunately, campaign.shopping_setting.feed_label is not exactly the product level like for example the segments.product_country. If I have a campaign 123 targeting feed label A on December 1st and feed label B on December 2nd (feed label can be changed in the campaign settings), the shopping performance view will show me campaign.shopping_setting.feed_label as A on December 1st and B on December 2nd and later. Therefore I won't be able to assign the statistics to a specific product in GMC (there can be more products with the same product ID but different feed label). Also, I believe it's possible to set no feed_label and no sales_country (meaning the campaign will use products from all feeds). In that case, there's no way to specify the product in shopping_performance_view either. Do you by any chance have any information regarding adding feed label to the product level of the shopping performance view in some of new versions of Google Ads API? It would help us a lot. Kind regards, Katerina On Wednesday, December 28, 2022 at 8:17:39 AM UTC+1 adsapi wrote: > Hi Katerina, > > Thank you for getting back to us. I hope that you are doing well today. > > Moving forward to your concern on how to get the Feed label in product > level, in the shopping_performance_view > <https://developers.google.com/google-ads/api/fields/v12/shopping_performance_view> > > report, the campaign > <https://developers.google.com/google-ads/api/fields/v12/campaign> report > is included as segmenting resources. With that being said, you may use the > campaign.shopping_setting.feed_label > <https://developers.google.com/google-ads/api/fields/v12/campaign#campaign.shopping_setting.feed_label> > to > fetch the Feed Label information. > > Add to that, please note that if the Feed label is not used, it will fetch > the information of sales country codes. You may also use the > campaign.shopping_setting.sales_country > <https://developers.google.com/google-ads/api/fields/v12/campaign#campaign.shopping_setting.sales_country> > in > the query to get the value of the Feed label in the UI if it shows country > codes. > > You may try the sample query I used below: > > - {"query": "SELECT campaign.shopping_setting.feed_label, > segments.product_item_id, campaign.shopping_setting.sales_country, > segments.product_channel, segments.product_country, > segments.product_language, segments.product_merchant_id FROM > shopping_performance_view WHERE segments.date = '2022-12-22'"} > > > You may also check this reference > <https://developers.google.com/google-ads/api/reference/rpc/v12/Campaign.ShoppingSetting> > for > Shopping settings. > > Kind regards, > [image: Google Logo] > Sherwin Vincent > Google Ads API Team > > > ref:_00D1U1174p._5004Q2hMLTm: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 "Google Ads API and AdWords 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/e0bae3a6-5f63-42d1-a7e6-40553768f208n%40googlegroups.com.
