Free Growth Assessment
Free Template

Keyword Research Template for MSPs and IT Companies

A keyword research template is a spreadsheet that lists each search phrase with its intent, volume, difficulty, buyer stage and the one page that targets it. This one is built for MSPs and IT companies.

Last updated: November 20, 2026
Collect the Phrases
Your own data first, tools second.
Tag Each One
Intent and buyer stage, row by row.
Map to a Page
One phrase, one owner.
Review Monthly
Positions, status and new phrases.
What It Is

What a Keyword Research Template Is

A keyword research template is a spreadsheet with one row per search phrase. Each row records what the searcher wants, how often they search, how hard the phrase is to win, where the buyer sits in the buying process and which single page on your site targets it. It turns a long list into a plan.

Without one, a keyword list is just an export. Picture a 30-person MSP that pulls 400 phrases from a tool in January. By April a service page, two blog posts and a pricing guide are all chasing the same phrase, and nobody can say which one was meant to rank. Sound familiar?

Start With Seven Columns

The grid below has seven columns, and that’s the floor, not the ceiling. This page is the spreadsheet. The method for filling it in lives in our keyword research guide for MSPs, and the wider service sits under our keyword research services for MSPs and IT companies.

A hand holding a fountain pen above a blank ruled ledger with seven columns on a dark desk beside a brass lamp
Where It Goes Wrong

Why Keyword Lists Stop Working

A keyword list rarely fails on day one. It fails around week six, and it fails in the same three ways.

No Page Owns the Phrase

If two pages chase one phrase, they compete with each other, and if no page chases it, nobody can win it, so a column for the one target page forces a choice you’d otherwise leave to luck. Skip the column and you’re guessing. Guessing gets expensive.

Volume Without a Buyer

A phrase with big volume and no buying intent fills a report and not a pipeline, which is why ‘What is an MSP’ draws readers while ‘Managed IT for dental offices’ draws buyers. Tag the intent first. Otherwise the sheet sorts by the wrong thing. Our guide to bottom-of-funnel SEO shows which phrases sit nearest a sale.

Nobody Updates It

A sheet built once in January describes January, because positions move, pages ship and new questions turn up on sales calls long after anyone last opened the file. Give it a review date and a named owner. Otherwise it quietly dies. Not ideal.

Common Breakdowns
Every one is easy to prevent early.
Two pages chasing one phrase
No page for a phrase buyers use
Volume pulled from three different tools
Intent never tagged
Status that nobody updates
A list with no service tied to it
The Template

The Keyword Research Template

Fill in the setup sheet first, then the grid. The setup sheet takes about twenty minutes and you only do it once. No form, no email, nothing to download. It’s all right here.

Setup Sheet
Fill this in once. Every row follows it.
Part 1 Scope It
1
Services in scope
List the services you want inbound leads for, such as managed IT, cybersecurity or backup. A phrase that doesn’t tie to one of them doesn’t earn a row.
2
Who’s searching
Name the buyer behind the search, whether that’s the owner, the office manager or the IT lead. They use different words for the same problem.
3
Places you serve
Only if buyers search by place. List the cities or regions you really serve and leave out the rest.
Part 2 Choose Your Sources
4
Where phrases come from
Search Console queries, a keyword tool, sales call notes and support tickets. Pick at least three and write them down.
5
Your volume and difficulty tool
Pick one tool and one month. Numbers from different tools don’t compare, so keep them out of the same column.
Part 3 Set the Labels
6
Intent labels
Informational, commercial and transactional. Add navigational only for searches on your own brand name.
7
Buyer stages
Awareness, consideration and decision. Write one sentence for each, so two people tag the same phrase the same way.
8
Status labels
Not started, drafted, live, refresh and parked. Say who changes them and when.
Part 4 Keep It Alive
9
Review date and owner
Pick a monthly date and a named person. A sheet with no owner is a snapshot, not a tool.

The Keyword Grid

One row per phrase. Select the grid and paste it into a blank sheet in Google Sheets or Excel, then add rows as you go. Seven columns is the floor, so add a column for the service line or the current Search Console position if it helps. Blank beats a guess.

Keyword Intent Buyer stage Monthly searches Difficulty Target page Status

Write the tool and the month beside Monthly searches and Difficulty the first time you fill them in. A volume number with no source is a rumor.

Two colleagues sorting blank index cards into three groups on a dark conference table at dusk
Worked Example

A Filled-In Example, Row by Row

Here’s a made-up example. A 40-person MSP that serves law firms and dental offices fills in the grid after a Search Console export and two sales call debriefs.

It’s an illustration. Not a C4 client, and not data. Volume and difficulty are left out on purpose, since those come from your own tool and month. Look at the calls, not the numbers.

Keyword Intent Buyer stage Target page The call
managed IT services for law firms Commercial Consideration Service page for law firms One page owns it, so the home page stops competing
how much does managed IT cost per user Informational Consideration Pricing guide post Buyers ask this before they call
MSP vs in-house IT Commercial Consideration Comparison post The answer needs a page of its own
IT support Informational Awareness None, parked Too broad to own right now
what is a managed service provider Informational Awareness Existing post, refresh A page exists, so update it
dental office IT security checklist Informational Awareness Checklist page Earns attention and points at the service page
switch managed IT provider Transactional Decision Switching page with a booking button Warm buyers who need one next step
Acme IT login Navigational Decision Home page Check the title, write nothing new
Why It Works This Way

Four Rules the Template Follows

Each rule below comes from a Google page you can read in a few minutes. We link every one. A rule you can’t check is just an opinion.

Rule 01

Use the Words Buyers Use

Google’s SEO Starter Guide says people who know a topic well often search with different words than newcomers do. The sheet keeps the buyer and the source beside every phrase for that reason.

Rule 02

Start With Your Own Data

The Search Console performance report shows the queries that already bring people to your site, with clicks, impressions, click-through rate and average position. Those are your first rows, and they’re free.

Rule 03

Treat Volume as an Estimate

Google’s Keyword Planner help describes monthly searches as estimates and says very low-volume keywords may not show up at all, which is why a small number isn’t a reason to drop a phrase a buyer would use.

Rule 04

Don’t Stuff the Page

Google’s spam policies define keyword stuffing as filling a page with keywords to manipulate rankings, and the examples include blocks of text listing the cities a page is trying to rank for. One target page, written for a reader.

How It Works

How to Use the Keyword Research Template

Set up. Collect. Tag. Map.

1
Step 1

Fill In the Setup Sheet

Spend twenty minutes on boxes 1 to 9 before you add a single row. The labels you choose now are what keep row 5 and row 500 consistent.

2
Step 2

Collect Phrases From Four Places

Start with Search Console queries, then add a keyword tool, your sales call notes and the questions buyers type into AI assistants. Our prompt research guide shows how to find those last ones, and our AI search prompt library lists thirty to start from.

3
Step 3

Tag Every Row, Then Map It

Fill in the intent and the buyer stage, then name one target page. If a page already exists, mark the row refresh. If none fits, a new page goes on the list, and our MSP service page template is the next sheet to open.

4
Step 4

Review It Every Month

Update positions and statuses on your review date, then add new phrases from sales calls and send the changes to whoever writes the pages, and our SEO report template shows where the numbers can go. Short and regular beats big and rare.

Before You Hand It Off

Check the Sheet Before a Writer Sees It

Run the finished sheet through these nine checks. One miss takes a minute to fix. Three misses mean the sheet isn’t ready to brief anyone, and our content brief template is the next step once it passes.

  • Every phrase ties to a service you sell
  • Intent and buyer stage filled in on every row
  • Volume and difficulty from one tool and one month
  • Exactly one target page per phrase
  • No two pages sharing a phrase
  • Existing pages marked refresh, not rewritten from scratch
  • Broad phrases parked, with a reason
  • A named owner and a monthly review date
  • Place names limited to cities you really serve

Blanks happen. A blank cell tells you what to find out next, and finding it out now is cheaper than rewriting a page later.

A woman and a man studying columns of blank sticky notes on a dark office wall with a city view at dusk
Ways to Work

Run It Yourself, or Run It With C4

The sheet works fine on its own. Plenty of teams stop here. If you’d like help turning the map into pages, our SEO consulting services page shows how we work, and our SEO, AEO and GEO for MSPs page shows where keyword research sits in the wider plan. Planning a site that hasn’t launched? Our SEO for a new website checklist shows where this sheet fits before launch.

Already Have a Keyword List?

Paste it into the grid and fill in the columns it’s missing. Plenty of lists carry only a keyword and a volume, so the gaps are usually intent, buyer stage and target page. Those three are the ones that make it a plan.

Who This Template Suits

Right Fit
  • A marketing lead, owner or account manager at a US MSP, IT services firm, VAR or telecom provider with up to $50M in revenue
  • A team with a keyword export and no plan for it
  • Someone who wants to know which page should win which phrase
  • A leader who’ll name an owner and a review date
Not the Right Fit
  • You want a tool that pulls search volumes for you, which a sheet can’t do
  • You want a finished keyword list handed over, since this is a template and not a list
  • You need a content calendar, which comes after the map
  • You want a file behind a form, since the sheet lives on this page
Common Questions

Questions MSP Owners Ask About Keyword Research

What is a keyword research template?

It’s a spreadsheet that lists each search phrase with its intent, search volume, difficulty, buyer stage and the one page that targets it. The point is to turn a long export into a plan someone can act on.

What columns should a keyword research template have?

Seven at minimum. Keyword, intent, buyer stage, monthly searches, difficulty, target page and status. Many teams add the service line and the current Search Console position once those seven are working.

How many keywords should an MSP start with?

Fewer than you’d think. Enough to cover each service you sell at each buyer stage, which is usually a few dozen phrases rather than thousands. A short sheet that someone updates beats a long one nobody opens.

Is search volume the column that matters?

Not on its own. For a services business, intent and buyer stage usually tell you more, and Google’s Keyword Planner help calls the monthly figures estimates, so use volume to rank similar phrases, not to decide what a buyer needs.

Do I need different keyword research for AI search?

Not a separate sheet. Google says there are no additional requirements to appear in AI Overviews or AI Mode, and SEO fundamentals still apply. Add the questions buyers type into AI assistants as rows, and our prompt research guide shows how to find them.

How often should I update the sheet?

Monthly is a good rhythm for a small team. Update positions from Search Console, change statuses and add phrases from sales calls. A quarterly pass can work for a quiet site, but name the owner either way.

Can I download the keyword research template?

No download and no form. The sheet is on this page, so select the grid and paste it into Google Sheets or Excel. In a modern browser each column should land in its own cell.

Turn the Keyword List Into a Plan

Bring the sheet, filled in or not. We’ll look at which phrases deserve a page first and where your SEO and AI search plan has gaps, and you’ll leave with a short list.