Query Google Ads (GAQL)
ads_queryRun a read-only GAQL query against one Google Ads account.
Covers any report: campaigns, ad groups, ads, keywords, search terms, assets,
conversions, budgets, change history. Monetary fields ending in _micros are
in millionths of the account currency (divide by 1,000,000). Use
ads_list_fields to discover the fields of a resource. Columns come back in
camelCase (e.g. metrics.costMicros).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum rows to return. | |
| query | Yes | GAQL query, e.g. SELECT campaign.name, metrics.clicks, metrics.cost_micros FROM campaign WHERE segments.date DURING LAST_30_DAYS ORDER BY metrics.cost_micros DESC | |
| customer_id | Yes | Google Ads account id, 10 digits (dashes allowed). | |
| login_customer_id | No | Manager account id, when the account is accessed through an MCC. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||