This is the follow-up to What I Actually Learned Building a Side Project in 5 Days With AI. That post was about AI. This one is about what happens after you ship — when you actually have to run the thing.
I lost a freelance client last year because I forgot to send a monthly report.
Not because I didn't do the work. I did the work. I just never wrote it down in a place I'd actually look. The report lived in my head — or, more honestly, in one of forty-seven Notion pages I'd lovingly over-engineered and then abandoned.
I didn't have a tooling problem. I had a systems problem. It took me six months and one lost retainer to admit the difference.
The over-engineered years
For a while I was that freelancer. The one with the Notion workspace that looks like a SaaS product. Databases inside databases. Linked views. Templates for templates.
I'd spend Sunday evening building a new system. By Wednesday I'd forget where things lived. By the following Monday I was back in my email looking for the client's last message to remember what we agreed on.
This is the dirty secret of "productivity tools": the more powerful they get, the more they reward the part of your brain that loves building systems over using them. Notion is a playground for that brain. Airtable is worse. Linear is worse still if you're not actually a team.
I tried them all. Every single one of them lost to the one tool I kept avoiding because it felt too boring to take seriously.
The dumb tool that won
A spreadsheet. Three tabs. No login screen. No sync conflicts. Works on a plane.
That's it. That's the system.
Here's the exact structure — you can rebuild it in twenty minutes:
Tab 1: Client Tracker
One row per client. Eight columns, never more:
| Client | Domain | Last report | Next report due | MRR | Status | Notes | Next action |
|---|
That's the whole thing. Conditional formatting on "Next report due" so overdue goes red. Sort by date. Done.
The "Next action" column is the one that saved me. One sentence. Always present tense. Never empty. If I can't write a next action, the relationship is dead and I just haven't admitted it yet.
Tab 2: Keyword Rank Log
One row per data point. Never aggregate prematurely.
| Date | Client | Keyword | Position | URL | Notes |
|---|
Dump rankings in once a week. Pivot table at the bottom turns it into a chart. The chart is the deliverable. I stopped using any "SEO dashboard" tool the day I built this.
Why this beats every SaaS tool I tried: it's mine. The data is mine. The format is mine. When a client asks me a question I can answer it in three clicks, not by logging into someone else's platform that might change its pricing next quarter.
Tab 3: Backlink Log
| Source | Target URL | Anchor | Date acquired | Status | Notes |
|---|
Status column has three values: Live, Lost, Pending. That's it. If you need more states than that, you're optimizing the tracker instead of doing the work.
Every Friday I ctrl-F for "Pending" and send follow-ups. Every month I ctrl-F for "Lost" and decide whether to replace or let go. The whole backlink outreach operation runs out of one tab.
What I gained
Forty minutes a week, roughly. Not by working faster — by stopping the constant tab-switching and re-remembering.
But the real win wasn't time. It was trust in my own memory of the business. I used to be that person who opens a call with "let me check my notes quickly" and then spends ninety seconds failing to find anything. Now I open the sheet and I'm in.
I also started charging more. Turns out when you can answer client questions in three seconds instead of three minutes, you look like someone who has their act together. You are, in fact, someone who has their act together. Pricing follows.
The unsexy truth
Devs love this line, so I'll say it: boring tools age well. A spreadsheet from 2015 still opens. A Notion workspace from 2015 is probably unrecoverable inside a workspace archive three migrations deep.
Side projects are fun. Systems are what actually make freelancing work. I spent three years confusing one for the other. I hope you don't.
You have the whole blueprint above — rebuild it in a fresh sheet, tab by tab, and you're done. If you'd rather skip the formatting work, I also packaged the exact template I use with the pivot charts and conditional formatting pre-built.
Next post I'll share the four formulas that turn Tab 1 into an auto-generated monthly client report.
