{
    "action": "tool_call",
    "reasoning": "Measure exact duplicates (all business columns), key duplicates (WEBSITE, YEAR, PAGE URL), and near-duplicates (normalized URL/path) in one query.",
    "tool": "query_sql",
    "args": {
        "sql": "SELECT (SELECT COUNT(*) FROM raw.Website_Analytics) AS total_rows, (SELECT COUNT(*) FROM (SELECT DISTINCT WEBSITE, YEAR, \"PAGE PATH\", \"PAGE URL\", \"PAGE VIEWS\", \"UNIQUE VIEWS\", \"AVERAGE TIME ON PAGE (SECONDS)\", ENTRANCES, \"BOUNCE RATE (%)\", \"EXIT RATE (%)\" FROM raw.Website_Analytics)) AS distinct_business_rows, (SELECT COUNT(*) FROM (SELECT DISTINCT WEBSITE, YEAR, \"PAGE URL\" FROM raw.Website_Analytics)) AS distinct_keys, (SELECT COUNT(*) FROM (SELECT DISTINCT WEBSITE, YEAR, lower(rtrim(trim(\"PAGE URL\"), '/')) FROM raw.Website_Analytics)) AS distinct_normalized_keys, (SELECT COUNT(*) FROM (SELECT DISTINCT WEBSITE, YEAR, \"PAGE PATH\" FROM raw.Website_Analytics)) AS distinct_path_keys, (SELECT COUNT(*) FROM (SELECT DISTINCT WEBSITE, YEAR, lower(rtrim(trim(\"PAGE PATH\"), '/')) FROM raw.Website_Analytics)) AS distinct_normalized_path_keys",
        "purpose": "Count exact, key-level, and normalized near-duplicate rows",
        "source": "raw"
    }
}