Importing Media Plans

Importing Media Plans

Importing Media Plans allows users with media buying rights to save time by importing large amounts of data from a source file into MarketingPilot.  The media plan import does not create new entities, it maps to existing data that has already been created in the application.  For example, if your media outlet, vendor, or rate has not already been created in the application, you cannot create them by putting them on the import source file. 

Imported media plans cannot be hard deleted.  They can be edited them or soft deleted after the import, but they cannot be hard deleted.  Try importing small single line item plans first in order to get familiar with the process and results of the field mapping. 

Before preparing your source file, open up a Media Plan and view the columns available to see what values are pulled in and compare those to what is entered on your source file for accuracy.

The import will not overwrite or update an existing media plan.  It is for creating new plans only.

Below are some guidelines to help with the process and best practice tips. 

Media Plan Outlets, Vendors, and Rates

The entries in the source file must be an exact match of what is stored in the application for all media outlet names in order for the import to be successful.  If any are not a direct match, such as extra or missing spaces or punctuation not included or varied in any way between the two, the import will fail. 

Examples:

In addition to media outlets, other fields that you are mapping must also be an exact match or they will not be imported.  If the Media Outlets match, the import will succeed but other values can fail to import if they are not an identical match.

Examples of commonly used fields that require an exact match are Vendor Contact, Rates, Expense and Revenue Accounts (when importing accounts make sure you use the account name only – not the number), Advertisement, Market, etc. 

Note – Vendor Contact pulls from the Display As name so must appear on your source file in that format.  The Display As name can be seen on the contact details tab

Screenshot of Contact page for display as name:

Examples:

Below is a basic example of a source file for import:

If you have rates defined on your media outlet, you can use Rates on the import and do not need to enter the cost, price, commission values – they will pull from the imported rate.  

Below is a basic example of source file for import with a rate:

Example of rate in MarketingPilot for Fox 47 media outlet:

The values defined on the rate will pull into the line item when the rate is imported:

Media Plan Dates and Times

Media plans have a start and end date parameter for the plan, and the line items also have start and end dates as well as start and end times.  The line items within the plan must fall in between the start and end date parameters of the plan.  This is easily identifiable when manually entering a media plan, however, when doing an import there are some tips to keep in mind. 

On your import you can identify a Run Date, Start Date, and End Date.  While only the Run Date is required, it may be easier for more complex plans if your source file has all three date fields (Run, Start, and End) defined. 

However, if all the orders on the plan are for specific date, then you only need to identify a Run Date on your source file for each line item.  If you only identify a Run Date on your plan, this will define the Start and End date parameters of the plan and the start and end dates for each order. 

Source file example Run Date import only:

The start and end date of the plan uses the earliest date (6/01) and the latest date (6/07) from the Run Date field to define the plan parameters:

And the start and end date for each order are also taken from what is identified for that line item:

If your individual orders will span over a date range, then you will want to add Start Date and End Date fields to your source file.  

Tip – notice the run date columns in the source file above.  When you have a Start and End dates defined they will drive the line item start and end dates.  Use your Run Date field to define the start and end parameters for the plan.  In this example, the line items go from 6/01 thru 6/30, so the Run Date fields must encompass the full span of all line item dates. 

NoteYou could also set a Run Date of 5/01/2011 and 7/01/2011, as long as the date values allow the full date range of all line items your plan will import correctly. 

The imported plan header results:

And the line items results:

If your line items require start and end times, you can add those to your source file within the Start Date and End Date fields as shown in the example below:

Result of import header:

And the line items with start and end dates and times:

Example of a slightly more complex import source file:

Screenshot of result of import:

For more information on MediaPlans please visit the MarketingPilot online help.

Advertisements