Juvo Leads Metrics That Matter v2SHARED

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1		Metrics That Matter Monthly Channel Totals
2		CPI (Impression)		$29.31	CPS (Subscriber)		$392.53		Total Marketing Spend				$7,066	*To Make a copy Click "File" -> Make a Copy if you're signed into Google. Or "Download As" to download it in Excel. From there you can edit and make this your own.*
3									Total Case Value				$80,900
4		CPC (Click)		$4.87	COCA		$415.62		Lead = Message + Call + Chat
5		CPL (Lead)		$133.31					All Data here is pulled from other Tabs
6
7		COSTS
8	Traffic Source	Fixed	Variable	Other Spend	Sum	Impressions	Clicks	SUBs	MSGS	Calls	Leads (Msgs + Calls)	% Leads Converted	New Clients	Avg CT Value	Ttl Case Value	Channel COCA
9	SEO	$2,500	$0	$0	$2,500	32,000	780	21	8	8	16	17.24%	5	$5,000	$25,000	$500
10	Adwords	$1,616	$0	$0	$1,616	7,064	159	9	9	16	25	28.00%	7	$5,000	$35,000	$231
11	FB Ads	$700	$0	$0	$700	120,000	1,200	18	4	4	8	25.00%	2	$3,334	$10,000	$350
12	InPerson	$50	$950	$0	$1,000	0	0	2	1	3	4	50.00%	2	$2,800	$5,400	$500
13	Email Marketing	$50	$0	$0	$50	0	83		3	0	3	33.33%	1	$5,500	$5,500	$50
14	Directory #1	$1,200	$0	$0	$1,200	80,000	8		1	1	2	0	0	$3,000	$0	More than $1200
15
16
17
18
19
20
21	SUM	$3,616	$950	$0	$7,066	207,064	1,450	29	18	24	42	1	17	$4,106	$80,900	$415.62
22
23
24
25
26
27
28
29
30
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