Keyword Intent Classifier for Affiliate Articles (Queries → Intent → CTA Map)
Transform mixed keyword lists into clear intent buckets with matching article types and affiliate CTAs.
Prompt Overview
Featured AI Partner
Tips For You
- Use Semrush or Ahrefs to fill Volume and KD; paste minimal columns only. - Merge near-duplicates to keep your editorial calendar lean. - Use strong CTAs only on comparison/review pages to protect UX.
From Operations TeamNexusAi TechnologyProblem It Solves
Prevents producing informational content that can’t convert by mapping each query to suitable formats and CTAs.
Intent Bucketing
Maps every query to buyer stage for conversion-aligned content.
Article Type Recommender
Suggests best format for ranking and monetizing.
CTA Mapping
Ensures each page pushes toward revenue.
Clustered Roadmap
Outputs pillars and supporting posts for a tight structure.
AI Prompt Instructions
Act as: SEO and Affiliate Content Strategist.
Why this task matters: Intent–format alignment raises CTR, time on page, and affiliate EPC by matching user stage with the right article and CTA.
Important boundaries:
- Classify only from the provided keywords and metrics; do not guess volumes.
- If KD/competition missing, mark Unknown and advise how to obtain it.
User inputs:
- A CSV or list of keywords with optional Volume and KD (Semrush/Ahrefs export).
- Optional notes on available products or affiliate programs.
Objectives:
1) Classify each keyword into intent buckets: Informational, Commercial Investigation, Comparison, Transactional.
2) Recommend the best article type (how-to, listicle, vs, roundup, review) and primary CTA.
3) Suggest internal links and next best queries for each cluster.
Analysis workflow:
1) Parse and clean keywords; group by semantic similarity.
2) Assign intent using modifiers (best, vs, review, price, near me, how to).
3) For each cluster, define one pillar and 3–5 supporting posts.
Required output format:
- Table: Keyword | Intent | Article Type | Primary CTA | Suggested Internal Links | Notes.
- Cluster summary with pillar URL suggestions.
Quality controls:
- Ensure every Comparison or Review query has a clear product CTA.
- Avoid duplicate article types for near-identical keywords; consolidate instead.
Verification checklist:
- Are high-volume commercial terms prioritized?
- Are CTAs realistic for available offers?
Final instruction: Output the table, then list the top 5 money pages to draft first with reasons.
Expected Outcome
Keyword Intent Table (excerpt): - "best portable power station for camping" | Commercial Investigation | Roundup | CTA: Compare top 5 with price table | Links: camping use-case pillar - "jackery 1000 vs ecoflow delta" | Comparison | VS article | CTA: model chooser - "how to size a power station" | Informational | Guide | CTA: lead-in to roundup
Implementation Journey
Classify with Gemini
Open Gemini and paste the prompt with your keyword list (and Volume/KD if available). Gemini will cluster queries, assign intent, and propose article types with CTAs.
15–20 minAdd metrics in Semrush
In Semrush, export Volume and KD for the same keywords. Paste back into Gemini to reprioritize based on difficulty and potential.
15–25 minSelect top money pages
Use Gemini’s prioritized list to choose 5 money pages. Create internal link targets and CTA notes in your planning doc to speed briefing.
20–30 min