Keyword Strategy: Prioritizing and Implementing Keywords from Research Results into a Website


There is a big confusion that occurs after the keyword research process and competition analysis.

Which keyword is chosen?

How do you use the keyword?

How many times must be included in the content?

It's useless to do research for hours or days if we don't know how to choose the best keywords and how to use them.

That is what is discussed in this guide.This is the fourth chapter of the keyword research guide series

1. Analyze the level of difficulty

First, then we must know the level of difficulty first.

We have discussed how to analyze keyword competition in the previous chapter, there are several ways starting from the manual (with MozBar or SEOQuake) or automatic (with TermExplorer).

We discuss starting from the manual.

Manual analysis phase 1 - Filter keywords with a high enough volume

Because the number of keywords is very large, then we must reduce it first. For that, we are hiding the search volume very low.

We are looking for a high enough volume.

First, open your CSV file in Microsoft Excel or Google Sheets.

(CSV file from Keyword Planner, discussed here )

Blocks the following columns:


Then right-click on the column head> Delete selected columns.

After that, block the remaining columns and click the filter button:


(left: Google Sheets, right: Excel)

Click the arrow next to Avg. Monthly, then the filter that is bigger than the number you want:


The volume is up to your wishes.

It depends on each person, so I can't give the numbers right.

In the example above, I delete a keyword whose search volume is smaller than 1000 per month.

Finally, click the arrow again then sort largest to smaller (ZA sort for Google Sheets).

Manual analysis stage 2 - Get the difficulty value

Now we will analyze the remaining keywords.

Do a search on Google with the remaining keywords:


Click the green button "Get Keyword Difficulty".

(If it's not there, install MozBar)

Wait a few seconds for the percentage numbers to come out.


After that, create an additional column to the right of the spreadsheet, the title is "Difficulty".

Enter the number:


That's the manual method.

These two stages are just the practical version, if you want to do more accurate research please read the previous chapter again .

For those of you who want to be more practical, there is an easier way to analyze thousands of keywords at once:

Automatic analysis - with TermExplorer

This one is much easier.

  1. Click the Keyword Analyzer menu at the top, click 'Start a Keyword Analyzer Project'.
  2. Paste the keyword from the Excel file that you have saved.
  3. Before pressing the 'Start Project' button change the country

Wait a few seconds / minute.

When finished, click the Download CSV button:


Then you can open this file in Microsoft Excel or Google Sheets.

Compared to the manual method, TermExplorer will produce a much more complete analysis.

You can see Difficulty Score in the far right column:



In just one step we can find out the difficulty level of many keywords at once, which is much easier.

There is one more way, semi-automatic analysis using Long Tail Pro.

Semi-automatic analysis - with Long Tail Pro

The only disadvantage of TermExplorer is the amount is limited. If we want to analyze a lot of keywords, then we have to pay more.

If our keyword list is a bit, it doesn't matter.

But if we have lots of keywords, it will be expensive.

Therefore, the middle road is Long Tail Pro.

With Long Tail Pro, we can easily filter, sort and get the level of difficulty.


1. Click Find Keywords, then click 'Add My Own Keywords'

Paste all your keywords, then click 'Generate Keywords & Fetch Data'


Wait until it's finished.

2. Click 'Calculate' to get the level of competition

Get difficulty-on-long-tail-pro keywords

Even though it's slower than TermExplorer, you can analyze as much as possible.

The process is also easier than manual.

2. Determine priority keywords

The method is easy.

About this consideration:

  1. Avoid keywords with low Avg. Monthly Searches but high difficulty
  2. Prioritize keywords with low high and difficulty volumes
  3. Prioritize keywords with medium volume and very difficulty
  4. Prioritize keywords with low volume, low difficulty, but very relevant to your target market
  5. Prioritize all keywords that are very relevant, regardless of the difficulty
  6. Remove keywords that don't make sense

There are 2 more things:

First, don't delete keywords with high volume and difficulty. This can still be used later when your website is large enough.

Secondly, it's a good idea to do manual analysis again based on previous guidelines for websites on the first page of Google for each keyword that you seek.

... because the number of competition is not always accurate.

To record the priority, create a new column named Priority in your Excel. Then enter the numbers from 1, 2, 3, ... according to the priority you want.

Like this:


Every time you want to create new content, you can use these keywords based on the order of priorities.

Priority based on the type of keyword

Apart from competition and volume, there is one more consideration: search intent.

We have learned in the previous chapter that there are 4 types of keywords based on their intent:

  • Informational
  • Navigational
  • Commercial investigation
  • Transactional

Not understand yet? Read in the search intent guide .

Because we don't use navigational, we now only have 3. If you follow the keyword research guidelines from the previous chapters, you now have 3 files each for 1 intent.

Which type do we prioritize?

We can see this from two sides: quality and quantity.

In quality, the quality for content in transactional keywords must be the highest ... while informational is lowest.

In quantity, vice versa.

The keyword informational quantity is higher than transactional.

So try so that your website pages that target the transactional keywords are not too many in number but must be VERY high quality.

The reason?

Visitors don't like to see a lot of content offering products.

The main purpose of people browsing online is to find information and find solutions to problems, so provide lots of content that is useful for them.

3. Understand the type of content that is right for certain keywords

Before that, one thing first:

Content is not just an article ...

... not only videos or images.

When I talk about content, besides the one before it can also include tools, files to download, reviews from buyers, product sales pages, and others.

The point is that whatever is on a website page is content.

Okay, continue ...

For the keyword commercial investigation and transactional, usually what we need is not the content of articles, videos or images.

Not enough.

For example the keyword "airplane ticket promo".

For these keywords, you will not be able to enter page 1 on Google if you only create a new article that contains a promo every month.

Google understands that people don't need articles.

The quality must be higher.

Therefore, try to search on Google with these keywords. From the ranking of 1-10 it contains a tool to search for promo flight ticket prices. Not an article.

Not article

How to find out the right type of content

Actually it's not difficult ... but unfortunately, many website owners don't care. They prefer to create article content, because it's easy.

Even though it's useless.

So how do you do this:

Position yourself as someone who wants to search on Google.

Imagine you are looking for those keywords on Google. What content do you expect to expect?

Let me give an example:

  • Keyword: "selling canon 60d". Content: sales page for Canon 60D products.
  • Keyword: "selling DSLR cameras". Content: the homepage of an online store that sells cameras (because the keywords are not specific).
  • Keyword: "dslr camera". Content: an explanation of DSLR cameras.
  • Keyword: "best dslr camera". Content: the article lists the best DSLR cameras
  • Keyword: "canon 60d". Content: Canon 60D product pages from Canon's official website

Like that.

From now on, don't rush to create articles for all types of keywords.

Pay attention to the content requirements.

4. Using keywords in the content

This is where many people make fatal mistakes.

SEO is now different from before 2013, since Google launched an algorithm called Hummingbird.

It used to be like this:

SEO practitioners use the keyword results of research repeatedly on the website page. The goal is for Google to understand that the page is targeting those keywords.

For example articles with the keyword "how to get rid of computer viruses".

These keywords are written repeatedly, and they are written exactly like keywords that appear from the Google Keyword Planner.

After that, bold / underline / italic decorations are given.

Now , like this:

We don't need to bother using keywords in the content. As long as we make content about these keywords, Google will understand.

So, for those keywords, you just have to make an article that contains a guide to removing computer viruses. No need to write the keywords exactly like that.

That's how it works.

With the Hummingbird, Google can understand the TOPIC of a page even though we don't write the keyword at all.

So what to do?

First, this is the most important:

Don't mind SEO at all when you create content.

Use the keywords as topics only, then create content that is "as is" without the need to worry about placing these keywords.

Besides that, you also don't need to bold / italic / underline every time the keyword appears.

If you think about it too much, your content will not be enjoyable.

But that does not mean the keyword is not used at all ...

... there are 3 places where we should include the keyword:

  1. Title of page
  2. URL
  3. Backlink

That is all.

For other on-page optimizations, please read the following guidelines:


1 Response to "Keyword Strategy: Prioritizing and Implementing Keywords from Research Results into a Website"

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel