{
    "classifications": [
        {
            "column": "WEBSITE",
            "role": "dimension",
            "confidence": 0.95,
            "reason": "Low-cardinality category (11 sites) used for grouping"
        },
        {
            "column": "YEAR",
            "role": "dimension",
            "confidence": 0.97,
            "reason": "Year is a time axis for grouping/filtering"
        },
        {
            "column": "PAGE PATH",
            "role": "attribute",
            "confidence": 0.6,
            "reason": "High-cardinality free-form URL path, displayed rather than grouped"
        },
        {
            "column": "PAGE URL",
            "role": "attribute",
            "confidence": 0.55,
            "reason": "High-cardinality full URL, descriptive; not a clean join key"
        },
        {
            "column": "PAGE VIEWS",
            "role": "measure",
            "confidence": 0.97,
            "reason": "Count metric to be summed"
        },
        {
            "column": "UNIQUE VIEWS",
            "role": "measure",
            "confidence": 0.97,
            "reason": "Count metric to be summed"
        },
        {
            "column": "AVERAGE TIME ON PAGE (SECONDS)",
            "role": "measure",
            "confidence": 0.96,
            "reason": "Numeric duration metric, averaged"
        },
        {
            "column": "ENTRANCES",
            "role": "measure",
            "confidence": 0.97,
            "reason": "Count metric to be summed"
        },
        {
            "column": "BOUNCE RATE (%)",
            "role": "measure",
            "confidence": 0.96,
            "reason": "Rate metric, aggregated by averaging"
        },
        {
            "column": "EXIT RATE (%)",
            "role": "measure",
            "confidence": 0.96,
            "reason": "Rate metric, aggregated by averaging"
        }
    ]
}