This media plan template will help you get started with your media planning. It gives you the basic structure and formulas (see below). Click to download.
Features of the Media Plan Template
Although it’s impossible to replicate all the features of full-fledged media planning software in Microsoft Excel, this free media plan template has the basics to get you started.
18 Built-in Media Cost Calculations
There are a lot of different ways to price out advertising media. Below are the Cost Methods supported by the media plan template:
CPA
CPM
CPC
CPCV
CPL
CPP
CPV
dCPM
Each
Flat
Makegood
PCI
Per Spot
Value Add
vCPM
/day
/week
/Month
24 Media Channels Supported
The following media channels are supported by the media plan template:
Broadcast
Radio
Television
Digital
Audio
E-Newsletter
Native
Online Display
Search
Social
Video
Direct
Email Broadcast
Fax Broadcast
Postal
Mobile
Mobile Display
SMS
Print
Free Standing Insert
Magazine
Newspaper
Out of Home
Airborne
Billboard
Digital Out of Home
Furniture
Kiosk
Point of Sale
Transit
Other
Other