February 19, 20261.0.71v1.0.71RSS

v1.0.71 — [DepthAudit] Revenue Analytics Dashboard (ARR, MRR, Cohort Retention, Top Products)

Release Notes

Verdict: N/A Evidence: src/components/billing/revenue-dashboard.tsx: All 6 KPIs and charts pull from real tRPC queries (trpc.revenueAnalytics.arrSummary, mrrTimeSeries, revenueMovement, subscriberLifecycle, cohortRetention, topProducts). src/lib/routers/revenue-analytics.ts: Each query executes raw SQL against the invoices, subscriptions, and customers tables with proper date ranges, aggregations, window functions, and cohort math. Revenue movement (newMrr, expansionMrr, churnedMrr) is computed from correlated subqueries. src/db/billing-schema.ts: invoices, subscriptions, customers, products, invoice_line_items tables all exist with proper columns. MRR alert banner at src/components/billing/revenue-dashboard.tsx:62-102 fires when momGrowthPct < -10. File: N/A Recommendation: No action required. Fully production-quality.