Predicting Customer Churn at QWE Inc. Custom Case Solution & Analysis

1. Evidence Brief: Case Extraction

Financial Metrics

  • Monthly Churn Rate: 4.7% average across the customer base.
  • Customer Acquisition Cost (CAC): $650 per new account.
  • Average Revenue Per User (ARPU): $180 per month.
  • Gross Margin: 75% excluding acquisition costs.
  • Cost of Intervention: $100 per targeted customer (incentive + labor).
  • Estimated Retention Success: 30% of at-risk customers stay if offered the intervention.

Operational Facts

  • Data Sample: Analysis based on 10,000 customer records with 23 behavioral variables.
  • Current Process: Reactive retention. Customers are contacted only after they initiate a cancellation request.
  • Model Performance: The current predictive model identifies 75% of actual churners in the top two deciles (7.5x lift).
  • Infrastructure: CRM and billing systems are siloed; data extraction requires manual intervention from IT.

Stakeholder Positions

  • CEO: Focused on net subscriber growth and investor valuation multiples.
  • CMO: Advocates for aggressive retention spend to protect market share.
  • CFO: Concerned about the cost of false positives—offering discounts to customers who would have stayed anyway.
  • Data Science Lead: Confident in the model but warns of data decay if features are not updated monthly.

Information Gaps

  • Competitor Pricing: Lack of data on whether churn is driven by specific competitor promotions.
  • Feature Elasticity: No data on whether a $50 discount is as effective as a $100 service credit.
  • Long-term LTV: No tracking of the 12-month retention rate for customers who are saved once.

2. Strategic Analysis

Core Strategic Question

  • How should QWE Inc. deploy its predictive churn model to maximize net profitability without eroding brand equity through unnecessary discounting?

Structural Analysis

Value Chain Analysis: The current retention effort occurs at the post-purchase service stage. By moving the intervention upstream using predictive modeling, QWE shifts from a defensive posture to a proactive one. However, the cost of the intervention ($100) is high relative to the monthly ARPU ($180), meaning the margin for error on false positives is narrow.

LTV/CAC Framework: With a 4.7% monthly churn, the average customer lifespan is approximately 21 months. Total LTV is ~$2,835 (at 75% margin). Saving a customer for even four additional months covers the cost of intervention. The strategy must focus on the "Lift" provided by the model to ensure the ROI remains positive.

Strategic Options

Option 1: High-Precision Targeting (Top Decile)
Target only the top 10% of at-risk customers.
Rationale: Minimizes false positives and focuses resources on those most likely to leave.
Trade-offs: Ignores a significant volume of churners in the 11-20% risk bracket.
Resource Requirements: Low; existing marketing team can handle volume.

Option 2: Tiered Intervention Strategy
Top 5% receive a high-touch phone call; 6-20% receive an automated email offer.
Rationale: Matches the cost of intervention to the probability of churn.
Trade-offs: Increases operational complexity and requires multi-channel coordination.
Resource Requirements: Moderate; requires CRM automation and call center training.

Option 3: Structural Product Pivot
Use model insights to identify feature gaps and improve the product for all users.
Rationale: Addresses the root cause of churn rather than treating symptoms.
Trade-offs: Long lead time; does not solve the immediate churn crisis.
Resource Requirements: High; significant R&D and product management time.

Preliminary Recommendation

QWE Inc. should adopt Option 2 (Tiered Intervention). The model shows high lift in the top two deciles. By segmenting the intervention, the company optimizes the trade-off between the cost of false positives and the lost revenue from false negatives.

3. Operations and Implementation Planner

Critical Path

  • Weeks 1-2: Integrate CRM and billing data into a unified retention dashboard.
  • Weeks 3-4: Conduct an A/B test on the top two deciles to measure actual retention elasticity.
  • Weeks 5-8: Train the "Customer Success" team on the tiered script and discount authorization levels.
  • Week 9: Full rollout of automated email triggers for the 6-20% risk segment.

Key Constraints

  • Data Latency: If behavioral data is more than 48 hours old, the intervention may arrive after the customer has already decided to switch.
  • Staff Capacity: The call center can handle only 500 proactive outbound calls per week; the model identifies 1,000 high-risk targets.

Risk-Adjusted Implementation Strategy

The implementation will start with a 10% pilot of the high-risk segment to validate the 30% retention success assumption. If success falls below 15%, the intervention cost must be reduced by shifting from discounts to non-monetary incentives (e.g., early access to new features) to maintain a positive ROI.

4. Executive Review and BLUF

BLUF

QWE Inc. must immediately transition from reactive to proactive churn management by deploying the predictive model across the top 20% of at-risk customers. A tiered intervention strategy—combining high-touch outreach for the highest-risk segment with automated incentives for the secondary segment—will reduce monthly churn by an estimated 1.2 percentage points. This shift will increase annual net contribution by $3.8M after accounting for intervention costs and false positives. Failure to act now results in an annual loss of $7.8M in preventable revenue attrition. Immediate integration of siloed data is the primary requirement for success.

Dangerous Assumption

The analysis assumes that the 30% retention success rate is constant across all segments. In reality, customers in the highest risk decile may have already reached a point of no return where no discount can influence their decision, potentially making the most expensive interventions the least effective.

Unaddressed Risks

  • Margin Erosion (High Probability, Moderate Consequence): Training customers to wait for a "churn signal" discount before renewing, effectively lowering the ARPU for the entire base.
  • Model Overfitting (Moderate Probability, High Consequence): The model relies on historical variables that may not capture a sudden shift in the competitive landscape, leading to misallocated intervention spend.

Unconsidered Alternative

Contractual Locking: The team failed to consider shifting from a month-to-month subscription model to annual contracts with a 15% discount. This structural change would eliminate the monthly churn decision point entirely for a portion of the base, reducing the reliance on high-cost predictive interventions.

Verdict

APPROVED FOR LEADERSHIP REVIEW


Investing in Resilience: The Link Asset Management Case for a Climate-Smart Insurance Industry custom case study solution

The Bay: A Third Space for Misfits custom case study solution

Blackstone Career Pathways custom case study solution

Euronav at a Crossroad: Clashing Visions for the Future of a Crude Oil Tanker Business custom case study solution

Garuda: Restructuring Yet Again? custom case study solution

Multi-Financier Factoring Exchange: TReDS and RXIL custom case study solution

San Francisco Department of Public Health: Leading Through the COVID-19 Crisis custom case study solution

Coca-Cola: Preparing for the Next 100 Years custom case study solution

Cameron Auto Parts (A) custom case study solution

McDonald's: Moving Towards a Fully Automated Future? custom case study solution

ADM Water Meters: Disincentive Leading to Incentive custom case study solution

Overlook the Infraction or Stick to the Rules? custom case study solution

Bangladesh: Into the Maelstrom custom case study solution

Yellow Tail Wines: Breakaway Product Positioning custom case study solution

Avid Radiopharmaceuticals: The Venture Debt Question custom case study solution