Automated Customer Segmentation K-Means Prep & Cluster Profiling Sheet

This preparation worksheet standardizes customer features, handles scaling (z-score), encodes categorical variables, and prepares a sample CSV for k-means clustering. It includes helper computations for elbow method metrics (within-cluster SSE) and profiles clusters by summarizing demographic and behavioral means for each cluster. The sheet documents preprocessing steps for reproducibility and suggests labeling heuristics for operational use (e.g., high-value, frequent). After clustering in Python/R, import cluster labels back to the sheet for profiling and segmentation activation. The workbook supports iterative segmentation refinement and downstream activation lists for marketing or product teams.