Skip to content
Datablare
Claude Code SaaS Revenue & growth

MRR movements and net revenue retention

Net revenue retention of 95.4%, $124.3K of new MRR this year and $46.7K lost to churn, with ARPA by plan.

Data
Synthetic SaaS demo data (PostgreSQL)
Asked in
Claude Code
Updated
Try this on your data

1 · The brief

What Claude Code was asked

Break our MRR growth down for 2026: new MRR, expansion and churned MRR each month, net new MRR, our net revenue retention over the last year, and average revenue per account on each plan.

Given exactly like this. Claude Code asked Datablare which tables it could read, wrote the SQL itself, ran each query through Datablare and built the dashboard from what came back.

2 · The dashboard

The dashboard Claude Code built

MRR movements and net revenue retention dashboard: MRR movements per month, ARPA by plan, October, Net new MRR per month

Built from 4 read-only queries. Every figure on the dashboard was read from the database through Datablare; nothing was estimated or typed in.

Headline numbers (January–October 2026):

  • Net revenue retention: 95.4% (Oct 2026 vs Oct 2025 cohort)
  • New MRR: $124.3K (Added in 2026)
  • Expansion MRR: $41.6K (Growth on existing accounts)
  • Churned MRR: $46.7K (Lost in 2026)

What stands out:

  • MRR movements per month: New and expansion MRR against MRR lost to churn
  • ARPA by plan, October: A Scale account pays $953 a month on average
  • Net new MRR per month: 10 of 10 months grew MRR

The data is a synthetic SaaS dataset made for this example, so the numbers describe no real company. The queries, the dashboard and the audit entries are real: Claude reached the database only through Datablare, read-only, and every query is on record with the question it served.

3 · What Datablare ran

4 read-only queries, nothing changed

Each query below is copied from the audit log of this run. Datablare checked that it only reads, ran it read-only, and gave only the rows to Claude Code; it never stores them.

  1. Query 1

    Net revenue retention: October 2026 MRR of accounts that paid in October 2025, against their October 2025 MRR

    1 row · 61 ms

    SELECT round(sum(m26.mrr), 0) AS mrr_now, round(sum(m25.mrr), 0) AS mrr_year_ago,
           round(sum(coalesce(m26.mrr, 0)) / sum(m25.mrr), 4) AS net_revenue_retention, count(m25.account_id) AS accounts_year_ago
    FROM saas.mrr_monthly m25
    LEFT JOIN saas.mrr_monthly m26 ON m26.account_id = m25.account_id AND m26.month = DATE '2026-10-01'
    WHERE m25.month = DATE '2025-10-01'
  2. Query 2

    New and expansion MRR by month in 2026

    10 rows · 150 ms

    WITH m AS (
      SELECT account_id, month, mrr, lag(mrr) OVER (PARTITION BY account_id ORDER BY month) AS prev
      FROM saas.mrr_monthly
    )
    SELECT to_char(month, 'YYYY-MM') AS month,
           round(sum(mrr) FILTER (WHERE prev IS NULL), 0) AS new_mrr,
           round(sum(mrr - prev) FILTER (WHERE prev IS NOT NULL), 0) AS expansion_mrr
    FROM m
    WHERE month >= DATE '2026-01-01'
    GROUP BY 1
    ORDER BY 1
  3. Query 3

    MRR lost to churn by month in 2026 (an account’s last MRR, counted the month after)

    10 rows · 95 ms

    WITH m AS (
      SELECT account_id, month, mrr, lead(month) OVER (PARTITION BY account_id ORDER BY month) AS next_month
      FROM saas.mrr_monthly
    )
    SELECT to_char(month + INTERVAL '1 month', 'YYYY-MM') AS month, round(sum(mrr), 0) AS churned_mrr
    FROM m
    WHERE next_month IS NULL AND month >= DATE '2025-12-01' AND month < DATE '2026-10-01'
    GROUP BY 1
    ORDER BY 1
  4. Query 4

    Average MRR per account by plan, October 2026

    3 rows · 46 ms

    SELECT plan, count(*) AS accounts, round(avg(mrr), 0) AS arpa
    FROM saas.mrr_monthly
    WHERE month = DATE '2026-10-01'
    GROUP BY 1
    ORDER BY 3 DESC
Tables read saas.mrr_monthly

4 · The audit entry

Who asked what, on record

Every query is recorded with the person who asked, the question in their words and why the agent ran it. Admins see this in the audit log; nothing reaches the database without it.

How the audit log works

query_data_source

via Claude Code

Allowed
Who
The person signed in (hidden on this public page)
Question
Break our MRR growth down for 2026: new MRR, expansion and churned MRR each month, net new MRR, our net revenue retention over the last year, and average revenue per account on each plan.
Intent
Net revenue retention: October 2026 MRR of accounts that paid in October 2025, against their October 2025 MRR
Result
4 queries, 24 rows, read-only

More use cases

All examples
  • SaaS MRR, churn and plan mix dashboard: MRR by plan, MRR mix by plan, October, Accounts churned per month, MRR by region, October
    Claude Code SaaS Revenue & growth

    SaaS MRR, churn and plan mix

    $458.7K MRR across 1,760 accounts, 12.8% logo churn over 12 months, MRR by plan and region, and churn month by month.

    Updated Open

  • Account retention by plan and signup cohort dashboard: Still active, by signup quarter, How long churned accounts stayed, Churned share by region, Churned share by plan
    Claude Code SaaS Customer analytics

    Account retention by plan and signup cohort

    452 of 2,200 accounts have churned, after a median 9.0 months; Middle East churns most.

    Updated Open

  • E-commerce sales and retention dashboard dashboard: Monthly revenue, Revenue by category, 2026, Lifetime revenue per customer, by channel, Orders per month
    Claude Code E-commerce Executive overview

    E-commerce sales and retention dashboard

    ₹5.21M revenue from 11,897 orders this year, a 57.9% repeat-customer rate, and which channels bring the customers who spend most.

    Updated Open

Build this on your own data.

Connect your database, choose the tables Claude may read, and give it the same brief. Claude is connected in about two minutes.

30 minutes with the founder. Or WhatsApp / [email protected]