How to Set Up a Content Tracker in a Spreadsheet

Each column exists to answer one question. If a column does not change what you do on Monday morning, delete it. Microsoft's own tracker templates follow the same logic, using custom drop-downs for status and assignee and pre-formatted date columns so the sheet stays consistent as items move from planned to done the Excel template library.

The Audience and Format columns are where the strategy page pays off. Defining why you need the content, who it is for and which format suits the topic is the first item on a well-known small-team content checklist the Marketing Meetup checklist. Writing "Parents of kids under 12" rather than "customers" forces a decision you would otherwise defer until the draft is half written.

The Channel column deserves its own discipline. Distribution is the step that turns an asset into results, and a documented plan for how, where and when content reaches people is what stops teams from relying on a single channel or publishing inconsistently Mimeo's distribution guide. One primary channel per row keeps the tracker honest. Repurposing to a second channel is a new row with the same content and a new ID, which is why the ID column beats a title as the key: titles change, IDs do not.

The Target keyword column is optional in practice. Leave it blank for newsletters, sales emails and anything that will never be searched for. A blank cell is information; a keyword stuffed into a piece that does not need one is noise.

Most trackers collapse under their own status lists. Idea, research, outline, drafting, editing, design, review, scheduled, published, promoted, updating is a workflow, not a status. It requires a decision every time you update a row, and you will stop updating rows.

Three values keep the sheet live:

• Idea. The row exists, the promise is clear, nothing has been written. The only allowed next action is to schedule writing time, which means setting a review date or moving it to Drafting.
• Drafting. Someone is actively working on it. If no one has touched it for two weeks, it is not drafting; it is an idea with a guilty conscience.
• Live. The published URL is filled in. The piece is out in the world and becomes eligible for review, refresh or repurposing.

Where a fourth value helps, add Parked for ideas you have deliberately decided not to pursue. Parked rows are excluded from every filter and never appear in the weekly pass. That single addition prevents the most common failure, which is deleting good ideas because the sheet felt cluttered.

On the repurposing question, the honest split is this: a fourth status buys almost nothing, while two rules do. Every Live row gets a review date fourteen days after publication, and every Live row whose review date has passed without a new action becomes a Drafting row again, either an update or a repurposed version for another channel. Most teams already repurpose content, which is why this loop is worth a status change and not a separate tab; the practice is widespread enough that it is treated as a standard efficiency move the Hannon Hill guide.

The status set also drives the question of what a "due date" means. For Idea rows, the due date is the publishing target. For Drafting rows, it is the deadline for the first complete draft. For Live rows, it is the date the piece went out, and the Next review date takes over as the live deadline.

Do this once, in any spreadsheet app (Excel, Google Sheets, Numbers). The screenshots in Microsoft's tracker gallery show the same shape: a header row, drop-downs for status and owner, and date-formatted columns the Excel templates.

1. Put the eleven column headers in row 1, in the order listed above.
2. Freeze row 1 (View > Freeze > 1 row in Sheets, View > Freeze Panes in Excel).
3. On the Status column, add data validation with exactly three options: Idea, Drafting, Live. In Sheets: Data > Data validation > Dropdown. In Excel: Data > Data Validation > List. The same trick works for Owner and Channel, which removes most typos.
4. Format Due date and Next review as dates, not text. A date stored as text will break every sort and filter.
5. Add a filter (Data > Create a filter). This is the whole engine.
6. Add ID as a plain number. If you want it to auto-fill, use a formula in row 2 and drag it down:

=ROW()-1

That returns 1 in row 2, 2 in row 3, and so on, so the ID always matches the row.

You do not need a progress percentage, a Gantt chart or a dashboard tab. Those exist to report to other people, and a solo operator with one weekly pass is the report. If you later need a second tab, make it a filtered view, not a second set of data to update. Duplicated data in two tabs is how trackers die.

Run this at the same time every week, ideally Friday afternoon, so nothing rots over the weekend. Set a timer. The routine has four steps and each one is mechanical.

Step 1, filter the review dates (2 minutes). On the Next review column, filter for dates on or before today. Everything that needs attention is now on one screen. In Sheets the filter is a condition on the column; in Excel it is Date Filters > Before. Count the rows and write the number down; you will want it next week.

Step 2, move every row one step (10 minutes). For each row in the filtered view, take exactly one action:

• An Idea with a clear promise and a real due date becomes Drafting if you will start it this week. If not, set the Next review date forward by 7 days and leave it.
• A Drafting row that is now written and scheduled becomes Live the day the URL exists. Paste the URL in the same action. Never mark Live without the URL; a status with no evidence is a wish.
• A Live row whose review date has passed gets read again. If it is still accurate, move the Next review date forward by 90 days. If it is stale, change the status back to Drafting and set a due date for the rewrite.

Step 3, set Next action for anything stuck (5 minutes). Any row you could not move gets a one-line Next action in plain words: "Ask Sam for the case study numbers." A row without a next action is a row you have decided not to work on, and it should be Parked.

Step 4, clear the filter and check the shape of the sheet (3 minutes). Turn the filter off. Look at the count of each status. If Ideas outnumber Drafting and Live combined by more than about three to one, stop adding ideas for a month and work the queue down. If Drafting holds more than about five rows, the same rule applies: the constraint is writing time, not the list.

That is the whole routine. The discipline is that every change happens inside the twenty minutes. Changes made midweek are fine, but they are recorded in the same way: status, URL, or a review date. Nothing else.

The tracker is designed for the point where one person makes all the decisions. It starts to fail when a second contributor needs to see it, because two editors updating one row can overwrite each other's review date, and because the owner cannot tell from a URL alone whether the piece is still accurate.

Three moves, in order of effort:

1. Share the sheet, keep the routine. Give the second person edit access to the same file and the same rules. One weekly pass, run by whoever owns the calendar. This works for small collaborations and costs nothing.
2. Add a Needs review column. A Yes or No drop-down, set by the contributor when they finish work on a row. This gives the reviewer a second, cheap filter and keeps the twenty-minute pass intact.
3. Automate the boring parts. Export a filtered list, or call a model to draft the next action for each stuck row. Worked example: with 40 open rows, roughly a third are genuinely stuck at any time, which is 13 rows; writing a one-line next action for each is maybe 10 minutes of typing but closer to 3 if a model drafts them and you approve. That is where a single API for text models earns its keep: Quanta Inference gives you one OpenAI-compatible key for text, embeddings and other model types, priced in US dollars, so the script that drafts next actions does not need a stack of vendor accounts.

Beyond that, the honest answer is that a spreadsheet is the wrong tool once three or more people edit daily and status changes need a history. That is the point to move to a workflow tool, and the data from the sheet (columns, statuses, review dates) transplants almost directly the monday.com strategy guide.

The FAQ block has been moved to the end of this article. It covers whether the tracker should live in Sheets or Excel, what to do with ideas that never get picked, how many rows are too many for one person, whether the twenty-minute routine works with a shared file, and how to hand the tracker to a new owner. Each answer is two to four sentences so you can skim it in the order you need.

One last decision rule, because it is the question people actually ask: should a piece that goes out on two channels be one row or two? If the second channel is a copy of the same asset (a newsletter linking to an article, a post sharing a link), it is one row and the link lives in the Published URL. If the second channel needs its own asset (a video version, a rewritten post with different framing), it is a second row with its own ID and its own due date. The first case is distribution, the second is repurposing, and they fail differently Mimeo's distribution guide.