craig
6eff12e8ac
SmartCrawl plugin reference (11 docs): - Overview, configuration, titles & meta, schema, sitemaps, social/OG, redirects, breadcrumbs, content analysis, hooks/filters, known issues SEO strategy playbook (6 docs): - Keyword research, per-page-type selection, on-page optimization, local SEO, technical SEO, content strategy Reusable templates (3): - Site audit checklist, keyword research worksheet, page optimization checklist Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
185 lines
3.9 KiB
Markdown
185 lines
3.9 KiB
Markdown
# 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:_
|