GAQL Lab

Query live Google Ads data with GAQL: write queries with autocomplete, build them visually and export the results.

GAQL (Google Ads Query Language) is the SQL-like language behind Google Ads reporting. GAQL Lab runs queries against any connected account, straight from chiliad.

When to use it

Before writing a script — check which campaigns, labels or conversion actions an account really has.
For a quick report — pull numbers without building a report in Google Ads.
While debugging — run the query your script uses and look at what comes back.

The Lab is read-only. It accepts SELECT queries only and cannot change anything in your accounts.

The editor

As you type, the editor suggests fields, resources and date ranges for the position of your cursor. Press Ctrl+Space to open the suggestions yourself.

app.chiliad.io/gaql

GAQL Lab

EditorBuilder

1GrowthLab Store 234-567-8901 ▾

SELECT campaign.name, metrics.clicks, metrics.cost_micros
FROM campaign
WHERE campaign.status = 'ENABLED'
  AND segments.date DURING LAST_7_DAYS
ORDER BY metrics.cost_micros DESC

Valid query

Examples:Campaign PerformanceKeywords + Quality ScoreSearch Terms2

Run Query3AdsApp.search()CSV5⌘↵ run

Results 4

3 rows · 0.8s

Copy CSV

#	Campaign Name	Clicks	Cost
1	Brand — Search	1,204	$312.40
2	Shopping — Core	986	$281.75
3	PMax — Prospecting	540	$198.10

1
Pick the account to query.
2
Start from an example and adapt it.
3
Run Query, or press Cmd+Enter. The validator flags unknown fields and syntax errors before you run.
4
Results with readable column names. Cost values in micros are converted for you.
5
Copy the query as an AdsApp.search() snippet for a script, or download the rows as CSV.

Tip

History under the editor keeps your recent queries so you can run them again.

The query builder

Not sure of the field names? The Builder tab assembles the query from a form.

app.chiliad.io/gaql

EditorBuilder

GrowthLab Store 234-567-8901 ▾

Resource (FROM) 1

campaign ▾

Fields (SELECT) 2

Attributes

campaign.name

campaign.status

Metrics

metrics.clicks

metrics.cost_micros

Segments

segments.date

segments.device

Filters (WHERE) 3

segments.dateDURINGLAST_7_DAYS

Order By

metrics.cost_micros ↓

Limit

Generated Query

SELECT campaign.name, metrics.clicks, metrics.cost_micros
FROM campaign
WHERE campaign.status = 'ENABLED'
  AND segments.date DURING LAST_7_DAYS
ORDER BY metrics.cost_micros DESC

Use in Editor4

1
Choose the resource to query — the FROM part.
2
Tick the fields you need. They are grouped into attributes, metrics and segments.
3
Add filters, including date ranges such as LAST_7_DAYS.
4
Use in Editor moves the generated query to the editor, where you can run or refine it.

From query to script

A query that returns the right rows is most of a reporting script. Click AdsApp.search() to copy a ready snippet that runs the same query inside Google Ads, then build your logic around it in a script.

Claude can run the same read-only queries through the Claude connector, which is how it checks real account data before setting per-account values.

When to use it

Before writing a script — check which campaigns, labels or conversion actions an account really has.
For a quick report — pull numbers without building a report in Google Ads.
While debugging — run the query your script uses and look at what comes back.

The Lab is read-only. It accepts SELECT queries only and cannot change anything in your accounts.

The editor

As you type, the editor suggests fields, resources and date ranges for the position of your cursor. Press Ctrl+Space to open the suggestions yourself.

app.chiliad.io/gaql

GAQL Lab

EditorBuilder

1GrowthLab Store 234-567-8901 ▾

SELECT campaign.name, metrics.clicks, metrics.cost_micros
FROM campaign
WHERE campaign.status = 'ENABLED'
  AND segments.date DURING LAST_7_DAYS
ORDER BY metrics.cost_micros DESC

Valid query

Examples:Campaign PerformanceKeywords + Quality ScoreSearch Terms2

Run Query3AdsApp.search()CSV5⌘↵ run

Results 4

3 rows · 0.8s

Copy CSV

#	Campaign Name	Clicks	Cost
1	Brand — Search	1,204	$312.40
2	Shopping — Core	986	$281.75
3	PMax — Prospecting	540	$198.10

1
Pick the account to query.
2
Start from an example and adapt it.
3
Run Query, or press Cmd+Enter. The validator flags unknown fields and syntax errors before you run.
4
Results with readable column names. Cost values in micros are converted for you.
5
Copy the query as an AdsApp.search() snippet for a script, or download the rows as CSV.

Tip

History under the editor keeps your recent queries so you can run them again.

The query builder

Not sure of the field names? The Builder tab assembles the query from a form.

app.chiliad.io/gaql

EditorBuilder

GrowthLab Store 234-567-8901 ▾

Resource (FROM) 1

campaign ▾

Fields (SELECT) 2

Attributes

campaign.name

campaign.status

Metrics

metrics.clicks

metrics.cost_micros

Segments

segments.date

segments.device

Filters (WHERE) 3

segments.dateDURINGLAST_7_DAYS

Order By

metrics.cost_micros ↓

Limit

Generated Query

SELECT campaign.name, metrics.clicks, metrics.cost_micros
FROM campaign
WHERE campaign.status = 'ENABLED'
  AND segments.date DURING LAST_7_DAYS
ORDER BY metrics.cost_micros DESC

Use in Editor4

1
Choose the resource to query — the FROM part.
2
Tick the fields you need. They are grouped into attributes, metrics and segments.
3
Add filters, including date ranges such as LAST_7_DAYS.
4
Use in Editor moves the generated query to the editor, where you can run or refine it.

From query to script

Claude can run the same read-only queries through the Claude connector, which is how it checks real account data before setting per-account values.