Hi,
I am working on creating a table of metrics broken down by gender type and came across the following cookbook link: https://developers.google.com/google-ads/api/docs/query/cookbook#gender_demographics . The suggested query works but returns multiple records for each gender type, depending on the number of campaigns and ad groups. I would like to aggregate these metrics so that I have a single summarized row per gender, for example: GENDER, clicks, ctr, average_cpc FEMALE, 1000, 10.24, 154.47 MALE, 2000, 20.24, 454.47 One challenge I am facing is that simply averaging fields like CTR and Average CPC across rows would not produce correct results, as they require weighted averages. However, the query results do not provide the necessary weights for each row. Could you please advise on the best way to correctly aggregate these metrics by gender? GAQL query suggested by quick book - SELECT ad_group_criterion.gender.type, campaign.name, ad_group.name, ad_group_criterion.system_serving_status, ad_group_criterion.bid_modifier, metrics.clicks, metrics.impressions, metrics.ctr, metrics.average_cpc, metrics.cost_micros, campaign.advertising_channel_type FROM gender_view WHERE segments.date DURING LAST_7_DAYS -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/908ee4bb-22f3-44ab-8149-bcaea89858ben%40googlegroups.com.
