Google Ads query (GAQL)
ads_queryRun read-only Google Ads Query Language queries to pull search terms, campaign metrics, and paid vs organic performance data from linked ad accounts.
Instructions
Runs a read-only Google Ads Query Language query. Examples: paid vs organic for the same query (needs Ads linked to Search Console) — SELECT paid_organic_search_term_view.search_term, metrics.organic_clicks, metrics.organic_impressions, metrics.clicks, metrics.impressions FROM paid_organic_search_term_view WHERE segments.date DURING LAST_30_DAYS; search terms that triggered ads — SELECT search_term_view.search_term, metrics.clicks, metrics.cost_micros, metrics.conversions FROM search_term_view WHERE segments.date DURING LAST_30_DAYS ORDER BY metrics.clicks DESC; campaigns — SELECT campaign.name, campaign.status, metrics.clicks, metrics.cost_micros FROM campaign WHERE segments.date DURING LAST_30_DAYS. cost_micros / 1,000,000 = account currency.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| query | Yes | GAQL SELECT statement | |
| customerId | No | Google Ads customer ID (123-456-7890); defaults to googleAdsCustomerId |