Spreadsheet: SEO - Keyword Analysis
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.

Description: Keyword analysis for Search Engine Optimization (SEO).