SEO - Keyword Analysis

Saving...

| cells cell options

| spreadsheet formula options

SEO - Keyword Analysis by psergio

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
Keyword	Relevance	Popularity	Competition	KEI score
beer	1	87986	182000000	42.54
coke	2	35125	51700000	23.86
root beer	3	4650	2270000	9.53
pepsi	3	89370	38700000	206.38
milk	2	54859	140000000	21.50
water	3	159438	1230000000	20.67
A&W root beer	2	2400	129000	44.65
diet pepsi	1	3476	1240000	9.74
fanta	2	4978	6180000	4.01
sisi	3	3989	2400000	6.63
lemon soda	3	58	65500	0.05
empty	0	0	0	0.00
empty	0	0	0	0.00
empty	0	0	0	0.00
empty	0	0	0	0.00
empty	0	0	0	0.00
empty	0	0	0	0.00
empty	0	0	0	0.00
empty	0	0	0	0.00
empty	0	0	0	0.00
empty	0	0	0	0.00
empty	0	0	0	0.00
empty	0	0	0	0.00
empty	0	0	0	0.00
empty	0	0	0	0.00

	Number Formatting
		none		1,234 1,234.56 $1,234 $1,234.56		1234 1234.56 25% 25.35%		Currency symbol: Decimal places:

	Row/Column Options
		insert row before insert row after		insert column before insert column after		remove row remove column

	Font Formatting
		B I U		strike a⁺ a^-