Cohort Curve
Your dataset contains roughly 19,000 subscription records for a monthly streaming service, each with a customer ID, a signup date, and a cancellation date.
Your task is to group subscribers into cohorts by signup month and calculate each cohort’s retention rate after 1 month, 2 months, 3 months, and so on.
A few rules to keep in mind:
Treat each subscription record independently. If a customer cancels and later resubscribes, each subscription belongs to the cohort associated with its own signup date.
A subscription is only considered retained after N months if it remained active beyond the corresponding monthly renewal date. If the cancellation date falls exactly on that date, do not count it as retained.
Subscriptions with no cancellation date should be treated as active through the latest applicable month in the analysis.
See example below:
Submit your solution
What was the 3-month retention rate for the November 2025 cohort? (Round down to the nearest whole percentage point)
Styled, Responsive and Ready to RollNo need to spend time changing colors and styles manually. Our component & layouts are styled out of the box Not just a UI KitPowered up with Framer's animation library and custom code componentsDark, Light and Dynamic componentsComponents will automatically adjust theme and color pallette based on your brand Responsive color stylesComponents and Layouts can easily be customized to your brand color in a few clicks 1st Feb24 layouts3rd March12 components2nd April44 componentsA Lifetime of UpdatesContinuously evolving library adjusting to the latest design trends and Framer Updates Responsive Text StylesText styles adapt to different breakpoints, avoiding the need to manually adjust MonthlyYearlyStyled ComponentsComponents & layouts are automatically styled based on your CopyCopy to ClipboardCopy, Paste, RepeatCopy and paste 100+ styled, responsive, interactive elements in two click TemplatesGet 4 custom templates worth $200+ with Pro. View Templates DesktopTabletPhoneResponsiveComponents will automatically adjust to the screen size that they are pasted into
Check back soon for the full solution video & tutorial from Maven instructors
