{
    "action": "tool_call",
    "reasoning": "Missing-value rates per column require row-level null counts; compute in one query over raw.Website_Analytics, including empty-string checks for text columns.",
    "tool": "query_sql",
    "args": {
        "sql": "SELECT COUNT(*) AS total_rows, COUNT(*) - COUNT(\"WEBSITE\") AS website_nulls, COUNT(*) - COUNT(\"YEAR\") AS year_nulls, COUNT(*) - COUNT(\"PAGE PATH\") AS page_path_nulls, COUNT(*) - COUNT(\"PAGE URL\") AS page_url_nulls, COUNT(*) - COUNT(\"PAGE VIEWS\") AS page_views_nulls, COUNT(*) - COUNT(\"UNIQUE VIEWS\") AS unique_views_nulls, COUNT(*) - COUNT(\"AVERAGE TIME ON PAGE (SECONDS)\") AS avg_time_nulls, COUNT(*) - COUNT(\"ENTRANCES\") AS entrances_nulls, COUNT(*) - COUNT(\"BOUNCE RATE (%)\") AS bounce_nulls, COUNT(*) - COUNT(\"EXIT RATE (%)\") AS exit_nulls, COUNT(*) - COUNT(\"_ingestion_timestamp\") AS ingest_ts_nulls, COUNT(*) - COUNT(\"_batch_id\") AS batch_nulls, COUNT(*) - COUNT(\"_source_file\") AS source_file_nulls, COUNT(*) - COUNT(\"_source_system\") AS source_system_nulls, SUM(CASE WHEN TRIM(\"WEBSITE\")='' THEN 1 ELSE 0 END) AS website_blank, SUM(CASE WHEN TRIM(\"PAGE PATH\")='' THEN 1 ELSE 0 END) AS page_path_blank, SUM(CASE WHEN TRIM(\"PAGE URL\")='' THEN 1 ELSE 0 END) AS page_url_blank FROM raw.Website_Analytics",
        "purpose": "Count nulls (and blank strings) in every column of raw.Website_Analytics",
        "source": "raw"
    }
}