Hi all! I'm getting some reports with AWQL, but when I try to order the retrieve, it fails.
This is my good query: * $reportQuery = 'SELECT CampaignId, CampaignName, AdGroupId, Id, Criteria, CriteriaType, '* * . 'Impressions, Clicks, Cost FROM CRITERIA_PERFORMANCE_REPORT '* * . 'WHERE Status IN [ACTIVE, PAUSED] DURING ' . $dateRange;* The $dateRange variable it's fine, so that isn't the problem. This is the failing query: * $reportQuery = 'SELECT CampaignId, CampaignName, AdGroupId, Id, Criteria, CriteriaType, '* * . 'Impressions, Clicks, Cost FROM CRITERIA_PERFORMANCE_REPORT '* * . 'WHERE Status IN [ACTIVE, PAUSED] DURING ' . $dateRan**ge** . ' ORDER BY Cost DESC';* And this is the error I get: *Underlying errors are Type = 'QueryError.INVALID_ORDER_BY_CLAUSE', Trigger = '', FieldPath = ''.* All what I read says me that *the documentation is WRONG*, because there is also an error with "DURING_CLAUSE" if I don't use it within the query string. Can anyone clarify me that? Thank you! -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
