Skip to content

Amodni007/Focused-Customer-Retention-Program

Repository files navigation

Telco Customer Churn Analysis (Focused Customer Retention Programs)

Business Context

Imagine you’re running a telecom business. Every time a customer leaves, it’s not just a lost sale — it’s money you spent on marketing, onboarding, and support gone out the window. Worse, it's expensive to bring in someone new.

So what if we could predict who’s likely to leave, understand why, and take action before it’s too late?

That’s exactly what this project aims to do: understand customer churn behavior, build a predictive model, and recommend practical, real-world actions to retain customers and reduce losses.

Value Meaning 0 Not churned (the customer stayed) 1 Churned (the customer left)

Problem Statement

"How can we predict whether a customer will churn based on their usage patterns, demographics, and contract information — and what can we do about it?"


Objectives

  • Identify the key factors behind churn
  • Build a machine learning model that can flag high-risk customers
  • Provide business insights to drive smarter retention campaigns

Key EDA Insights

After exploring the data visually using Excel and Power BI:

  • Customers with month-to-month contracts churn the most (~45%)
  • Higher monthly charges are strongly linked to churn
  • New customers (tenure < 12 months) churn far more than older ones
  • Gender has no significant effect on churn

Modeling Highlights (Python)

I used a Logistic Regression model to predict churn.

  • Accuracy: 78.25%
  • ROC-AUC: 0.683
  • Precision: 0.62
  • Recall: 0.47

Feature Importance

Here’s what the model says influences churn the most:

Feature Impact on Churn
Month-to-month Contract 🔺 Increases churn risk
Short Tenure (< 12 months) 🔺 Strong churn indicator
High Monthly Charges 🔺 Related to dissatisfaction
No Tech Support 🔺 Less sticky, churns more
Two-Year Contract 🔻 Strong retention anchor

These patterns give us a roadmap for action.


Business Recommendations

1. Encourage Long-Term Contracts

Customers on month-to-month plans are unstable. Offer discounts to switch to 1-2 year contracts — lower churn, higher lifetime value.

2. Engage New Customers Early

Most churn happens within the first year. Run loyalty offers or bonus packages during onboarding.

3. Adjust Pricing for High-Risk Segments

Churn increases with higher bills. Offer bundled or usage-based pricing to ease billing pressure.

4. Upsell Tech Support Services

Users without support or security services churn more. Bundle these during signup or as low-cost add-ons.


Power BI Dashboard Summary

Your dashboard clearly shows:

  • “Churn is highest among month-to-month contract customers.”
  • “Customers in their first year have 2x churn risk.”
  • “Higher monthly charges correlate with higher churn.”

Two slicers (Contract + Internet Service) allow decision-makers to interact and filter segments quickly.


Final Reflection:

“This project isn't just about numbers — it's about understanding behavior. We can now tell who’s likely to leave, why, and exactly what we can do to keep them. And we can show it in a dashboard, backed by a model that explains itself.”

“This means fewer lost customers, more targeted retention campaigns, and better customer lifetime value — with data to prove it.”

“The model is better at identifying customers who will stay, but it misses more than half of those likely to churn. It still gives us a useful head start — we can catch around 47% of churners and act on them with precision ~62%.”


🛠 Tools Used

  • Excel – Data cleaning, summary analysis, power query
  • Power BI – Visual dashboard
  • Python – pandas, scikit-learn, matplotlib
  • Jupyter Notebook – Modeling + feature importance

Future Work & Opportunities for Deeper Insights

To enhance this churn analysis and make it more actionable in a real-world scenario, the following ideas could be implemented:

1. Enrich the Dataset with External Sources

  • Merge with Customer Support Logs Understand if churn correlates with service issues, complaint frequency, or resolution delays.
  • Integrate with Payment History Identify churn patterns among customers with late payments, billing errors, or missed auto-pay setups.

2. Explore Advanced Modeling Techniques

  • Move beyond basic logistic regression by implementing:

    • Random Forest for better handling of feature interactions
    • XGBoost for higher accuracy and model interpretability
    • SHAP Values to explain model predictions at the customer level

3. Build a Churn Risk Dashboard or App

  • Create an interactive web app using:

    • Streamlit or Flask for real-time churn prediction
    • A dashboard where users can input customer data and receive churn risk scores with explanations
    • Integration with Power BI or Tableau for executive-friendly insights

About

A predictive analytics project to identify telecom customers likely to churn, explain why using feature importance, and recommend actions to improve retention. Includes logistic regression modeling, key insights, and a Power BI dashboard for stakeholder use.

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

No releases published

Packages

 
 
 

Contributors