ML-driven churn & disconnect forecasting
Replaced manual weekly forecasting with Random Forest churn attribution and XGBoost disconnect prediction — 250+ hours of analyst time reclaimed annually.
Context
A team responsible for FIOS and Fixed Wireless Access (FWA) retention was running manual weekly forecasting processes and had no ML-based churn signal. Leadership needed a proactive, data-driven retention signal and a faster forecast cadence.
The problem
Disconnect forecasting was manual, weekly, and backward-looking. The churn identification process relied on rule-based segmentation that couldn’t adapt to evolving customer behavior.
Methodology
Churn attribution model (2023)
- Data collection — pulled historical customer data across behavioral, demographic, and transactional attributes from EDW
- Feature engineering — applied one-hot encoding to categorical variables; built correlation matrices to identify multicollinearity; iteratively tested attribute combinations
- Modeling — trained Random Forest Classifier and Decision Tree Classifier; evaluated using Feature Importance rankings, Decision Tree visualizations, and regression outputs
- Validation & refinement — scientific iteration: tested feature subsets, compared model outputs, refined toward a targeted prediction score with meaningful separation between churn/retain populations
- Output — churn probability score per customer, deployed to support retention targeting decisions
Disconnect forecasting model (2024)
- Problem — manual FIOS and FWA disconnect forecasting consumed 250+ team hours annually; data was available only weekly
- Approach — replaced manual process with XGBoost-based predictive model trained on historical disconnect patterns and leading indicators
- Automation — built a pipeline to produce daily and monthly disconnect forecasts automatically; no manual intervention required
- Impact measurement — tracked prediction accuracy vs. actuals; compared to prior manual forecast error rates
Automation layer
Automated the full data pipeline — scheduled scripts pull from EDW, execute transformations, generate forecasts, and distribute outputs. Weekly manual process replaced with daily automated cadence.
Stack
Python (scikit-learn, XGBoost, pandas), SQL / Teradata EDW, Tableau, BTEQ.
Impact
- 250+ hours of manual forecasting eliminated annually
- Daily forecast cadence vs. prior weekly manual process
- Churn model deployed to support marketing retention strategy
- Manager review: “instrumental in developing the algorithmic forecasting of Fios and FWA, shifting the team from manual forecasting, which has highlighted valuable insights for the base KPIs”