Final Copy of Keyword Opportunity Model

	A	B	C	D	E	F	G	H	I	J	K
1	Assumptions Per URL				SERP Rank CTR's		Competitive Weighting			Cost Multiplier Difficult Serp Adjustment
2	Revenue		Average Costs		Position #1	18.20%	Cost Multiplier	1.42		Avg SERP CI	Difficulty Adjustment
3	Average SERP CTR	6.10%	Research	$25.00	Position #2	10.10%	CI Threshold	50		100	1
4	Conversion Rate	1.50%	Content Development	$250.00	Position #3	7.20%	CI Adjustment	0.2		90	0.6
5	Average Conversion Value	$150.00	Editing & Production	$100.00	Position #4	4.80%				80	0.3
6			Content Cost #4	-	Position #5	3.10%				70	0.2
7			Content Cost #5	-						60	0.1
8			Total	$375						50	0

9	Keyword	Monthly Search Volume	(Optional) Current SERP Rank If 1-5	Potential Visitors	Conversions	Revenue	Avg SERP CI	Costs	MER
10	seo software	5,400		329	5	$741.15	64	$532.50	1.39
11	seo service	4,400	5	136	2	$306.90	64	$532.50	0.58
12	seo basics	2,400	1	437	7	$982.80	54	$532.50	1.85
13	seo link building	2,900	3	209	3	$469.80	58	$532.50	0.88
14	seo analysis	1,900		116	2	$260.78	51	$532.50	0.49
15	seo tool	1,600		98	1	$219.60	60	$532.50	0.41
16	seo link tools	28		2	0	$3.84	62	$532.50	0.01
17	organic seo	2,400		146	2	$329.40	63	$532.50	0.62
18	seo services	18,100		1,104	17	$2,484.23	70	$532.50	4.67
19	seo tools	8,100		494	7	$1,111.73	64	$532.50	2.09
20	Total	47,228	3	3,071	46	$6,910.22	61	$5,325.00	1.30
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100