Growth Machine Traffic Projection Spreadsheet PUBLIC

	A	B	C	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Source: Growth Machine Blog: Plan Better Content Marketing Goals with Our Simple Traffic Predictor
2	Keyword	Volume (desc)	Traffic Estimate

3	herbal tea benefits	1800	1440
4	oolong tea benefits	6900	5520	Results	% Traffic	3 Months	6 Months	9 Months	12 Months
5	black tea benefits	8000	6400	Low	10%	2,011	14,077	30,567	44,242		All KWs Traffic	160,880
6	green tea benefits	26000	20800	Good	30%	6,033	42,231	91,702	132,726		KW Count	48
7	pu-erh tea benefits	700	560	Great	50%	10,055	70,385	152,836	221,210		Traffic Multiplier	0.8
8	chai tea benefits	2900	2320	Excellent	70%	14,077	98,539	213,970	309,694		Monthly Pace	12
9	jasmine tea benefits	2600	2080
10	white tea benefits	4800	3840
11	mate tea benefits	450	360
12	rooibos tea benefits	5400	4320	Month	1	2	3	4	5	6	7	8	9	10	11	12
13	ginger tea benefits	9700	7760	Total Articles	12	24	36	48	60	72	84	96	108	120	132	144
14	benefits of mint tea	1700	1360
15	red tea benefits	700	560	Total Traffic	0	40,220	80,440	120,660	160,880	201,100	241,320	281,540	321,760	361,980	402,200	442,420
16	ginseng benefits	5700	4560	Time Discount	100%	90%	75%	60%	45%	30%	20%	10%	5%
17	chamomile tea benefits	8900	7120	Discounted Traffic	0	4,022	20,110	48,264	88,484	140,770	193,056	253,386	305,672	361,980	402,200	442,420
18	matcha tea benefits	5300	4240	Low	0	402	2,011	4,826	8,848	14,077	19,306	25,339	30,567	36,198	40,220	44,242
19	how to make jasmine tea	300	240	Good	0	1,207	6,033	14,479	26,545	42,231	57,917	76,016	91,702	108,594	120,660	132,726
20	how to make white tea	100	80	Great	0	2,011	10,055	24,132	44,242	70,385	96,528	126,693	152,836	180,990	201,100	221,210
21	how to make oolong tea	250	200	Excellent	0	2,815	14,077	33,785	61,939	98,539	135,139	177,370	213,970	253,386	281,540	309,694
22	barley tea benefits	1100	880
23	how to make mate tea	100	80
24	how to make chaga tea	1100	880
25	how to make milk tea	6700	5360
26	how to make hibiscus tea	2200	1760
27	how to make green tea	3100	2480
28	how to make thai tea	4400	3520
29	how to make iced tea with tea bags	1000	800
30	how to make matcha tea	4400	3520
31	how to make mint tea	1100	880
32	how to make ginger tea	10000	8000
33	how to make chai tea	3600	2880
34	how to make turmeric tea	2100	1680
35	how to make kombucha tea	1100	880
36	decaf tea	1500	1200
37	caffeinated tea	700	560
38	oolong tea vs green tea	800	640
39	how to steep tea	2700	2160
40	tea for upset stomach	1700	1360
41	what is tea	1600	1280
42	tea for sleep	1300	1040
43	how is tea made	600	480
44	types of tea	14000	11200
45	green tea vs black tea	3100	2480
46	weight loss tea	7400	5920
47	high caffeine tea	1700	1360
48	tea infuser	25000	20000
49	healthiest tea	2100	1680
50	green tea side effects	2700	2160
51			0
52			0
53			0
54			0
55			0
56			0
57			0
58			0
59			0
60			0
61			0
62			0
63			0
64			0
65			0
66			0
67			0
68			0
69			0
70			0
71			0
72			0
73			0
74			0
75			0
76			0
77			0
78			0
79			0
80			0
81			0
82			0
83			0
84			0
85			0
86			0
87			0
88			0
89			0
90			0
91			0
92			0
93			0
94			0
95			0
96			0
97			0
98			0
99			0
100			0