KPI Reporting Template

	A	B	C	D	E	F	G
1
2
3		LINKEDIN KPI TRACKING SPREADSHEET
4
5		SALE VALUE	ACQUISITION RATE		Add your data
6		$ 24,000	10%		to cells this color
7
8
9		Invitation Acceptance Rates
10		CONNECTION STATUS	QUANTITY	%
11		Accepted	1,017	29%
12		List - Pending	2,500	71%
13		Total Invitations Sent	3,517
14
15
16
17
18
19
20		Connection Status
21		SEGMENT	QUANTITY	%
22		List - No Reply	500	49%
23		List - Not A Lead	100	10%
24		List - Replied - in funnel	350	34%
25		List - Converted to sales funnel	57	6%
26		List - Client	10	1%
27		Total	1,017
28
29
30
31
32
33
34		Active Users
35		SEGMENT	QUANTITY	%
36		List- Not A Lead	100	19%
37		List - Replied - in funnel	350	68%
38		List - Converted to sales funnel	57	11%
39		List - Client	10	2%
40		Total	517
41
42
43
44
45
46
47		Campaign Expectations
48		CONNECTION REQUESTS	ACCEPT	CONVERTED TO SALES FUNNEL	EST. ACQUISITIONS	TOTAL SALES	AVERAGE VALUE OF EACH CONNECTION
49		700	202	11	1.13	$ 27,228	$134.51
50		2000	578	32	3.24	$ 77,794	$134.51
51		2500	723	41	4.05	$ 97,242	$134.51
52		3000	868	49	4.86	$ 116,690	$134.51
53
54
55
56		Estimating List Value
57		LIST COUNT	ACCEPT CONNECTION REQUEST	CONVERTED TO SALES FUNNEL	EST. ACQUISITIONS	TOTAL SALES
58		12000	3,470	194	19.45	$ 466,761
59
60
61
62		Estimating Time Investment (DIY)
63		ACTION	QUANTITY	TIME PER ACTION h:mm:ss	TOTAL TIME h:mm:ss
64		Connection Request	1,000	0:00:20	5:33:20
65		1st Message	289	0:00:30	2:24:35
66	3	Follow Ups (if no reply)	426	0:00:20	2:22:10
67		Reply to Active	147	0:01:00	2:27:00
68		Add Conversions to CRM	16	0:05:00	1:21:02
69		Estimated Acquisitions	2
70
71		Total Time	14:08:07
72		Time Per Lead	0:52:20
73		Time Per Acquisition	8:43:18
74		Acquisition Value	$24,000
75
76
77
78		Estimating Time Investment (Working With Virtual Assistant)
79		Hourly Rate - VA	$15.00
80		Hourly Rate - You	$75.00
81
82		ACTION	QUANTITY	TIME PER ACTION h:mm:ss	TOTAL TIME h:mm:ss
83		Connection Request	1,000	0:00:20	5:33:20	VIRTUAL ASSISTANT
84		1st Message	289	0:00:30	2:24:35	VIRTUAL ASSISTANT
85	3	Follow Ups (if no reply)	426	0:00:20	2:22:10	VIRTUAL ASSISTANT
86		Reply to Active	147	0:01:00	2:27:00	YOU
87		Add Conversions to CRM	16	0:05:00	1:21:02	YOU
88		Estimated Acquisitions	2
89
90
91			Total Cost	Cost Per Lead	Time Per Lead	Cost Per Acquisition	Time Per Acquisition h:mm:ss
92		Virtual Assistant	$155	$10	0:38:16	$96	6:22:36
93		You	$285	$18	0:14:04	$176	2:20:42
94
95
96
97
98
99
100