Re: ORDER BY Clicks DESC Returns INVALID_ORDER_BY_CLAUSE - Bug
Hi Marcin, It's the intended behavior. ORDER BY is not supported by AdHoc report. Best, - Takeshi, AdWords API Team On Tuesday, July 23, 2013 2:51:13 PM UTC+9, Takeshi Hagikura (AdWords API Team) wrote: Hi Marcin, Thanks for the report. I'm looking into this. I'm going to update the thread for updates. Best, - Takeshi, AdWords API Team On Tuesday, July 23, 2013 2:17:32 AM UTC+9, Marcin Rosinski wrote: Hi guys, there seems to be a bug regarding the Reporting AWQL endpoint. What steps will reproduce the problem? Run query: SELECT Query, MatchType, Clicks, Cost, Impressions FROM SEARCH_QUERY_PERFORMANCE_REPORT DURING 20130621,20130721 ORDER BY Clicks DESC Query without ORDER BY Clicks DESC works all OK. Please can you advise. P.S. Initially I have reported it here - https://code.google.com/p/google-api-adwords-php/issues/detail?id=103 but been asked to move it under this forum. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: ORDER BY Clicks DESC Returns INVALID_ORDER_BY_CLAUSE - Bug
Thanks, but in this case can you let me know when/where ORDER is supported then? cheers, /Marcin On 24/07/2013 07:34, Takeshi Hagikura (AdWords API Team) wrote: Hi Marcin, It's the intended behavior. ORDER BY is not supported by AdHoc report. Best, - Takeshi, AdWords API Team On Tuesday, July 23, 2013 2:51:13 PM UTC+9, Takeshi Hagikura (AdWords API Team) wrote: Hi Marcin, Thanks for the report. I'm looking into this. I'm going to update the thread for updates. Best, - Takeshi, AdWords API Team On Tuesday, July 23, 2013 2:17:32 AM UTC+9, Marcin Rosinski wrote: Hi guys, there seems to be a bug regarding the Reporting AWQL endpoint. What steps will reproduce the problem? Run query: SELECT Query, MatchType, Clicks, Cost, Impressions FROM SEARCH_QUERY_PERFORMANCE_REPORT DURING 20130621,20130721 ORDER BY Clicks DESC Query without ORDER BY Clicks DESC works all OK. Please can you advise. P.S. Initially I have reported it here -https://code.google.com/p/google-api-adwords-php/issues/detail?id=103 https://code.google.com/p/google-api-adwords-php/issues/detail?id=103 but been asked to move it under this forum. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 a topic in the Google Groups AdWords API Forum group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-api/yL7xHG1axv0/unsubscribe. To unsubscribe from this group and all its topics, send an email to adwords-api+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: ORDER BY Clicks DESC Returns INVALID_ORDER_BY_CLAUSE - Bug
Thanks, but in this case can you let me know when/where ORDER is supported then? cheers, /Marcin On Wednesday, 24 July 2013 07:34:02 UTC+1, Takeshi Hagikura (AdWords API Team) wrote: Hi Marcin, It's the intended behavior. ORDER BY is not supported by AdHoc report. Best, - Takeshi, AdWords API Team On Tuesday, July 23, 2013 2:51:13 PM UTC+9, Takeshi Hagikura (AdWords API Team) wrote: Hi Marcin, Thanks for the report. I'm looking into this. I'm going to update the thread for updates. Best, - Takeshi, AdWords API Team On Tuesday, July 23, 2013 2:17:32 AM UTC+9, Marcin Rosinski wrote: Hi guys, there seems to be a bug regarding the Reporting AWQL endpoint. What steps will reproduce the problem? Run query: SELECT Query, MatchType, Clicks, Cost, Impressions FROM SEARCH_QUERY_PERFORMANCE_REPORT DURING 20130621,20130721 ORDER BY Clicks DESC Query without ORDER BY Clicks DESC works all OK. Please can you advise. P.S. Initially I have reported it here - https://code.google.com/p/google-api-adwords-php/issues/detail?id=103 but been asked to move it under this forum. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: ORDER BY Clicks DESC Returns INVALID_ORDER_BY_CLAUSE - Bug
Even for AdHoc reports (not AWQL), ORDER BY is not supported. We're not planning to support it currently. Best, - Takeshi, On Wednesday, July 24, 2013 3:36:51 PM UTC+9, Marcin Rosinski wrote: Thanks, but in this case can you let me know when/where ORDER is supported then? cheers, /Marcin On Wednesday, 24 July 2013 07:34:02 UTC+1, Takeshi Hagikura (AdWords API Team) wrote: Hi Marcin, It's the intended behavior. ORDER BY is not supported by AdHoc report. Best, - Takeshi, AdWords API Team On Tuesday, July 23, 2013 2:51:13 PM UTC+9, Takeshi Hagikura (AdWords API Team) wrote: Hi Marcin, Thanks for the report. I'm looking into this. I'm going to update the thread for updates. Best, - Takeshi, AdWords API Team On Tuesday, July 23, 2013 2:17:32 AM UTC+9, Marcin Rosinski wrote: Hi guys, there seems to be a bug regarding the Reporting AWQL endpoint. What steps will reproduce the problem? Run query: SELECT Query, MatchType, Clicks, Cost, Impressions FROM SEARCH_QUERY_PERFORMANCE_REPORT DURING 20130621,20130721 ORDER BY Clicks DESC Query without ORDER BY Clicks DESC works all OK. Please can you advise. P.S. Initially I have reported it here - https://code.google.com/p/google-api-adwords-php/issues/detail?id=103 but been asked to move it under this forum. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: ORDER BY Clicks DESC Returns INVALID_ORDER_BY_CLAUSE - Bug
Thanks but in this case this Documentation is misleading - https://developers.google.com/adwords/api/docs/guides/awql - as it shows ORDER clause in there even in examples. cheers, /Marcin On Wednesday, 24 July 2013 07:41:01 UTC+1, Takeshi Hagikura (AdWords API Team) wrote: Even for AdHoc reports (not AWQL), ORDER BY is not supported. We're not planning to support it currently. Best, - Takeshi, On Wednesday, July 24, 2013 3:36:51 PM UTC+9, Marcin Rosinski wrote: Thanks, but in this case can you let me know when/where ORDER is supported then? cheers, /Marcin On Wednesday, 24 July 2013 07:34:02 UTC+1, Takeshi Hagikura (AdWords API Team) wrote: Hi Marcin, It's the intended behavior. ORDER BY is not supported by AdHoc report. Best, - Takeshi, AdWords API Team On Tuesday, July 23, 2013 2:51:13 PM UTC+9, Takeshi Hagikura (AdWords API Team) wrote: Hi Marcin, Thanks for the report. I'm looking into this. I'm going to update the thread for updates. Best, - Takeshi, AdWords API Team On Tuesday, July 23, 2013 2:17:32 AM UTC+9, Marcin Rosinski wrote: Hi guys, there seems to be a bug regarding the Reporting AWQL endpoint. What steps will reproduce the problem? Run query: SELECT Query, MatchType, Clicks, Cost, Impressions FROM SEARCH_QUERY_PERFORMANCE_REPORT DURING 20130621,20130721 ORDER BY Clicks DESC Query without ORDER BY Clicks DESC works all OK. Please can you advise. P.S. Initially I have reported it here - https://code.google.com/p/google-api-adwords-php/issues/detail?id=103 but been asked to move it under this forum. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: ORDER BY Clicks DESC Returns INVALID_ORDER_BY_CLAUSE - Bug
Yes, it's supported by service calls (such as CampaignService). But not supported by AdHoc reports. It's documented in *In AdHoc reports* section. - ORDER BY and LIMIT (Sorting and Paging) are *NOT* supported for AdHoc reports. Including these clauses in a query will generate an error. Best, - Takeshi, On Wednesday, July 24, 2013 3:45:55 PM UTC+9, Marcin Rosinski wrote: Thanks but in this case this Documentation is misleading - https://developers.google.com/adwords/api/docs/guides/awql - as it shows ORDER clause in there even in examples. cheers, /Marcin On Wednesday, 24 July 2013 07:41:01 UTC+1, Takeshi Hagikura (AdWords API Team) wrote: Even for AdHoc reports (not AWQL), ORDER BY is not supported. We're not planning to support it currently. Best, - Takeshi, On Wednesday, July 24, 2013 3:36:51 PM UTC+9, Marcin Rosinski wrote: Thanks, but in this case can you let me know when/where ORDER is supported then? cheers, /Marcin On Wednesday, 24 July 2013 07:34:02 UTC+1, Takeshi Hagikura (AdWords API Team) wrote: Hi Marcin, It's the intended behavior. ORDER BY is not supported by AdHoc report. Best, - Takeshi, AdWords API Team On Tuesday, July 23, 2013 2:51:13 PM UTC+9, Takeshi Hagikura (AdWords API Team) wrote: Hi Marcin, Thanks for the report. I'm looking into this. I'm going to update the thread for updates. Best, - Takeshi, AdWords API Team On Tuesday, July 23, 2013 2:17:32 AM UTC+9, Marcin Rosinski wrote: Hi guys, there seems to be a bug regarding the Reporting AWQL endpoint. What steps will reproduce the problem? Run query: SELECT Query, MatchType, Clicks, Cost, Impressions FROM SEARCH_QUERY_PERFORMANCE_REPORT DURING 20130621,20130721 ORDER BY Clicks DESC Query without ORDER BY Clicks DESC works all OK. Please can you advise. P.S. Initially I have reported it here - https://code.google.com/p/google-api-adwords-php/issues/detail?id=103 but been asked to move it under this forum. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. For more options, visit https://groups.google.com/groups/opt_out.
ORDER BY Clicks DESC Returns INVALID_ORDER_BY_CLAUSE - Bug
Hi guys, there seems to be a bug regarding the Reporting AWQL endpoint. What steps will reproduce the problem? Run query: SELECT Query, MatchType, Clicks, Cost, Impressions FROM SEARCH_QUERY_PERFORMANCE_REPORT DURING 20130621,20130721 ORDER BY Clicks DESC Query without ORDER BY Clicks DESC works all OK. Please can you advise. P.S. Initially I have reported it here - https://code.google.com/p/google-api-adwords-php/issues/detail?id=103 but been asked to move it under this forum. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. For more options, visit https://groups.google.com/groups/opt_out.
Re: ORDER BY Clicks DESC Returns INVALID_ORDER_BY_CLAUSE - Bug
Hi Marcin, Thanks for the report. I'm looking into this. I'm going to update the thread for updates. Best, - Takeshi, AdWords API Team On Tuesday, July 23, 2013 2:17:32 AM UTC+9, Marcin Rosinski wrote: Hi guys, there seems to be a bug regarding the Reporting AWQL endpoint. What steps will reproduce the problem? Run query: SELECT Query, MatchType, Clicks, Cost, Impressions FROM SEARCH_QUERY_PERFORMANCE_REPORT DURING 20130621,20130721 ORDER BY Clicks DESC Query without ORDER BY Clicks DESC works all OK. Please can you advise. P.S. Initially I have reported it here - https://code.google.com/p/google-api-adwords-php/issues/detail?id=103 but been asked to move it under this forum. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and discussion group: http://adwordsapi.blogspot.com http://groups.google.com/group/adwords-api =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. For more options, visit https://groups.google.com/groups/opt_out.
