Advertising Media Plan Template for Cost Analysis and Annual Calendar

advertising media plan template

marketing planPrepare an annual media plan and budget for print and online advertising with downloadable worksheet package that helps businesses create a budget, review ad sizes and rates and develop an annual advertising calendar for scheduled media placements

Most small businesses can’t afford to use advertising or media buying agencies to help them evaluate print and online advertising opportunities, perform cost analysis comparisons or develop an annual calendar to visually track media placements throughout the year.

Although agencies typically work on commission of placements, many will not work with small businesses that have small advertising budgets because the potential commission for their time investment is not profitable. Therefore, creating an advertising media plan is typically a do-it-yourself exercise for small businesses.

Advertising media plan templateThis easy-to-follow Advertising Media Plan Template Package developed by SBMarketingTools.com will help small businesses gather advertising opportunity data, compare costs, set a budget and create an annual calendar for advertising placements.

Designed to be a tactical and detailed worksheet, the template can be used as an extension of a full detailed annual marketing plan or annual marketing calendar. The comprehensive, downloadable template package is a fully editable excel file that includes blank templates and sample data.

At one low cost, the template package can be used over and over for your business planning needs year after year.

The Advertising Media Plan Template Package can be purchased individually or as part of our Marketing Plan Bundle package (see details below).


I am so thankful I came across these templates - they are a life & time saver!

As the owner of a marketing consulting firm its just me currently doing all the work...
these templates make my work life easier & I will be able to get more done with them.

I was also pleasantly surprised at the speed of service when I had questions and I will DEFINITELY recommend you to others!

Barbara BlackBlack & White Marketing

Plan Purchased: Marketing Plan Bundle with Advertising Media Plan Template and Marketing Template Builder




Download Advertising Media Plan Template

One-Time Cost, Unlimited Use: Only $9.99

Click BUY NOW to Purchase Plan

Buy Now

IMPORTANT: Upon completion of payment, hit “Complete Purchase” to be directed to a page for instant download of the template package  – you will also be sent an email with a link to download the template. We use e-Junkie to deliver instant file download and PayPal for safe & secure payment via PayPal or a major credit card. (Click on “Pay by Credit Card or Debit Card” to see credit card payment options.)


How to Use the Template for an Advertising Cost Analysis and Media Plan Budget

The first step in creating an advertising media plan is identifying the target segments for your advertising (based on target audiences and/or geography) and the primary publications or websites that serve these segments. These publications or websites could be industry or trade, consumer-oriented or local media opportunities.

Advertising opportunities are typically available as downloadable media kits from the publication or website, or can be easily attained by contacting the listed sales representative for advertising. Reviewing the abundance of information available media kits and filtering out the advertising opportunities that are the best fit for your business (both by budget and targets) is the most laborious part of the exercise.

Once you have gathered advertising opportunity data from your target publications and/or websites, the template will help you compare costs. The advertising media plan template is a worksheet that allows businesses to fill in the blanks with ad sizes, rates and circulation figures for print or online advertising opportunities. The template includes built-in formulas that produce a cost-per-impression analysis to compare advertising opportunities and create a media budget.

Creating an Annual Calendar for Print and Online Advertising Plans

The advertising cost analysis process will help you determine what media opportunities are appropriate for your budget and desired advertising goals. After that analysis is complete, ad sizes and costs for selected publications or websites can be transferred onto the annual calendar template for your advertising plan. The calendar template will help you visually plan the timing of advertising in your target segments throughout the year for your various publication and websites.

When planning your advertising calendar, be careful to review the timing of other marketing plans (such as events or direct marketing) in your full annual marketing plan calendar to maximize promotional opportunities and maintain an integrated marketing approach.

Download Advertising Media Plan Template Package

Advertising media plan templateUse this advertising media plan template package to maximize your print and online advertising opportunities and budget. The layout is meant to be a guide that can be flexible for your individual business and advertising plans.

**Please note that some formulas in the spreadsheet may not work properly if the template format is altered.

WHAT’S IN THE PACKAGE:

The comprehensive, downloadable template package is a fully editable excel file developed by SBMarketingTools.com and includes the following worksheet tabs:

  • Advertising Media Cost Analysis (template) – blank version to fill in advertising opportunities with circulation, ad sizes, rates and notes
  • Advertising Media Cost Analysis (sample) – sample data to illustrate how the advertising media cost analysis template can be used
  • Media Plan and Calendar (template) – blank version to fill in advertising sizes and costs for your selected publications or websites for desired months throughout the year
  • Media Plan and Calendar (sample) – sample data to illustrate how the plan and calendar template can be used

Download Advertising Media Plan Template

One-Time Cost, Unlimited Use: Only $9.99

Click BUY NOW to Purchase Plan

Buy Now

IMPORTANT: Upon completion of payment, hit “Complete Purchase” to be directed to a page for instant download of the template package  – you will also be sent an email with a link to download the template. We use e-Junkie to deliver instant file download and PayPal for safe & secure payment via PayPal or a major credit card. (Click on “Pay by Credit Card or Debit Card” to see credit card payment options.)


 BUY MARKETING PLAN BUNDLE

marketing-plan-bundleBuy BOTH the Advertising Media Plan Template Package ($9.99 individually) and Marketing Plan Template Builder ($9.99 individually) and SAVE 20%.

Marketing Plan Template BUNDLE: Only $15.99 (Save 20%)
One-Time Cost, Unlimited Use of Both Plans.

Click BUY NOW to Purchase Bundle

Buy Now

IMPORTANT: Upon completion of payment, hit “Complete Purchase” to be directed to a page for instant download of the template package  – you will also be sent an email with a link to download the template. We use e-Junkie to deliver instant file download and PayPal for safe & secure payment via PayPal or a major credit card. (Click on “Pay by Credit Card or Debit Card” to see credit card payment options.)


Templates and resources developed by SBMarketingTools.com are created and/or reviewed by the editor of SBMarketingTools.com and are based on over 20 years of corporate marketing and small business marketing consulting experience.



The following two tabs change content below.

Editorial Staff

This article was written by SBMarketingTools.com editorial staff.