SEO Content Brief & Topic Cluster System
A 12-sheet spreadsheet system that scores your keywords, plans your clusters, and flags which posts need fixing, automatically.
You’ve got keywords in one spreadsheet, post ideas in a Notion page, half a brief in a Google Doc, and no idea which of your published posts is quietly sinking.
That’s not a content strategy. That’s four browser tabs and a hope.
This is the file that replaces all of it.
What It Actually Does
Most templates hand you empty columns and wish you luck. This one does the thinking with you.
Enter volume and difficulty, the sheet does the rest.
- Ranks every keyword by real opportunity, not just search volume
- Weights commercial and transactional terms higher, they’re the ones that convert
- Recalculates instantly as you add new keywords
The moment two posts compete for the same keyword, you’ll know.
- Same keyword entered twice turns the row red automatically
- Catches one of the most common reasons small blogs quietly stall
- No manual cross-checking required
Every pillar topic, checked for you.
- Flags clusters under 3 posts as too thin to work
- Flags clusters over 8 posts as needing a split
- Keeps pillar and supporting posts mapped together
Guessing at length is how you write 3,000 words nobody needed.
- Log the top 5 ranking results for your keyword
- Averages their word counts automatically
- Sets your target at +15% over that average
Type your title, see the count update as you go.
- Live character count for meta titles
- Same live count for meta descriptions
- Flags anything Google is likely to cut off
A 10-point sign-off gate built into the sheet.
- Reads “NOT YET” until every check is genuinely done
- Stops half-finished posts from going live
- Ten checks, right where you’re already working
Content decay is invisible until it isn’t.
- Log rankings monthly, right in the sheet
- Works out the trend automatically
- Recommends maintain, optimise, expand, or rewrite
What’s Inside: 12 Sheets
Every sheet arrives with example data built in, so you can see exactly how it’s meant to be filled in before you clear it and start.
Twelve sheets, one file, zero guesswork on your next brief.
Who This Is (And Isn’t) For
A quick gut check before you buy.
- Bloggers who are publishing consistently but can’t tell what’s working.
- Freelance writers and small agencies who brief clients’ content and want to stop rewriting the same doc from scratch.
- Anyone who’s been told to “build topic clusters” and never got a straight answer on how.
If you haven’t published anything yet, start with the 90-Day Blog Growth Roadmap instead. This system assumes you’re already writing and want to do it deliberately.
This won’t write your posts for you and it won’t rank you overnight. It’s a system for making better decisions before you write and better calls after you publish. That’s it, but that’s the part most people skip.
Before You Buy
Will this work in Google Sheets?
Do I need a keyword research tool to use it?
Is this a course or a template?
Do I get future updates?
What if it’s not for me?
- One .xlsx file
- Works in Excel, Google Sheets, LibreOffice and Numbers
- All formulas, dropdowns and colour-coding built in
- Example data in every sheet, delete it and start
- Yours to keep, use on unlimited projects
Digital download: no refunds once the file is delivered. Questions before buying? Email theardentblogger@gmail.com and I’ll answer honestly.