Hi Vincent, Yes, the ORDER BY and LIMIT are currently not supported in the AdWords API reports as discussed here <https://developers.google.com/adwords/api/docs/guides/awql#using_awql_with_reports>. Additionally, there is currently no workaround via the AdWords API for this and you may have to implement sorting only at your end.
As for filtering using the CampaignStatus field, you may refer to my sample query below : SELECT CampaignId, CampaignName, Clicks, Impressions FROM CAMPAIGN_PERFORMANCE_REPORT WHERE CampaignStatus = ENABLED DURING LAST_7_DAYS I hope this helps. Thanks and regards, Peter 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/8a2305d2-e742-4f2a-ba6e-d1a65a894b33%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
