Mission: Build Your Complete Keyword Spreadsheet
Organize, prioritize, and track SEO opportunities with a Complete Keyword Spreadsheet designed to improve rankings and content planning.
Your graduation task — building the complete keyword system
You have completed 14 lessons covering the full scope of keyword research: how to pick first keywords, understand volume and difficulty, identify search intent, find long-tail and question keywords, use Google's free tools, analyse competitors, run gap analysis, handle seasonal keywords, build topic clusters, manage negative keywords, and prioritise your list into a 90-day plan.
This final lesson is your graduation task: building a complete, production-ready keyword research spreadsheet for your real website. This is not a practice exercise — the output of this lesson is the working document you will use to guide your content production for the next 3–6 months.
A keyword spreadsheet sitting on your desktop is worthless. A keyword spreadsheet connected to a content calendar with published articles is everything. The goal of this lesson is to produce a document you will actively use, not file and forget.
The complete keyword spreadsheet structure
Your spreadsheet should have these tabs:
Tab 1 — Master Keyword List
Every qualified keyword you have identified across all research methods. Columns:
- Keyword— the exact search query
- Monthly Volume— from your keyword tool
- Keyword Difficulty— from RankTracker or Ahrefs
- Intent— Informational / Commercial / Transactional
- Content Type— Blog post / Product page / Landing page / Tool
- Content Format— How-to / List / Comparison / Definition / Tutorial
- Source— Brainstorm / GKP / GSC / Competitor / Gap analysis / Seasonal
- Priority Score— Your 4-factor total from Lesson 24
- Target URL— Existing page or planned new URL
- Status— To target / In progress / Published / Excluded
Tab 2 — Topic Cluster Map
One section per planned topic cluster. Each section shows the Pillar Page at the top (keyword, URL, status) and all Cluster Pages below it (keyword, URL, internal link destination, status). This gives you a visual overview of your topical authority building plan.
Tab 3 — 90-Day Content Calendar
The prioritised list of articles to publish in the next 90 days. Columns:
- Article title / working title
- Primary keyword
- Target URL
- Target word count
- Planned publication date
- Writer (you, freelancer, AI-assisted)
- Status (Not started / Brief written / Draft / In review / Published)
Tab 4 — Do Not Target List
All excluded keywords with reasons and revisit dates, as built in Lesson 22.
Tab 5 — Tracking Dashboard
Updated monthly: published articles with their current average position, clicks, and impressions from Google Search Console. This is where you measure whether your keyword strategy is working and identify articles needing improvement.
The complete research checklist — confirming you have done everything
| Research method | Lessons covered | Done? |
|---|---|---|
| Seed keyword brainstorm (15–25 seeds) | Lesson 11 | ☐ |
| Google Keyword Planner research | Lesson 16 | ☐ |
| Google Search Console striking-distance analysis | Lesson 17 | ☐ |
| Competitor keyword research (2–3 competitors) | Lesson 18 | ☐ |
| Keyword gap analysis | Lesson 19 | ☐ |
| Question keyword research (AnswerThePublic) | Lesson 21 | ☐ |
| Seasonal keyword identification (Google Trends) | Lesson 20 | ☐ |
| Topic cluster mapping (1 full cluster planned) | Lesson 23 | ☐ |
| Negative keyword exclusion list built | Lesson 22 | ☐ |
| Full keyword list scored and prioritised | Lesson 24 | ☐ |
| 90-day content calendar with publication dates | Lesson 24 | ☐ |
| All keywords imported to RankTracker for tracking | All lessons | ☐ |
What a good keyword list looks like — quality signals
Before finalising your list, check it against these quality signals:
- Volume range is appropriate for your authority— Most keywords should be within your achievable difficulty range. If your list is full of KD 60+ terms, you have not filtered aggressively enough.
- Intent variety exists— Your list should include informational (for traffic and brand awareness), commercial (for purchase-intent visitors), and at least a few transactional terms (for direct conversion). A list of only informational terms will not drive business results.
- Topic clustering is clear— You should be able to visually see groups of related keywords that naturally cluster together. Isolated, unrelated keywords are flags — they may produce articles that do not contribute to any topical authority building.
- You have enough to fill the calendar— A 90-day plan with one article per week needs 12–13 unique keyword targets. Make sure your list has at least double this number so you have options if some keywords turn out to be unsuitable during content creation.
What comes after keyword research — Stage 3
Keyword research answers the question: what should I write about? Stage 3 — On-Page SEO — answers the question: how should I write it? This covers title tags, meta descriptions, heading structure, content depth, internal linking, schema markup, featured snippets, and the complete on-page optimisation checklist.
Every keyword in your spreadsheet represents a page that needs to be created and optimised. Stage 3 gives you the system for doing that optimisation consistently and efficiently — so every article you publish from your keyword calendar lands as well as it possibly can.
Graduation Complete — Your SEO Roadmap Starts Now
Completing this keyword research stage means you no longer have to guess what content to create next. You now have a structured system for identifying opportunities, prioritising topics, building topical authority, and measuring performance over time.
The real value of your keyword spreadsheet is not the data it contains but the actions it drives. Every keyword represents a potential page, every cluster represents a future authority asset, and every article in your 90-day calendar is an opportunity to increase organic visibility. Continue updating your spreadsheet monthly, track rankings consistently, and refine priorities based on real performance data. With a documented keyword system in place, your content strategy becomes predictable, scalable, and focused on long-term SEO growth rather than short-term experimentation.