Hi all,
I would like to generate a dataframe in spark to represent the performance of ad_groups segmented by Age, Gender and Device. Device is easy to have in AdGroupPerformance report type, but how can I grab Age and Gender info in awql or other api calls? It's not possible to join AdGroupPerformance, AgeRangePerformance and GenderPerformance reports dataframe to achieve the goal because I believe it's hard to segment the ad_group performances by gender and age by just joining Age and Gender tables, for example: #assume I want some dataset like this below: campaign_name ad_group_name gender age_range clicks impressions campaign_1 ad_group_1 Male 18to24 14 203 campaign_1 ad_group_1 Female 18to24 34 455 campaign_1 ad_group_1 Male gt64 0 13 campaign_1 ad_group_1 Female gt64 2 24 Please let me know if any ways that I can pull data like this, bunch of thanks in advance !! Thanks, James -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords 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 Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/ba1cde16-c0bf-4b50-ac6d-e5d7cdc67d0f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.