get_session_kvp_report_by_domain
Retrieve session-based key-value pair report for a domain, filtered by a specified key (e.g., utm_campaign). Returns data with country, date, and total counts from Snowflake.
Instructions
Session-based KVP report for a domain (sessions data from Snowflake).
Returns rows with COUNTRY_CODE, COUNTRY_NAME, KEY, VALUE, RECORDED_DATE and TOTAL, filtered by the given key.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| key | No | Key to group by, e.g. 'utm_campaign' or 'utm_source' | utm_campaign |
| domain | Yes | Site domain, e.g. 'example.com' | |
| end_date | No | Report end date, 'YYYY-MM-DD' (optional) | |
| timezone | No | Timezone for the data. One of: '' (default), 'gam' (Google Ad Manager), 'pacific', 'gmt_3', 'cet', 'eastern'. | |
| start_date | Yes | Report start date, 'YYYY-MM-DD' | |
| network_code | No | GAM network code for the domain. Optional — if omitted, the server falls back to the ACTIVEVIEW_NETWORK_CODE environment variable. |