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
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

Spreadsheet SEO - Keyword Analysis was created by psergio and last modified on Fri Jun 2 07:09:42 2006.
Would you like to create your own sharable social spreadsheets?
[ default color ]
 
 recent: