Dashboard - Julie1 .xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1		KEY PERFORMANCE INDICATOR	41851	41882	41912	41943	41973	42004	42035	42063	42094	42124	42155	42185	42216	42247	42277	42308	42338	42369	Note: was not quite sure where this belongs?
2
3			Jan-18	Feb-18	Mar-18	Apr-18	May-18	Jun-18	Jul-18	Aug-18	Sep-18	Oct-18	Nov-18	Dec-18	Jan-19	Feb-19	Mar-19	Apr-19	May-19	Jun-19
4		VISITORS & SIGNUPS
5	Website Visits		55625	64335	94970	92960	128020	120142.5	142362.5	125182.5	184590	173127.5	178660	161200	226610	239950	598412.5	998372.5	670792.5	718240
6	mom growth			15.7%	47.6%	-2.1%	37.7%	-6.2%	18.5%	-12.1%	47.5%	-6.2%	3.2%	-9.8%	40.6%	5.9%	149.4%	66.8%	-32.8%	7.1%
7	Total New signups		4287.5	5770	7372.5	6147.5	7217.5	5190	7120	6907.5	10052.5	10300	11870	8925	12912.5	16192.5	17207.5	21215	20527.5	17985
8	mom growth			34.6%	27.8%	-16.6%	17.4%	-28.1%	37.2%	-3.0%	45.5%	2.5%	15.2%	-24.8%	44.7%	25.4%	6.3%	23.3%	-3.2%	-12.4%
9	Conversion Visits to Signups		7.7%	9.0%	7.8%	6.6%	5.6%	4.3%	5.0%	5.5%	5.4%	5.9%	6.6%	5.5%	5.7%	6.7%	2.9%	2.1%	3.1%	2.5%
10
11		PAYING CUSTOMERS
12	Customers beginning of the month		682	926	1087	1591	1733	2036	2388	2698	2891	2881	3305	3353	3511	3484	3621	3894	4170	4480
13		SMB customers	650	881	1042	1539	1686	1973	2316	2617	2799	2764	3198	3233	3352	3317	3450	3688	3961	4255
14		Enterprise customers	32	40	40	42	42	48	52	56	62	72	72	80	94	102	106	126	134	160
15	New customers		461	408	660	443	555	639	576	391	335	648	421	417	262	438	508	572	727	647
16	Conversion Signups To Paying		11%	7%	9%	7%	8%	12%	8%	6%	3%	6%	4%	5%	2%	3%	3%	3%	4%	4%
17		SMB customers	455	406	658	441	553	637	574	385	329	644	413	413	252	434	490	560	693	623
18		Enterprise customers	6	2	2	2	2	2	2	6	6	4	8	4	10	4	18	12	34	24
19	Plan upgrades (from SMB to enterprise)		2	0	2	0	4	2	4	4	8	0	2	10	0	0	6	0	2	4
20
21	Lost customers		-217	-247	-156	-301	-252	-287	-266	-198	-345	-224	-373	-259	-289	-301	-235	-296	-417	-336		9375
22		SMB customers	-217	-245	-154	-301	-252	-287	-266	-196	-343	-224	-371	-259	-287	-301	-231	-294	-413	-336
23		Enterprise customers	0	-2	-2	0	0	0	0	-2	-2	0	-2	0	-2	0	-4	-2	-4	0			11250
24	Churn Rate		31.82%	26.67%	14.35%	18.92%	14.54%	14.10%	11.14%	7.34%	11.93%	7.78%	11.29%	7.72%	8.23%	8.64%	6.49%	7.60%	10.00%	7.50%
25	Plan downgrades (from enterprise to SMB)		0	0	0	7	0	0	7	7	7	14	0	0	0	0	0	7	21	14
26
27	Net New customers		244	161	504	142	303	352	310	193	-10	424	48	158	-27	137	273	276	310	311
28	Customers end of the month		926	1087	1591	1733	2036	2388	2698	2891	2881	3305	3353	3511	3484	3621	3894	4170	4480	4791
29		SMB customers	881	1042	1539	1686	1973	2316	2617	2799	2764	3198	3233	3352	3317	3450	3688	3961	4255	4542
30		Enterprise customers	40	40	42	42	48	52	56	62	72	72	80	94	102	106	126	134	160	184
31	mom growth			17.4%	46.4%	8.9%	17.5%	17.3%	13.0%	7.2%	-0.3%	14.7%	1.5%	4.7%	-0.8%	3.9%	7.5%	7.1%	7.4%	6.9%
32
33		MRR
34	MRR beginning of the month		283927	312585	330267	378525	392420	445655	498848	594076	678706	742875	772961	837228	895748	889217	977039	1182713	1405159	1522668
35		MRR beginning of the month SMB	137403	153713	174195	214886	227745	260610	301140	319753	342769	355516	381759	395759	420455	425887	444710	492772	495369	517265
36		MRR beginning of the month enterprise	146524	158872	156072	163639	164675	185045	197708	274323	335937	387359	391202	441469	475293	463330	532329	689941	909790	1005403
37	New MRR from new customers		32683	34573	50932	34076	47719	59521	39249	50561	67193	53011	95256	58597	47390	110488	218645	266175	163779	215306
38		New MRR from new SMB customers	22491	31080	42182	30583	41888	53690	35056	35448	26859	42994	39837	36603	19705	41489	54166	43400	57582	56868
39		New MRR from new enterprise customers	10192	3493	8750	3493	5831	5831	4193	15113	40334	10017	55419	21994	27685	68999	164479	222775	106197	158438
40	New MRR from account expansions		4550	5096	10577	5796	20811	12397	80535	65135	30877	11977	11844	23758	11956	5208	16135	8939	18823	23709
41		New MRR from account expansions SMB	2394	5096	8267	5796	6272	5565	8113	8134	14490	11277	8624	10157	6307	5208	9485	8022	4487	13699
42		New MRR from account expansions enterprise	0	0	0	0	0	6300	68215	50701	1750	700	0	5950	5649	0	0	917	10738	980
43		New MRR from account expansions SMB to enterprise	2156	0	2310	0	14539	532	4207	6300	14637	0	3220	7651	0	0	6650	0	3598	9030
44	Total New MRR (new customers + account expansions)		37233	39669	61509	39872	68530	71918	119784	115696	98070	64988	107100	82355	59346	115696	234780	275114	182602	239015
45
46	Lost MRR from cancellations		-7819	-20601	-10969	-16877	-12817	-14931	-18235	-25739	-25424	-16331	-35980	-15750	-18046	-21021	-24997	-41335	-54964	-26684
47		Lost MRR from cancellations SMB	-7819	-14308	-7476	-16877	-12817	-14931	-18235	-15239	-22218	-16331	-27608	-15750	-14840	-21021	-13111	-37492	-32872	-26684
48		Lost MRR from cancellations enterprise	0	-6293	-3493	0	0	0	0	-10500	-3206	0	-8372	0	-3206	0	-11886	-3843	-22092	0
49	Lost MRR from downgrades		-756	-1386	-2282	-9100	-2478	-3794	-6321	-5327	-8477	-18571	-6853	-8085	-47831	-6853	-4109	-11333	-10129	-22008
50		Lost MRR from downgrades SMB	-756	-1386	-2282	-4326	-2478	-3794	-5523	-3234	-2191	-7938	-6853	-6314	-5740	-6853	-2478	-9240	-4284	-7238
51		Lost MRR from downgrades enterprise	0	0	0	-2457	0	0	0	0	-2093	-6874	0	-1771	-42091	0	-1631	0	-2828	-7560
52		Lost MRR from downgrades enterprise to SMB	0	0	0	-2317	0	0	-798	-2093	-4193	-3759	0	0	0	0	0	-2093	-3017	-7210
53	Total Lost MRR (cancellation + downgrades)		-8575	-21987	-13251	-25977	-15295	-18725	-24556	-31066	-33901	-34902	-42833	-23835	-65877	-27874	-29106	-52668	-65093	-48692
54	MRR Churn Rate		3.0%	7.0%	4.0%	6.9%	3.9%	4.2%	4.9%	5.2%	5.0%	4.7%	5.5%	2.8%	7.4%	3.1%	3.0%	4.5%	4.6%	3.2%
55	Net new MRR (Total New MRR + Total Lost MRR)		28658	17682	48258	13895	53235	53193	95228	84630	64169	30086	64267	58520	-6531	87822	205674	222446	117509	190323
56	MRR end of month		312585	330267	378525	392420	445655	498848	594076	678706	742875	772961	837228	895748	889217	977039	1182713	1405159	1522668	1712991
57		MRR end of month SMB	153713	174195	214886	227745	260610	301140	319753	342769	355516	381759	395759	420455	425887	444710	492772	495369	517265	546700
58		MRR end of month enterprise	158872	156072	163639	164675	185045	197708	274323	335937	387359	391202	441469	475293	463330	532329	689941	909790	1005403	1166291
59	mom growth			5.7%	14.6%	3.7%	13.6%	11.9%	19.1%	14.2%	9.5%	4.0%	8.3%	7.0%	-0.7%	9.9%	21.1%	18.8%	8.4%	12.5%
60
61	ARPA per Month		$338	$304	$238	$226	$219	$209	$220	$235	$258	$234	$250	$255	$255	$270	$304	$337	$340	$358
62	Arpa new customers		$71	$85	$77	$77	$86	$93	$68	$129	$201	$82	$226	$141	$181	$252	$430	$465	$225	$333
63
64
65
66
67
68
69
70
71
72
73																			100
74																			8.333333333
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