Platform statistics

GET https://app.speybooks.com/api/v1/admin/stats

Retrieve platform-wide statistics for the admin dashboard. Executes six parallel queries:

  1. User counts — total, active, locked
  2. Organisations by plan — total, trial, sole_trader, limited_company
  3. Trial pipeline — active trials, expiring within 48h, expired
  4. Revenue — MRR in pence (sole trader £14.95, limited company £24.95), formatted MRR, active counts per plan
  5. Recent signups — last 10 users with organisation and plan
  6. Webhook health — last 24h totals: processed, failed, overall status

MRR is calculated from active subscriptions only (subscription_status = 'active'). The mrrFormatted field includes the £ symbol for display.

Response

200 Platform-wide stats: user counts, org breakdown by plan, trial pipeline, MRR, recent signups, and webhook health.
Show response fields
organisations object
Show child attributes
limitedCompany integer
soleTrader integer
total integer
trial integer
recentSignups array<object>
Show child attributes
createdAt string date-time
email string
fullName string
id integer
orgName string
plan string
revenue object
Show child attributes
limitedActive integer
mrr integer
mrrFormatted string
soleTraderActive integer
trials object
Show child attributes
active integer
expired integer
expiringSoon integer
users object
Show child attributes
active integer
locked integer
total integer
webhookHealth object
Show child attributes
failed integer
processed integer
status string
total integer