2024 · Founder-led agency · Systems design
40+ client accounts, one place to see them
A single console for a founder running 40+ client accounts.
12 hrs / week
Founder time saved
+15%
Net retention lift
21 days earlier
At-risk lead time
Context
The founder was running 40+ concurrent client accounts out of email threads and three disconnected tools. Status was a guess, renewals were last-minute, and at-risk accounts were only visible after they churned.
Problem
No single source of truth for account health. No early-warning signals. The founder was spending 12+ hours a week assembling status manually, and still missing things.
My role
Designed the system and the daily operating rhythm around it.
Build
- Mapped every signal — calls, tickets, usage, invoices — into one Airtable schema with health scoring.
- Built a Notion command center that surfaces only what the founder needs to act on today: at-risk accounts, renewals in 30 days, blocked implementations.
- Automated the data pull and the daily brief via Make.com + a GPT-4 summarizer.
- Trained the founder and one VA on the cadence: 10 minutes a day instead of 12 hours a week.
Built with: Notion · Airtable · Make.com · GPT-4 · Slack
Takeaway
The system wasn't the interesting part. The discipline of deciding what the founder should and shouldn't see was.
References available on request.
Have a similar problem?
Request a callNext case
6 → 1
A founder's morning, cut to a 90-second read