{
    "action": "tool_call",
    "reasoning": "Get the overall distribution of each numeric measure in one query, one row per metric via UNION ALL.",
    "tool": "query_sql",
    "args": {
        "sql": "SELECT 'PAGE VIEWS' AS metric, COUNT(\"PAGE VIEWS\") AS n, MIN(\"PAGE VIEWS\") AS min_v, MAX(\"PAGE VIEWS\") AS max_v, AVG(\"PAGE VIEWS\") AS mean_v, MEDIAN(\"PAGE VIEWS\") AS median_v, STDDEV(\"PAGE VIEWS\") AS stddev_v, QUANTILE_CONT(\"PAGE VIEWS\",0.25) AS p25, QUANTILE_CONT(\"PAGE VIEWS\",0.75) AS p75, QUANTILE_CONT(\"PAGE VIEWS\",0.99) AS p99 FROM raw.Website_Analytics UNION ALL SELECT 'UNIQUE VIEWS', COUNT(\"UNIQUE VIEWS\"), MIN(\"UNIQUE VIEWS\"), MAX(\"UNIQUE VIEWS\"), AVG(\"UNIQUE VIEWS\"), MEDIAN(\"UNIQUE VIEWS\"), STDDEV(\"UNIQUE VIEWS\"), QUANTILE_CONT(\"UNIQUE VIEWS\",0.25), QUANTILE_CONT(\"UNIQUE VIEWS\",0.75), QUANTILE_CONT(\"UNIQUE VIEWS\",0.99) FROM raw.Website_Analytics UNION ALL SELECT 'AVG TIME ON PAGE (SEC)', COUNT(\"AVERAGE TIME ON PAGE (SECONDS)\"), MIN(\"AVERAGE TIME ON PAGE (SECONDS)\"), MAX(\"AVERAGE TIME ON PAGE (SECONDS)\"), AVG(\"AVERAGE TIME ON PAGE (SECONDS)\"), MEDIAN(\"AVERAGE TIME ON PAGE (SECONDS)\"), STDDEV(\"AVERAGE TIME ON PAGE (SECONDS)\"), QUANTILE_CONT(\"AVERAGE TIME ON PAGE (SECONDS)\",0.25), QUANTILE_CONT(\"AVERAGE TIME ON PAGE (SECONDS)\",0.75), QUANTILE_CONT(\"AVERAGE TIME ON PAGE (SECONDS)\",0.99) FROM raw.Website_Analytics UNION ALL SELECT 'ENTRANCES', COUNT(\"ENTRANCES\"), MIN(\"ENTRANCES\"), MAX(\"ENTRANCES\"), AVG(\"ENTRANCES\"), MEDIAN(\"ENTRANCES\"), STDDEV(\"ENTRANCES\"), QUANTILE_CONT(\"ENTRANCES\",0.25), QUANTILE_CONT(\"ENTRANCES\",0.75), QUANTILE_CONT(\"ENTRANCES\",0.99) FROM raw.Website_Analytics UNION ALL SELECT 'BOUNCE RATE (%)', COUNT(\"BOUNCE RATE (%)\"), MIN(\"BOUNCE RATE (%)\"), MAX(\"BOUNCE RATE (%)\"), AVG(\"BOUNCE RATE (%)\"), MEDIAN(\"BOUNCE RATE (%)\"), STDDEV(\"BOUNCE RATE (%)\"), QUANTILE_CONT(\"BOUNCE RATE (%)\",0.25), QUANTILE_CONT(\"BOUNCE RATE (%)\",0.75), QUANTILE_CONT(\"BOUNCE RATE (%)\",0.99) FROM raw.Website_Analytics UNION ALL SELECT 'EXIT RATE (%)', COUNT(\"EXIT RATE (%)\"), MIN(\"EXIT RATE (%)\"), MAX(\"EXIT RATE (%)\"), AVG(\"EXIT RATE (%)\"), MEDIAN(\"EXIT RATE (%)\"), STDDEV(\"EXIT RATE (%)\"), QUANTILE_CONT(\"EXIT RATE (%)\",0.25), QUANTILE_CONT(\"EXIT RATE (%)\",0.75), QUANTILE_CONT(\"EXIT RATE (%)\",0.99) FROM raw.Website_Analytics",
        "purpose": "Overall distribution profile (count, min, max, mean, median, stddev, quartiles, p99) of every numeric measure",
        "source": "raw"
    }
}