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
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
- “Francisco Ramos”
- “Tatiana Garcia”
- “Felipe Diniz”
- member72%
- viewer21%
- admin6.9%
- “framos@oakleaf.com.br”
- “tgarcia@oakleaf.com.br”
- “fdiniz@oakleaf.com.br”
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_id7,892 rows checked0 orphans
subscriptions
- account_idaccounts.account_id1,200 rows checked0 orphans
support_tickets
- account_idaccounts.account_id6,946 rows checked0 orphans
users
- account_idaccounts.account_id25,002 rows checked0 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.
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 1outcome accounts tickets_per_user_month avg_satisfaction churned 170 0.056 3.77 stayed 894 0.035 4.11 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 descplan january_accounts january_billed december_billed nrr_pct Business 97 226,424 230,780 101.9 Enterprise 21 278,001 275,789 99.2 Growth 177 106,944 91,416 85.5 Starter 152 13,728 10,116 73.7 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_satisfactionindustry scored_tickets avg_satisfaction scored_1_or_2_pct Logistics 367 3.85 16.3 Healthcare 944 3.95 12.3 Financial Services 986 3.99 12.7 Retail 437 4.04 11.7 Education 219 4.06 11 Software 737 4.08 11.1 Manufacturing 964 4.11 9.2 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_pctplan accounts seats users utilisation_pct median_account_pct Growth 339 9,132 6,259 68.5 67.4 Enterprise 44 6,716 4,704 70 72.1 Starter 300 2,172 1,525 70.2 70 Business 211 11,580 8,459 73 72.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 premiumCard 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
AML Transaction Monitoring
$5launch priceOne 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- Retail star schemaA dimensional model you can actually practise joins on: one fact table, four dimensions, 47,051 rows, every join resolving and every total known.47,051 rows · 5 tables
- Ecommerce storefrontA year of orders across five joined tables, with best sellers, heavy buyers, a real Q4 peak and totals that reconcile to the cent.49,493 rows · 5 tables
- Credit risk portfolio3,000 borrowers and 4,200 commercial loans, where a credit rating actually predicts whether the loan defaults, at the rate S&P's own data says it should.7,200 rows · 2 tables
- Network intrusion / netflow500 hosts and 20,000 labeled flows, where a port scan, a DDoS flood, and a brute-force attempt each carry the real statistical signature their MITRE ATT&CK technique actually leaves in traffic.20,500 rows · 2 tables
- Contact center queueing (Erlang C)4 queues, 2,400 half-hour intervals over a full business month, where agents_staffed is what Erlang C (1917) says is actually required to clear each queue's own SLA target, not a plausible-looking number.2,404 rows · 2 tables
- Clinical trial: sites, patients, visits and adverse eventsTwo trials across nine sites: enrolment, scheduled visits, dosing, lab biomarkers and graded adverse events, all in the right order.22,496 rows · 7 tables
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.

