ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
ADVERTISING MEDIA PLAN TEMPLATE
https://www.smartsheet.com/try-it?trp=11803&utm_source=integrated-content&utm_campaign=/content/media-plan-templates&utm_medium=Advertising+Media+Plan+google+sheets+11803&lpa=Advertising+Media+Plan+google+sheets+11803
3
User to enter Quantity, Projected Cost Per Unit, and additional Campaign Types. Subtotals and Chart Information will populate automatically.PROJECTED SUBTOTAL
TO DATE		 $ -
4
5
CAMPAIGN TYPEQTYPROJECTED
COST PER UNIT		PROJECTED
SUBTOTAL		COMMENTS
6
National Marketing $ -
7
Banner Ads1 $ -
8
 $ -
9
 $ -
10
Local Marketing $ -
11
Newspaper $ -
12
Outdoor Advertising $ -
13
POP $ -
14
In-Store Marketing $ -
15
 $ -
16
Public Relations $ -
17
Public Events $ -
18
Sponsorships $ -
19
Press Releases $ -
20
Webinars $ -
21
Conferences $ -
22
Client Events $ -
23
 $ -
24
Content Marketing $ -
25
Sponsored Content $ -
26
Landing Page $ -
27
White Papers / eBooks $ -
28
 $ -
29
Social Media $ -
30
Twitter $ -
31
Facebook $ -
32
Snapchat $ -
33
Instagram $ -
34
TikTok $ -
35
LinkedIn $ -
36
 $ -
37
 $ -
38
Online $ -
39
Blog $ -
40
Website $ -
41
Mobile App $ -
42
Mobile Alerts $ -
43
Email Newsletter $ -
44
 $ -
45
Advertising $ - ––––––– DATA POPULATES AUTOMATICALLY –––––––
46
Online $ - CAMPAIGN TYPESUBTOTAL%
47
Print $ - National Marketing $ - #DIV/0!
48
Outdoor $ - Local Marketing $ - #DIV/0!
49
Radio $ - Public Relations $ - #DIV/0!
50
Television $ - Content Marketing $ - #DIV/0!
51
 $ - Social Media $ - #DIV/0!
52
 $ - Online $ - #DIV/0!
53
Web $ - Advertising $ - #DIV/0!
54
Development $ - Web $ - #DIV/0!
55
Pay-Per-Click Marketing $ - Market Research $ - #DIV/0!
56
SEO $ - Campaigns $ - #DIV/0!
57
 $ - Other $ - #DIV/0!
58
 $ - $ -
59
Market Research $ -
60
Surveys $ -
61
Impact Studies $ -
62
 $ -
63
Campaigns $ -
64
Campaign A $ -
65
Campaign B $ -
66
Campaign C $ -
67
Campaign D $ -
68
Campaign E $ -
69
 $ -
70
Other $ -
71
Branding $ -
72
Business Cards $ -
73
Signage $ -
74
 $ -
75
 $ -
76
77
CLICK HERE TO CREATE IN SMARTSHEET
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100