Keyword Research Checklist

An SEO lead's recurring workflow for keyword research — from seed brainstorm and competitor gap analysis through SERP intent mapping, content assignment, and rank tracking in GSC and Ahrefs/Semrush.

5 sections 19 steps Collects data
1

Scope and Seed Discovery

  1. Confirm ICP and target persona
    • Pull the active ICP and persona docs from the brand library. Note the persona's job title, the problems they search for, and the vocabulary they use — keyword work that ignores persona language ends up ranking for terms the buyer never types.

  2. Brainstorm seed keywords with the PMM
    • 30-minute working session with Product Marketing. Capture product category terms, jobs-to-be-done phrases, and competitor brand terms. Aim for 20-40 seeds across the buyer journey (TOFU/MOFU/BOFU) before expanding with tools.

    Collects file
  3. Pull competitor keyword gaps in Ahrefs or Semrush
    • Run the Content Gap report (Ahrefs) or Keyword Gap (Semrush) against 3-5 named competitors. Filter to keywords where competitors rank top 20 and you don't rank at all. Export to the working sheet.

  4. Mine GSC for existing query opportunities
    • In Google Search Console, filter Performance to queries ranking positions 8-20 with impressions above your monthly threshold. These are striking-distance terms — usually the highest-ROI place to start before targeting net-new keywords.

2

Keyword Analysis and SERP Review

  1. Pull volume, KD, and CPC for each candidate
    • Use Ahrefs Keywords Explorer or Semrush Keyword Magic to enrich the master list with monthly volume, Keyword Difficulty (KD), CPC, and parent topic. Cross-check volume against Google Keyword Planner for paid-side sanity.

  2. Classify search intent for each keyword
    • Tag each keyword as Informational, Navigational, Commercial, or Transactional. Manually open the SERP for any ambiguous term — Google's ranking pages are the ground truth on intent, not the keyword text. A term that returns only listicles is informational regardless of how transactional it sounds.

  3. Cluster keywords into topic groups
    • Group keywords that share a parent topic and SERP overlap into a single cluster — these become pillar pages and supporting articles. Use Ahrefs Parent Topic, Keyword Insights, or manual SERP-overlap clustering. One cluster, one URL; never split intent across two competing pages.

  4. Audit SERP features for each cluster
    • Note featured snippets, People Also Ask, video carousels, AI Overviews, and shopping packs on each target SERP. Heavy AI Overview presence or zero-click formats lowers expected CTR — adjust ROI scoring accordingly.

  5. Score and prioritize the final keyword list
    • Apply a priority score combining business relevance, intent match, KD vs. domain authority, and traffic potential. Flag the top 15-25 clusters as Priority 1 — these drive the next quarter's content calendar. Keep Priority 2 in the backlog.

    Collects number Collects file Collects list
3

Revision Cycle

  1. Address reviewer feedback on the priority list
    • Reviewer feedback typically lands on intent classification or competitive realism for high-KD terms. Update the sheet, re-run scoring, and circulate for sign-off before moving to content mapping.

4

Content Mapping and Calendar

  1. Map priority keywords to existing URLs
    • For each priority cluster, find the best existing URL (if any) using a site: search plus GSC query data. Mark each cluster as Optimize Existing, Consolidate (when two URLs cannibalize), or Create New.

  2. Identify cannibalization conflicts
    • Two URLs ranking for the same query is the most common cannibalization pattern; both pages underperform. Decide which URL to keep, redirect (301) the loser, and update internal links pointing to the redirected page.

    Collects list
  3. Plan 301 redirects for cannibalized URLs
    • Document the redirect map in the working sheet: source URL, destination URL, and internal links to update. Coordinate with the dev team for the implementation window. Validate redirects in Screaming Frog post-launch — chains and 302s are common mistakes here.

  4. Write SEO briefs for new-content clusters
    • Each brief includes target keyword, secondary keywords, search intent, target word count based on top-10 average, suggested H2s pulled from People Also Ask, internal-link targets, and the persona angle. Use Clearscope or Surfer for content-grade targets where available.

  5. Add clusters to the editorial calendar
    • Slot each cluster into the editorial calendar (Notion, Asana, or Airtable) with assigned writer, editor, target publish date, and pillar/supporting role. Pillar pages get the longest lead time; supporting articles cluster around the pillar's publish date.

5

Tracking and Reporting Setup

  1. Add priority keywords to rank tracker
    • Load the priority keyword list into Ahrefs Rank Tracker, Semrush Position Tracking, or your tracker of choice. Tag by cluster and by content status (existing/optimize/new) so reporting can roll up by initiative.

  2. Configure GA4 landing-page reports
    • Build a GA4 exploration filtered to organic sessions on the target URLs, with conversion events for the relevant CTAs. Verify the conversion events fire correctly — mis-mapped conversion events (firing on email-blur instead of submit) is the most common reporting distortion.

  3. Schedule the 30-day performance review
    • Calendar a 30-day check on indexing status (GSC Coverage), early ranking movement, and CTR on optimized URLs. Most net-new content needs 60-90 days for stable ranking, but indexing and impression trends should already be visible at 30.

  4. Share findings in the monthly SEO report
    • Roll cluster performance into the monthly stakeholder report: ranking deltas, organic sessions, conversions, and recommended adjustments. Tie back to the Priority 1 clusters so leadership sees the throughline from research to revenue impact.

    Collects file

Use this template

Copy it to your account, customize the steps, and run it with your team in minutes.


Sections 5
Steps 19
Category Marketing
Price Free to start
Need a different process

Browse hundreds of free templates across every team and industry.

Back to template library

Run Keyword Research Checklist with your team

Customize the steps, assign roles, set a schedule, and keep a complete record for every run.