IC-Digital-Marketing-Media-Buying-Plan-Template-Example_Google_Sheets

	B	C	D	E	F	G	H	I	J	K	L	M
1

2	DIGITAL MARKETING MEDIA BUYING PLAN TEMPLATE EXAMPLE								https://www.smartsheet.com/try-it?trp=11803&utm_source=integrated-content&utm_campaign=/content/media-plan-templates&utm_medium=Digital+Marketing+Media+Buying+Plan+Example+google+sheets+11803&lpa=Digital+Marketing+Media+Buying+Plan+Example+google+sheets+11803
3	Enter data in non-shaded / white cells, only.
4	TOTAL IMPRESSIONS NEEDED in Campaign to Reach Goal	TOTAL IMPRESSIONS	OVER (UNDER) GOAL		TOTAL RESPONSE RATE	CONVERSION RATE OF TOTAL RESPONSES	TOTAL NO. OF RESPONSES	TOTAL NO. OF CONVERSIONS	TOTAL COST	COST PER IMPRESSION	COST PER RESPONSE	COST PER CONVERSION
5	500	370	(130)		34.19%	6.09%	127	8	$ 467.50	$ 1.26	$ 3.70	$ 60.71
6
7		IMPRESSIONS	COSTS		RESPONSE & CONVERSION		PROJECTED OUTCOME		COST PROJECTIONS
8	MEDIA TYPE	ESTIMATED NO. OF IMPRESSIONS	COST PER IMPRESSION	FIXED COST FOR THIS MEDIA	ESTIMATED RESPONSE RATE	EST. % OF RESPONDERS THAT WILL CONVERT	NO. OF RESPONSES	NO. OF CONVERSIONS	TOTAL COST	COST PER IMPRESSION	COST PER RESPONSE	COST PER CONVERSION
9	SOCIAL MEDIA						0	0	$ -
10	Platform A	65	$ 1.50		30.00%	10.00%	19.5	2.0	$ 97.50	$ 1.50	$ 5.00	$ 50.00
11	Platform B	50	$ 1.00	$ 45.00	50.00%	17.00%	25.0	4.3	$ 95.00	$ 1.90	$ 3.80	$ 22.35
12	Platform C	50	$ 1.00	$ 65.00	60.00%	5.00%	30.0	1.5	$ 115.00	$ 2.30	$ 3.83	$ 76.67
13	Platform D	80	$ 2.00		65.00%		52.0	0.0	$ 160.00	$ 2.00	$ 3.08
14	TELEMARKETING								$ -
15	Outbound calling	50					0.0	0.0	$ -	$ -
16	Inbound call handling	75					0.0	0.0	$ -	$ -
17	ONLINE								$ -
18	Email campaigns						0.0	0.0	$ -
19	Organic search						0.0	0.0	$ -
20	Blogs						0.0	0.0	$ -
21	Paid search						0.0	0.0	$ -
22	Webinars						0.0	0.0	$ -
23	EVENTS								$ -
24	Event A						0.0	0.0	$ -
25	Event B						0.0	0.0	$ -
26	Event C						0.0	0.0	$ -
27	DIRECT MAIL								$ -
28	Type A						0.0	0.0	$ -
29	Type B						0.0	0.0	$ -
30	TRADITIONAL MEDIA								$ -
31	Print ads						0.0	0.0	$ -
32	In-store						0.0	0.0	$ -
33	Radio						0.0	0.0	$ -
34	Television						0.0	0.0	$ -
35
36	CLICK HERE TO CREATE IN SMARTSHEET
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