Media Plan Download

Media Plan Download

From the Actions button on a media plan page, clicking Media plan creates a Microsoft Excel Worksheet (.xlsx) file. The file provides a summary of the media plan details.

Note: When data is not applicable (empty), the cell is blank.

Download - Media Plan Fields

Title

Description

Example

Report File Name

Title of the Microsoft Excel file

 
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

Proposal Date

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

6/7/2016

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

http://www.jones.com

Line Item

Description such as target, market, and category

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

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

6/1/15

End Date

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

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.

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
Cost

Value or price of advertising products and services

$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.

Media Plan Download Microsoft Excel File

MP_dwnldmedplan_a_v.png DwnldMP_xlsx_raw.png
Was this article helpful?
0 out of 0 found this helpful