Marketing

Keyword Research Template

Identify high intent, low competition keywords to attract your target customer.

Growth Business Template - Play Button
Keyword Research Template

Why use this template?

Keyword research is arguably the most important task to complete when executing an SEO strategy. Only second to clearly defining your focus areas and content structure.

I used to think you had to get lucky to generate tens or even hundreds of thousands of visitors to your website every month.

Until I realized, it's not about luck.

We grew our monthly traffic to over 250,000 organic visitors. That's a lot of traffic for a B2B SaaS website.

I will walk you through how to do keyword research using a simple, but very powerful excel spreadsheet or google sheet. You can replicate or even surpass our results.

This Keyword Research excel template includes the following tabs:

  • Instructions: instructions on how to use this template most effectively.
  • Content Map TEMPLATE: a framework for outlining your content focus, both in breadth and depth.
Content Map Template included.
  • Keyword Research TEMPLATE: a blank template to analyze your target keywords.
  • Content Map Example: an example of what your content map may look like after completing the exercise for your SaaS company.  
  • Keyword Research Example: an example of keywords analyzed for a SaaS company.
  • BONUS: a go-to-market checklist to inspire you to check all the boxes with best practices across the board.

What's inside the template

At one point, I majorly screwed up our SEO strategy.  

We started targeting high volume keyword terms that had low competition, but no relevance to our target audience.

This made our traffic numbers go up, but they weren't the right people visiting our website. So it was just a vanity metric that made us feel good.

We convinced ourselves that we were doing well because our unique visitors were growing, but revenue remained flat.

This template is designed to walk you through a content mapping exercise first to ensure your keyword analysis aligns with your high level vision, then a detailed keyword analysis.

Here are the steps I recommend you take:

  1. Review all tabs in the spreadsheet first. It's always good to familiarize yourself with the content before you really dig in.
  2. Map out your content structure. Choose the breadth of content you plan to cover and then the depth within those focus areas.
  3. Use a keyword research tool like SEMrush or MOZ to identify keywords that align with your focus areas.
  4. Drop in keywords into the Keyword Research template.
  5. Prioritize your keywords.
  6. Start producing content to target the highest priority keywords.

Be sure to gather input and feedback across departments. Gaining buy-in early will help you avoid going too far down the wrong rabbit hole.

How to use this template

SEO is a long-term investment. I think every SaaS company needs to invest in it. How much you invest all depends on how big the opportunity is...

Immediately download this template and customize it for your team.

Click “Add to Cart” on the right. You will receive a link to the Google Sheet of the Keyword Research Template when you checkout.

If you run a go-to-market team at a B2B SaaS company, explore these other templates as well:

$ 15 USD

Click "Add to Cart" below. When you checkout, you will immediately receive an email with a link to download

  • Premium design
  • Customizable files
  • Growth Business Template - Mobile Icon
    Lifetime access from any device

Top reviews from SaaS Executives

Growth Business Template - Star

“These are GOLD! I was having to build all of this from scratch.”

Growth Business Template Testimonial - Nick
Nick C.
Director Sales
Growth Business Template - Star

“This is exactly what I was looking for. A repeatable playbook I could plug-n-play for our business.”

Growth Business Template Avatar - Michael
Michael P.
Chief Executive Officer
Growth Business Template - Star

“I feel more confident hitting our revenue goals now than I ever have.”

Growth Business Template Avatar - Jessica
Jessica P.
Sr. Director of Demand Generation
Growth Business Template - Star

“My job just became so much easier! I’m all about working smarter, not harder.”

Growth Business Template Avatar - Clark
Clark A.
VP of Sales
Growth Business Template - Star

“These are GOLD! I was having to build all of this from scratch.”

Growth Business Template Testimonial - Nick
Nick C.
Director Sales
Growth Business Template - Star

“This is exactly what I was looking for. A repeatable playbook I could plug-n-play for our business.”

Growth Business Template Avatar - Michael
Michael P.
Chief Executive Officer
Growth Business Template - Star

“I feel more confident hitting our revenue goals now than I ever have.”

Growth Business Template Avatar - Jessica
Jessica P.
Sr. Director of Demand Generation
Growth Business Template - Star

“My job just became so much easier! I’m all about working smarter, not harder.”

Growth Business Template Avatar - Clark
Clark A.
VP of Sales
Growth Business Template - Star

“These are GOLD! I was having to build all of this from scratch.”

Growth Business Template Testimonial - Nick
Nick C.
Director Sales
Growth Business Template - Star

“This is exactly what I was looking for. A repeatable playbook I could plug-n-play for our business.”

Growth Business Template Avatar - Michael
Michael P.
Chief Executive Officer
Growth Business Template - Star

“I feel more confident hitting our revenue goals now than I ever have.”

Growth Business Template Avatar - Jessica
Jessica P.
Sr. Director of Demand Generation
Growth Business Template - Star

“My job just became so much easier! I’m all about working smarter, not harder.”

Growth Business Template Avatar - Clark
Clark A.
VP of Sales