If you publish content for a living or for a side business, you probably have a system. It just happens to be five systems. Ideas live in a notes app. The schedule lives in a calendar. Drafts sit in a document folder. Results hide in each platform’s analytics. And the real status of everything lives in your head.

That setup works until a busy week. Then a post goes out late, a newsletter slips, and you realize nobody (including you) could say what was supposed to ship, what was stuck, and which format actually performs.

The fix I keep coming back to is boring on purpose: one table, one row per piece of content, and everything else calculated from it.

What goes in the table

Each row holds a working title, a platform, a format, a content pillar (teach, story, proof, offer, community), a status, an owner, a draft date, a publish date, and after publishing, a handful of numbers: views, likes, comments, link clicks, and hours spent. That is the whole data model.

What the table does for you

Because the data lives in one place, the rest can be formulas. A calendar view reads the publish dates. A flag column marks anything past its publish date as overdue, anything past its draft date as late, and anything due in two days as due soon. A dashboard counts pieces by status and platform, shows engagement per platform, and compares the pillar mix you actually publish with the mix you intended.

That last one is the quiet win. Most creators over-teach and under-promote. Seeing 7 teaching pieces against 1 offer on a chart is more persuasive than any advice about posting your offer more often.

The ten-minute weekly review

Once a week, count what you published against your goal, look at the top five pieces by views, clear anything flagged, and pull two ideas from a scored backlog into the pipeline. Score each idea as impact times two minus effort and the choice mostly makes itself.

Build it yourself or grab the template

You can build this in an hour in any spreadsheet. If you would rather skip the setup, I packaged mine as the Content Pipeline Tracker: an Excel and Google Sheets workbook with the pipeline, auto calendar, dashboard, weekly review, idea bank and an 8-page playbook. No macros, no subscription.

Gumroad: https://logi2.gumroad.com/l/goepn

Etsy: https://www.etsy.com/listing/4602838106

I also write a short weekly note about building simple systems like this one. You can subscribe free at https://aifounderweekly.substack.com

The best content plan is not the prettiest one. It is the one you can see at a glance on a Monday morning.

Originally published on Medium.