Marketing Plan for SaaS

Still loading...

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Guidelines
2	1	Plug your numbers in the yellow cells. If you don't know them, assume the pre-filled one
3	2	Plug your current monthly traffic in the orrange cell				Note: To edit the numbers, first make a copy of this sheet (File > Make a copy).
4	3	List marketing ideas/tactics to increase each key metrics				Provided by:	@GaryGaspar
5	4	Estimate Investment vs Return					https://marker.io
6	5	Define how to measure success of those ideas
7
8
9	STEP 1 - Key metrics
10	A	Monthly traffic increase	10%
11	B	Visit to free account rate	8%
12	C	Free account to activated rate	19%
13	D	Activated to paying customer rate	21%
14	E	churn rate	3.2%
15	F	Monthly subcription ($)	$49
16	G	Lifetime value	$1,531
17
18
19
20	STEP 2 - Revenue model		Month 0	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12
21		Monthly New vistors	25,000	27,500	30,250	33,275	36,603	40,263	44,289	48,718	53,590	58,949	64,844	71,328	78,461
22		New Free accounts	2,000	2,200	2,420	2,662	2,928	3,221	3,543	3,897	4,287	4,716	5,187	5,706	6,277
23		New Activated accounts	380	418	460	506	556	612	673	741	815	896	986	1,084	1,193
24		New Paying customers	80	88	97	106	117	129	141	156	171	188	207	228	250
25		Existing customers	0	80	168	264	370	487	616	757	913	1,084	1,272	1,479	1,706
26		Lost customers	0	3	5	8	12	16	20	24	29	35	41	47	55
27		Total customers	80	165	259	362	475	600	737	888	1,054	1,237	1,438	1,659	1,902
28		Total revenue ($)	$3,910.20	$8,086.29	$12,680.00	$17,733.07	$23,291.45	$29,405.67	$36,131.31	$43,529.51	$51,667.54	$60,619.37	$70,466.38	$81,298.09	$93,212.97
29
30
31
32	STEP 3, 4, 5 - Marketing ideas		Main Impact on:	Investment	Return	Metrics
33		Write guest post	A	Medium	Low	200 new visitors
34		Buy adwords	A	Medium	Medium	150 new vistors
35		Email outreach	A	High	High	15 influencers using the product
36		New landing page	B	Low	Medium	30% increase in signups
37		Design a new signup flow	C	Medium	Medium	20% increase in activation
38		Implement a live chat widget	D	Low	High	10% increase in paying customer for those who uses the live chat
39		New features development	F	High	Low	10% increase in paying customer
40		Call most succesfull customers	E	Low	Medium	survey 30 customers & Identify the 3 reasons why customers stay
41		Call least succesfull customers	E	Low	Low	survey 30 customers & Identify the 3 reasons why customers leave
42		Support	G	High	Medium	Increase in LTV for people who interact with support
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