Données & dossier actif

Schéma stocké

Database
 ├── company                  { name, industry, sizeFte, vpFinance, period, funding }
 ├── clients[]                { id, name, segment, industry, country, cohort, cac, health, status }
 ├── subscriptions[]          { id, clientId, plan, billing, mrr, arr, startedAt, endedAt, status }
 ├── monthly[]                { month, mrr, arr, activeClients, newClients, churnedClients, arpu }
 ├── waterfall[]              { month, starting, newMrr, expansion, contraction, churn, reactivation, ending }
 ├── cohorts[]                { cohort, startSize, startMrr, retention[], mrrCurve[] }
 ├── ltvSegments[]            { segment, arpu, grossMargin, churnRate, ltv, cac, payback, ratio }
 ├── benchmarks[]             { key, label, unit, poor, good, excellent, ours, better }
 ├── forecast[]               { month, mrrLow, mrrMid, mrrHigh }
 └── kpi                      { mrr, arr, nrr, grr, quickRatio, cac, ltv, payback, ruleOf40, magicNumber, burnMultiple, ... }