AWQL Limits and Select TOP results

[Kenny Chung]

Hi Guys,

I'm in the process of migrating from v201209 to v201309 and I'm coming into all sorts of problems.

We previously used the selector and paging method to get all the adgroups (over 168,000), but paging over 100,000 is no longer supported.

I've recently learnt that AWQL is useless for this as well, as it has a query limit of only 10,000 and there is no paging for AdHoc Reports.

We need to get the full list of adgroups in order to perform processing, so what method should we be using now to get the data from the AdGroupPage?

Regards,

Kenny

[Josh Radcliff (AdWords API Team)]

Hi Kenny,

It sounds like Structure Reports would provide exactly what you need.  Could you provide details of where you are seeing a limit of only 10,000 rows for AWQL?  Per a previous post, I wouldn't expect such a limit to exist.  If you have a report example that's giving you trouble please send it along.  You can also send the customer ID directly to me by clicking "Reply to Author" if you'd like me to run the report on my side.

Thanks,

Josh, AdWords API Team