List business-metric-snapshots

GET

/business-metric-snapshots

• Current canonical versioned path (F3.API.01)

F3.ANALYTICS.01 — daily cron-computed cache of platform-wide business metrics (MRR, churn, DAU/MAU, funnel, MTTP/TTV, ARPA). The /sencai-admin/business-metrics endpoint reads the latest row instead of running live aggregation queries per request.

Authorizations

• bearerAuth
• apiTokenAuth

Parameters

Query Parameters

pagination[page]

integer

pagination[pageSize]

integer

filters

Strapi REST filter syntax

object

sort

string

populate

string

Responses

200

OK

object

data

Array

object

snapshot_date

required

Calendar day (UTC) this snapshot represents — one row per day, upserted idempotently by the cron.

string format: date

computed_at

required

string format: date-time

mrr_usd

required

Monthly Recurring Revenue — sum of active subscription-enrollment tier prices (yearly normalized /12).

number

mrr_growth_pct

MRR percentage growth vs the previous snapshot (day-over-day here; dashboard aggregates for month-over-month).

number

arr_usd

Annual Recurring Revenue — mrr_usd * 12.

number

logo_churn_rate_monthly

Fraction (0..1) of active accounts at start of trailing 30d window that cancelled/expired by end of window.

number

revenue_churn_rate_monthly

Fraction (0..1) of MRR at start of trailing 30d window lost to cancellations/downgrades (gross, pre-expansion).

number

net_revenue_retention_pct

NRR — (starting MRR + expansion - contraction - churned MRR) / starting MRR * 100, trailing 30d cohort.

number

dau

Distinct active users (platform-event actor_user_id) in the trailing 24h window.

integer

mau

Distinct active users (platform-event actor_user_id) in the trailing 30d window.

integer

stickiness_pct

DAU / MAU * 100 — engagement stickiness ratio.

number

funnel

Activation funnel snapshot — reuses computeActivationFunnel() (F3.ONBOARDING.03), stored verbatim ({ steps, ttv, … }).

mttp_hours

Mean time to paid — average hours between signup (onboarding.signup platform-event) and first billing-event for the same organisation.

number

ttv_median_hours

Median time-to-value hours, taken from the activation-funnel ttv computation (signup -> first value event).

number

arpa_usd

Average Revenue Per Account — mrr_usd / active_paid_accounts.

number

trial_conversion_rate_pct

% of trials started (trailing 90d) that converted to a paid subscription-enrollment.

number

active_paid_accounts

integer

total_accounts

integer

raw

Full computation result object (BusinessMetricsResult) — superset of the flattened columns above, kept for forward-compatible dashboard consumption without a migration.

documentId

string

id

integer

createdAt

string format: date-time

updatedAt

string format: date-time

publishedAt

string format: date-time

nullable

meta

object

pagination

object

page

integer

pageSize

integer

pageCount

integer

total

integer

401

Missing or invalid authentication

403

Not authorized (tenant scope or capability)