```json { "classifications": [ {"column": "Customer ID", "role": "identifier", "confidence": 1.0, "reason": "Primary key with unique values per row"}, {"column": "Gender", "role": "dimension", "confidence": 1.0, "reason": "Categorical field for grouping/filtering"}, {"column": "Age", "role": "dimension", "confidence": 0.95, "reason": "Numeric but used for grouping/segmentation"}, {"column": "Under 30", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Senior Citizen", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Married", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Dependents", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Number of Dependents", "role": "measure", "confidence": 0.9, "reason": "Numeric count that can be aggregated"}, {"column": "Country", "role": "dimension", "confidence": 1.0, "reason": "Geographic category (single value but still dimension)"}, {"column": "State", "role": "dimension", "confidence": 1.0, "reason": "Geographic category (single value but still dimension)"}, {"column": "City", "role": "dimension", "confidence": 1.0, "reason": "Geographic category for grouping"}, {"column": "Zip Code", "role": "dimension", "confidence": 1.0, "reason": "Geographic code for grouping/filtering"}, {"column": "Latitude", "role": "dimension", "confidence": 1.0, "reason": "Geographic coordinate for mapping/filtering"}, {"column": "Longitude", "role": "dimension", "confidence": 1.0, "reason": "Geographic coordinate for mapping/filtering"}, {"column": "Population", "role": "measure", "confidence": 0.95, "reason": "Numeric quantity that can be aggregated"}, {"column": "Quarter", "role": "dimension", "confidence": 1.0, "reason": "Time period for grouping"}, {"column": "Referred a Friend", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Number of Referrals", "role": "measure", "confidence": 1.0, "reason": "Numeric count to be aggregated"}, {"column": "Tenure in Months", "role": "measure", "confidence": 0.95, "reason": "Numeric duration to be aggregated"}, {"column": "Offer", "role": "dimension", "confidence": 1.0, "reason": "Categorical field for grouping"}, {"column": "Phone Service", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Avg Monthly Long Distance Charges", "role": "measure", "confidence": 1.0, "reason": "Monetary amount to be aggregated"}, {"column": "Multiple Lines", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Internet Service", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Internet Type", "role": "dimension", "confidence": 1.0, "reason": "Categorical field for grouping"}, {"column": "Avg Monthly GB Download", "role": "measure", "confidence": 1.0, "reason": "Numeric quantity to be aggregated"}, {"column": "Online Security", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Online Backup", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Device Protection Plan", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Premium Tech Support", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Streaming TV", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Streaming Movies", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Streaming Music", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Unlimited Data", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Contract", "role": "dimension", "confidence": 1.0, "reason": "Categorical field for grouping"}, {"column": "Paperless Billing", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Payment Method", "role": "dimension", "confidence": 1.0, "reason": "Categorical field for grouping"}, {"column": "Monthly Charge", "role": "measure", "confidence": 1.0, "reason": "Monetary amount to be aggregated"}, {"column": "Total Charges", "role": "measure", "confidence": 1.0, "reason": "Monetary amount to be aggregated"}, {"column": "Total Refunds", "role": "measure", "confidence": 1.0, "reason": "Monetary amount to be aggregated"}, {"column": "Total Extra Data Charges", "role": "measure", "confidence": 1.0, "reason": "Monetary amount to be aggregated"}, {"column": "Total Long Distance Charges", "role": "measure", "confidence": 1.0, "reason": "Monetary amount to be aggregated"}, {"column": "Total Revenue", "role": "measure", "confidence": 1.0, "reason": "Monetary amount to be aggregated"}, {"column": "Satisfaction Score", "role": "measure", "confidence": 1.0, "reason": "Numeric rating scale to be averaged"}, {"column": "Customer Status", "role": "dimension", "confidence": 1.0, "reason": "Categorical status for grouping"}, {"column": "Churn Label", "role": "dimension", "confidence": 1.0, "reason": "Boolean flag for filtering/grouping"}, {"column": "Churn Score", "role": "measure", "confidence": 1.0, "reason": "Numeric score to be aggregated"}, {"column": "CLTV", "role": "measure", "confidence": 1.0, "reason": "Customer lifetime value to be aggregated"}, {"column": "Churn Category", "role": "dimension", "confidence": 1.0, "reason": "Categorical field for grouping"}, {"column": "Churn Reason", "role": "attribute", "confidence": 0.95, "reason": "Descriptive text for display, high cardinality"} ] } ```