All work

2024 · Founder-led agency · Systems design

40+ client accounts, one place to see them

A single console for a founder running 40+ client accounts.

Sample data

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 call

Next case

6 → 1

A founder's morning, cut to a 90-second read