- Home
- Skills
- Marketing & SEO
- seo opportunity research
seo opportunity research
Find beatable SEO opportunities and build high-intent page plans using the scenario keyword matrix.
Free
Works with the AI Agents you already use
seo opportunity research
Example session with this skill installed
I'm building a simple SQL formatter tool. I can ship 4 pages a month. Do keyword research and find 3 P0 opportunities using the scenario keyword matrix. I don't have SEMrush data.
- Read your context and instructions
- Compiled the seo opportunity research
I have analyzed the SQL formatting niche using the scenario keyword matrix. Since no tool data was provided, all volume estimates are marked as UNVERIFIED based on Google Autocomplete and Reddit discussion frequency.
SEO opportunity research (checked 2025-05-14)
Keyword opportunities
| Keyword | Intent | Volume | Competition read | Score | Priority |
|---|---|---|---|---|---|
| format sql for jira comments | Transactional | UNVERIFIED | Low (forum threads only) | 9 | P0 |
| prettify minified sql server script | Transactional | UNVERIFIED | Medium (generic tools) | 8 | P0 |
| sql formatter for powerpoint slides | Informational | UNVERIFIED | Very Low (no tool pages) | 7 | P0 |
Scenario keyword matrix (tool products)
| Scenario query | Axes | Evidence | Scenario-unique content | Priority |
|---|---|---|---|---|
| "format sql for slack" | SQL x Slack x Developer | Autocomplete | Code block syntax guide | P1 |
| "unminify sql from logs" | Minified SQL x Debugging x DevOps | Reddit /r/sql | Batch processing tips | P0 |
P0 pages to build now
- Title: Format SQL for Jira Comments - Free Online Tool
- Keyword/Intent: "format sql for jira" / Transactional
- URL:
/format-sql-for-jira - Unique Value: Automatically wraps SQL in
{code:sql}tags specific to Jira's markup language. - Outline: Tool Input, Jira Syntax Guide, One-click Copy for Jira, FAQ on Markdown vs Jira.
- CTA: Try the Jira-ready formatter.
Top-10 Weakness: Existing tools provide generic SQL but users have to manually add Jira tags which is a friction point.
- Title: Prettify SQL Server Scripts - Online Formatter
- Keyword/Intent: "prettify sql server script" / Transactional
- URL:
/sql-server-formatter - Unique Value: T-SQL specific formatting (bracket handling, CTE indenting).
- Outline: T-SQL Formatter, Common T-SQL formatting rules, Copy to SSMS.
- CTA: Clean your T-SQL.
Top-10 Weakness: Most formatters use MySQL standards and break on specific T-SQL syntax like TOP or CROSS APPLY.
Next steps
- Verify "Jira comment" search frequency using a keyword tool if possible.
- Create the Jira-specific formatting logic for the tool.
- Draft the T-SQL specific formatting rules for the second P0 page.
Connects securely to your tools. The creator never sees your data.
About this skill
Stop wasting time and money on high-competition keywords that your site will never rank for. Most SEO advice is written for big agencies with massive budgets, leading solo founders to target "category" terms that are already locked down by incumbents. This skill shifts the focus to low-competition, high-intent gaps where you can actually win.
What it does
- Scenario decomposition breaks your product features into ultra-specific user problems to find "zero-volume" keywords that actually convert.
- Competitor gap analysis audits the top 10 search results to find specific weaknesses like outdated info, thin content, or format mismatches.
- Intent classification maps every keyword to its search intent to ensure you build the right page type for the query.
- Opportunity scoring prioritizes tasks by demand, beatability, product fit, and commercial value on a 1 to 10 scale.
- Content planning generates structured P0 page plans including title, URL slug, unique value proposition, and internal linking strategy.
How it works
- Discovery phase where you provide your product details, shipping capacity, and any available tool data from Ahrefs or SEMrush.
- Analysis mode where the agent mines community discussions, Google Autocomplete, and "People Also Ask" to find unverified but high-demand keywords.
- Execution planning where the agent produces a prioritized P0 to P2 roadmap with a specific scenario keyword matrix for tool products.
Frameworks & tools
This skill uses a custom scoring rubric and the scenario keyword matrix method. It integrates with data from Ahrefs, SEMrush, Google Search, Reddit, and Hacker News.
Why this beats prompting it yourself
Generic prompts often return generic "best practices" or high-volume keywords you can't rank for. This skill enforces strict evidence rules, requiring verifiable sources for every keyword and a specific "reason to win" for every planned page.
Use cases
- Launching a new SaaS tool and needing a Day 1 programmatic SEO strategy.
- Auditing a stagnant blog to find why current pages aren't ranking or converting.
- Building a content cluster around a core product feature to gain topical authority.
- Scaling a tool via long-tail scenario pages that solve specific "stuck" moments.
Known limitations
Does not provide automated rank tracking or backlink building. Qualitative demand assessments are marked as UNVERIFIED if no third-party tool data is provided.
Requires product details and shipping capacity. Qualitative assessments marked UNVERIFIED without tool data. No rank tracking or backlink services.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Free forever
No account required to browse
Trust & safety
Security scan
Security scan passed today
- Free with an Agensi account