SEO - Keyword Analysis by  nzwaneveld  nzwaneveld 
  Log In  |  Create a FREE Account  |  Everyone's Spreadsheets  |  Tags  |  Help  
 Saving... 
  login to save   undo redo  |  bold italic font text underline more font formatting  |  align left align center align right  |  text color background text color  |  sum hide/show tools
  fx
Enter 25 keywords. Decide how relevant the keywords are to your business. Lookup the popularity (how often used in past month) and the competition. Please read the comments below for further instructions.Relevance to your business (Score 1 - 3. 1 = hardly relevant. 3 = very relevant)Popularity - How often used in past month. Use Overture / WordTracker (Please read the comments below for further details.)Number of sites that meet exact search on Google / MSN (Please read the comments below for further details.)Keyword Effectiveness Index (this is a formula!)Go through the list and remove the poor keywords. It helps when you sort by Relevance or by KEI score. Next pick the Top 20 keywords. Out of your Top 20, you pick your Top 5 list of keywords. Now look at each of your webpages and first pick the most applicable keywords from your Top 5 list, then pick keywords from your Top 20. If you still have space, fill it with applicable keywords from your large list.http://www.frontlinesoft.nl
KeywordRelevancePopularityCompetitionKEI score
beer18798618200000042.54
coke2351255170000023.86
root beer3465022700009.53
pepsi38937038700000206.38
milk25485914000000021.50
water3159438123000000020.67
A&W root beer2240012900044.65
diet pepsi1347612400009.74
fanta2497861800004.01
sisi3398924000006.63
lemon soda358655000.05
empty0000.00
empty0000.00
empty0000.00
empty0000.00
empty0000.00
empty0000.00
empty0000.00
empty0000.00
empty0000.00
empty0000.00
empty0000.00
empty0000.00
empty0000.00
empty0000.00
 
Average Rating:  5 Stars (6 ratings)
 
Name:  SEO - Keyword Analysis by  nzwaneveld nzwaneveld 
Description:  Keyword analysis for Search Engine Optimization (SEO).
Tags:  SEO keyword analysis Google Yahoo  

Comments:

nzwaneveld
nzwaneveld
Why the weighting...
The weighting used is based on experience. The weighting can be tailored to your specific market, but I suggest working with the default values at first. As experience is gained, you can start experimenting with the weighting factor.
534 days ago 


gugo
gugo
which theory you use?
The formula applied is: KEI score = Popularity^2 x Competition So you give the square weight to the popularity. But why? Why not ^3 or ^3/2 Also the relevance, is out the formula. why not also ad the relevance in this way? KEI score + relevance = Popularity^2 x Competition x 1/ relevance The relevance is tooked linearly, but could also do in square basis.
726 days ago 


nzwaneveld
nzwaneveld
Link to get free Google API license key
https://www.google.com/accounts/NewAccount?continue=http://api.google.com/createkey&followup=http://api.google.com/createkey
883 days ago 


nzwaneveld
nzwaneveld
Popularity (Dutch keywords)
http://inventory.nl.overture.com/d/searchinventory/suggestion/
883 days ago 


nzwaneveld
nzwaneveld
Popularity (any language)
http://www.digitalpoint.com/tools/suggestion/ (Note: Google API license key required for some functionality)
883 days ago 


nzwaneveld
nzwaneveld
Popularity (English Keywords)
http://inventory.overture.com/d/searchinventory/suggestion/
883 days ago 


nzwaneveld
nzwaneveld
Competition...
Just a note on how to find out the competition. Go to your search page (i.e. www.google.com) and enter your keyword. If your keyword is more than one word, place it in quotes. The seach engine will tell you how many matches it found. The number of matches is the numer you fill in for competition.
883 days ago 


Add Comment
[ default color ]
 
 recent: