Keyword Research-Acquired Data Analysis and Decision Making in Excel

in #seo-class6 years ago

image

We will open the excel file we created earlier. Where there are keywords, searches and allintitle. Now, to measure keyword competitiveness, we have to see that there are a high number of searches and low number of competitor (pages) in a keyword. From this we can get our desired keywords.
Now look at the picture of the example, then you can see that the 'eletronic book reading device' is the search number 880 and the contestant is only 147 pages, so here can be competed, because the 880 search is not bad at all.
image

Then the 'electronic books device' is better than this keyword because allintitle is just 6 in comparison to 480 search. Find out the keywords as well and you can color the excel's cell green or you can do other colors of your choice. In this way, gradually select other keywords and highlight them with green color.

image
Notice that there are some keywords in this sheet that have fewer searches and allintitle too much. These keywords must be omitted. We will make these types of keywords red color. For example: see 'electornic books online' in the search for this keyword only 480 versus competition 12,300 This keyword will be competing for the fool Generally, such incidents happen when someone starts optimizing a keyword without having to do keyword research. That's why keyword research is very important, otherwise your time and labor will be wasted. So there is a problem for keyword research, but take a moment to do it and do it correctly. Then, eventually you will be profited.
When all keywords are highlighted, then our allintitle column of Excel sheet should be sorted in the order of smallest to largest. Then we will have a lot of benefits to understand.

Here are some more things to consider, such as if your site is new then a strategy and if the site is old then you have to follow another strategy. For this you can see the graph below.

image
Generally it is believed that if allintitle is below 1,000, then non-competitive, up to 1000-3000 fairly competitive, up to 3000-5000 competitive and highly competetive.
So if your site is very popular and aged then you can choose competitive or highly competitive keyword, but if your site is brand new, then your non-competitive keyword should definitely be selected. By filling that target you can target fairly comopetitive keywords.

image

If you can choose the right keyword by properly researching keyword and you can optimize that keyword properly, then you can gradually see the results. Here's the end of today. Invitation to read the next post.

£££¢¢¢£££¢ Previous class £££¢¢¢£££¢
Class no #1
https://steemit.com/seo/@nevlu123/what-is-seo-why-is-it-used-class-no-1-7244bec278c99
Class no #2
https://steemit.com/seo/@nevlu123/today-i-explained-about-keyword-research-class-no-2-bc769157aadb2
Class no #3
https://steemit.com/seo/@nevlu123/seo-keyword-recharge-part-2-class-no-3-fffb3a35fcadc
Class no #4
https://steemit.com/seo/@nevlu123/seo-keyword-research-part-3-class-no-4-44ea6864a639b
Class no #5
https://steemit.com/seo-class/@nevlu123/keyword-research-manually-data-from-google-we-search-by-entering-the-excel-sheet-from-kindle-reviews-to-google-028a65e065afb
###################################
###################################

My favourite steemains which help me all time
#1 @melip
#2 @solominer
#3 @mathworksheets
#4 @lavanyalakshman
#5 @hr1
#6 @saqibmirza
#7 @imran786
#8 @nrose123
#9 @sentu1
#10 @rossey
And also more steemains......................thanks to all for suporting me.......
###################################

###################################



gifeditor_20180509_002219.gif

###################################



gifeditor_20180530_011550.gif

###################################

Sort:  

This post has received a 3.13 % upvote from @drotto thanks to: @nevlu123.

Upvoted.

DISCLAIMER: Your post is upvoted based on curation algorithm configured to find good articles e.g. stories, arts, photography, health, etc. This is to reward you (authors) for sharing good content using the Steem platform especially newbies.
If you're a dolphin or whales, and wish not to be included in future selection, please let me know so I can exclude your account. And if you find the upvoted post is inappropriate, FLAG if you must. This will help a better selection of post.

Keep steeming good content.
@Yehey

Posted using https://Steeming.com condenser site.

Loading...