[New] Admin deep-dive (commerce/config): Membership (Gate) dashboard lacks churn rate, trial-conversion, and MRR-over-time trend

Area: Admin deep-dive (commerce/config) (audit p15b) · Surface: /admin/gate?tab=dashboard (AdminGateController@dashboardTab) · Dimension: competitor-gap · Severity: minor

Every membership platform (Mighty, Circle, Skool) and subscription tool leads with churn % and MRR trend, because absolute counts don't tell an operator whether the business is healthy. We compute trial_days and create trialing subs but never report trial-conversion rate. An operator can see 'MRR $X right now' and 'N churned' but cannot see whether MRR is growing or shrinking month over month, or whether trials are converting. Churn rate = churned_30d / (active + churned_30d) is computable from data we already store.

Evidence

GateSubscription::stats (GateSubscription.php:145-176) returns active/past_due/canceled_30d/new_30d counts; revenue() (line 190-234) returns a single point-in-time mrr_cents + per-tier detail. There is no churn-RATE (%), no trial->paid conversion, no time series. dashboard.php renders MRR and a raw 'Churned 30d' count (templates/admin/gate/dashboard.php:80-95) but no trend line.

Suggested fix. Add to GateSubscription a monthly MRR snapshot (or compute on the fly from subscription created/canceled timestamps), derive churn-rate %, gross/net MRR delta, and trial-conversion rate, and render an MRR-over-time sparkline reusing the dailySeries SVG helper already in AdminDashboardController.

Filed by the automated tenant-app audit and adversarially evidence-verified. Status: verified. Open — not yet actioned.