Marketing AnalystSEO and Content AnalyticsIntermediateSingle prompt

Keyword Opportunity Analysis AI Prompt

Identify and prioritize keyword opportunities for organic growth. Current keyword rankings: {{current_rankings}} Keyword research data: {{keyword_research}} (from Semrush, Ahref... Copy this prompt template, run it in your AI tool, and use related prompts to continue the workflow.

Prompt text
Identify and prioritize keyword opportunities for organic growth.

Current keyword rankings: {{current_rankings}}
Keyword research data: {{keyword_research}} (from Semrush, Ahrefs, or similar)
Competitor domains: {{competitors}}
Business focus: {{business_focus}}

1. Keyword opportunity matrix:
   Segment all target keywords by:
   - Current position: ranking (1-3), ranking (4-10), ranking (11-20), not ranking
   - Search volume: high (> 1000/month), medium (100-1000), low (< 100)
   - Keyword difficulty: easy (< 30), medium (30-60), hard (> 60)
   - Business relevance: core (direct product/service match), adjacent (related problem), awareness (broad topic)

2. Quick win keywords:
   - Currently ranking 4-10 for high-volume, high-relevance keywords
   - Small position improvements (e.g. from 7 to 3) can double traffic
   - For each: current page, specific optimization needed, expected traffic gain from top-3

3. Competitor gap analysis:
   - Keywords where competitors rank in top 10 but we have no content
   - Filter by: high volume + medium difficulty + high business relevance
   - These are the highest-priority new content creation opportunities

4. Long-tail keyword clusters:
   - Group related keywords by topic cluster (not just individual keywords)
   - A single piece of comprehensive content can rank for multiple related long-tail terms
   - Identify the 5 most valuable topic clusters we are not yet covering

5. Search intent classification:
   For the top 50 opportunity keywords, classify intent:
   - Informational: user wants to learn (blog, guide content)
   - Commercial investigation: user is comparing options (comparison, review content)
   - Transactional: user is ready to buy (product page, landing page)
   - Match content type to search intent: mismatched content will not rank

6. Prioritized keyword roadmap:
   Quarter 1: quick wins (optimize existing content for 4-10 position keywords)
   Quarter 2: new content for the top 5 competitor gap opportunities
   Quarter 3: build topic authority clusters for the highest-value themes

Return: keyword opportunity matrix, quick win list, competitor gap analysis, topic clusters, and quarterly roadmap.

When to use this prompt

Use case 01

Use it when you want to begin seo and content analytics work without writing the first draft from scratch.

Use case 02

Use it when you want a more consistent structure for AI output across projects or datasets.

Use case 03

Use it when you want prompt-driven work to turn into a reusable notebook or repeatable workflow later.

Use case 04

Use it when you want a clear next step into adjacent prompts in SEO and Content Analytics or the wider Marketing Analyst library.

What the AI should return

The AI should return a structured result that covers the main requested outputs, such as Keyword opportunity matrix:, Current position: ranking (1-3), ranking (4-10), ranking (11-20), not ranking, Search volume: high (> 1000/month), medium (100-1000), low (< 100). The final answer should stay clear, actionable, and easy to review inside a seo and content analytics workflow for marketing analyst work.

How to use this prompt

1

Open your data context

Load your dataset, notebook, or working environment so the AI can operate on the actual project context.

2

Copy the prompt text

Use the copy button above and paste the prompt into the AI assistant or prompt input area.

3

Review the output critically

Check whether the result matches your data, assumptions, and desired format before moving on.

4

Chain into the next prompt

Once you have the first result, continue deeper with related prompts in SEO and Content Analytics.

Frequently asked questions

What does the Keyword Opportunity Analysis prompt do?+

It gives you a structured seo and content analytics starting point for marketing analyst work and helps you move faster without starting from a blank page.

Who is this prompt for?+

It is designed for marketing analyst workflows and marked as intermediate, so it works well as a guided starting point for that level of experience.

What type of prompt is this?+

Keyword Opportunity Analysis is a single prompt. You can copy it as-is, adapt it, or use it as one step inside a larger workflow.

Can I use this outside MLJAR Studio?+

Yes. The prompt text works in other AI tools too, but MLJAR Studio is the best fit when you want local execution, visible Python code, and reusable notebooks.

What should I open next?+

Natural next steps from here are Content Calendar Data Strategy, Content Performance Analysis, SEO Performance Audit.