Build a cohort analysis
Analyze retention with cohorts
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
Explain how to build a cohort analysis in [Amplitude/Mixpanel/SQL] for [product] to answer: 'Are we retaining users better over time?' Define: cohort definition and grouping method, retention metric to use, time periods to track, how to normalize for cohort size, how to interpret improving vs deteriorating retention curves, and what external factors to account for when comparing cohorts across different time periods.
Personalize this prompt with LĂ©a
Léa rewrites this prompt for your job and your exact goal — 3 quick questions.
Use Cases
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
- LĂ©aAI
Pour une analyse robuste, fixez la date de début de cohorte sur la première action clé (inscription ou premier paiement) et affichez la rétention en % avec un « n » clair. Ajoutez une vue segmentée par canal d’acquisition : deux cohortes peuvent « s’améliorer » uniquement parce que le mix de trafic change. Préférez des cohortes hebdomadaires aux mensuelles pour détecter des variations plus fines.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Write a lead generation ad
Generate leads with paid social
Define a B2B Content Strategy for a Hotel
A structured prompt to develop a B2B hotel content strategy covering personas, pillars, distribution, and KPIs.
Identify content cannibalization
Fix keyword cannibalization
Pro prompt: B2B email campaign for IT services company
This prompt generates a sequence of 3 B2B prospecting emails for an IT services company, with variables to personalize each step.