Total Revenue
Total Revenue
Description:
Total revenue in the selected period.
Exclusions:
Outside date range or missing amounts.
Formula:
SUM(payment_amount) WHERE status = success
0.00
--
Monthly Recurring Revenue
Monthly Recurring Revenue
Description:
Monthly recurring revenue from active subscriptions.
Exclusions:
Cancelled or expired subscriptions.
Formula:
SUM(monthly_amount) WHERE status = active
0.00
--
Annual Recurring Revenue
Annual Recurring Revenue
Description:
Annualized recurring revenue from active subscriptions.
Exclusions:
Cancelled or expired subscriptions.
Formula:
MRR × 12
0.00
--
Average LTV
Average LTV
Description:
Average lifetime value per subscriber.
Exclusions:
Subscribers without revenue or outside the range.
Formula:
Total revenue / COUNT(DISTINCT subscribers)
0.00
--
Product Activations
Product Activations
Description:
Number of product activations in the period.
Exclusions:
Missing activation events or outside the date range.
Formula:
COUNT(activation_events)
0.00
--

MRR & ARR Trends

MRR & ARR Trends
Description:
Trend of monthly and annual recurring revenue.
Exclusions:
Inactive subscriptions or missing revenue amounts.
Formula:
MRR = SUM(monthly_amount); ARR = MRR × 12

Churn Rate

Churn Rate
Description:
Churn rate trend over the selected period.
Exclusions:
Missing subscription start/end dates.
Formula:
Churned / Active at start × 100

Customer Segments

Customer Segments
Description:
Distribution of revenue across customer segments (by package).
Exclusions:
Subscriptions without valid pricing data.
Formula:
SUM(price) GROUP BY package
{{-- Dunning Success Rate Chart - Commented out

Dunning Success Rate

--}}