Admin area
Business
Revenue, renewals, costs. Owner-only — Theodore and other admins don't see this view.
Owner only
Annual recurring revenue
$490k
Across 40 active fellows
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.
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.