Customer Analytics Deep Dive Template

Build a customer analytics deep dive framework for [Company/Product]. Include: 1) Customer segmentation — RFM analysis, behavioral clustering, value-based segmentation, needs-based segmentation. Methodology for each with implementation steps. 2) Cohort analysis — define cohorts (acquisition month, plan type, acquisition channel), metrics to track per cohort (retention, revenue, engagement), visualization templates, interpretation guide. 3) Customer journey analysis — touchpoint mapping, conversion funnel analysis, drop-off identification, path analysis, multi-channel attribution. 4) Churn analysis — churn definition and measurement, leading indicator identification, survival analysis, churn prediction model features, intervention trigger design. 5) Customer lifetime value — CLV calculation methodology (historical, predictive, probabilistic), CLV by segment, CLV:CAC ratio analysis, sensitivity analysis on key inputs. 6) Product usage analytics — feature adoption matrix, usage depth analysis, activation metric identification, engagement scoring model. 7) Voice of customer integration — NPS/CSAT correlation with behavior, text analytics on feedback, survey response bias correction. 8) Reporting and dashboards — weekly customer health dashboard, monthly deep dive template, quarterly board-level customer metrics. 9) SQL query templates for common analyses.