researching-content-opportunities
Researches keyword and content opportunities for FlashFusion using Ahrefs and Semrush. Runs quarterly before content planning to identify what to write, what FlashFusion can realistically rank for, an
SKILL.mdplugins/loxihart-business/skills/researching-content-opportunities/SKILL.md
GitHubContent Opportunity Researcher
Finds the keyword territory FlashFusion should own this quarter. Output is a short, prioritized topic list — not a 500-keyword spreadsheet nobody acts on.
Run this before writing anything. Running SEO research after writing is closing the barn door.
Load references/ff-seo-context.md before running any search step.
Phase 1: Competitor Gap Analysis (Semrush)
Finds keywords where FlashFusion's competitors rank but FlashFusion does not.
- Semrush → Keyword Gap tool
- Enter
flashfusion.co+ 2–3 competitor domains from the context file's competitor list - Filter results:
- Competitors rank positions 1–20
- FlashFusion does not rank in top 100
- Monthly volume: 100–5,000
- Keyword difficulty: under 40
- Intent: informational or commercial investigation (not pure transactional)
- Export top 50, note the best 15 opportunities
Phase 2: Trending Content in This Space (Ahrefs)
Finds what's gaining traction right now in FlashFusion's content pillars.
- Ahrefs → Content Explorer
- Run a search per content pillar (e.g.,
"n8n automation","AI agent workflow","AI for MSPs","tool consolidation") - Filter: Published last 90 days · Referring domains > 3 · DR < 65
- Surfaces what's performing and not yet over-covered
- Note 5–10 topics with meaningful traffic and low competitive saturation
Phase 3: Own-Keyword Acceleration (Ahrefs)
Finds FlashFusion content already ranking in positions 10–50 — "almost there" opportunities that need a push, not new content.
- Ahrefs → Site Explorer →
flashfusion.co - Organic keywords → filter position 10–50
- Note 3–5 terms where a content refresh or targeted internal link could move rankings
These get added to the output as refresh tasks, not new content tasks.
Phase 4: Cluster and Prioritize
Take all candidate topics from Phases 1–3 and cluster related terms together (run searchfit-seo:keyword-clustering if the list exceeds 30 terms).
Score each cluster:
| Dimension | Score |
|---|---|
| Business alignment — does this lead to FlashFusion services or newsletter signups? | 1–3 |
| Achievability — can FlashFusion realistically rank here in 90 days? | 1–3 |
| Volume potential — is the traffic worth the effort? | 1–3 |
Prioritize clusters scoring 7+. Anything below 5 goes to the Defer list.
Output Format
Q[X] Content Targets — FlashFusion
Generated: {{DATE}}
DO NOW (score 7–9)
1. [Topic cluster] — primary keyword: "[keyword]" (vol: X/mo, KD: X) — content type: [tutorial / case study / post / guide]
2. ...
DO NEXT (score 5–6)
3. ...
REFRESH EXISTING
• [URL] — ranking for "[keyword]" at position X — action: [content refresh / add internal links / update title tag]
SKIP THIS QUARTER
• [Cluster] — reason: [KD too high / volume too low / poor business alignment / content already exists]
Save output to: FlashFusion/Content/SEO/{{YYYY-Q}}_content-targets.md
Tool Split
| Task | Use |
|---|---|
| Keyword volume + difficulty data | Semrush |
| Competitor content research | Ahrefs Content Explorer |
| SERP analysis for specific keywords | Ahrefs |
| Backlink analysis | Ahrefs |
| Content gap vs. competitors | Semrush Keyword Gap |
| Site health + technical audit | Semrush Site Audit |
| Rank tracking (ongoing) | Ahrefs Rank Tracker |
Do not run both tools on the same task — pick the better one per job.
Cadence
- Quarterly: Full run (all 4 phases) — start of Q1, Q2, Q3, Q4
- Monthly pulse: Phase 3 only (own-keyword check, 15 minutes)
- Ad hoc: Phase 2 only when starting a new content series
Anti-Patterns
- Don't optimize for raw volume alone. KD 75 at 50K/month is not a FlashFusion opportunity — it's a fantasy until domain authority is established. Stay under KD 40.
- Don't produce more than 15 prioritized targets. Longer lists don't get used.
- Don't skip the competitor gap step. Writing what you want vs. what has a gap are different activities.
- Don't confuse social reach with SEO. LinkedIn impressions have no bearing on Google rankings.
- Don't run this without a live content hub. SEO research is premature if
flashfusion.co/blogdoesn't exist yet. If the hub isn't live, the first output of this skill should be: "Build the content hub first."