Hi, I'm afraid you cannot use full SQL vocabulary in AWQL query. Although AWQL is inspired by SQL, JOIN and GROUP BY clauses are omitted. You can use AwReporting framework <https://github.com/googleads/aw-reporting> using which reports can be stored in your relational database.
You can use Placement Performance Report <https://developers.google.com/adwords/api/docs/appendix/reports/placement-performance-report> and Automatic Placements Performance Report <https://developers.google.com/adwords/api/docs/appendix/reports/automatic-placements-performance-report> to get statistics at the placement level, for managed and automatic placements respectively. To get statistics for how an Ad performed for different keywords, you can use Ad Performance Report <https://developers.google.com/adwords/api/docs/appendix/reports/ad-performance-report#criterionid> and add CriterionId field in the query. This field contains IDs for keywords and other criterion types. If you include the Date field in the report query, the data will be segmented by date. You can store these reports in your database and use SQL to group results as needed. I hope this helps. Regards, Shwetha, AdWords API Team. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/05fd530e-a255-4289-a3b4-6bac99dd6562%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
