Klar - Minimum Order Value Threshold Calculator

	B	D	E	F	G	H	I	K	L	M	N	O	P	Q	R	S	T	V	W	X	Y	AA	AB	AC	AD	AE	AF	AG
1	Minimum Order Value Threshold Calculator
2
3		Explainer Video:	https://www.loom.com/share/f5d464e2f709447680e8cb1ffe6bed21
4		Make your own copy of this file to fill it out via File -> Make a copy
5
6
7		CM2 New Customers per AOV Bucket									CM2 Repeat Customers per AOV Bucket									CM3 per AOV Bucket
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26	Input your own data in the "input" sheets
27	Input your own data in the "input" sheets
28	yellow = input field
29
30		Status Quo - Repeat Customer						Status Quo - New Customers										Adjusted - Repeat Customers				Adjusted - New Customers
31	AOV Bucket	Orders	Order Share	Revenue	Revenue Share	CM2 Status Quo - Repeat	CM2 Share Status Quo - Repeat	Orders	Order Share	Revenue	Revenue Share	CM2 Status Quo - New	CM2 Share	365d CLV	CAC	365d CM3	Total 365d CM3 Status Quo	Adj Order Share	Adj Orders	Adj Revenue	Adj CM2 - Repeat	Adj Order Share	Adj Orders	Adj CAC	Adj Revenue	Adj CM2 - New	Adj 365d CM3	Adj Total 365d CM3
32	Lost Orders																	7.00%	10,613	0	0	17.00%	26,917	0.00	0	0	0.00	0
33	0 - 9.99	2,349	1.55%	11,097	0.13%	-42,028	-1.08%	4,776	3.02%	33,586	0.47%	-17,106	-0.53%	-0.61	32	-32.61	-155,745	0.00%	0	0	0	0.00%	0	38.55	0	0	-39.01	0
34	10.00 - 19.99	7,513	4.96%	118,846	1.39%	31,199	0.80%	14,246	9.00%	216,654	3.03%	62,156	1.94%	16.68	32	-15.32	-218,249	0.00%	0	0	0	0.00%	0	38.55	0	0	-21.22	0
35	20.00 - 29.99	21,109	13.92%	550,037	6.42%	228,823	5.85%	38,459	24.29%	982,803	13.74%	417,174	13.01%	26.33	32	-5.67	-218,063	0.00%	0	0	0	0.00%	0	38.55	0	0	-11.41	0
36	30.00 - 39.99	16,635	10.97%	570,563	6.66%	259,933	6.65%	18,062	11.41%	616,213	8.62%	285,954	8.92%	40.17	32	8.17	147,567	16.00%	24,259	832,066	379,066	25.00%	39,584	38.55	1,350,470	626,686	2.90	114,746
37	40.00 - 49.99	26,063	17.19%	1,216,808	14.20%	541,883	13.86%	26,510	16.74%	1,235,914	17.28%	560,643	17.48%	49.78	32	17.78	471,348	22.00%	33,356	1,557,317	693,522	20.00%	31,667	38.55	1,476,346	669,709	12.74	403,286
38	50.00 - 59.99	24,946	16.45%	1,359,470	15.87%	614,157	15.71%	21,472	13.56%	1,163,514	16.27%	522,528	16.30%	57.41	32	25.41	545,604	18.00%	27,292	1,487,296	671,904	15.00%	23,750	38.55	1,286,975	577,974	20.60	489,243
39	60.00 - 69.99	15,755	10.39%	1,024,709	11.96%	469,751	12.02%	13,406	8.47%	869,673	12.16%	404,256	12.61%	71.07	32	39.07	523,772	12.00%	18,194	1,183,368	542,484	9.00%	14,250	38.55	924,440	429,714	34.67	494,094
40	70.00 - 79.99	12,187	8.04%	911,104	10.64%	430,044	11.00%	7,834	4.95%	587,461	8.22%	278,447	8.68%	69.8	32	37.8	296,125	8.50%	12,888	963,488	454,770	5.00%	7,917	38.55	593,670	281,390	33.05	261,663
41	80.00 - 89.99	6,763	4.46%	570,709	6.66%	280,148	7.17%	4,480	2.83%	377,456	5.28%	184,227	5.75%	83.84	32	51.84	232,243	4.43%	6,717	566,807	278,233	3.00%	4,750	38.55	400,211	195,334	47.54	225,808
42	90.00 - 99.99	5,232	3.45%	496,105	5.79%	237,071	6.06%	3,013	1.90%	285,503	3.99%	134,377	4.19%	87.51	32	55.51	167,252	3.45%	5,231	495,999	237,021	2.00%	3,167	38.55	300,069	141,233	51.22	162,193
43	100.00 - 109.99	3,330	2.20%	348,977	4.07%	171,626	4.39%	1,990	1.26%	208,476	2.92%	97,268	3.03%	97.07	32	65.07	129,489	2.20%	3,336	349,568	171,917	1.40%	2,217	38.55	232,226	108,348	61.06	135,344
44	110.00 - 119.99	2,263	1.49%	259,450	3.03%	127,750	3.27%	1,173	0.74%	134,351	1.88%	62,592	1.95%	101.54	32	69.54	81,570	1.49%	2,259	259,007	127,532	0.80%	1,267	38.55	145,081	67,591	65.53	83,000
45	120.00+	7,475	4.93%	1,128,329	13.17%	558,948	14.30%	2,915	1.84%	439,396	6.14%	214,156	6.68%	131.74	32	99.74	290,742	4.93%	7,475	1,128,309	558,938	1.80%	2,850	38.55	429,605	209,385	96.26	274,339
46
47	Total	151,620	100%	8,566,204	100%	3,909,304	100%	158,336	100%	7,151,000	100%	3,206,674	100%	46.49	32	14.49	2,293,656	100.00%	141,007	8,823,226	4,115,386	100.00%	131,419	38.55	7,139,094	3,307,364	20.12	2,643,715
48	Change Abs																		-10,613	257,022	206,082		-26,917	6.55	-11,906	100,690	5.63	350,059
49	Change %																		-7%	3.00%	5.27%		-17%	20%	0%	3%	38.87%	15.26%
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