Case Study — 03
I built this for myself — a Google Sheets system to track every affiliate link, commission rate, product I'm testing, and post I'm planning. No more running it all from memory.
The Problem I Was Having
I was managing my affiliate content operation entirely in my head. Links scattered across browser tabs and bookmarks. Commission rates I'd have to log back into dashboards to check. Products I wanted to post about but couldn't remember if I already had. No system — just mental notes that kept piling up.
I needed one place to hold all of it: the links, the rates, what I was testing, and what I planned to post next. So I built it.
What I Built
Every affiliate link I have, organized by platform and source — with the commission rate right there in the same row so I never have to go hunting for it.
A dedicated section for products I'm currently reviewing. Status fields and notes I can update as I test — so I always know where something is in the process.
Planned product posts with draft status and scheduled dates — so nothing stays stuck in my head or falls through the cracks between idea and publish.
Same fields, same format every time I add something new. It keeps the whole workbook clean and easy to scan as it grows.
What Changed
Affiliate links, rates, and sources are organized and accessible in under 30 seconds — no logging back in anywhere.
Products in testing have a clear status — I always know what stage something is in without having to think hard about it.
My content pipeline is visible end-to-end — from product idea to planned post date, all in one view.
The mental load dropped. The system holds the details so I don't have to carry them around in my head all day.
Inside the System
Three tabs. Everything in one workbook. Here's the real thing.
Skills Demonstrated
Work With Me
I build custom workbook systems for creators, coaches, and small business owners. Bring the chaos — I'll build the structure.
Get in Touch