← Studio Cruz

Case Study — 03

Affiliate Inventory
Workbook
System

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.

Built By Joy Cruz-Medranda
Tool Google Sheets
Type Personal Operations System

Running it all from memory

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.

How the workbook is structured

01
Link Library

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.

02
Testing Tracker

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.

03
Content Pipeline

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.

04
Consistent Entry Structure

Same fields, same format every time I add something new. It keeps the whole workbook clean and easy to scan as it grows.

What this system actually did for me

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.

What it actually looks like

Three tabs. Everything in one workbook. Here's the real thing.

Affiliate Inventory
Affiliate Inventory tab showing product ideas with status, commission rates, and content angles
Rates & Sources
Rates and Sources tab showing Amazon Associates commission rates by category
Workflow
Workflow tab showing step-by-step guidance for using the workbook

What went into building this

Affiliate Link Management Content Pipeline Design Google Sheets Systems Workflow Structuring Operations Design

Work With Me

Need a system like this for your business?

I build custom workbook systems for creators, coaches, and small business owners. Bring the chaos — I'll build the structure.

Get in Touch