Ir al contenido principal
Petanque Life

Revenue Tracking & Business Analytics

F19.10 7 funcionalidades Entregado

En resumen

Revenue tracking turns the marketing and pricing funnel into a SaaS business dashboard — MRR/ARR with growth and churn forecasts, per-segment cohort retention, CAC per channel with payback period, LTV per segment, conversion-funnel drop-off and confidence-bounded revenue forecasts with scenario analysis — so leadership runs the company on data rather than gut feel and catches issues weeks earlier.

Cómo funciona

Every billing event from Stripe and every conversion event from the marketing analytics stack flows into an internal revenue warehouse that powers the business dashboard. MRR and ARR are computed nightly with month-over-month and year-over-year growth indicators, plus a churn-adjusted forecast that projects the next 12 months under current conditions. Churn analytics are sliced per segment (Club, Professional, Federation) and rendered as cohort retention curves — the canonical SaaS visual — so leadership can see whether a cohort retains 80% at month 12 or collapses at month 3.

Early-warning indicators (declining engagement, payment failures, support escalations) flag at-risk accounts before they cancel. CAC is tracked per acquisition channel (organic, Google Ads, Meta, LinkedIn, partnerships) with payback period and an efficiency ranking, so the marketing team kills underperforming channels and doubles down on winners. LTV is computed per segment and divided by CAC to produce LTV/CAC; the dashboard flags any segment where the ratio drops below the 3:1 target.

The conversion funnel — visit → trial → paid — is rendered with absolute and percentage drop-off at every step, so optimisation efforts target the leakiest stage. Cohort analysis renders as a retention heatmap with trend indicators per signup month. Revenue forecast scenarios — base, optimistic, pessimistic — let leadership pressure-test plans before committing to hiring or investment.

Capacidades clave

  • MRR/ARR dashboard with MoM/YoY growth and churn-adjusted forecasts
  • Per-segment churn analytics with cohort retention curves and early-warning flags
  • CAC tracking per channel with payback period and efficiency ranking
  • LTV per segment with LTV/CAC ratio and contribution margin analysis
  • Conversion funnel (visit → trial → paid) with drop-off analysis
  • Cohort retention heatmap with trend indicators per signup month
  • Revenue forecast with confidence intervals and scenario analysis

En la práctica

The CEO opens the revenue dashboard on a Monday morning. MRR is up 8.2% month over month, the cohort heatmap shows Q1 federations retaining at 96% versus Q4 clubs at 78%, and CAC for LinkedIn ads has crept above the 3:1 LTV/CAC threshold for the Professional tier. She drills into the conversion funnel and sees the Professional trial-to-paid step has dropped from 41% to 33% in the last six weeks.

She pings the product team with a Loom link to the funnel view. By the next dashboard review, an onboarding-friction fix has lifted the step back above 40% and the Professional cohort is back on plan.

Funcionalidades de este subsistema

7
ID Status Funcionalidades
F19.10.01 Entregado MRR/ARR dashboard with growth indicators (MoM/YoY) and churn-adjusted forecasts
F19.10.02 Entregado Churn analytics per segment with cohort retention curves and early warning indicators
F19.10.03 Entregado CAC tracking per channel with payback period, efficiency ranking, and attribution
F19.10.04 Entregado LTV per segment with LTV/CAC ratio (target >3:1) and contribution margin analysis
F19.10.05 Entregado Conversion funnel (visit → trial → paid) with drop-off analysis
F19.10.06 Entregado Cohort analysis with retention heatmap and trend indicators
F19.10.07 Entregado Revenue forecast with confidence intervals and scenario analysis