SEO KEYWORD RESEARCH EXCEL

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













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:

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.

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.

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

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

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:

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.

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’.

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

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.

Step 4: Analyse and refine full keyword list.

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:

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.

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.

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.

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.

Step 2: Create your seed list.

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.

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

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.

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

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:

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

Open as Google Sheet.

This template brings together all those different approaches into one place. So instead of bouncing around between a thousand tabs, losing track of where you are in the process…

Download as Microsoft Excel.

What’s included?

Download the Keyword Research Template.

The Digital Marketing Templates Library.

Keyword Research Template.

When you’re done, you’ll have a BIG list of keywords. Plus all the metrics to help you pick which to target.

In SEO there’s nothing more important than choosing the right keyword. This template makes it easy to create a large list of keywords to choose from. And to add the metrics you’ll need to evaluate them.

Streamline and organize your keyword research with this free template (available in Excel and Google Sheets). Whether you’re starting a new SEO project, want to improve your site’s search traffic, or are looking for target keywords for a new piece of content, this template will help you do keyword research quickly and effectively.

You can just go through this template. Simple. Step-by-step.

How to use this template.

Here’s what’s included in this keyword research template:

Like pretty much everything in SEO, keyword research is more complicated than ever. Back in the day, everyone used the old Google Keyword Tool. Today? There are a million different tool options. Plus, you’ve more techniques for finding keywords coming out every week.

But at the end of that process, you’ll still have to pick one. Here’s how to do that:

Why Use a Keyword Research 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.