{
    "action": "tool_call",
    "reasoning": "Profile each website's year span, volume, bounce and exit rates in one query to ground the analysis.",
    "tool": "query_sql",
    "args": {
        "sql": "SELECT WEBSITE, MIN(YEAR) AS first_year, MAX(YEAR) AS last_year, COUNT(*) AS page_rows, SUM(\"PAGE VIEWS\") AS page_views, SUM(ENTRANCES) AS entrances, ROUND(AVG(\"BOUNCE RATE (%)\"),1) AS avg_bounce, ROUND(AVG(\"EXIT RATE (%)\"),1) AS avg_exit, ROUND(AVG(\"AVERAGE TIME ON PAGE (SECONDS)\"),1) AS avg_time FROM raw.Website_Analytics GROUP BY WEBSITE ORDER BY page_views DESC",
        "purpose": "Profile each website's span, volume and engagement to ground candidate analytical questions",
        "source": "raw"
    }
}