Admin area
Business
Owner-only — Theodore and other admins don't see this view. Three lenses on the same business: top-of-funnel, mid-funnel, and what's already in the book.
Last 30 days
$47.5k
+38% vs same period last year
YTD revenue
$162k
+59% vs YTD 2025
New fellows this month
3
+$25k closed
2 fellows in grace period
Their program ended but the 30-day grace window is still open. Personal outreach has the highest renewal-conversion lift — surface them on a call this week if you can.
CL
Christophe Legrand
Expired 12d ago · last contacted 8 days ago
YT
Yuki Tanaka
Expired 18d ago · no recent contact logged
Total revenue at stake: $15k
Active book by tier
Revenue concentration across the three program offerings.
HTO
8 fellows
$240k
49% of book
Mid
18 fellows
$180k
37% of book
Entry
14 fellows
$70k
14% of book
HTO is 49% of revenue from 20% of fellows. Watch concentration risk if HTO churns disproportionately.
Renewal pipeline
Programs ending in the next 90 days, ranked by date.
At risk in 30 days
$35k
- Likely renewingLayla SaitoHTOExpires May 12, 2026 · 12d out$30k
- Likely renewingJens HolmMIDExpires May 15, 2026 · 15d out$10k
- UncertainFelix BrandtMIDExpires May 22, 2026 · 22d out$10k
- At riskExpires May 28, 2026 · 28d out$30k
- Likely renewingPieter JanssenENTRYExpires Jun 8, 2026 · 39d out$5k
- Likely renewingExpires Jun 14, 2026 · 45d out$10k
- UncertainHenrik NyströmENTRYExpires Jun 22, 2026 · 53d out$5k
Stage 1 wires this to a daily cron over program_active_until + your Square + Stripe customer status.
Skool community
Money actually collected each month. Mix of monthly subs, annual prepays, and churn — so we count cash, not MRR.
Cash collected (last 30d)
$1,042
3-mo avg: $968
Active members
47
Net +3 this month
New (30d)
+6
Churned (30d)
-3
Cash collected by month
$0.90k
Nov
$0.87k
Dec
$1.14k
Jan
$0.90k
Feb
$0.96k
Mar
$1.04k
Apr
Counted separately from the coaching book — the math models are different (high-ticket coaching is lumpy/annual; Skool is recurring with annual prepays mixed in). Stage 1 ingests via monthly Skool CSV export or Stripe Connect webhooks.
Recent payments
Last 10 transactions across Square and Stripe.
- HVHana VossRenewalSquare · 2 days ago$30,000
- MAMarcus AlbrechtNew fellowSquare · 4 days ago$10,000
- DRDiego ReyesMonthlyStripe · 5 days ago$3,000
- ECEleanor ChenNew fellowSquare · 9 days ago$5,000
- VPVincent ParkRenewalSquare · 12 days ago$30,000
- SMSofia MendesNew fellowStripe · 16 days ago$5,000
- ILInes LarsenMonthlyStripe · 19 days ago$3,000
- TBThomas BellRenewalSquare · 23 days ago$10,000
- RMRohan MehtaMonthlyStripe · 26 days ago$1,500
- ELEmma LindqvistReactivationSquare · 29 days ago$500
Operating costs
What it costs to run the platform this month.
vercel$20
supabase$0(free tier)
anthropic$42
perplexity$5
resend$0(free tier)
vimeo$20
Total / mo$87
~$2.17 per fellow per month. Margin per fellow: ~$1,019/mo.
Privacy: this view is gated by the Owner role. Theodore and Coach roles never see business data; their views top out at program-state metrics on the Operator dashboard. Stage 1 enforces this server-side via middleware against the user_roles table, not just the client-side check used in this prototype.
Source of truth: the renewal pipeline reads users.program_active_until joined against active Square + Stripe subscription status. The recent-payments stream comes from your existing Square and Stripe webhooks. The opcosts breakdown comes from monthly invoices on each provider, ingested via a Resend monthly digest.
Source of truth: the renewal pipeline reads users.program_active_until joined against active Square + Stripe subscription status. The recent-payments stream comes from your existing Square and Stripe webhooks. The opcosts breakdown comes from monthly invoices on each provider, ingested via a Resend monthly digest.