Google Ads: Report
ads_reportRun a GAQL query against one Google Ads account. Use for spend, clicks, conversions, cost per conversion, search terms and keyword performance. The result's date_range is the period the query covers. Auction insights metrics (auction_insight_*) are restricted by Google to allowlisted developers and not available here; use impression share instead. GAQL rules that most refusals come from: campaign dates are campaign.start_date_time / campaign.end_date_time (campaign.start_date does not exist); any field in WHERE or ORDER BY must also be in SELECT; DURING takes only LAST_7_DAYS, LAST_14_DAYS, LAST_30_DAYS, THIS_MONTH, LAST_MONTH and similar (no LAST_90_DAYS; use segments.date BETWEEN 'YYYY-MM-DD' AND 'YYYY-MM-DD').
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| query | Yes | A GAQL query, e.g. "SELECT campaign.name, metrics.cost_micros, metrics.conversions FROM campaign WHERE segments.date DURING LAST_30_DAYS" | |
| customer_id | Yes | Account ID from ads_list_accounts |