ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
ADVERTISING MEDIA PLAN TEMPLATE EXAMPLE
https://www.smartsheet.com/try-it?trp=11803&utm_source=integrated-content&utm_campaign=/content/media-plan-templates&utm_medium=Advertising+Media+Plan+Example+google+sheets+11803&lpa=Advertising+Media+Plan+Example+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		 $ 70,025.00
4
5
CAMPAIGN TYPEQTYPROJECTED
COST PER UNIT		PROJECTED
SUBTOTAL		COMMENTS
6
National Marketing $ 2,000.00
7
Banner Ads4$500.00 $ 2,000.00
8
 $ -
9
 $ -
10
Local Marketing $ 13,200.00
11
Newspaper6$600.00 $ 3,600.00
12
Outdoor Advertising2$3,500.00 $ 7,000.00
13
POP2$500.00 $ 1,000.00
14
In-Store Marketing4$400.00 $ 1,600.00
15
 $ -
16
Public Relations $ 800.00
17
Public Events $ -
18
Sponsorships $ -
19
Press Releases8$100.00 $ 800.00
20
Webinars $ -
21
Conferences $ -
22
Client Events $ -
23
 $ -
24
Content Marketing $ 14,400.00
25
Sponsored Content $ -
26
Landing Page12$1,200.00 $ 14,400.00
27
White Papers / eBooks $ -
28
 $ -
29
Social Media $ 6,800.00
30
Twitter20$100.00 $ 2,000.00
31
Facebook20$100.00 $ 2,000.00
32
Snapchat10$100.00 $ 1,000.00
33
Instagram10$100.00 $ 1,000.00
34
TikTok4$100.00 $ 400.00
35
LinkedIn4$100.00 $ 400.00
36
 $ -
37
 $ -
38
Online $ 3,200.00
39
Blog4$800.00 $ 3,200.00
40
Website $ -
41
Mobile App $ -
42
Mobile Alerts $ -
43
Email Newsletter $ -
44
 $ -
45
Advertising $ 11,700.00 ––––––– DATA POPULATES AUTOMATICALLY –––––––
46
Online4$2,500.00 $ 10,000.00 CAMPAIGN TYPESUBTOTAL%
47
Print2$850.00 $ 1,700.00 National Marketing $ 2,000 3%
48
Outdoor $ - Local Marketing $ 13,200 19%
49
Radio $ - Public Relations $ 800 1%
50
Television $ - Content Marketing $ 14,400 21%
51
 $ - Social Media $ 6,800 10%
52
 $ - Online $ 3,200 5%
53
Web $ 6,400.00 Advertising $ 11,700 17%
54
Development1$6,400.00 $ 6,400.00 Web $ 6,400 9%
55
Pay-Per-Click Marketing $ - Market Research $ 4,800 7%
56
SEO $ - Campaigns $ 5,900 8%
57
 $ - Other $ 825 1%
58
 $ - $ 70,025
59
Market Research $ 4,800.00
60
Surveys6$800.00 $ 4,800.00
61
Impact Studies $ -
62
 $ -
63
Campaigns $ 5,900.00
64
Campaign A1$5,900.00 $ 5,900.00
65
Campaign B $ -
66
Campaign C $ -
67
Campaign D $ -
68
Campaign E $ -
69
 $ -
70
Other $ 825.00
71
Branding $ -
72
Business Cards15$55.00 $ 825.00
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