E-commerce & Retail Analytics Path · Mission 18 of 30Hard
Repeat-purchase cohort retention
Build a cohort table — first-order month is the cohort, repurchasers are customers who placed any order strictly after their first. Two CTEs (cohort + repurchaser flag), LEFT JOIN, ratio. The fundamental retention curve.