Intelligent OperationsPattern Posts

Search Intent Mapping: The SEO Framework That Actually Works

The 15-column Search Intent Analysis library applied to real keyword research.

The Prompt Engineering Project February 7, 2025 7 min read

Quick Answer

Search intent analysis classifies search queries by the underlying goal: informational (learning something), navigational (finding a specific page), commercial investigation (comparing options), or transactional (ready to buy or act). Mapping intent to content ensures you deliver what searchers actually want, which is the single biggest factor in ranking and engagement. Mismatched intent is why good content fails to rank.

Keyword research without intent classification is just a list of words with numbers next to them. You know the search volume. You know the difficulty score. But you do not know what the searcher actually wants -- and without that, you cannot create content that satisfies their query, ranks sustainably, or moves them through your funnel. The Search Intent Analysis library applies 15 columns of structured analysis to every keyword, transforming raw keyword data into an actionable content map that connects search behavior to business outcomes.

This article walks through all 15 columns, shows how they work on real keyword research data, explains the priority scoring formula that ranks opportunities by potential impact, and demonstrates how the Search Intent database feeds directly into the Content Strategy database for execution.

The 15 Columns

The Search Intent Analysis library organizes keyword intelligence into four groups: keyword data (what people search for), intent analysis (why they search for it), content mapping (what to create), and prioritization (what to create first).

search-intent-schema.txt
SEARCH INTENT ANALYSIS — 15 COLUMNS
=====================================

KEYWORD DATA (Columns 1-4):
  1. Keyword              — The search term or phrase
  2. Monthly Volume       — Average monthly search volume
  3. Difficulty Score     — Competition score (0-100)
  4. Current Ranking      — Your current position (if any)

INTENT ANALYSIS (Columns 5-7):
  5. Intent Type          — Informational, Navigational, Commercial,
                            Transactional
  6. Funnel Stage         — Awareness, Research, Desire, Action
  7. Content Match        — Existing content that targets this keyword

CONTENT MAPPING (Columns 8-13):
  8. Content Gap          — Does content exist? Yes/No/Partial
  9. SERP Features        — Featured snippets, PAA, maps, images,
                            video carousels, knowledge panels
 10. Competitor Content   — Top 3 ranking pages and their approach
 11. Recommended Type     — Blog post, guide, landing page, tool, etc.
 12. Title Suggestion     — Proposed content title
 13. Target Word Count    — Recommended length based on SERP analysis

PRIORITIZATION (Columns 14-15):
 14. Priority Score       — Calculated opportunity score
 15. Status               — Not Started, In Progress, Published, Optimizing

The columns progress from raw data to analysis to action. Columns 1 through 4 are facts you pull from SEO tools. Columns 5 through 7 require human or AI-assisted judgment to classify intent and map to your funnel. Columns 8 through 13 translate the analysis into specific content recommendations. And columns 14 through 15 rank everything by opportunity and track execution. No column is decorative. Every one either informs a decision or tracks a status.

The Six-Step Process

The 15-column database is populated through a six-step process that moves from raw keyword discovery to prioritized content recommendations.

1

Start with seed keywords. Pull 5-10 core terms from your product positioning, ICP pain points, and existing high-performing pages. These become the foundation for expansion.

2

Expand with AI-assisted research. Use keyword research tools and AI-assisted expansion to generate 200-500 related terms. Include long-tail variations, question-based queries, and competitor-targeted terms. Fill columns 1-4 for every keyword.

3

Classify intent. For each keyword, analyze the current SERP results to determine intent type (column 5). Informational queries show guides and blog posts. Commercial queries show comparison pages and reviews. Transactional queries show product pages and pricing. Map each intent type to a funnel stage (column 6).

4

Audit existing content. For each keyword, check whether you already have content targeting it (column 7). Identify gaps (column 8) where no content exists or existing content only partially addresses the query.

5

Analyze the SERP landscape. Document SERP features (column 9) and competitor content (column 10) for each keyword. This data determines the recommended content type (column 11), title suggestion (column 12), and target word count (column 13).

6

Calculate priority scores and begin execution. Apply the priority scoring formula to rank every keyword by opportunity. Assign status (column 15) and begin creating content for the highest-scoring opportunities.

Do not try to fill all 15 columns for 500 keywords in one pass. Start with columns 1-4 for the full list, then work through the remaining columns for the top 50-100 keywords by volume. The intent classification and SERP analysis steps require real judgment and should not be rushed.

A Complete Row in Practice

Here is a fully populated row for a single keyword, demonstrating how the 15 columns work together to produce a specific, actionable content recommendation.

complete-search-intent-row.txt
SEARCH INTENT ROW: "sales pipeline metrics"
=============================================

 1. Keyword:           sales pipeline metrics
 2. Monthly Volume:    3,400
 3. Difficulty Score:  58
 4. Current Ranking:   Not ranking

 5. Intent Type:       Informational
 6. Funnel Stage:      Awareness
 7. Content Match:     None (partial mention in /blog/forecasting)

 8. Content Gap:       Yes — no dedicated content exists
 9. SERP Features:     Featured snippet (definition), PAA (6 questions),
                       image pack (pipeline diagrams)
10. Competitor Content:
    - HubSpot: "Sales Pipeline Metrics" (4,200 words, pillar page)
    - Salesforce: "Key Sales Metrics" (2,800 words, glossary format)
    - Close.io: "Pipeline Metrics Guide" (3,500 words, practical guide)

11. Recommended Type:  Pillar guide with embedded calculator
12. Title Suggestion:  "Sales Pipeline Metrics: 12 KPIs You Must Track"
13. Target Word Count: 5,000 (competitors average 3,500; aim to be
                       the most comprehensive resource)

14. Priority Score:    78.4 (see scoring formula below)
15. Status:            Not Started

Every column informs the content recommendation. The intent type (informational) and funnel stage (awareness) tell us the content should educate, not sell. The SERP features tell us to optimize for the featured snippet and include a visual pipeline diagram. The competitor analysis tells us the minimum viable length and reveals an opportunity: none of the top three results include an interactive calculator. The recommended type and title incorporate all of this intelligence into a specific content specification that a writer or AI agent can execute against.

How Priority Scoring Works

Column 14 -- Priority Score -- is a calculated field, not a judgment call. The formula weighs three factors: the volume of the opportunity, the achievability based on competition, and the business value based on intent type.

priority-scoring-formula.txt
PRIORITY SCORE FORMULA
=======================

Score = Volume Factor * Achievability Factor * Intent Value

WHERE:

Volume Factor = log10(monthly_volume) * 20
  - Normalizes volume on a logarithmic scale
  - Prevents high-volume keywords from dominating
  - 100 volume = 40, 1000 = 60, 10000 = 80

Achievability Factor = (100 - difficulty_score) / 100
  - Higher difficulty = lower achievability
  - Difficulty 20 = 0.80, Difficulty 50 = 0.50, Difficulty 80 = 0.20

Intent Value = multiplier based on intent type
  - Transactional:  1.5  (highest business value)
  - Commercial:     1.3  (strong purchase signals)
  - Informational:  1.0  (baseline value)
  - Navigational:   0.5  (lowest value unless it is your brand)

EXAMPLE: "sales pipeline metrics"
  Volume Factor:       log10(3400) * 20 = 3.53 * 20 = 70.6
  Achievability:       (100 - 58) / 100 = 0.42
  Intent Value:        Informational = 1.0
  Raw Score:           70.6 * 0.42 * 1.0 = 29.7

EXAMPLE: "best crm for b2b saas"
  Volume Factor:       log10(1900) * 20 = 3.28 * 20 = 65.6
  Achievability:       (100 - 42) / 100 = 0.58
  Intent Value:        Commercial = 1.3
  Raw Score:           65.6 * 0.58 * 1.3 = 49.5

The commercial keyword scores higher despite lower volume
because it has better achievability and higher intent value.

The formula intentionally uses logarithmic scaling for volume. Without it, a keyword with 50,000 monthly searches would dominate every priority list regardless of difficulty or intent. The logarithmic scale compresses volume differences so that a 10x volume difference produces only a moderate score difference, allowing achievability and intent value to meaningfully influence the ranking.

The intent value multiplier is the most strategically significant factor. A transactional keyword with modest volume and moderate difficulty will often outscore an informational keyword with high volume and low difficulty. This is correct: the transactional keyword represents someone ready to buy, while the informational keyword represents someone just beginning to learn. Both have value, but the business impact per visitor is fundamentally different.

Priority scoring replaces editorial intuition with a repeatable formula. The highest-scoring keywords are not always the most obvious ones -- they are the ones where volume, achievability, and business value intersect most favorably.

How This Feeds the Content Strategy Database

The Search Intent Analysis database is an input to the Content Strategy database, not a replacement for it. When you identify a high-priority keyword with a content gap, that keyword becomes a new row in the Content Strategy database. The data flows across databases with clear column mappings:

database-mapping.txt
SEARCH INTENT → CONTENT STRATEGY COLUMN MAPPING
=================================================

Search Intent Column         → Content Strategy Column
─────────────────────────────────────────────────────
1.  Keyword                  → 3.  Target Keyword
2.  Monthly Volume           → 4.  Search Volume
3.  Difficulty Score         → 5.  Keyword Difficulty
5.  Intent Type              → 6.  Search Intent
6.  Funnel Stage             → 7.  Funnel Stage
11. Recommended Type         → 2.  Content Type
12. Title Suggestion         → 1.  Content Title
13. Target Word Count        → (informs Content Brief)

The remaining Content Strategy columns (8-18) are filled
during the strategy, creation, and distribution phases.
The Search Intent database provides the research foundation.
The Content Strategy database provides the execution plan.

This mapping is why the databases use compatible column structures. The Search Intent database answers "what should we create and why." The Content Strategy database answers "how do we create it, where do we publish it, and how do we measure it." Neither database is complete on its own. Together, they form a research-to-execution pipeline that connects search behavior data to content production to distribution to measurement.

The database mapping also works in reverse. When a published piece of content in the Content Strategy database starts ranking, its position feeds back into column 4 (Current Ranking) of the Search Intent database. This feedback loop keeps the Search Intent data current and surfaces optimization opportunities for content that is ranking but not in the top positions.

Key Takeaways

1

The 15-column Search Intent Analysis library transforms raw keyword data into actionable content recommendations by adding intent classification, SERP analysis, content gap identification, and priority scoring.

2

The six-step process moves from seed keywords to prioritized content specs: expand keywords, classify intent, audit existing content, analyze the SERP landscape, calculate priority scores, and begin execution.

3

Priority scoring uses a formula -- Volume Factor times Achievability Factor times Intent Value -- that prevents high-volume keywords from dominating and elevates commercial and transactional keywords with genuine business impact.

4

The Search Intent database feeds directly into the Content Strategy database through explicit column mappings. Search Intent provides the research foundation; Content Strategy provides the execution plan.

5

The feedback loop between databases keeps intelligence current: published content performance feeds back into Search Intent rankings, surfacing optimization opportunities for content already in the index.

Frequently Asked Questions

Common questions about this topic

Campaign Architecture: Four Stages of Customer Conversion

Related Articles

Intelligent Operations

Content Strategy at Scale: The 18-Column Approach

How the Content Strategy prompt library structures planning, SEO targeting, and distribution into one unified 18-column ...

Intelligent Operations

Campaign Architecture: Four Stages of Customer Conversion

The four campaign stage libraries form a complete conversion funnel. Architecture, content types, and measurement for ea...

Intelligent Operations

Brand Voice Codification: Teaching AI How You Sound

Using the Brand Voice and Messaging library to create a brand voice specification that AI agents can actually follow con...

All Articles