To set CAC ceilings and retention priorities we need an estimate of future value, not just past revenue.
Task
I needed a forward-looking value estimate rather than a backward-looking revenue total, so I owned the basis for setting CAC ceilings and retention priorities.
Source: github.com/NikitaBoyarkin/volta-banking — 22 projects; figures recomputed from the repo's own datasets (data/*.csv) via its analysis scripts. Funnel counts from data/volta_funnel_data.csv (10,000 users); A/B, retention, segmentation, churn, RFM, CLV, attribution, anomalies, spend, support, NPS, JTBD, unit economics, premium, KYC deep-dive, referral, assisted CAC, FX sourcing, premium offers, anchor CAC and dormant win-back follow the published project narrative (README + part pages).
CLV by three methods
Customer lifetime value by segment, estimated three ways: historical, retention-curve and Gamma-Gamma. The order Power > Growth > Casual > Dormant is robust.
Key takeaways
Power leads across all three methods: Gamma-Gamma €5,166 vs Dormant €27.7 — a ~187× gap.
Predictive methods run 2.9–5.9× above historical — the historical method understates future value.