The following search query doesn't include performance max campaigns. How can I replicate the above UI query in GAQL?
SELECT segments.product_item_id, metrics.clicks, metrics.impressions, metrics.all_conversions, campaign.end_date, campaign.id FROM shopping_performance_view WHERE campaign.end_date BETWEEN '2022-07-01' AND '2022-07-31' ORDER BY metrics.clicks DESC Thanks On Tuesday, 16 August 2022 at 10:21:04 UTC+1 Brett Hadley wrote: > Hi > > That doesn't appear to give the MCA ItemId > > In the Google UI I'm looking to replicate this report which does include > performance max clicks. You can see here "Item ID" this is Product level > aggregation within the MCA. > > w[image: Screenshot 2022-08-16 at 10.20.08.png] > > On Monday, 15 August 2022 at 21:18:17 UTC+1 adsapi wrote: > >> Hi Brett, >> >> Upon checking further, you should be able to use the >> asset_group_product_group_view >> <https://developers.google.com/google-ads/api/fields/v11/asset_group_product_group_view> >> for >> statistics of your Performance Max campaigns listing groups. Let me know if >> this helps. >> >> >> Best regards, >> >> [image: Google Logo] >> Peter Laurence >> Google Ads API Team >> >> >> ref:_00D1U1174p._5004Q2dKlCV:ref >> > Brett Hadley Head of Engineering T: +44 (0)330 127 3969 E:brett.had...@redbrain.com W: www.redbrain.com Redbrain Ltd is a company registered in England and Wales with registered number 10434678. Registered office: Office 3, St Ann's House, Guildford Road, Lightwater, Surrey, GU18 5RA, United Kingdom. Redbrain Ltd accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing [other than by email]. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/ca0a49e0-eb07-4332-b889-1fb15f8d416en%40googlegroups.com.
