Google Ads performance
google_campaign_performanceGoogle Ads metrics for the account, its campaigns, ad groups or keywords over a period: cost, impressions, clicks, CTR, CPC, conversions, value, CPA, ROAS. Period: date_preset (LAST_* periods do not include today) or since and until, in the account time zone. level: account, campaign (default), ad_group or keyword; campaign_id narrows campaign, ad group and keyword rows to one campaign. by_day adds a row per date. Rows are ordered by cost, highest first (by date with by_day). Cost is in micros and as text in the account currency; conversions_value is in the account currency. Cost and clicks update about hourly, and conversions can be added for days afterwards. totals are over the returned rows; complete=false means more rows exist than were returned. Ads: google_ad_performance; search terms: google_search_terms. Read-only and free: changes nothing and does not count toward the monthly change limit. An identical read within 30 seconds may return the same data (see data_age_seconds).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| level | No | account, campaign, ad_group or keyword. Default campaign. | |
| limit | No | Most rows to return, 1–500. Default 200. | |
| since | No | First day, YYYY-MM-DD, in the account time zone. Goes with until. | |
| until | No | Last day, YYYY-MM-DD, in the account time zone. Goes with since. | |
| by_day | No | A row per date instead of one row for the whole period. | |
| connection | No | Which connected Google Ads account to use: the connection id from start_here or the customer id (123-456-7890 or 1234567890). Needed only when several Google Ads accounts are connected. | |
| campaign_id | No | Only this campaign: for level campaign, ad_group or keyword. | |
| date_preset | No | A predefined period. Omit with since and until; with neither, LAST_7_DAYS. |