Hi Can you please let me know which query to use to extract the asset information together with the metrics and the ad/campaign ids?
Thank you Irina On Saturday, January 25, 2025 at 12:24:48 AM UTC Irina Neagu wrote: > Hi > > Similar to this query 'Asset level data of Pmax / DemandGen through API' , > I am looking to easily extract asset level (i.e conversion data per > creative) and most importantly, the asset (creative) itself. So, if it's a > headline, i'm looking to extract the text string. > I have tried the query shared in the thread but it does not retrieve the > creative itself. Is there a way to get the actual asset/ headline string? > > This is for demandGen - i have searched the documentation but I couldn't > find which table/ column is or if multiple need to be merged. > [image: 6JSoRviZC8J2k3x.png] > > > ' SELECT metrics.conversions, metrics.conversions_value, > metrics.cost_per_all_conversions, metrics.all_conversions_value, > asset.name, metrics.all_conversions, metrics.cost_per_conversion, > metrics.conversions_value_per_cost, metrics.all_conversions_value_per_cost > FROM ad_group_ad_asset_view WHERE segments.date BETWEEN '2024-12-24' AND > '2025-01-22' AND asset.id = AND ad_group.id = AND campaign.id = AND > ad_group_ad.ad.id = ' > > > Thank you > Irina > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 visit https://groups.google.com/d/msgid/adwords-api/58e9b46f-97e4-4f66-b5f1-61abfdad6f44n%40googlegroups.com.
