<invoke name="tool_call"> <parameter name="reasoning">Profile all numeric columns in one query for nulls, ranges, impossible values (negatives, rates >100, unique>page views, entrances>page views), and duplicates keys.</parameter> <parameter name="tool">query_sql</parameter> <parameter name="args">{"sql":"SELECT COUNT(*) n, COUNT(DISTINCT \"WEBSITE\") sites, MIN(\"YEAR\") ymin, MAX(\"YEAR\") ymax, SUM(CASE WHEN \"PAGE VIEWS\"<0 THEN 1 ELSE 0 END) neg_pv, SUM(CASE WHEN \"UNIQUE VIEWS\">\"PAGE VIEWS\" THEN 1 ELSE 0 END) uv_gt_pv, SUM(CASE WHEN \"ENTRANCES\">\"PAGE VIEWS\" THEN 1 ELSE 0 END) ent_gt_pv, SUM(CASE WHEN \"BOUNCE RATE (%)\">100 OR \"BOUNCE RATE (%)\"<0 THEN 1 ELSE 0 END) bad_bounce, SUM(CASE WHEN \"EXIT RATE (%)\">100 OR \"EXIT RATE (%)\"<0 THEN 1 ELSE 0 END) bad_exit, SUM(CASE WHEN \"AVERAGE TIME ON PAGE (SECONDS)\"<0 THEN 1 ELSE 0 END) neg_time, SUM(CASE WHEN \"AVERAGE TIME ON PAGE (SECONDS)\"=0 THEN 1 ELSE 0 END) zero_time, SUM(CASE WHEN \"PAGE VIEWS\"=0 THEN 1 ELSE 0 END) zero_pv, MAX(\"PAGE VIEWS\") max_pv, MEDIAN(\"PAGE VIEWS\") med_pv, QUANTILE_CONT(\"PAGE VIEWS\",0.99) p99_pv, MAX(\"ENTRANCES\") max_ent, MAX(\"AVERAGE TIME ON PAGE (SECONDS)\") max_time, QUANTILE_CONT(\"AVERAGE TIME ON PAGE (SECONDS)\",0.99) p99_time, SUM(CASE WHEN \"PAGE PATH\" IS NULL THEN 1 ELSE 0 END) null_path, SUM(CASE WHEN \"PAGE URL\" IS NULL THEN 1 ELSE 0 END) null_url, SUM(CASE WHEN \"BOUNCE RATE (%)\" IS NULL THEN 1 ELSE 0 END) null_bounce, SUM(CASE WHEN \"EXIT RATE (%)\" IS NULL THEN 1 ELSE 0 END) null_exit, SUM(CASE WHEN \"BOUNCE RATE (%)\"=0 THEN 1 ELSE 0 END) zero_bounce, SUM(CASE WHEN \"BOUNCE RATE (%)\"=100 THEN 1 ELSE 0 END) b100 FROM raw.Website_Analytics","purpose":"Profile numeric columns for impossible values, outliers, nulls","source":"raw"}</parameter> </invoke>