SaaS Metrics and Analytics Complete Guide 2026

class SAASMetrics:
    def __init__(self, customers, subscriptions, transactions):
        self.customers = customers
        self.subscriptions = subscriptions
        self.transactions = transactions
    
    def calculate_mrr(self):
        """Monthly Recurring Revenue"""
        mrr = 0
        for sub in self.subscriptions:
            if sub.status == 'active':
                mrr += sub.monthly_price
        return mrr
    
    def calculate_arr(self):
        """Annual Recurring Revenue"""
        return self.calculate_mrr() * 12
    
    def calculate_arpu(self):
        """Average Revenue Per User"""
        active_customers = [c for c in self.customers if c.status == 'active']
        if not active_customers:
            return 0
        return self.calculate_mrr() / len(active_customers)

Growth Metrics:
├── MRR Growth Rate
│   └── ((Current MRR - Previous MRR) / Previous MRR) × 100
│
├── Net Revenue Retention (NRR)
│   └── (Starting MRR + Expansion - Contraction - Churn) / Starting MRR
│
├── Gross Revenue Retention (GRR)
│   └── (Starting MRR - Churn) / Starting MRR
│
└── Logo Growth
    └── (New Customers - Churned Customers) / Previous Customers

def calculate_churn_metrics(customers, period='month'):
    """Calculate various churn metrics"""
    
    # Customer Churn Rate
    start_count = customers.start_count
    churned = customers.churned_count
    customer_churn = (churned / start_count) * 100
    
    # Revenue Churn
    start_mrr = customers.start_mrr
    churned_mrr = customers.churned_mrr
    revenue_churn = (churned_mrr / start_mrr) * 100
    
    # Net Churn (includes expansion)
    expansion = customers.expansion_mrr
    contraction = customers.contraction_mrr
    net_churn = ((churned_mrr + contraction - expansion) / start_mrr) * 100
    
    return {
        'customer_churn': customer_churn,
        'revenue_churn': revenue_churn,
        'net_churn': net_churn
    }

def calculate_ltv_cac(customers, subscriptions):
    """Calculate LTV and CAC"""
    
    # Average Revenue Per User
    arpu = calculate_arpu(customers, subscriptions)
    
    # Gross Margin (typical SaaS: 70-80%)
    gross_margin = 0.75
    
    # Customer Lifespan (in months)
    churn_rate = 0.05  # 5% monthly churn
    lifespan = 1 / churn_rate
    
    # Customer Lifetime Value
    ltv = arpu * lifespan * gross_margin
    
    # Customer Acquisition Cost
    total_acquisition_spend = customers.acquisition_spend
    new_customers = customers.new_customers_count
    cac = total_acquisition_spend / new_customers
    
    # LTV:CAC Ratio
    ltv_cac_ratio = ltv / cac
    
    return {
        'ltv': ltv,
        'cac': cac,
        'ltv_cac_ratio': ltv_cac_ratio
    }

SaaS Dashboard Essentials:
├── Revenue Overview
│   ├── MRR/ARR
│   ├── Revenue by plan
│   └── Revenue growth trend
│
├── Customer Metrics
│   ├── Total customers
│   ├── New customers
│   ├── Churned customers
│   └── Net revenue retention
│
├── Product Usage
│   ├── Active users
│   ├── Feature usage
│   └── Session duration
│
└── Financial Health
    ├── Burn rate
    ├── Runway
    └── Unit economics

-- MRR Calculation
SELECT 
    DATE_TRUNC('month', subscription_start_date) as month,
    SUM(CASE 
        WHEN subscription_status = 'active' 
        THEN monthly_price 
        ELSE 0 
    END) as mrr
FROM subscriptions
GROUP BY DATE_TRUNC('month', subscription_start_date)
ORDER BY month;

-- Cohort Analysis
WITH cohorts AS (
    SELECT 
        customer_id,
        DATE_TRUNC('month', first_subscription_date) as cohort_month,
        subscription_start_date
    FROM customers
)
SELECT 
    cohort_month,
    DATE_TRUNC('month', subscription_start_date) as month_num,
    COUNT(DISTINCT customer_id) as customers,
    SUM(monthly_price) as revenue
FROM cohorts c
JOIN subscriptions s ON c.customer_id = s.customer_id
WHERE s.subscription_status = 'active'
GROUP BY cohort_month, month_num
ORDER BY cohort_month, month_num;