Stella Rising SEO Forecasting Template

	A	B	C	D	E	F	G	H	I	J	K	M	N	O	P	Q
1	Step 1: Enter your keywords, search volume, CPC and current traffic below. Send questions and feature requests to jmorabito@stellarising.com											Step 2: Enter Average Order Value, Conversion Rate and CTR based on search term type.Refer to https://www.advancedwebranking.com/ctrstudy/ for CTRs
2	Sources:	Semrush Data	Semrush Data	Semrush Data								Average Order Value	Conversion Rate	CTR for #1	CTR for #2	CTR for #3
3	Keyword	Volume	Traffic Now	CPC	Media Value	Traffic if #1	Revenue if #1	Traffic if #2	Revenue if #2	Traffic if #3	Revenue if #3	$40.00	2.00%	29.76%	13.70%	6.70%

4	flavored floss	150	354	0.35	$15.62	45	$35.71	21	$16.44	10	$8.04
5	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
6	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
7	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
8	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
9	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
10	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
11	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
12	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
13	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
14	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
15	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
16	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
17	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
18	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
19	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
20	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
21	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
22	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
23	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
24	Example Keyword	150,000	354	0.35	$15,624.00	44,640	$35,712.00	20,550	$16,440.00	10,050	$8,040.00
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