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
Claude Prompt to Create a Marketing Plan
Creating a solid marketing plan is a strategic exercise that requires a global vision of the market, a fine understanding of your target, and the ability to articulate objectives, channels, and budgets coherently. Claude excels at this task thanks to its ability to structure complex information, propose proven frameworks, and adapt its recommendations to the specific context of your business. Whether you are launching a new product, repositioning an existing brand, or planning your annual strategy, Claude can generate a complete marketing plan including market analysis, positioning, marketing mix, action timeline, and measurable KPIs. The major advantage lies in the speed of iteration: you can refine your plan in just a few exchanges, test different budget scenarios, and receive well-argued recommendations for each acquisition channel. Claude leverages best practices in strategic marketing to deliver an actionable document, ready to be presented to your management or to guide your team on a daily basis.
Prompt to Create Blog Headlines That Drive Traffic
Generates 15 blog headlines optimized for organic traffic using proven copywriting formulas, power words and varied emotional angles.
Write an SEO audit report
Communicate SEO audit results
Write personalized subject lines
Personalize subject lines at scale