Go Back

Revenue Risk & Customer Dependency Analysis — Contoso

Business Context

Contoso is a global retail company operating across multiple countries and product categories. Revenue grew from $88M in 2015 to $444M in 2022 before declining, raising concerns around customer retention and revenue concentration. Leadership suspects that revenue may be heavily dependent on a relatively small group of high-value customers, creating potential exposure if these customers reduce engagement or churn.

The Challenge: Assess dependency on high-value customers, identify early disengagement signals, and quantify revenue exposed to potential churn.

Executive Summary

Contoso faces a significant revenue concentration risk, with 43.5% of total revenue generated by its top 20% of customers. This analysis identified $78.7M in revenue and $44.2M in profit at risk from declining high-value customers, with exposure concentrated in the Online channel and a small number of physical stores. The findings show that revenue risk is driven by weakening engagement among high-value customers rather than being evenly distributed across the customer base. Strengthening retention efforts for declining customers, high-risk channels, and priority stores is therefore likely to deliver the greatest business impact.

Key Findings

1. Nearly Half of Contoso's Revenue Flows from Just 20% of Customers

The top 20% of customers contribute 43.5% of total revenue and 44.26% of total profit. Within that group, the top 10% alone account for more than a quarter of both revenue and profit. This level of concentration increases the business's exposure if high-value customers reduce spending or churn.

2. Within the Top 20%, Engagement Is Fragmenting

Only 26% of high-value customers show consistent engagement, while 49% are classified as Inactive. The Declining segment (1,421 customers) shows the largest recency gap at ~558 days despite historically healthy purchase frequency. This suggests that revenue risk is emerging before customers are fully lost, creating an opportunity for targeted retention efforts.

3. $78M in Revenue Is Still Recoverable

The Declining segment contributes $78.7M in revenue and $44.2M in profit, representing the largest recoverable opportunity among high-value customers. In contrast, Inactive customers account for $411M in historical revenue, indicating a substantial portion has already been lost. Prioritizing this segment offers the greatest opportunity to protect revenue before customers become inactive.

4. Risk Is Concentrated — One Channel Dominates Revenue Exposure

The Online channel holds $27.1M at risk across 1,420 declining customers, representing 34% of total at-risk revenue. Eighteen high-risk physical stores contribute an additional $34M, but the exposure is distributed across locations rather than concentrated in a single channel. Targeting the Online channel and high-risk stores is likely to produce a greater impact than broad company-wide retention initiatives

Recommendations

1. Retain Declining High-Value Customers (Immediate)

Target Segment: 1,421 Declining customers ($78.7M revenue at risk)

• Prioritize customers with the longest inactivity periods
• Personalize offers using historical purchase behavior
• Collect feedback to identify drivers of disengagement

2. Treat Online Channel Risk (Critical)

Target Area: Online channel ($27.1M at-risk revenue)

• Segment outreach by inactivity duration
• Prioritize high-spend customers for direct intervention
• Implement dedicated digital retention campaigns

3. Activate Store-Level Retention in High-Risk Locations

Target Area: 18 high-risk stores ($34M at-risk revenue)

• Provide store-level lists of at-risk customers to each store manager
• Review purchase history for product availability issues
• Track monthly recovery rates by store

4. Raise Customer Concentration Risk to Leadership

Target Area: Customer concentration risk

• Establish monitoring thresholds for top-customer activity
• Reduce long-term dependency through broader customer acquisition

Limitations & Assumptions

1. Partial 2024 Data: The latest recorded orders end in April 2024. As a result, recency metrics may appear higher because the full year is not represented.
2. Churn Estimated from Behavior: At-risk customers were identified using recency and frequency patterns, not confirmed churn records.
3. Multi-Currency Transactions: Revenue figures were calculated in transaction currency without USD normalization. A post-analysis validation confirmed only a 1.47% net difference — findings remain directionally accurate.
4. Threshold Benchmarks: All segmentation thresholds were derived from internal data distributions, as no external industry benchmarks were available.
5. No External Context: The analysis identifies who is at risk and how much revenue is exposed, but cannot fully explain why customers are disengaging without feedback or market data.
6. Synthetic Dataset: Contoso is a fictional dataset. Additional context such as loyalty history, customer feedback, or campaign data was unavailable.