Unit Metrics Calculator

	A	B	C	D	E	F	G	H
1	Metric <> Channel	Paid_LinkedIn	Paid_META	Paid_GoogleAds	Organic/Direct	Referral/Social	Others	Blended

2	Leads	340	101	102	103	104	105	855
3	MQL	140	46	47	48	49	50	380
4	SQL	10	26	27	28	29	30	150
5	Opp	4	11	12	13	14	15	69
6	Customers (Closed)	1	4	5	6	7	8	31
7	Pipeline	$500,000	$500,000	$500,000	$500,000	$500,000	$500,000	3,000,000
8	ARR (Closed)	$150,000	$150,000	$150,000	$150,000	$150,000	$150,000	900,000
9
10	Metric in % <> Channel	Paid_LinkedIn	Paid_META	Paid_GoogleAds	Organic/Direct	Referral/Social	Others	Blended
11	Lead_to_MQL	41%	46%	46%	47%	47%	48%	44%
12	MQL_to_SQL	7%	57%	57%	58%	59%	60%	39%
13	SQL_to_Opp	40%	42%	44%	46%	48%	50%	46%
14	Opp_to_Customer	25%	36%	42%	46%	50%	53%	45%
15	Avg Deal Size (ARR)	$150,000	$37,500	$30,000	$25,000	$21,429	$18,750	$29,032
16	MRR	$12,500	$3,125	$2,500	$2,083	$1,786	$1,563	$2,419
17
18	Costs	Paid_LinkedIn	Paid_META	Paid_GoogleAds	Organic/Direct	Referral/Social	Others	Blended
19	Marketing Spends	$20,000	$30,000	$40,000	$0	$0	$0	$90,000
20	Sales Spends	$0	$0	$0	$0	$0	$0	$0
21	Tools Spends	$5,000	$5,000	$5,000	$5,000	$5,000	$5,000	$30,000
22	Others	$0	$0	$0	$0	$0	$0	$0
23	TOTAL	$25,000	$35,000	$45,000	$5,000	$5,000	$5,000	$120,000
24
25	Revenue	Paid_LinkedIn	Paid_META	Paid_GoogleAds	Organic/Direct	Referral/Social	Others	Blended
26	Gross Margin	80%	80%	80%	80%	80%	80%	80%
27	Gross Revenue	$120,000	$120,000	$120,000	$120,000	$120,000	$120,000	$720,000
28
29	Unit Economics	Paid_LinkedIn	Paid_META	Paid_GoogleAds	Organic/Direct	Referral/Social	Others	Blended
30	Pipeline to Spend %	5%	7%	9%	1%	1%	1%	4%
31	Spend_to_GrossRevenue	21%	29%	38%	4%	4%	4%	17%
32	CAC	$25,000	$8,750	$9,000	$833	$714	$625	$3,871
33	LTV : CAC	4.8	3.4	2.7	24.0	24.0	24.0	6.0
34	CAC Payback	2	3	4	0	0	0	2
35
36	CP-Lead	$59	$297	$392	$0	$0	$0	$105
37	CP-MQL	$143	$652	$851	$0	$0	$0	$237
38	CP-SQL	$2,000	$1,154	$1,481	$0	$0	$0	$600
39	CP-Opp	$5,000	$2,727	$3,333	$0	$0	$0	$1,304
40	CP-Deal	$20,000	$7,500	$8,000	$0	$0	$0	$2,903
41
42
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