Analytics Dashboard Overview
Navigate the LostChurn analytics dashboard — understand your key metrics at a glance, filter by date range and cohort, export data, and see real-time vs. rolled-up reporting.
The Analytics page gives you a single view of your payment recovery performance. It combines real-time data from SpacetimeDB subscriptions with pre-aggregated rollups so you can monitor what is happening right now and track trends over time.
Dashboard Layout
When you open Analytics, the page is organized into three sections:
- Revenue Impact Calculator — A top-level projection that estimates the annual revenue impact of your recovery program based on the current period's results.
- KPI Cards — Four summary cards showing Total Recovered, Recovery Rate, Average Recovery Time, and Projected Annual Revenue Saved.
- Charts and Tables — Recovery trend lines, decline code breakdowns, channel attribution donuts, A/B test results, and a recent attribution log.
Each chart includes an accessible data table that can be toggled for screen readers or copy-paste workflows.
Date Range and Filtering
Date Range Selector
Use the period tabs in the top-right corner to switch between time windows:
| Period | Description |
|---|---|
| 7d | Last 7 days |
| 30d | Last 30 days (default) |
| 90d | Last 90 days |
| 12mo | Last 12 months |
The selected date range applies globally to every chart and KPI card on the page.
Cohort Filters
Below the date range selector, a filter bar lets you narrow the data by two dimensions:
- Decline Category — Filter by Soft Retry, Hard Customer, Terminal, or Unknown to focus on a specific failure type. See Decline Categories for details on each category.
- Recovery Channel — Filter by Smart Retry, Email Dunning, SMS, Self-Service, or Backup Method to isolate a specific recovery channel.
Period Comparison
Toggle Compare previous period to overlay the equivalent prior period on the recovery trend chart. For example, when viewing the last 30 days, the comparison shows the 30 days before that as dashed lines. This helps you spot improvements or regressions at a glance.
KPI Cards
The four headline metrics update in real time as new recovery events stream in:
| Card | What It Shows |
|---|---|
| Total Recovered | Dollar amount recovered within the selected period |
| Recovery Rate | Percentage of failed payments that were successfully recovered |
| Avg Recovery Time | Average number of days from payment failure to successful recovery |
| Projected Annual Revenue | Current period recovery extrapolated to a 12-month run rate |
Click any KPI card to navigate to the related detail page (e.g., clicking Recovery Rate takes you to the payments list filtered by recovered status).
Exporting Data
Click the Download CSV button at the top of the page to export the current decline code breakdown as a CSV file. The export respects your active date range and cohort filters, so you get exactly the data you see on screen.
For bulk data exports (payment events, attribution records, rollups), use the Data Export feature in Settings. It supports CSV and JSON formats and runs as a background job.
Real-Time vs. Rolled-Up Metrics
LostChurn uses two complementary data sources to give you both immediacy and performance:
Real-Time Data (WebSocket)
Live tables — recovery_state, attribution_record, and payment_event — stream updates to the dashboard via WebSocket. KPI cards, the activity feed on the Overview page, and the recovery pipeline all update in real time as events occur, with no page refresh needed. This means you see every recovery the moment it happens.
Pre-Aggregated Trend Data
Trend charts and period comparisons use the analytics_rollup table, which pre-aggregates metrics by period (daily, weekly, or monthly granularity). This data updates every few minutes and includes:
- Total failed payment count and dollar amount
- Recovered count and dollar amount
- Silent retry count and success count
- Dunning sent count and dunning recovered count
- Terminal count
- Average recovery time in hours
Pre-aggregating trend data keeps charts fast and responsive, even when rendering long time ranges (90 days, 12 months) with thousands of underlying events.
What's Next
- Recovery Metrics — Deep dive into recovery rate, MRR saved, time-to-recover, and breakdown by decline category
- Campaign Performance — Analyze open rates, conversion rates, A/B test results, and channel effectiveness
- Engagement Analytics — Email delivery funnels, recovery attribution by method, and customer engagement metrics
- Cohort Analysis — Segment recovery performance by customer cohort, signup date, plan tier, and more
- Revenue Forecasting — Project recovered revenue and churn impact using historical trends and ML models
- How Automatic Recovery Works — Understand the pipeline that generates the data you see here