Re: AWQL : how to use CampaignStatus, ORDER BY and LIMIT to retrieve formated datas ?

['Peter Oliquino' via AdWords API Forum]

Hi Vincent,

Yes, the ORDER BY and LIMIT are currently not supported in the AdWords API 
reports as discussed here 
.
 
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.

AWQL : how to use CampaignStatus, ORDER BY and LIMIT to retrieve formated datas ?

[Vincent Pélage]

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 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/5a20a2a9-1d6f-45a7-9b0b-18b6f3242790%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.