daphni - marketplace KPI Spreadsheet

	A	B	C	D	E	F	G	H
1		Jan 2016	Feb 2016	Mar 2016	Apr 2016	May 2016	Jun 2016	Jul 2016
2	Overall
3	GMV (K€)	12800	32895	35310	39590	45580	51600	68904
4	GMW Growth rate MoM (%)		61%	7%	11%	13%	12%	25%
5	Transactions (#)	64	153	165	185	212	240	319
6	Average Order Value (€)	200	215	214	214	215	215	216
7	Take rate (%)	20%	20%	20%	20%	20%	20%	20%
8	Listings fees (€)	0	0	0	0	0	0	0
9	Special services (€)	0	0	0	0	0	0	0
10	Revenue (€)	2560	6579	7062	7918	9116	10320	13780.8
11	Revenue Growth MoM (%)		61%	7%	11%	13%	12%	25%
12	Revenue/transaction (€)	40	43	42.8	42.8	43	43	43.2
13	Buyer-to-Seller ratio	1.2	1.8	2.3	2.9	3.0	3.3	3.8
14	Buyer/Seller overlap	13%	15%	14%	16%	15%	14%	16%
15	Monthly CAC	1051	1577	2126	2607	3277	5630	5117
16	CAC/revenue (%)	41%	24%	30%	33%	36%	55%	37%
17	Variable Costs (per unit)	24	24	24	22	20	19	17
18	Contribution margin (per unit)	16	19	18.8	20.8	23	24	26.2
19	Contribution margin ratio	40%	44%	44%	49%	53%	56%	61%
20
21	Supply (sellers)
22	New suppliers (#)	49	53	49	61	63	79	83
23	Resurrected (#)	0	0	9	12	19	3	4
24	Churn (#)	0	-29	-21	-48	-42	-49	-53
25	Suppliers (#)	49	73	110	135	175	208	242
26	Supplier Growth Rate MoM		49%	51%	23%	30%	19%	16%
27	Quick ratio (new+res)/churn		1.83	2.76	1.52	1.95	1.67	1.64
28	Retention rate
29	Supplier Net Promoter Score	63%	62%	64%	64%	62%	61%	67%
30	New listings (#)	0	0	0	0	0	0	0
31	Listings (#)	0	0	0	0	0	0	0
32	Listing Growth Rate (%)		#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!
33	Average Listing Price (€)	0	0	0	0	0	0	0
34	Average supplier CAC (paid)) (€)	64	63	61	62	63	61	61
35	Suppliers acquired through paid (%)	23%	28%	24%	23%	21%	29%	18%
36	Average Supplier CAC (€)	15	20	26	31	37	60	44
37	Monthly Suppliers CAC	721	1083	1294	1894	2315	4765	3615
38	Revenue by top 20% of suppliers (%)	39%	37%	38%	39%	41%	40%	37%
39	Average revenue/seller (€)	52	90	64	59	52	50	57
40
41	Demand (buyers)
42	New buyers (#)	59	84	129	158	185	211	298
43	Resurrected (#)	0	0	9	12	19	3	4
44	Churn (#)	0	-12	-14	-38	-61	-57	-77
45	Buyers (#)	59	131	255	387	530	687	912
46	Buyers Growth Rate MoM		122%	95%	52%	37%	30%	33%
47	Quick ratio (new+res)/churn		7.00	9.86	4.47	3.34	3.75	3.92
48	Buyers Net Promoter Score	78%	82%	84%	84%	84%	79%	85%
49	Demand Fulfillment Rate (%)	83%	88%	89%	83%	85%	80%	87%
50	Average Buyers CAC (paid) (€)	43	42	43	41	40	41	42
51	Suppliers acquired through paid (%)	13%	14%	15%	11%	13%	10%	12%
52	Average Buyers CAC (€)	5.59	5.88	6.45	4.51	5.2	4.1	5.04
53	Monthly Buyers CAC	330	494	832	713	962	865	1502
54	Average Order Frequency (AOF)	1.1	1.2	0.6	0.5	0.4	0.3	0.3
55	AOF growth MoM		7.7%	-44.6%	-26.1%	-16.3%	-12.7%	0.1%
56	Average purchase/buyer (€)	40	43	42.8	42.8	43	43	43.2
57	Revenue/buyer (€)	43	50	28	20	17	15	15
58	Reccuring Buyers (%)		51%	59%	62%	63%	65%	67%
59	GMV from Reccuring Buyers (%)		53%	63%	64%	65%	67%	69%
60	GMV by top 20% of buyers (%)	29%	27%	28%	29%	21%	20%	27%
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