As i see there is no way to get placement and keyword together. пятница, 11 ноября 2016 г., 19:18:00 UTC+3 пользователь Shwetha Vastrad (AdWords API Team) написал: > > 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/18b00a96-1c4c-4ec7-b573-e312e320dce2%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
