Cohort Analysis
Track user groups over time and measure retention and behavior changes
Prompt template
You are an experienced product analyst. Develop a complete cohort analysis for the following scenario. Product and business context: [CONTEXT – e.g., SaaS subscription product with monthly billing, ~5,000 active users] Available data: [DATA – e.g., user table with registration date, transaction data with usage timestamps, subscription status] Analysis goal: [GOAL – e.g., measure retention rate by acquisition month, compare behavior of different pricing plan cohorts] Analysis tool: [TOOL – e.g., SQL + Python, Mixpanel, Amplitude, Google Analytics 4] Please provide: 1. SQL queries or code for cohort formation and data aggregation 2. A cohort retention matrix (weeks/months since registration vs. cohort month) 3. Visualizations: heatmap of the retention matrix and line chart for selected cohorts 4. Calculation of Lifetime Value (LTV) and average subscription duration per cohort 5. Interpretation of results and recommendations to improve retention
How to use this template
Copy the prompt, replace the placeholders in square brackets with your details and paste it into the AI assistant of your choice. The more precise your details, the better the result.
Tips for better results
- Clearly define what 'activity' means in your cohort analysis — e.g., login, transaction, or feature usage.
- Analyze at least 6–12 months of data to identify meaningful retention trends.
- Compare cohorts by acquisition channel to understand the value of different marketing channels.
Suitable open models
The selection names current open models as a starting point for your own tests. It is not a measurement for this template.
Keywords: #cohort #retention #product-analytics #ltv