Custom Google Ads query
run_gaqlExecute arbitrary Google Ads Query Language (GAQL) queries to retrieve custom reports beyond built-in report tools, returning rows as table, JSON, or CSV.
Instructions
Execute an arbitrary GAQL (Google Ads Query Language) query.
For queries beyond the dedicated report tools. Returns the result rows in the requested format with the query echoed back; cost fields stay in raw micros (cost_micros / 1,000,000 = account currency). A failing query returns an error with a hint.
Queries the Google Ads API. GAQL syntax and fields: https://developers.google.com/google-ads/api/docs/query/overview
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | The GAQL query, e.g. "SELECT campaign.name, metrics.clicks FROM campaign WHERE segments.date DURING LAST_7_DAYS". | |
| format | No | Output format: "table" (default, readable), "json" (structured), or "csv" (exportable). | table |
| customer_id | No | Google Ads customer ID, digits with or without dashes (123-456-7890). Empty uses the configured default account. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||