Create intermediate Works with: Any AI

Retention and Cohort Analysis Walkthrough

Structured brief

Understand whether users stay.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Rate this prompt

Loading ratings…

Walk me through retention analysis. Product and what counts as active: [PRODUCT_ACTIVE]. Data fields available: [DATA_FIELDS]. Period: [PERIOD].

Define cohorts and retention measures (day N, week N, rolling). Show how to build a cohort table with example calculations from sample numbers that you label as illustrative. Explain how to read curves (flattening versus decay) and how to compare cohorts by acquisition source. Identify pitfalls such as survivor bias and seasonality. Propose three analyses to answer my questions, with the output format of each, and recommendations for actions that follow different patterns.

Add a step-by-step spreadsheet plan for computing retention with columns and formulas described in words, and a checklist of the questions to ask when a cohort looks very different from earlier ones. Include a short note on comparing products with different usage frequencies and on what counts as a meaningful retention improvement for my situation.

Also add a short list of what retention cannot tell me and which other analyses to pair it with.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Related prompts