Execute Google Ads report
google_ads_execute_reportExecute a structured Google Ads GAQL query for one account. Returns JSON Lines (every line is a JSON object): the first line is a JSON Schema of the selected fields (carrying a "metadata":"schema" marker to identify it), then one nested JSON object per row. Field names are the snake_case Google Ads GAQL names; enums are returned as their Google value (e.g. ENABLED). On a Google API error a detailed message describing the problem is returned.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Optional maximum number of rows (GAQL LIMIT). | |
| fields | Yes | GAQL fields to select, e.g. ["campaign.name", "metrics.clicks", "metrics.impressions"]. | |
| report | Yes | Google Ads report/resource to query, e.g. "campaign", "ad_group", "keyword_view", "ad_group_ad". | |
| endDate | No | Optional end date (yyyy-MM-dd); startDate is required when set. | |
| orderBy | No | Optional ORDER BY entries, e.g. ["metrics.clicks DESC"]. | |
| accountId | Yes | TrueClicks account id (the numeric Id field from the account listing, not the Google Ads customer id / ClientCustomerId). Must be a Google Ads account accessible by the connector. | |
| startDate | No | Optional start date (yyyy-MM-dd); endDate is required when set. | |
| predicates | No | Optional GAQL WHERE predicates, e.g. ["campaign.status = 'ENABLED'", "metrics.impressions > 0"]. |