SEO Forecasting Worksheet

	A	B	C	D	E	F	G	K	L	M
1			Link to Search Engine Land article showing how to use worksheet
2	MonthDate	Traffic A -- Actual	Traffic A - MoM Growth Rate	Traffic A -- Forecast	SEO Forecast	YoY % Assumptions	MoM
3	1/1/22	119,645		119,645	119,645			Inputs
4	2/1/22	122,001	0.01969158761	122,001	122,001			Rows 3-14: Historical Data
5	3/1/22	120,931	-0.008767301088	120,931	120,931			Traffic A - Avg MoM growth rate in 2022	0.48%
6	4/1/22	123,739	0.02321929514	123,739	123,739			YoY % Growth Assumption with SEO Q1	8	10
7	5/1/22	124,662	0.007452599895	124,662	124,662			YoY % Growth Assumption with SEO All Other Quarters	10	15
8	6/1/22	126,701	0.01636307137	126,701	126,701
9	7/1/22	128,862	0.01705617546	128,862	128,862
10	8/1/22	127,148	-0.01330200712	127,148	127,148
11	9/1/22	125,563	-0.01247010583	125,563	125,563
12	10/1/22	132,110	0.05214033195	132,110	132,110
13	11/1/22	128,793	-0.02510576585	128,793	128,793
14	12/1/22	125,793	-0.02329321397	125,793	125,793
15	1/1/23	126,399		130,640	131,610	10.00%	4.62%
16	2/1/23	127,008		131,443	132,981	9.00%	1.04%
17	3/1/23	127,619		132,169	133,025	10.00%	0.03%
18	4/1/23	128,234		132,972	136,113	10.00%	2.32%
19	5/1/23	128,852		133,750	139,621	12.00%	2.58%
20	6/1/23	129,472		134,553	145,707	15.00%	4.36%
21	7/1/23	130,096		135,331	144,326	12.00%	-0.95%
22	8/1/23	130,723		136,134	142,406	12.00%	-1.33%
23	9/1/23	131,352		136,937	143,141	14.00%	0.52%
24	10/1/23	131,985		137,715	145,321	10.00%	1.52%
25	11/1/23	132,621		138,518	141,672	10.00%	-2.51%
26	12/1/23	133,260		139,296	144,662	15.00%	2.11%
27	1/1/24	133,902		140,099	147,403	12.00%	1.89%
28	2/1/24	134,546		140,902	152,928	15.00%	3.75%
29	3/1/24	135,195		141,654	151,649	14.00%	-0.84%
30	4/1/24	135,846		142,457	153,808	13.00%	1.42%
31	5/1/24	136,500		143,235	154,979	11.00%	0.76%
32	6/1/24	137,158		144,038	164,649	13.00%	6.24%
33	7/1/24	137,818		144,816	160,202	11.00%	-2.70%
34	8/1/24	138,482		145,619	162,343	14.00%	1.34%
35	9/1/24	139,149		146,422	163,181	14.00%	0.52%
36	10/1/24	139,819		147,200	164,213	13.00%	0.63%
37	11/1/24	140,493		148,003	157,256	11.00%	-4.24%
38	12/1/24	141,170		148,781	164,915	14.00%	4.87%
39	1/1/25	141,850		149,584	162,143	10.00%	-1.68%
40	2/1/25	142,533		150,387	174,338	14.00%	7.52%
41	3/1/25	143,219		151,113	166,814	10.00%	-4.32%
42	4/1/25	143,909		151,916	176,879	15.00%	6.03%
43	5/1/25	144,602		152,694	175,126	13.00%	-0.99%
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