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. Company size follows a power law, so most customers are small and a few are large, and the plan each account is on follows from its size rather than being sprinkled at random. Seats fit the plan, MRR is exactly seats times the plan's price, and nobody licenses more seats than they have employees. Support tickets resolve faster as priority rises.
- 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.
5 tables
users.csv
21,884 rows · 5 columns · 1 foreign keys
- Cheng He<0.1%
- Fatou Okonkwo<0.1%
- Edward Young<0.1%
- Pablo Castillo<0.1%
- Amadou Eze<0.1%
- 5484 more values · 100%
- member62%
- viewer20%
- admin18%
- “eedwards@funnelsoftgroup1.com”
- “amorris@funnelsoftgroup1.com”
- “lnair@funnelsoftgroup1.com”
Keys
Every join resolves
4 foreign keys, 43,184 references checked against the table each one points at. None points at a row that does not exist.
invoices
- account_idaccounts.account_id14,500 rows checked0 orphans
subscriptions
- account_idaccounts.account_id1,200 rows checked0 orphans
support_tickets
- account_idaccounts.account_id5,600 rows checked0 orphans
users
- account_idaccounts.account_id21,884 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
- 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
- Seats rise with plan: 5, 23, 69, 189 median for Starter to Enterprise
- Churned subscriptions all carry an end date; active ones never do
- Median resolution: 4h urgent, 12h high, 34h normal, 77h low
- 8.4% of tickets are still open, and none of those carry a satisfaction score
- All 21,884 user emails are unique
The same checks ship in the zip as INTEGRITY.txt, so you can rerun them in any SQL engine. How we verify
Questions
Worth asking it
- 1Does support load predict churn?
- 2What is net revenue retention by plan tier?
- 3Which industry has the worst satisfaction scores?
- 4How does seat utilisation vary between Starter and Enterprise?
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 premiumWeekly 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 previewProfile and previewAn X-bar chart with the truth underneath: flatness, characteristic 139
3 plants, 36 CNC machines, six months
Six months of control charts with the ground truth underneath
Answer key
- active_cause_id
- true_cause_shift_sigma
- true_tool_wear_sigma
- +6 more
- Rows
- 515,442
- Tables
- 15
- Checks
- 101 of 101
Free previewProfile and previewVibration through a life that ends in failure
240 machines at 4 plants, two years
Two years of sensor readings, failures, repairs and costs for 240 machines
Answer key
- failure_mode
- true_life_days
- true_failure_at
- +6 more
- Rows
- 179,038
- Tables
- 6
- Checks
- 67 of 67
Free previewProfile and preview
Related free datasets
All 12- Retail star schemaA dimensional model you can actually practise joins on: one fact table, four dimensions, 63,170 rows, and every join resolving.63,170 rows · 5 tables
- Machine degradation100 machines monitored from commissioning to failure, with an exact remaining-useful-life label on every one of 23,118 readings.46,336 rows · 3 tables
- Ecommerce storefrontA year of orders across five joined tables, with a real Q4 peak and totals that reconcile to the cent.49,192 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
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.