Actions: Download Media Plan

The Actions button on the planning mode provides media plan Downloads. Selecting a download creates a media plan report of the applicable fields in Microsoft Excel Worksheet (.xslx) file format. You select the following Download options from the Actions drop menu:

  • Media Plan (Net)
  • Media Plan (Gross)

The net or gross media plan report appears in your download folder. The report contains a header and a table. 

The Media Plan reports display a separate add-ons section below the line items containing the data for a single campaign. Each row represents a single add-on. The Media Plan table displays the fields applicable to add-ons under the description.

Actions - Downloading a Media Plan

Campaign_Planning_-Proposals_-_Actions_Download_Media_Plan1.png

Campaign_Planning_-Proposals_-_Actions_Download_Media_Plan2.png

Campaign_Planning_-Proposals_-_Actions_Download_Media_Plan3.png

Download - Media Plan (Net or Gross) Fields

Header Fields

Title

Description

Example

Report File Name

Title of the Microsoft Excel file

Report name follows the following formats:

 
Net: campaignID_Media_Plan_Net 1454_Media_Plan_Net.xlsx
Gross: campaignID_Media_Plan 1454_Media_Plan.xlsx
campaign ID_Media-Plan_Vendor 2321_Media-Plan_Vendor.xlsx

Brand

Name of brand

Wholefoods

Client Name of client 123 Media

Proposal Date

Date of the creation and download of the report (m/d/yyyy)

6/7/2016

Initiative Name of initiative Spring Special
Campaign Name of campaign Organic Fruit

Campaign ID

Unique Identification number of the campaign 

JS001

First Objective

Type/name of objective

Continues with Second and Third if applicable

New Product Launch
First KPI

Type/name of objective

Continues with Second and Third if applicable

Brand Lift

Download Report Fields

Name

Description

Example

Property

Location or website of the ad space

Add-ons: Service Provider/Type

http://www.jones.com

Add-ons: Nielsen/Brand Study

Line Item

Description such as target, market, and category

Add-ons: Description of the add-on service

Tech, Science, US & World; Geo-target to Chicago, San Fran, and Toronto

Add-ons: Brand Study with monthly fee

Platform

Property digital ad type

Mobile, Tablet, or Web Browser

Format

Ad configuration type of creative

Display, Video, Audio, or Text

Size

Dimensions of the ad placement, if applicable

Width x Height (WxH) pixels

160x600, 300x600, or 230x33

Start Date

First day of the campaign based on the accepted insertion order, in this format: m/d/yyyy

Add-ons: First day of the applied add-on for billing

6/1/15

End Date

Last day of the campaign based on the accepted insertion order, in this format: m/d/yyyy

Add-ons: Last day of the applied add-on

6/30/15

Rate Type

Online ad space type rate (clicks, impressions, views, or actions) per the units. The “units” depend on the Rate Type selection.

Add-ons: Flat

CPM
Impressions Quantity of units (CPM, Dynamic CPM, Flat imps, AV imps) 90,000
CPM Price per unit (CPM, Dynamic CPM, Flat imps, AV imps) $1.00
Clicks Quantity of units (CPC, Dynamic CPC) $1.00
CPC Price per unit (CPC, Dynamic CPC) $1.00
Completed Views Quantity of units (CPCV, Dynamic CPCV, Flat Completed Views, AV Completed Views) 90,000
Cost per Completed View Price per unit (CPCV, Flat Completed Views, AV Completed Views) $1.00
Actions Quantity of units (CPA) 90,000
Cost per Action Price per unit (CPA) $1.00
Views Quantity of units (CPV, Flat Views, AV Views) 90,000
Cost per View Price per unit (CPV, Flat Views, AV Views) $1.00
Viewable Impressions Quantity of units (CPVI) 90,000
Cost per Viewable Impressions Price per unit (CPVI) $1.00

Total Units

Number of units (clicks, impressions, views, or actions) delivered

7,106,305

SOV

Share of Voice

95%
Rate Cost measurement by quantity of frequency CPM

Est. Rate

Estimated cost measurement by quantity of frequency CPM
Cost

Value or price of advertising products and services

Add-ons: Net (add-ons) or gross cost

$40,505.94
Property Subtotal

Sum of the costs per metric for the property

$22,000.00

Total (Plan) Sum of the costs per metric for the campaign

$42,000.00

Note: The Excel file displays values in the fields. The fields are not calculated.

 

Was this article helpful?
0 out of 0 found this helpful