SEO KEYWORD RESEARCH TEMPLATE

Matthew Carter
Hello friends, my name is Matthew Carter. I’m a professional link builder for a large SEO agency in New York City.

TRY OUR PACKAGES

Small Package
$49
Human Articles with Readable Spin
TIER 1
15 High DA web 2.0 Properties
10 High DA Trusted Profiles
20 High DA Bookmarks
5 EDU Profiles
50 Powerful Web 2.0 Profiles
10 Blog Platform Articles
10 High DA Documents Links
10 Manual Image Submission Links
10 Niche Related Blog Comments
1 Weebly Post
1 Tumblr Post
1 Wordpress Post
1 Blogspot Post
1 Medium Post
50 Facebook Reshares
50 Twitter Retweets
100 Pinterest Repins
TIER 2
Blog Comments LinkJuice
Bookmarks LinkJuice
Instant Link Indexer Services
Drip Feed Pinging
Order Now
Medium Package
$99
80 Unique Human Articles no spin
TIER 1
30 High DA web 2.0 Properties
25 High DA Trusted Profiles
30 High DA Bookmarks
7 EDU Profiles
70 Web 2.0 Media Profiles
25 Blog Platform Articles
15 High DA Documents Links
12 Image Sharing Backlinks
20 Niche Related Blog Comments
10 High DA Forum Profiles
10 Press Releases
Video Creation
10 Video Submissions
Power Point Creation
10 Power Point Submissions
1 EDU Blog Post
1 Weebly Post
5 High PA Tumblr Posts
1 Wordpress Post
1 Blogspot Post
1 Medium Post
1 Mix.com Share
1 Flickr Share
1 Myspace Share
100 Facebook Reshares
100 Twitter Retweets
250 Pinterest Repins
TIER 2
Blog Comments LinkJuice
Bookmarks LinkJuice
Article Submission
Guestbook Comments
Social Network Profiles
Static Links
Referrer Links
Instant Link Indexer Services
Drip Feed Pinging
Order Now
Big Package
$159
140 Unique Human Articles no spin
TIER 1
50 High DA web 2.0 Properties
40 High DA Trusted Profiles
40 High DA Bookmarks
10 EDU Profiles
100 Web 2.0 Media Profiles
50 Blog Platform Articles
20 High DA Documents Links
15 Image Sharing Backlinks
30 Niche Related Blog Comments
20 High DA Forum Profiles
20 Press Releases
Video Creation
20 Video Submissions
Power Point Creation
20 Power Point Submissions
1 EDU Blog Post
1 Weebly Post
10 High PA Tumblr Posts
1 Wordpress Post
1 Blogspot Post
1 Medium Post
1 Mix.com Share
1 Flickr Share
1 Myspace Share
1 Penzu Post
1 Ex.co Post
1 Behance Post
1 Voog Post
1 Linkedin Post
1 EzineArticle Post
250 Facebook Reshares
300 Twitter Retweets
500 Pinterest Repins
TIER 2
Blog Comments LinkJuice
Bookmarks LinkJuice
Article Submission
Guestbook Comments
Social Network Profiles
Static Links
Referrer Links
Instant Link Indexer Services
Drip Feed Pinging
Order Now

PORTFOLIO

For example, you could think that people searching for “writing well” on Google are looking for copywriting tips—maybe a great keyword for a company offering content marketing services, right?

In the past, search engines were dumb. To find a relevant document for a search, they would look for how many times the keyword was mentioned on the page. The page that repeated the keyword the most won.

Classify your keywords. Re-name each of these buckets according to the site page you will think they would work on. These buckets will constitute the foundation of your website. You may not be able to include all of them, but they will give you a very good idea of what your site needs to look like and what keywords to use when optimizing each of its pages.

Google Ads Keyword Planner: This used to be the go-to keyword research tool for most SEOs. But, Google has drastically limited the amount of data you can get from this tool unless you are willing to spend a good amount of money on their advertising platform. It’s free and better than nothing—but we don’t recommend using it unless you have no other option. Check out the Google Ads Keyword Planner.

Secondary keywords are still important. Collectively, they often bring more organic traffic than your core keyword.

How To Use Our Keyword Research Template.

Search engines use LSI to figure out the overall topic of a page by finding words that frequently show up together.

They are the type of keywords that would come up if you were having a real-life conversation about your core keyword.

Core Keyword: sailing lesson boston massachusetts.

Keyword research is helpful at any stage of your business. By performing keyword research, you can:

World-class templates and checklists for entrepreneurs, marketers, bloggers & agencies.

A comprehensive keyword research template to understand what users are searching for (and create content that answers their questions).

A comprehensive keyword research template to understand what users are searching for (and create content that answers their questions).

There are usually hundreds of different ways to search for a core idea (see example below). This doesn’t mean you need to make hundreds of pages on your website to capture all these search queries.

Partial Match: boston massachusetts lessons for sailing.

That’s why it’s important to not only know how popular a keyword is but to also understand what users mean when they type them into the search bar.

3) Consider Keyword Competition.

Core Keywords : This is the target keyword you will optimize your page for.

Your core keyword will be the one that best represents a specific search topic — for a group of keywords with very similar meanings like on the table above, the core keyword is typically the one with the highest search volume.

When you find a core keyword you want to use, pick one page on your site to optimize for it.

There are many ways to determine the authority of different websites (more on that in the “Off-Page Optimization article”) but some keyword research tools already include a metric for competition that you can use.

First, to determine how popular a keyword is, look for its search volume using a third-party tool (more on this in the “ Tools ” section of this post.)

Measure your ROI. If you want to push things even further and reap all the benefits of your hard work, you could use your keyword buckets to make business calculations (and take decisions based on them). Here’s how our template looks like to calculate your ROI:

One page can rank for all these keywords. Any page on your site can rank for hundreds, sometimes thousands of keywords.

Browse More Digital Marketing Templates.

Up until now, we’ve picked a core keyword and the web page we want to optimize. We also have secondary & accessory keywords ready to go.

And we organized them on our template:

Best places to find secondary keywords are Google-related searches, Google auto-suggest, and Google trends.

Accessory Keywords: These are keywords that come up in the same topic as core keywords, but aren’t directly related. They often have less search volume but have less competition.

Keep in mind the golden rule for keyword research:

Now that you know different categories of keywords and what to consider while doing keyword research, let’s go over the actual steps of finding and organizing the keywords in the excel/google sheets:

Repeat your keyword research process with the Questions tab. This will generate a list of question based queries for that keyword. These keywords will be excellent to create long-form guides or blog posts.

We pick a core keyword to simplify things and make optimizing easier. If you’re optimizing for your core keyword, you will often rank for secondary keywords, even if they’re not used on the page.

With your spreadsheet (.csv file) downloaded, you’ll see several columns of data. You’ll want to focus on three columns only: ‘Keyword’, ‘Avg. Monthly Searches’ and ‘Competition’. Unclutter the sheet by deleting all other columns.

So, to refine your keyword selection further, it’s a good idea to split your ‘clean list’ into the following groups:

Open your template and add the keywords you feel your target audience might use to find your website, starting at your theme and then branching out. It’s also important to consider all three types of queries:

The tool we use to identify our keyword ranking is Accuranker , but there are many more SEO tools you can use, including:

Here at Jellyfish Training, we believe in the power of effective keyword research. Whether you’re an SEO beginner or specialist, our free keyword research template in Google Sheets will help you focus your research, whatever your level.

Step 3: Build out keyword lists using Google Ads Keyword Planner.

On the other hand, keywords identified as ‘low search volume’ receive very little search traffic on Google. These can be identified as keywords generating under 250 searches a month. This low search volume indicates these keywords may not be relevant to our target audience and won’t result in traffic to your website.

In this guide, we will walk you through each step of the research process. We’ll cover how to do keyword research through to analysis of keyword ranking and content mapping. To get started, open the keyword research template . This version is view only, so you’ll need to make a copy. You can do this by going to File then Make a copy.

Long-tail keywords: Longer, more specific keyword phrases that can be easier to rank for but have lower search volume.

Vanity keywords: Broad phrases representing an entire industry or topic that are hard to rank for but have higher search volume.

Expand your seed list The Google Keyword Planner will take your seed list(s) and expand on them by providing related search terms users might use to find a website or webpage like yours. Here’s what you need to do:

Once you’ve made a copy of the template, you’re ready to jump into keyword research. To make sure you get the most value from this guide, we’ve divided it into seven steps:

Finally, refine your list of keywords by deleting those we’ve identified above as either irrelevant or with a low search volume. You now have the final keyword selection, otherwise known as the ‘clean list’.

Access the Keyword Planner tool You will need access to your Google Ads account or create a new account using any Google account. Once you’ve logged in, go to Tools at the top of the page and select Keyword Planner from the dropdown menu.

Here’s an example. A skincare brand geared towards the premium marketplace with eco-friendly goals could identify luxury face cream, sustainable body lotion, and organic skincare as their themes.

Step 6: Final keyword selection.

Before you dive into keywords, you first need to consider themes. This is an important step that will help steer your keyword research in the right direction. So, to understand your themes, you need to think about your products or services and your customers. Then identify the core topics or messages of your website and marketplace.

Now, explore the keywords appearing in the list. You’ll find some seem irrelevant, off-topic or provide too little search volume to warrant inclusion in your final keyword selection.

Generally, the more searches a keyword receives, the better because we know people are searching this particular query. But the higher the search volume, the greater the competition, so we don’t want to select high search volumes only.

This next step focuses on finding effective keywords using your seed list.

Let’s run through each step in more detail so you can get the best use out of the template.

With the list of themes identified, it’s time to think about the search terms your ideal customers might use to find the products, services or information you offer.

Step 1: Select your themes.

Once you have finalised your keyword selections, the next step is to see if you’re already ranking for the keywords identified. This process will let you spot gaps in content or key pages not performing as you would expect. You’ll want to ask questions such as:

Your ‘clean list’ will include all of the keywords that you should consider targeting as part of your campaign. Naturally, some of these phrases will be of greater value than others – some will be ‘vanity’ keywords while others will be ‘long-tail keywords’. Here is how we define these:

Firstly, create a new column in your spreadsheet and mark the key phrases that directly match your core products or services with ‘high’ conversion intent. Where a user could be interested in your product or service but isn’t likely to convert, mark these as ‘medium’. If the query relates to your audience but, at this stage, they’re probably not interested in your offering, mark these as ‘low’.

This guide forms part of our SEO Standard course. If you’re looking to elevate your SEO strategy and master the basics of search engine optimisation, take a look at the range of SEO training courses delivered by our in-house experts.

It’s essential in SEO to make sure the pages you are targeting for any particular keyword match the query’s intent. To help you establish whether keywords should be targeted on landing pages, supporting pages, or informational pages, it’s useful to organize your keywords by commercial intent.

We recommend aiming for keywords with high-medium search volumes in your initial research. Occasionally, low difficulty keywords can benefit your ranking in search engine results pages (SERPs), as they’re usually far less competitive; you can come back to these later if needed.

Depending on your business, your website may be geared towards one theme only or a variety of themes. Once you’ve determined your theme(s), you can list these in the Seed List tab on your template.

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.