Keyword Research Template with Auditite

Overview

This keyword research template helps you systematically discover, evaluate, and prioritize keywords for your SEO strategy. Use it to organize keywords by topic clusters, assess their business value, and map them to content pieces for a data-driven content plan.

Keyword Research Worksheet

Step 1: Seed Keyword Discovery

Start by listing your core topics and seed keywords. For each seed keyword, use Auditite or your preferred keyword tool to expand the list.

Seed Keyword	Source	Monthly Search Volume	Related Topics
	Google Search Console
	Competitor analysis
	Customer questions
	Industry forums
	Autocomplete suggestions

Step 2: Keyword Evaluation Matrix

For each candidate keyword, fill in the evaluation metrics:

Keyword	Search Volume	Keyword Difficulty (0-100)	CPC ($)	Search Intent	Business Relevance (1-5)	Current Rank	Priority Score
				Informational
				Navigational
				Commercial
				Transactional

Step 3: Priority Score Calculation

Calculate the priority score for each keyword using this formula:

Priority Score = (Business Relevance x 3) + (Search Volume Score x 2) + (100 - Keyword Difficulty) / 10

Search Volume Score:

Monthly Search Volume	Score
10,000+	5
5,000 - 9,999	4
1,000 - 4,999	3
500 - 999	2
100 - 499	1

Step 4: Topic Cluster Mapping

Group your prioritized keywords into topic clusters:

Cluster Name	Pillar Keyword	Supporting Keywords	Pillar Content URL	Status
				Not started / In progress / Published

Step 5: Content Mapping

Map each keyword to a specific content piece:

Keyword	Target URL	Content Type	Target Word Count	Publication Date	Assigned To
		Blog post
		Landing page
		Product page
		Guide

Search Intent Classification Guide

Intent Type	Signals	Content Format
Informational	”how to,” “what is,” “guide”	Blog posts, guides, tutorials
Navigational	Brand names, specific products	Homepage, product pages
Commercial	”best,” “review,” “compare”	Comparison pages, reviews
Transactional	”buy,” “pricing,” “signup”	Product pages, landing pages

Keyword Research Best Practices

Focus on keywords where you can realistically compete. A keyword with 50,000 monthly searches and a difficulty of 95 is less valuable than one with 2,000 searches and a difficulty of 30 if you can rank for the latter within months rather than years.

Balance your keyword portfolio across different intents. Informational keywords build traffic and authority, commercial keywords drive consideration, and transactional keywords generate conversions. A healthy content strategy addresses all stages of the buyer journey.

Revisit and update your keyword research quarterly. Search volumes shift with market trends, new competitors enter the landscape, and your own authority changes over time. Keep your keyword strategy dynamic rather than treating it as a one-time exercise.