How to use keywords for websites and content

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

Which keywords are chosen?

How to use the keywords?

How many times must be included in the content?

Free that we do for hours or for days if we don’t know how to choose the best keywords and how to use them.

That’s what was discussed in this guide.

1. Analyze the level of difficulty

First, we must know the level of difficulty first.

How to analyze keyword competition we have discussed in the previous chapter, there are several ways starting from the manual (with mozbar or seoquake) or automatic (with the terplorer).

We discuss starting from the manual.

Phase 1 Manual Analysis – High Volume Keyword Filter

Because the number of keywords is very large, we must reduce it first. For this reason, the search volume is very low we hide.

We are looking for a high volume.

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

(CSV files from Keyword Planner, have been discussed here)

The following column blocks:

Then right click on the head of the column> delete selected columns.

After that, the remaining column block and click the Filter button:

(Left: Google Sheets, Right: Excel)

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

The volume is up to your desire.

This depends on each person, so I can’t give the right number.

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

Finally, click the arrow again then Sort Largest to Smaller (Sort ZA for Google Sheets).

Phase 2 Manual Analysis – Get the difficult 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 not there, install mozbar)

Wait a few seconds until the percentage number comes out.

After that, make an additional column on the rightmost in the spreadsheet earlier, the title is “Difficulty”.

Enter the numbers:

That’s the manual way.

These 2 stages are only practical versions, if you want to do more accurate research, please reread the previous chapter.

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 keywords 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 CSV Download button:

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

Compared to the manual way, the Termexplorer will produce a much more complete analysis.

You can see the Dieficulty Score in the rightmost column:

Finished!

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

There is one more way, semi-automatic analysis using a long tail pro.

Semi-automatic Analysis-With Long Tail Pro

The only weakness of the Termexplorer is that the amount is limited. If we want to analyze many keywords, then we must pay more.

If our keyword list is a little, it doesn’t matter.

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

Therefore, the middle road is a long tail pro.

With a long tail pro, we can easily filter, sort, and get the level of difficulty.

Stages:

1. Click find the keyword, 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 competition level

Although slower than the Termexplorer, but you can do as much analysis as possible.

The process is also easier than manual.

2. Determine the priority of the keywords

It’s easy.

About this kind of consideration:

1. Avoid keywords with volume (Avg. Monthly Searches)
2. Prioritize keywords with high volumes and low difficulty
3. Prioritize keywords with medium volume and very discliculty
4. Prioritize keywords with low volume, low difference, but very relevant to your target market
5. Prioritize all very relevant keywords, regardless of the difficulty
6. Delete Keywords that Unreasonable

There are 2 more things:

First, do not delete keywords with high volume and difficulty. This can still be used later when your website is big enough.

Second, it helps you do a manual analysis again based on previous guidelines for websites on the first page of Google for each keyword you are after.

… because the competition rate is not always accurate.

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

Like this:

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

Priority based on the type of keyword

In addition to 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 the intent:

• Information
• Navigation
• Commercial investigation
• Transactional

Don’t understand? Read in the search intent guide.

Because we do not use navigational, then we now only have 3. If you follow the keyword research guide from the previous chapters, you now have 3 files each for 1 intent.

What type do we prioritize?

This we can see from 2 sides: quality and quantity.

In quality, the quality for the content in the transactional keyword must be the highest … while the lowest informational.

In quantity, on the contrary.

The quantity of informal keywords is higher than transactional.

So try so that your website pages that are targeting transactional keywords are not too much but must be very high quality.

The reason?

Visitors do not like to see a lot of content that offers products.

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

3. Understanding the right type of content for certain keywords

Before that, one thing first:

Content is not just an article …

… not just videos or pictures.

When I talk about content, other than those that can also include tools, files to be downloaded, reviews from buyers, product sales pages, and others.

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

Okay, continue …

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

Not enough.

For example the keyword “flight 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 promos 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 rank 1-10 it contains the tool to search for promo flight ticket prices. Not an article.

How to find out the right type of content

Actually it is not difficult … But unfortunately, many website owners do not care. They prefer to make article content, because it is easy.

Even though it’s useless.

So that’s how it is:

Position yourself as a person who wants to search on Google.

Imagine you are looking for keywords on Google. What kind of content do you expect?

Let me give a case example:

• Keyword: “Selling Canon 60D”. Content: Canon 60D product sales page.
• Keyword: “Selling DSLR Camera”. Content: Homepage from an online store that sells cameras (because the keywords are not specific).
• Keyword: “DSLR Camera”. Content: DSLR camera explanation.
• Keyword: “Best DSLR Camera”. Content: The article contains the list of the best DSLR cameras
• Keyword: “Canon 60D”. Content: Canon 60D product page from the official website of Canon

Like that.

From now on, don’t rush to make articles for all types of keywords.

Pay attention to the needs of the content.

4. Use the 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.

Beforelike this:

SEO practitioners use the keyword research results repeatedly on the website page. The goal is that Google understands that the page is eyeing the keywords.

For example articles with keywords “How to Get Rid of Computer Virus”.

The keywords are written repeatedly, and the writing is exactly like the keywords that appear from Google Keyword Planner.

After that, bold/underline/Italic decoration is given.

Nowlike this:

We don’t need to bother using the keywords in the content. As long as we create content that contains the keyword, Google will understand.

So, for the keywords earlier, all you have to do is make an article that contains a guide to eliminate computer viruses. No need to write the keywords exactly like that.

Like that how it works.

With the Hummingbird, Google can understand the topics of a page even though we don’t write the keywords at all.

Then what to do?

First, this is the most important:

Don’t care about SEO at all when you create content.

Use the keywords just as a topic, then create content that is “as is” without the need to bother where to place the keyword.

In addition, you also don’t need to bold/Italic/Underline every time the keyword appears.

If you think too much, your content is not enjoyable to enjoy.

But that does not mean the keywords are not used at all …

… There are 3 places where we should include keywords:

1. Page title
2. URL
3. Backlink

Just that.

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