B2B SaaS subscription analytics

Accounts, seats, MRR, churn and support load, where company size actually drives the plan.

A B2B SaaS business with 1,200 customer accounts in 10 countries, billed monthly through 2025. Company size decides the plan, seats fit the plan, MRR is exactly seats times the plan's price, and every invoice falls on the same day and second each month. Small accounts churn faster (Starter 3.9% a month, Enterprise 0.7%), the top fifth of accounts carry 81% of billings, and accounts that churned filed more tickets per user and rated support lower (3.77 against 4.11). Every time is UTC, so each country's activity sits at its own hours.

  • saas
  • b2b
  • churn
  • mrr
  • support
0450900Jan 2025Mar 2025May 2025Jul 2025Sep 2025Nov 2025Dec 2025
Rows per month in invoices.invoice_date, counted from the file.

Explore

Every table, profiled

Each column's type, spread, empties and most common values, measured from the CSVs in the download. Switch to the first rows to see the data exactly as it sits in the file.

users.csv

25,002 rows · 5 columns · 1 foreign keys

user_idprimary key
unique on every row
25,002 distinctno empties
account_idforeign key
points to accounts.account_id
1,200 distinctno empties
full_nametext
  • “Francisco Ramos”
  • “Tatiana Garcia”
  • “Felipe Diniz”
24,297 distinct13 chars on averageno empties
rolecategory
  • member
    72%
  • viewer
    21%
  • admin
    6.9%
3 valuesno empties
emailtext
  • “framos@oakleaf.com.br”
  • “tgarcia@oakleaf.com.br”
  • “fdiniz@oakleaf.com.br”
25,002 distinct22 chars on averageno empties

Keys

Every join resolves

4 foreign keys, 41,040 references checked against the table each one points at. None points at a row that does not exist.

invoices

  • account_idaccounts.account_id0 orphans

subscriptions

  • account_idaccounts.account_id0 orphans

support_tickets

  • account_idaccounts.account_id0 orphans

users

  • account_idaccounts.account_id0 orphans

Checks

What we checked

  • 0 orphaned foreign keys, exactly one subscription per account
  • 0 invoices or tickets dated before the account existed, inside the 14-day trial, or after a churned subscription ended
  • mrr equals seats times the plan's seat price, to the cent, for all 1,200
  • 0 accounts licensing more seats than they have employees, 0 with more users than seats
  • Seats rise with plan: 8, 23, 42, 92 median for Starter to Enterprise
  • Churned subscriptions all carry an end date; active ones never do
  • One invoice a month per account, same day and clock time; a live account's latest invoice equals its mrr
  • Median resolution: 4h urgent, 12h high, 34h normal, 77h low
  • 1.8% of tickets are still open, and none of those carry a satisfaction score
  • All 25,002 user emails are unique, each on its own company's domain

The same checks ship in the zip as INTEGRITY.txt, so you can rerun them in any SQL engine. How we verify

Questions, answered

Worth asking it

Each answer is the query's result on these exact files. Open one for its SQL and rows, then check your own query against it.

  1. 1Does support load predict churn?Accounts that churned filed 0.056 tickets per user a month and rated support 3.77; those that stayed filed 0.035 and rated 4.11.
    -- 2025 tickets per user-month: each account's tickets over its users times the months it was live in 2025.
    with life as (
      select s.account_id, s.status,
             (select count(*) from users u where u.account_id = s.account_id) as users,
             greatest(extract(epoch from (least(coalesce(s.ended_on, timestamp '2025-12-31 23:59:59'), timestamp '2025-12-31 23:59:59')
                                          - greatest(s.started_on, timestamp '2025-01-01'))), 0) / 86400 / 30.44 as months
      from subscriptions s
      where s.status <> 'trialing'
    ),
    t as (
      select account_id, count(*) as tickets, avg(satisfaction_score) as satisfaction
      from support_tickets
      group by account_id
    )
    select case when l.status = 'churned' then 'churned' else 'stayed' end as outcome,
           count(*) as accounts,
           round(sum(coalesce(t.tickets, 0)) / sum(l.users * l.months), 3) as tickets_per_user_month,
           round(avg(t.satisfaction), 2) as avg_satisfaction
    from life l
    left join t on t.account_id = l.account_id
    where l.months > 0
    group by 1
    order by 1
    outcomeaccountstickets_per_user_monthavg_satisfaction
    churned1700.0563.77
    stayed8940.0354.11
  2. 2What is net revenue retention by plan tier?Net revenue retention, January to December 2025: Business 101.9%, Enterprise 99.2%, Growth 85.5%, Starter 73.7%.
    -- Accounts billed in January 2025: their December billings over their January ones.
    with jan_bill as (
      select account_id, sum(amount) as billed
      from invoices
      where extract(month from invoice_date) = 1
      group by account_id
    ),
    dec_bill as (
      select account_id, sum(amount) as billed
      from invoices
      where extract(month from invoice_date) = 12
      group by account_id
    )
    select a.plan,
           count(*) as january_accounts,
           round(sum(j.billed), 2) as january_billed,
           round(sum(coalesce(d.billed, 0)), 2) as december_billed,
           round(100 * sum(coalesce(d.billed, 0)) / sum(j.billed), 1) as nrr_pct
    from jan_bill j
    join accounts a on a.account_id = j.account_id
    left join dec_bill d on d.account_id = j.account_id
    group by a.plan
    order by nrr_pct desc
    planjanuary_accountsjanuary_billeddecember_billednrr_pct
    Business97226,424230,780101.9
    Enterprise21278,001275,78999.2
    Growth177106,94491,41685.5
    Starter15213,72810,11673.7
  3. 3Which industry has the worst satisfaction scores?Logistics rates support lowest (3.85 on 367 scored tickets); Manufacturing highest (4.11).
    select a.industry,
           count(t.satisfaction_score) as scored_tickets,
           round(avg(t.satisfaction_score), 2) as avg_satisfaction,
           round(100.0 * sum(case when t.satisfaction_score <= 2 then 1 else 0 end) / count(t.satisfaction_score), 1) as scored_1_or_2_pct
    from support_tickets t
    join accounts a on a.account_id = t.account_id
    group by a.industry
    order by avg_satisfaction
    industryscored_ticketsavg_satisfactionscored_1_or_2_pct
    Logistics3673.8516.3
    Healthcare9443.9512.3
    Financial Services9863.9912.7
    Retail4374.0411.7
    Education2194.0611
    Software7374.0811.1
    Manufacturing9644.119.2
  4. 4How does seat utilisation vary between Starter and Enterprise?Seats in use on live subscriptions: Growth 68.5%, Enterprise 70.0%, Starter 70.2%, Business 73.0%.
    -- Live subscriptions: users on the account over the seats it pays for.
    with u as (
      select account_id, count(*) as users
      from users
      group by account_id
    )
    select a.plan,
           count(*) as accounts,
           sum(s.seats) as seats,
           sum(coalesce(u.users, 0)) as users,
           round(100.0 * sum(coalesce(u.users, 0)) / sum(s.seats), 1) as utilisation_pct,
           round(100 * percentile_cont(0.5) within group (order by 1.0 * coalesce(u.users, 0) / s.seats), 1) as median_account_pct
    from subscriptions s
    join accounts a on a.account_id = s.account_id
    left join u on u.account_id = s.account_id
    where s.status in ('active', 'past_due')
    group by a.plan
    order by utilisation_pct
    planaccountsseatsusersutilisation_pctmedian_account_pct
    Growth3399,1326,25968.567.4
    Enterprise446,7164,7047072.1
    Starter3002,1721,52570.270
    Business21111,5808,4597372.6

Every query runs on the files in the download as they are. ANSWERS.sql holds all of them; run it in DuckDB from the dataset's folder.

Use it

Take it, or make one shaped like yours

Rebuild it byte for byte

The zip includes schema.yaml. Run misata generate --config schema.yaml with seed 20260722 and you get the same rows.

Your own tables, your own numbers

Describe the data you need in Studio and get connected tables with the totals you state, profiled like this and checked before you download.

Premium datasets

All premium
  • Card spending each month, debit and credit

    2,500 US households at five banks and seven card issuers, two years

    Five banks' raw statement lines, with every label behind them

    Answer key

    • description
    • merchant_name
    • category
    • +6 more
    Rows
    7,627,186
    Tables
    14
    Checks
    50 of 50
    Free previewProfile and preview
  • transactions, rows per monthMay 2025 – Oct 2026

    One UAE bank, 10,000 customers, eighteen months

    A UAE bank's whole trail from KYC to STR, with the laundering nobody caught

    Answer key

    • is_suspicious
    • typology
    • ring_id
    • +7 more
    Rows
    11,711,393
    Tables
    16
    Checks
    129 of 129
    Free previewProfile and preview
  • Weekly sales, at regular price and on promotion

    Grocery chain, 10 stores, fiscal 2024 and 2025

    Two fiscal years of a grocery chain, from the shelf to the receipt

    Answer key

    • baseline_units
    • price_effect
    • promo_lift
    • +7 more
    Rows
    2,790,852
    Tables
    14
    Checks
    117 of 117
    Free preview18-question projectProfile and preview

Related free datasets

All 9

Fully synthetic. No real person, company or transaction is represented, and no production data was read to make it. CC0: use it anywhere, no attribution needed.