Keyword Research Worksheet
Use this template to research and organize keywords for a specific site. Copy this file per site.
Site Information
- Site:
- URL:
- Business type:
- Primary location(s):
- Target audience:
- Date:
1. Seed Keywords
List everything the target audience might search for:
Services / Products
| Service/Product |
Seed Keywords |
|
|
|
|
|
|
Problems / Questions
| Problem/Question |
Seed Keywords |
|
|
|
|
Location Variations
| Location |
Format |
| City |
[service] [city] |
| State |
[service] [state] |
| Neighborhood |
[service] [neighborhood] |
| Region |
[service] [region] |
2. Keyword Matrix (Local)
Fill in with Target / Assess / Skip for each intersection:
| Service ↓ \ Location → |
[City 1] |
[City 2] |
[City 3] |
[State] |
| [Service 1] |
|
|
|
|
| [Service 2] |
|
|
|
|
| [Service 3] |
|
|
|
|
3. Expanded Keywords
After running seed keywords through tools (Google Autocomplete, PAA, Keyword Planner, Ubersuggest):
Informational Keywords (Blog Content)
| Keyword |
Est. Volume |
Difficulty |
Intent |
Notes |
|
|
|
Informational |
|
|
|
|
Informational |
|
|
|
|
Informational |
|
|
|
|
Informational |
|
|
|
|
Informational |
|
Commercial Keywords (Service/Comparison Pages)
| Keyword |
Est. Volume |
Difficulty |
Intent |
Notes |
|
|
|
Commercial |
|
|
|
|
Commercial |
|
|
|
|
Commercial |
|
Transactional Keywords (Registration/Contact/Buy)
| Keyword |
Est. Volume |
Difficulty |
Intent |
Notes |
|
|
|
Transactional |
|
|
|
|
Transactional |
|
|
|
|
Transactional |
|
4. People Also Ask (PAA) Questions
From Google PAA results for your primary keywords:
| Question |
Target Page |
Priority |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
5. Competitor Keywords
From reviewing competitor sites and sitemaps:
| Competitor |
URL |
Keywords They Target |
Gap (We Don't Cover) |
|
|
|
|
|
|
|
|
|
|
|
|
6. Search Console Data (Existing Sites Only)
High-Impression Keywords (What Google Shows Us For)
| Query |
Impressions |
Clicks |
CTR |
Position |
Page |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Striking Distance (Position 8-20)
| Query |
Position |
Page |
Action |
|
|
|
|
|
|
|
|
|
|
|
|
High Impressions / Low CTR (Title/Description Fix)
| Query |
Impressions |
CTR |
Page |
Fix Needed |
|
|
|
|
|
|
|
|
|
|
7. Keyword-to-Page Mapping
Assign one primary keyword per page:
| Page |
Primary Keyword |
Secondary Keywords (2-3) |
Intent |
Status |
| Homepage |
|
|
Nav/Commercial |
|
| About |
|
|
Navigational |
|
| Contact |
|
|
Nav/Transactional |
|
| [Service 1] |
|
|
Commercial |
|
| [Service 2] |
|
|
Commercial |
|
| [Blog Post 1] |
|
|
Informational |
|
| [Blog Post 2] |
|
|
Informational |
|
Status: Not Started / In Progress / Optimized / Monitoring
8. Content Gap — New Pages Needed
Keywords that don't have a natural home on existing pages:
| Keyword |
Intent |
Proposed Page |
Priority |
|
|
|
|
|
|
|
|
|
|
|
|
9. Seasonal Opportunities
| Season/Event |
Keywords |
Content Needed |
Publish By |
|
|
|
|
|
|
|
|
Notes
Research observations, tool screenshots, or additional context:
craig
6eff12e8ac