Hi, I'm using https://www.awql.me to build request and the first one below works, I'm successfully able to retrieve all campaigns with datas from past 7 days :
SELECT CampaignId, CampaignName, Clicks, Impressions FROM CAMPAIGN_PERFORMANCE_REPORT DURING LAST_7_DAYS But when I try to add CampaignStatus *and*/*or* ORDER BY *and*/*or* LIMIT, I've got the following error message : Underlying errors are <br />Type = 'QueryError.LIMIT_CLAUSE_NOT_SUPPORTED', Trigger = '', FieldPath = '' There is below the request that cause the issue (I also tried to just use CampaignStatus, ORDER BY and LIMIT separately but the same error occured) : SELECT CampaignId, CampaignName, Clicks, Impressions FROM CAMPAIGN_PERFORMANCE_REPORT WHERE CampaignStatus = 'Enabled' DURING LAST_7_DAYS ORDER BY Clicks DESC LIMIT 0,5 I read that it's not possible to use ORDER BY and LIMIT with CAMPAIGN_PERFORMANCE_REPORT, so how do you guys get around this limitation to retrieve formated datas in the response, at a campaigns level ? Did you find a way to make the status works in your AWQL request ? Thanks a lot ! Vincent -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/921df9e0-47fb-4edb-ad99-0918d3510658%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
