Subscription Analytics and Churn Optimization Dashboard
A comprehensive data analysis project focused on understanding consumer behavior and subscription health for a direct to consumer digital product.
Business Problem
The primary challenge was a lack of visibility into consumer habits and high churn rates. The business needed to understand the relationship between customer acquisition costs and lifetime value to make informed product strategy decisions.
Solution
I led the research and analysis phase by integrating subscription analytics tools to track user behavior. I built a centralized dashboard that monitored key performance indicators. This involved segmenting users based on their habits to identify where drop-offs occurred in the lifecycle.
Tech Stack
- RevenueCat
- SQL
- Tableau or Power BI
- Python
- Digital Marketing Analytics Tools
Impact
The project provided regular reports that identified specific churn drivers. These insights allowed the product team to implement targeted retention efforts. The dashboard successfully visualized the ratio of customer acquisition cost to lifetime value which helped the strategy team optimize marketing spend.