Cohort Analysis Plan

Design a cohort analysis plan to answer this business question: [BUSINESS_QUESTION — e.g., "Are users who sign up via our referral program more retained at 90 days than organic signups?"]. Product or service being analyzed: [PRODUCT_NAME]. Available data: [AVAILABLE_DATA_DESCRIPTION]. The plan should specify: (1) Cohort definition — how will cohorts be grouped? (by acquisition date, acquisition channel, first product action, plan tier, etc.) and the exact cohort window (e.g., weekly cohorts from [START_DATE] to [END_DATE]), (2) Cohort size minimum — the minimum cohort size required for statistical reliability and how to handle small cohorts, (3) Key metrics per cohort — retention rate at Days [DAY_INTERVALS], and any secondary metrics: [SECONDARY_METRICS], (4) Analysis dimensions — which dimensions to slice by: [DIMENSIONS — e.g., acquisition channel, geography, plan type], (5) Expected output format — table structure and visualization type (heatmap vs. line chart), (6) SQL query skeleton — provide a skeleton query structure using [DATA_WAREHOUSE — e.g., BigQuery, Snowflake] syntax that a data analyst can populate, (7) Interpretation guide — how to read the results and what patterns indicate problems vs. health.