A keyword research template keeps all of your keyword data organized and in one place.
Without one you will get lost in keyword exports, Google or Excel spreadsheets, and you will miss valuable opportunities.
While speaking to SEOs and marketing professionals who do not use a keyword research document, I often hear the same pain points:
- How do I visualize my entire SEO opportunity?
- How can I organize all my data?
- How do I prioritize content?
- How do I map keywords to content?
- How do I avoid keyword cannibalization?
Keyword exports from tools like Ahrefs or SEMrush give you all the data you need to answer these questions, yet they lack features to help you organize, prioritize, and plan keyword targeting.
A keyword research and analysis template will help you research, organize, plan, prioritize, and run a cost benefit analysis on your keyword data.
How to use the keyword research template
Below is an overview of the different components of the SEO strategy template:
The foundation of every SEO strategy template starts with keyword research.
However, before diving head first into a keyword research tool it is important to brainstorm “seed keywords”.
Go through each of the categories listed below.
If the category applies to your business, jot down all of the keywords (or words used to describe it) that apply to it.
After you have filled out all of the information for the applicable categories, you can now use the keywords as seed keywords.
Be sure to use a “broad match” search to find all of the search queries that derive from your seed keyword list.
- Take inventory of your website’s content
- Identify gaps in keyword targeting where new content is needed
- Prioritize keyword targeting
After importing all keywords into the SEO strategy template, map the keywords (or more likely groups of keywords) to content on your website.
Mark all the existing URLs as “Exists”, and all content that needs to be created as “Planned”.
Our SEO strategy template will automatically sum the keyword search volume for content that is on your website, as well as content that is going to be created.
This gives you a black and white view of the total search demand of your content strategy, and your website.
Before you create content prioritize your website’s pages or blog posts:
- search intent x search volume – is the search intent “commercial” or “transactional”? What is the total opportunity?
You now have a clear view of the most important pages and articles, as well as have a starting point.
Now that you have a clear birds eye view of your SEO strategy, it is time to drill down into the individual pages and plan out important search engine ranking factors.
When planning the SEO details at a high level, focus on the 80/20 (small optimizations that will get the best results)
After using this exact method for almost 5 years, for hundreds of different businesses we have found that if you get the following 3 on-page SEO factors right, you will put yourself in the best possible position.
- Title Tag
- H1 Tag
Plan out the above for each of your URLs. Remember, you don’t have to do it all at once because of the prioritization.
The extra icing on the cake is to plan out specific content blocks for individual pages.
Although this is effective, it is not 100% necessary.
Use the long-tail keywords to influence the sections of content on your pages.
Get Our Keyword research template
What’s included in our keyword research template?
- Buyer persona research: Who are they and what do they search for?
- Sales & lead generation planning: Plan your highest ROI content, and user experience
- Content marketing strategy: Target your customers with SEO-friendly articles
- Link building strategy: How and where to acquire the best backlinks
- Set SEO goals to actual business goals in Google Analytics: Track your growth
|Get our keyword research template|
[Get it now]
Final thoughts on our keyword research template
The opportunities to increase your website’s visibility and organic traffic through keyword research & content marketing are almost endless.
Because of the vast opportunities it’s important to prioritize and run a cost-benefit analysis.
Not only is it crucial to plan your SEO campaign upfront, it is even more important budget the time and resources that are necessary to achieve your goals (and deliver a ROI).
Our keyword research template will give you a step by step SEO plan to execute the most efficient and effective SEO strategy for your business.