saas-growth-analytics

SaaS Growth Analytics Framework

🎯 Objective

Design a complete analytics system to measure acquisition efficiency, retention performance and revenue growth in a SaaS environment.

---

📊 Key Metrics

• Customer Acquisition Cost (CAC)
• Funnel Conversion Rate (Visit → Lead → Customer)
• Cohort Retention Analysis
• Lifetime Value (LTV) Estimation
• Channel Efficiency Comparison

---

🛠 Tech Stack

Python (Pandas, NumPy)
SQL
Power BI
Excel

---

📈 Business Impact

This framework enables founders and growth teams to:

• Identify highest-performing acquisition channels
• Detect funnel drop-offs
• Reduce churn risk
• Optimise marketing budget allocation

---

📂 Project Structure

• data/ → Raw & processed datasets
• sql/ → Data transformation queries
• notebooks/ → Analysis & modelling
• dashboard/ → KPI dashboard design

---

🚀 Next Steps

• Add real dataset
• Build cohort retention model
• Publish Power BI dashboard screenshots

---

📊 Key Insights

• Customers on month-to-month contracts show significantly higher churn.
• Simulated CAC highlights acquisition cost sensitivity.
• Churn distribution suggests retention should be prioritised over aggressive acquisition.

📊 Sample Output

=== Churn Distribution ===
No 0.73
Yes 0.27

=== Estimated CAC ===
Estimated CAC: 13.52 €