Writing the retention question before the first cohort table
Retention work goes wrong when someone builds a cohort chart before anyone has said what decision it should inform. Writing down the one question, such as whether customers acquired since the onboarding redesign stay longer than those before it, fixes the cohort, the period and the activity definition before any SQL is written. It also tells you when the analysis is finished.
First tasks
- Ask the requester what decision the retention analysis should change
- Write the retention question and the decision in one sentence each
- List the open choices: anchor event, period length and activity definition
- Get the requester to confirm the question in writing