Customer LTV Prediction & Revenue Risk Stratification

Oryndex Supply Chain Platform • Active Customers: 1,650 • ARR: $41.2M

24-Mo Predicted Portfolio Value
$38.4M
+2.8% QoQ
At-Risk ARR (Oct Renewals)
$4.7M
$2.1M High/Critical
Avg Predicted LTV
$24,970
Median: $18,450
Model MAPE (Churn)
14.8%
-9.3pp vs Q1
High-Confidence Expansion Pool
$6.2M
287 accounts >65% prob
Paid Social CAC:pLTV
2.1x
Below 2.5x threshold

Revenue at Risk by Churn Probability Decile

ARR concentration across predicted churn likelihood — decile 10 = 90-100% churn probability

Expansion Probability × Current ARR

Accounts sized by predicted LTV — upper-right quadrant = high-confidence upsell targets

Predicted LTV Distribution by Segment

Behavioral clusters: Enterprise Power Users, Mid-Market Growth, SMB Stable, SMB At-Risk

24-Month Predicted Portfolio Value Waterfall

Current ARR → Churn Impact → Expansion → Predicted Portfolio Value ($38.4M)

Top 10 High-Risk Accounts (Revenue Risk Score >75)

Sorted by Revenue Risk Score (RRS) — October 2024 renewals flagged

Account ARR RRS Churn Prob Predicted LTV CS Coverage Renewal Month
GlobalTech Industries $387,000 94 87% $112,400 Assigned Oct 2024
Velocity Logistics $284,000 91 82% $95,300 Assigned Oct 2024
Midwest Supply Co $219,000 88 79% $78,200 Pending Oct 2024
Apex Manufacturing $197,000 86 76% $71,100 Assigned Nov 2024
PrecisionParts LLC $178,000 83 74% $64,800 Pending Oct 2024
Summit Distribution $164,000 81 71% $59,700 Assigned Sep 2024
Frontier Warehouse Group $152,000 79 68% $55,400 Unassigned Oct 2024
Cascade Materials $143,000 78 67% $52,100 Assigned Oct 2024
Quantum Freight Services $138,000 76 65% $50,300 Pending Nov 2024
Pacific Chain Solutions $129,000 75 63% $47,000 Assigned Oct 2024
Total (Top 10) $1,991,000 $686,300 7/10

Predicted Portfolio Value Trend

8-quarter historical pCPV with expansion/churn impact overlay

At-Risk ARR by Quarter

ARR in high/critical risk bands (RRS >70) per quarter

CS Coverage Rate by Risk Band

Percentage of high-risk ARR with assigned CSM — target 95%

CAC:pLTV Ratio by Channel

Acquisition efficiency — ratios below 2.5x flagged for review

Churn Prediction Model MAPE by Quarter

Mean Absolute Percentage Error — Q1 2024 model retrain reduced MAPE from 24.1% to 14.8%