KPI_Mastery_Calculator.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	KPI MASTERY — Automatic Calculator (22 KPIs)
2	KPI MASTERY — Automatic Calculator (22 KPIs)
3	HOW TO USE: Yellow cells (blue text) = enter your own numbers. Green cells = result, calculated automatically. Example values are pre-filled — just overwrite them.
4	⚠ Before entering your numbers: File -> Make a Copy (or Download) -- do not edit this shared original.
5

6	#	KPI	Abbr.	Formula	Input 1	Value 1	Input 2	Value 2	Input 3	Value 3	Result	Unit
7	1	Cost Per Mille	CPM	(Ad Spend / Impressions) x 1000	Ad Spend	2000	Impressions	500000			4.00	$
8	2	Click-Through Rate	CTR	(Clicks / Impressions) x 100	Clicks	500	Impressions	10000			5.00	%
9	3	Cost Per Click	CPC	Ad Spend / Clicks	Ad Spend	500	Clicks	200			2.50	$
10	4	Conversion Rate	CR	(Conversions / Visitors) x 100	Conversions	50	Visitors	1000			5.00	%
11	5	Customer Acquisition Cost	CAC	Marketing Expenses / New Customers	Marketing Expenses	10000	New Customers	100			100.00	$
12	6	Return on Investment	ROI	((Revenue - Cost) / Cost) x 100	Revenue	25000	Cost	10000			150.00	%
13	7	Return on Ad Spend	ROAS	Revenue from Ads / Ad Spend	Revenue from Ads	20000	Ad Spend	5000			4.00	x
14	8	Customer Lifetime Value	CLV	Avg Purchase Value x Frequency x Lifespan	Avg Purchase Value	100	Purchase Frequency /yr	4	Customer Lifespan (yrs)	3	1,200.00	$
15	9	Engagement Rate	ER	(Engagements / Reach) x 100	Engagements	500	Reach	10000			5.00	%
16	10	Cost Per Acquisition	CPA	Ad Spend / Acquisitions	Ad Spend	5000	Acquisitions	50			100.00	$
17	11	Average Order Value	AOV	Revenue / Number of Orders	Revenue	10000	Number of Orders	200			50.00	$
18	12	Revenue Per Visitor	RPV	Revenue / Number of Visitors	Revenue	10000	Number of Visitors	5000			2.00	$
19	13	Net Promoter Score	NPS	%Promoters - %Detractors	% Promoters	60	% Detractors	20			40.00	pts
20	14	Repeat Customer Rate	RCR	(Repeat Customers / Total Customers) x 100	Repeat Customers	300	Total Customers	1000			30.00	%
21	15	View-Through Rate	VTR	(View-Through Conversions / Impressions) x 100	View-Through Conversions	10000	Total Impressions	1000000			1.00	%
22	16	Share of Voice	SOV	(Your Ad Spend / Total Market Ad Spend) x 100	Your Ad Spend	100000	Total Market Ad Spend	500000			20.00	%
23	17	Lead Conversion Rate	LCR	(Conversions / Leads) x 100	Conversions	150	Leads	1000			15.00	%
24	18	Cart Abandonment Rate	CAR	(1 - Completed Purchases / Carts Created) x 100	Completed Purchases	50	Carts Created	200			75.00	%
25	19	Upsell/Cross-Sell Conv. Rate	UCC	(Upsell Transactions / Total Transactions) x 100	Upsell/Cross-Sell Transactions	200	Total Transactions	1000			20.00	%
26	20	Customer Churn Rate	CCR	((Customers Start - Customers End) / Start) x 100	Customers at Start	200	Customers at End	180			10.00	%
27	21	Break Even ROAS	BROAS	1 / Profit Margin	Profit Margin (as decimal)	0.25					4.00	x
28	22	Click-to-Conversion Rate	CTR-to-CR	(Conversions / Clicks) x 100	Conversions	50	Clicks	500			10.00	%
29
30	© Mohamed Abd Rabou — KPI Mastery. Free to use and share as-is. abdrabou.com
31
32
33
34
35
36
37
38
39
40
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