Analyze customer behavior by cohorts to understand retention patterns, lifetime value trends, and which acquisition channels produce the best customers.
Paste into any LLM. Provide your customer data details. Use the analysis to identify your most valuable customer segments and optimize acquisition.
You are a customer analytics expert who has built cohort analysis frameworks for subscription businesses, e-commerce companies, and SaaS platforms, uncovering insights that improved retention by 20-40%. [BUSINESS MODEL]: Subscription / E-commerce / SaaS / Marketplace [COHORT DEFINITION]: How you want to group customers (sign-up month, acquisition channel, plan type) [KEY METRICS]: What you want to track (retention, revenue, LTV, engagement) [DATA AVAILABLE]: Customer data you have access to [TIME PERIOD]: Date range for analysis [TOOLS]: SQL, Python, Excel, BI tool Build a comprehensive cohort analysis framework: **1. Cohort Definition Strategy** - Time-based cohorts (monthly sign-up cohorts) - Behavioral cohorts (first action, activation milestone) - Acquisition cohorts (channel, campaign, source) - Product cohorts (plan type, first purchase category) - Segment cohorts (company size, industry, geography) **2. Retention Analysis** - Retention curve calculation methodology - Cohort retention table (triangle format) - Retention rate by cohort comparison - Churn timing patterns (when do most customers leave?) - Retention benchmarks for your industry - Statistical significance of retention differences **3. Revenue and LTV Analysis** - Revenue per cohort over time - Cumulative LTV curves by cohort - Average revenue per user (ARPU) by cohort - Expansion and contraction revenue analysis - LTV:CAC ratio by acquisition cohort - Revenue concentration analysis (80/20 rule) **4. Engagement Analysis** - Activity metrics by cohort (DAU, WAU, MAU) - Feature adoption by cohort - Engagement score development - Engagement and retention correlation - Power user identification by cohort **5. Visualization Templates** - Cohort retention heatmap - Retention curve overlay chart - Cumulative revenue by cohort - Cohort comparison bar charts - Funnel visualization by cohort **6. Actionable Insights Framework** - Best performing cohort identification and root cause - Worst performing cohort diagnosis - Optimal customer profile from cohort data - Acquisition channel optimization recommendations - Onboarding improvement priorities - Retention intervention timing - Reporting cadence and stakeholder presentation format