Search Engine Optimization SEO Tutorials from A to Z [Episode-05] :: Keyword Research - Manually Data from Google

 

Those who haven't read the previous tune can check it out by clicking on the link below:

We search for the kindle reviews phrase from the excel sheet by entering it in Google. Then see how many results Google has got on the right side. But the results that Google is actually showing here have only kindle results, only reviews have results, and there are also combined results of two phrases. From which it can be said, not all pages may be optimized for kindle review phrase.

Now we will search by putting the phrase "kindle review" in the quote. See the number of results has come down a lot, showing 60300 here. In other words, we can say, kindle review exact phrase is being used somewhere in the 80300 website. From here, things get trickier, and this is where the true meaning of "all" comes into play.

So we will use Google's advance search term.

Google it now: allintitle: "kindle reviews"

- Then you see that only 6060 results are showing, that is, the title tag of these websites has the word kindle reviews. Since the title tag contains the word kindle reviews, we can assume that these sites are optimized for this phrase. Since our site is highly relevant to this phrase, we can use it. Now we need to notice a few more things.

Do a Google search for the kindle reviews phrase and look at the results - first there is cnet.com which is very famous and has been on the web for a long time, which means it will be very difficult to compete with it.

Enter the first link and see the word kindle reviews is nowhere to be found directly on this site, it probably has a lot of backlinks with the kindle reviews phrase. There is no problem if you do not understand the meaning of backlink, we will discuss it one by one later. We can take this phrase.

Now there is a big site like pcworld in Google search. So it can be said that the competition will be very tough. If you wish, you can visit the first page sites of Google and see how they are optimizing their site for kindle reviews phrase. In this way, choose a few more keywords one by one and find out the number of contestants by following the same procedure.

Then open our excel sheet and do searches by changing the heading of Global monthly searches column and do a new column called Allintitle next to it. Now type 6060 in the Allintitle column in the kindle reviews phrase. Similarly, find out the allintitle number for other keywords, you can understand that it is a matter of time, so choose the highly related keywords very carefully and find out the allintitle for them. This way you can measure the competetiveness of the desired keyword for your site. Hopefully, that will help you rank better next time.