I Built a Scaling Dashboard for a $200K/Month UGC Agency

Three founders doing everything. Seven part-time managers who couldn't hold creators accountable. Tool sprawl across Notion, Google Sheets, Google Docs, and Any.do. No tracking. No SOPs. No role clarity in the founding team. Campaign quality was dropping because the founders — the only people who could actually run campaigns well — had stopped running campaigns.

And the number that mattered most: 15% gross margin. On $200K/month revenue, they were keeping about $29K. They wanted to scale to $1M/month. At that margin, scaling just means losing money faster.

They couldn't see any of this. It was all gut feel and scattered spreadsheets.

This is the trap Alex Hormozi describes in his scaling framework: founders try to jump from Prove to Scale without passing through Systemize. The instinct is always “more clients, more revenue.” The math says otherwise.

Tab 1: Unit Economics. Plug in your numbers — revenue per client, creator costs, manager costs, platform fees — and see your actual margin in real time. When their 15% flashed red on screen, the room went quiet. That silence was worth more than any advice I could give.

Tab 2: Growth Engine. Model what $1M/month actually requires: how many clients, how many creators, how many managers, what churn replacement looks like month over month. They discovered they'd need 20 clients, 140 creators, and 10 managers — plus 19 new creators per month just to replace churn. There's a toggle that shows what happens when AI agents handle some of the manager workload. Manager count drops from 10 to 4. The economics shift from strained to viable.

Tab 3: Scaling Roadmap. Built on Hormozi's four-stage model — Prove, Systemize, Scale, Leverage — adapted for agency economics. An honest assessment of where you are and what needs to happen before the next stage. They were trying to Scale when they hadn't finished Systemize. The dashboard showed them exactly why that breaks.

Each call peeled back a layer because the dashboard gave us shared language and real numbers to argue with. Not opinions. Math.

This is Paul Graham's “do things that don't scale” in practice. I didn't build a SaaS platform or a repeatable template. I sat with the founders, understood their specific business, and built a tool for their exact situation. The tool wasn't the engagement — it was the door. It turned a vague “can you help us organize stuff” into a concrete conversation about margins, operating models, and what actually needs to be true before you add your next client.

Every first-time founder scaling a service business hits the same wall. Revenue goes up, complexity goes up faster, and margin quietly disappears. The instinct is to hire more people. Usually the answer is to fix the model first.

The dashboard itself is simple to build. But it changes the nature of the conversation. Founders stop debating opinions and start looking at their own numbers. And their own numbers don't lie.

What I'd do differently: Start with the founding team alignment before the operational diagnosis. The tool problems were symptoms of a people problem. Also — set a paid engagement boundary earlier. Three calls of free strategic advice is generous. Two is probably the right number before scoping paid work.