In the dynamic world of SaaS, data is your roadmap to clarity and confidence.
This playbook equips you with ready-to-use SQL queries for the metrics that drive growth, retention, and profitability.
No need for advanced technical skills—just adapt the table and column names to your database, and let the insights unfold.
How to Use This Playbook
- Choose your metric.
Find the metric that answers your most pressing questions. - Copy the SQL.
Swap in your own table and column names. - Run it in your database tool.
Watch as the numbers reveal your business’s story.
Industry Benchmarks & Standards
Metric | Industry Benchmark (2025) | What It Means |
|---|---|---|
Net Revenue Retention (NRR) | 101% (B2B SaaS median) | Above 100% means your customers are growing their investment. |
Customer Churn Rate | 5% - 10% (varies by segment) | Lower is better; aim for <5% in high-growth SaaS. |
Annual Recurring Revenue (ARR) Growth Rate | 17% - 26% (median, varies by size) | Top performers can exceed 50%. |
DAU/MAU Ratio | 20% - 50% (varies by product) | Higher means your users are truly engaged. |
LTV/CAC Ratio | 3:1 or higher | Ensures your business model is robust and sustainable. |
Contribution Margin | 70% - 85% (healthy SaaS) | Direct costs should be a small slice of your revenue pie. |
Average Revenue Per User (ARPU) | Varies by segment | Higher ARPU means your customers find more value in your product. |
Your Data Foundation
These tables are the pillars of your SaaS analytics:
- main.saas_data_clients: The foundation of every client relationship.
- client_id, client_name, created_at
- main.saas_data_customers: Every user’s journey, captured in detail.
- customer_id, client_id, customer_name, signup_date, is_active
- main.saas_data_plans: Your product’s menu of options.
- plan_id, client_id, plan_name, monthly_price, annual_price, is_active
- main.saas_data_subscriptions: Captures the full lifecycle: sign-ups, renewals, and cancellations.
- subscription_id, client_id, customer_id, plan_id, start_date, end_date, status
- main.saas_data_payments: The flow of revenue through your business.
- payment_id, client_id, customer_id, subscription_id, amount, payment_date, is_refund
- main.saas_data_events: The story of every login, upgrade, and farewell.
- event_id, client_id, customer_id, event_type, event_date, is_churn
- main.saas_data_costs: The price of delivering value to your customers.
- cost_id, client_id, customer_id, cost_type, cost_amount, cost_date
Gross Revenue Churn
Gross Revenue Churn reveals the financial impact of lost customers and downgrades — not just who leaves, but how much recurring revenue walks out the door with them. It’s the monetary echo of each cancellation or downgrade. Keeping this number low means your customers see lasting value in your product, driving stronger loyalty and more predictable revenue streams. Monitoring Gross Revenue Churn helps you protect your recurring income and spot early signs of dissatisfaction before they grow.
Source Table | Columns used |
|---|---|
main.saas_data_subscriptions | plan_id, customer_id, start_date, end_date |
main.saas_data_plans | plan_id, plan_name, monthly_price |
main.saas_data_events | customer_id, is_churn, event_date |
WITH "plan_churn" AS (
SELECT
"plans"."plan_name" AS "plan_name",
ROUND(SUM(CAST("plans"."monthly_price" AS DOUBLE)), 2) AS "gross_revenue_churn"
FROM "main"."saas_data_subscriptions" AS "subscriptions"
JOIN "main"."saas_data_plans" AS "plans"
ON "subscriptions"."plan_id" = "plans"."plan_id"
JOIN "main"."saas_data_events" AS "events"
ON "subscriptions"."customer_id" = "events"."customer_id"
AND "events"."is_churn" = TRUE
AND "events"."event_date" BETWEEN "subscriptions"."start_date"
AND COALESCE("subscriptions"."end_date", CURRENT_DATE)
GROUP BY "plans"."plan_name"
)
SELECT
"plan_name",
ROUND("gross_revenue_churn", 2) AS "gross_revenue_churn"
FROM "plan_churn"
ORDER BY "gross_revenue_churn" DESCVisualization Ideas:
- Bar Chart: See which plans are losing the most revenue.
- Alert Widget: Flag high-churn plans for immediate attention.
- Pie Chart: Shows part-to-whole breakdown of gross revenue lost due to churn by plan
- Donut Chart: Displays gross revenue lost due to churn by plan
Implementation Checklist
- Define your metrics and add them to a data dictionary.
- Ensure your database schema supports the required calculations.
- Write and test SQL queries for each metric.
- Import results into your BI tool. Get started with DataBrain today!
- Build and share dashboards with stakeholders.
- Schedule regular reviews and updates.
Unlock the power of your data.
Start using this SQL Playbook today!
“In the world of SaaS, data is everyone’s responsibility. With this playbook, anyone can own their metrics and drive better outcomes.”
Now, simply run the SQL queries on your data and unlock the power of your SaaS analytics!