Get data (normalized, cross-source)
get_dataQuery Google Ads, GA4 and Search Console with one field vocabulary.
Prefer this over the source-specific tools for reporting and for comparing sources, e.g. Google Ads campaigns with their GA4 sessions (join on campaign_id), or GA4 landing pages with their Search Console clicks (join on landing_page). Rows missing in a source show null for its metrics. Ratios (ctr, cpc, cpa, roas, conversion_rate, engagement_rate) are recomputed from totals. Search Console data lags 2-3 days.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| fields | Yes | Dimensions and metrics from list_fields, e.g. ['date', 'spend', 'clicks']. | |
| date_to | No | YYYY-MM-DD, with date_from. | |
| filters | No | Conditions combined with AND, applied to every source. | |
| sources | Yes | One source, or several to join them on the requested dimensions. With several, metric columns are prefixed with the source (google_ads.clicks, search_console.clicks). | |
| order_by | No | Columns to sort by; prefix '-' for descending, e.g. -spend. In a blend, a bare metric name works when only one source has it; otherwise qualify it, e.g. search_console.clicks. | |
| date_from | No | YYYY-MM-DD, with date_to. | |
| date_preset | No | today, yesterday, last_Nd (last_7d, last_28d...), this_month, last_month, this_year, last_year. Default last_28d. last_Nd ends yesterday. | |
| force_refresh | No | Skip the cache. Recent data is cached 15 minutes. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||