👁 18 views
501 Keywords, 5 Rankings: What a Real Content Gap Analysis Reveals
Here’s an uncomfortable truth about SEO: having a keyword plan and executing a keyword plan are two very different things. Today, I ran a full content gap analysis on Master Control Press — and the numbers were humbling.
501 keywords in the tracking database. 5 showing any rankings in Google Search Console. That’s a 99% gap between ambition and reality. And you know what? That’s completely fine — because now we know exactly what to build.
What Is a Content Gap Analysis?
A content gap analysis is the process of identifying the keywords you want to rank for versus the keywords you actually rank for — and mapping the difference to content you need to create.
Most people think of content gap analysis as a competitor intelligence tool: find keywords your competitors rank for that you don’t, then create content to close the gap. That’s valid. But there’s an even more fundamental version: auditing your own keyword plan against your own rankings.
That’s what we did today, and it revealed something important about how SEO strategies often fail in practice.
The Keyword Plan Reality Check
Master Control Press was set up with a 501-keyword tracking plan — a carefully researched list of terms covering everything from “WordPress MCP” to “AI automation tools.” These were imported into our reporting platform at seobandwagon.dev, which now tracks MCP as a real client alongside other sites.
When we pulled the GSC data today and cross-referenced it against the keyword plan, here’s what we found:
- 5 keywords with any ranking (including position data)
- 1 keyword in the top 10: “acf mcp” at position 8
- 4 keywords between positions 62–79
- 496 keywords: not ranking at all
For context, the site has 25 pages getting impressions out of 76 total. Traffic is 88% direct, 12% Twitter. Organic search is essentially zero.
Is this a failure? No. The site is about three months old. Google doesn’t hand out trust to new domains for free. But it is a clear signal: we’ve been building a keyword strategy without building the content to back it up.
The Deeper Problem: Content Drift
Here’s what makes this more interesting. Master Control Press has a content plan with 17 planned articles — specific posts targeting specific keywords, researched and mapped months ago. We checked how many of those 17 planned pieces had been published.
Zero. Not one.
Meanwhile, the blog has been publishing posts — just not the right ones. The daily AI-driven content process (powered by OpenClaw) had been doing its own independent keyword research instead of consulting the existing plan. The result: about 40% topical alignment with the actual content strategy.
This is what I’d call content drift: when automated or ad-hoc publishing gradually diverges from your intentional SEO strategy. It’s surprisingly easy to let happen, especially when the publishing process is abstracted away from the planning process.
The fix is simple in concept but requires discipline: the content calendar has to be the source of truth. Every post needs to trace back to a planned keyword target, not just a vibe.
The 7-Day Reset: A Structured Content Plan
Today we corrected course. Rather than continuing random-topic content, we mapped out a concrete 7-day content schedule targeting high-volume keywords that align with MCP’s audience — people interested in AI tools, WordPress, and automation:
| Day | Target Keyword | Monthly Search Volume |
|---|---|---|
| Sun 3/8 | claude ai vs chatgpt | 3,600 |
| Mon 3/9 | claude ai free | 3,600 |
| Tue 3/10 | what is claude ai | 5,400 |
| Wed 3/11 | n8n ai agents | 2,400 |
| Thu 3/12 | ai voice agents | 1,900 |
| Fri 3/13 | ai automation | 8,100 |
| Sat 3/14 | manus ai agents | 6,600 |
These are real search terms with real volume. They’re not guaranteed winners — MCP will have to earn rankings through content quality and time — but at least the effort is being pointed in a deliberate direction.
What Good SEO Keyword Strategy Actually Looks Like
Running this analysis reinforced some principles that are easy to forget when you’re in execution mode:
1. Track keywords before you write, not after
The instinct is to publish content and then figure out what keywords it might rank for. The better approach is the reverse: identify target keywords, create content specifically for those terms, then track performance. Retroactive keyword mapping is a mess.
2. Volume isn’t the only signal
MCP’s one top-10 ranking — “acf mcp” at position 8 — has very low volume. But it’s extremely targeted. A new site will rank for long-tail, specific terms before it competes for head terms. The keyword plan should include a mix of aspirational head terms (for when authority builds) and realistic long-tail terms you can win now.
3. Content plans need a feedback loop
A static content plan goes stale. Rankings change, search intent shifts, competitors move. The plan MCP is working from was built months ago — some targets may already have moved. Building a feedback loop (monthly review of rankings → update content plan → adjust publishing calendar) is how you stay on course.
4. Transparency is a link-building strategy
Posts like this one — sharing real numbers, real gaps, real strategy decisions — are inherently more linkable than generic SEO advice. Building in public isn’t just a growth hack; it’s how you create content that other people in the space actually want to reference. If you’re doing SEO for a site, consider documenting the process. The meta-content often outperforms the object-level content.
The 28-Day Snapshot
For anyone following the MCP growth story, here’s where things stand over the last 28 days:
- GSC Impressions: 572 (up 193% week-over-week in the last 7 days: 41 → 120)
- Clicks: 1
- CTR: 0.17%
- GA4 Sessions: 17
- Users: 16
- Pageviews: 27
The impression growth is the encouraging signal. Google is starting to crawl and surface pages. That 193% week-over-week jump isn’t vanity — it means the site is gaining indexation and topical relevance. The click problem (0.17% CTR) is a title/meta description optimization issue, but fixing that only matters once we’re ranking well enough to get impressions in the first place. One thing at a time.
Takeaways
If you’re doing SEO — for yourself, for a client, or with AI tooling — here’s what today’s work suggests:
- Run a content gap analysis on your own plan first. Before looking at competitors, check whether your own content plan has actually been executed. You might be surprised.
- Content drift is a real risk with automated publishing. If an AI is writing your posts, make sure it’s writing to a plan — not improvising topics every day.
- New sites take 6–12 months to rank. The 193% impression growth is real progress. Sustainable rankings don’t happen in weeks.
- Build the feedback loop into your process. Rankings → plan update → publishing calendar. Repeat monthly.
The gap between 501 planned keywords and 5 actual rankings isn’t a failure — it’s a roadmap. Every one of those 496 unranked terms is a future opportunity. The question is just whether we’ll execute systematically or keep drifting.
We’re choosing systematic. Watch this space.
Master Control Press is built and documented in public. All metrics are real. This post was researched and drafted using OpenClaw, an AI assistant framework, running keyword research via the DataForSEO API and publishing directly to WordPress via MCP.
