Sample Marketing Expenses Breakdown

	A	B	C	D	E	F	G	H	I	J	L	M
1	Marketing Channel	Hard Costs	Time Spent (Hours)	Team Costs	Total Costs	Goal Type	Goal Count	Value per Goal	Total Goal Value	Channel ROI	Team Hourly Rate:	$100

2	Blogging	$0	250	$25,000	$25,000	eBook downloads	1,000	$150	$150,000	6.00
3	TV Commercials	$100,000	20	$2,000	$102,000	Impressions	20,000	$0.05	$1,000.00	0.01
4	Affiliate Partnerships	$35,000	150	$15,000	$50,000	Sales	40	$5,000	$200,000	4.00
5	Trade Shows	$60,000	100	$10,000	$70,000	Sales meetings	200	$300	$60,000	0.86
6	Email Marketing	$2,000	250	$25,000	$27,000	SQLs	50	$1,000	$50,000	1.85
7	LinkedIn Ads	$5,000	20	$2,000	$7,000	eBook downloads	75	$150	$11,250	1.61
8	LinkedIn (unpaid)	$1,000	100	$10,000	$11,000	Website visits	5,000	$1	$5,000	0.45
9	Facebook Ads	$5,000	20	$2,000	$7,000	eBook downloads	100	$150	$15,000	2.14
10	Facebook (unpaid)	$1,000	100	$10,000	$11,000	Website visits	5,000	$1	$5,000	0.45
11	Cold Calling	$0	200	$20,000	$20,000	Sales meetings	20	$300	$6,000	0.30
12				$0	$0				0	#DIV/0!
13				$0	$0				0	#DIV/0!
14				$0	$0				0	#DIV/0!
15				$0	$0				0	#DIV/0!
16				$0	$0				0	#DIV/0!
17				$0	$0				0	#DIV/0!
18				$0	$0				0	#DIV/0!
19				$0	$0				0	#DIV/0!
20				$0	$0				0	#DIV/0!
21				$0	$0				0	#DIV/0!
22				$0	$0				0	#DIV/0!
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