GAQL: Feature Request: Add OFFSET clause to allow for manual paging

[MS]

I'd like to propose an OFFSET clause in GAQL. This would allow manual paging using GAQL SearchStream().

For example, to skip the first 20 rows and the return 10 rows, a future GAQL query may look like this:

  SELECT
    campaign.name
  , campaign.status
  FROM campaign

  OFFSET 20

  LIMIT 10

[Axel Dahmen]

Thank you for your reply.

I understand that there is no OFFSET clause currently supported by the API. Just wanted to pose a feature request.

In the meantime, in my personal repository I will extend my GAQL parser for supporting an OFFSET clause and skip the corresponding number of returned rows. However, this is not be solving the original issue as it will retain the current unnecessary strain on Google servers and internet connection.

Best regards

Am 29.08.2025 um 19:46 schrieb Google Ads API Forum Advisor:

Hi,

Thank you for reaching out to the Google Ads API support team.

Please note that LIMIT with OFFSET is not a valid LIMIT clause in GAQL. You may use the Query Validator to check if the entered query is valid. For limiting the number of results, you may refer to this guide for more information. Let us know if you have any additional questions. To construct a query in Google Ads Query Language, you will need to build it using the language grammar. To know the valid and allowed clause in the GAQL query, please refer to this API documentation: Query Structure

I hope it helps. Kindly get back to us if you have any further queries related to the Google Ads API.

Thanks,
 

Google Ads API Team

Feedback
How was our support today?

               
[2025-08-29 17:46:05Z GMT] This message is in relation to case "ref:!00D1U01174p.!500Ht01u5VBe:ref" (ADR-00331368)

[Google Ads API Forum Advisor]

Hi,

It's not possible to submit a feature request for the OFFSET clause in the Google Ads API. For more details on supported clauses in the Google Ads Query Language Grammar, please refer to the official documentation.   

Thanks,
 

Google Ads API Team

Feedback
How was our support today?

               

[2025-09-01 15:24:59Z GMT] This message is in relation to case "ref:!00D1U01174p.!500Ht01u5VBe:ref" (ADR-00331368)