Limit the number of rows returned in a report fetch

[giles bodger]

HI all

I am wanting to limit the number of rows i pull down in a report fetch - we have a requirement to get ALL the keywords in an account and make sure they are labeled with a particular label.

Once we know the keywords that have NOT yet been labeled, from the report fetch, then we can label them and then the next time the report runs we will get a smalller returned amount

HOWEVER

I dont want to download ALL our keywords at once to start with as we have millions of them in each of our several 1000 accounts

Is there ANY way i could set a limit for a report fetch ?

If i use the SDK ReportUtilities with a paging object it tells me paging is not supported

AWQL also tells me that the LIMIT predicate is not allowed with reports

https://developers.google.com/adwords/api/docs/guides/awql

So any help you could give me would be great

many thanks - Giles 

[Google Ads API Forum Advisor Prod]

Hi Giles,

Thank you for reaching out. You can use predicate filters to get the keywords that are for a specific campaign or ad group which can help limit the amount of them that are returned. However, there is no way to explicitly limit the results to a certain amount.

Regards,
Mitchell
Google Ads API Team

ref:_00D1U1174p._5001UUzrLt:ref

[giles bodger]

Thanks for the reply Mitchell

 - unfortunately that doesnt help the requirement as we wont know any of the keywords that aren't labeled  - we just want to pull for all those keywords that dont have a specific label  -BUT we know that at some point that pull will be for millions of keywords and we have several 1000 accounts with millions of keywords - so we dont want to bloat our server memory with multiple huge report downloads. We had through od just doing the report fetch a bit at a time, hence asking about the "Limit" option

Never mind though, we have come up with an alternative solution

thanks again for the response

Giles