Keyword Gap Analysis — Competitor Gaps + Priority Plan

Unlike free competitor-analysis skills and "what keywords am I missing?" prompts that guess from memory, this skill runs a bundled script on your real exports (Ahrefs, Semrush, GSC or a plain position list) and labels every keyword MISSING, BEHIND, WEAK, SHARED_STRONG or UNIQUE_TO_US with the positions from your files. Then it turns the gaps into a ranked page plan. It never invents volumes, difficulty or rankings.

Sample run: mailerlite.com vs Mailchimp, Constant Contact and Brevo, 16 email-marketing keywords (positions = Brave Search top 20, US English, fetched 21 Oct 2026, not Google; no volume used; public pages; not affiliated with any of them):

1. Script: MISSING 6 · BEHIND 5 · SHARED_STRONG 3 · UNIQUE_TO_US 1 (newsletter templates: none of the 4 sites in the top 20)
2. best email marketing software → MISSING · all 3 rivals rank (Constant Contact #2, Brevo #10, Mailchimp #16) · top 10 is 8/10 "best X" lists → build one list page
3. email marketing software → MISSING · Mailchimp #3, Constant Contact #4 → same list page as #2, not a second page
4. email marketing pricing → MISSING · Constant Contact /pricing #5 · 6/10 are cost guides → write a cost guide, not another pricing page
5. email marketing for small business → BEHIND · our guide #17 vs Constant Contact #1 · our title still says "2024" → refresh
6. mailchimp alternatives → BEHIND · our vs-page #7 vs Constant Contact's numbered list #1 (7/10 are lists)
7. email automation → BEHIND · our feature page #14 vs Mailchimp's beginner guide #2 · 6/10 guides → page-type gap
8. how to build an email list → BEHIND · #12 vs Brevo #6 → quick win (positions 8-20)
9. Protect: welcome email examples #2 (Brevo #18), title says "for 2024" · landing page builder #16, only us
10. Excluded: mailerlite vs mailchimp (brand) · sms marketing, transactional email service (separate product lines: check fit)

Full report from this run in the Example below.

Works in Claude Code, Cursor and Codex · tested on real public data (the MailerLite run above) · SKILL.md + two Python scripts (stdlib only, no network, no API keys) · never invents volume, difficulty or rankings · v1.0, updated Oct 2026 · questions answered via Agensi messages within 24h · Group the gap keywords into topic clusters and briefs with our Apify actor: https://apify.com/cygnix_labs/keyword-clusterer-brief · Free no-API-key SEO MCP server (keyword clustering, search intent, briefs): https://github.com/cygnixlabs-cmd/cygnix-seo-mcp

Gap reports in SEO tools give you thousands of rows and no decision. This gives you the 5-10 pages to build or refresh, and the ones to protect.

What it does

• Compares your keyword export with 1-5 competitor exports: Ahrefs (UTF-16 TSV), Semrush CSV, GSC Queries CSV, or a plain list. Keyword, position and volume columns are auto-detected.
• Labels every keyword: MISSING (rivals rank, you don't), BEHIND (5+ positions behind the best rival), WEAK (you rank worse than 20), SHARED_STRONG, UNIQUE_TO_US.
• Adds a rule-based intent guess and a suggested page type, and flags low-confidence rows for a SERP check.
• Prioritises pages, not keywords: business fit × competitor proof × effort (quick wins at positions 8-20 score highest), and merges near-duplicates into one page.

How it works

1. Export your keywords and 1-5 competitors' keywords (templates/how-to-export.md shows where in each tool).
2. Your agent runs scripts/keyword_gap.py and reviews the top 15 gaps with you.
3. You get keyword-gap.csv plus a report: counts by status, top 10 opportunities, page plan (new pages / refreshes / quick wins), protect list, exclusions, and a verification checklist.

Who it's for

SEO leads, agencies and SaaS founders planning a content sprint from real competitor data. Not a rank tracker, and not a volume tool: it uses only the numbers in your files.

Pairs well with (Cygnix Labs, on Agensi)

• Keyword Clusters + Intent Map: No Paid SEO Tool Needed (agensi.io/skills/keyword-clusters-intent-map-no-paid-seo-tool-needed): cluster the gap list
• SERP Intent Mapper — Keyword → Page Type Match (agensi.io/skills/serp-intent-mapper-keyword-page-type-match): confirm the page type for each gap
• SEO Content Brief — Writer-Ready Outline, free (agensi.io/skills/seo-content-brief-writer-ready-outline): brief each new page
• Win Featured Snippets + People Also Ask: SERP Win Plan (agensi.io/skills/win-featured-snippets-people-also-ask-serp-win-plan): for gaps with a snippet
• Fix Keyword Cannibalization Using Google Search Console (agensi.io/skills/fix-keyword-cannibalization-using-google-search-console): before you add pages
• Find Decaying Pages: GSC Triage + Content Refresh Plan (agensi.io/skills/find-decaying-pages-gsc-triage-content-refresh-plan): for BEHIND pages losing traffic