Export DCM Placement Import

The DCM Placement Import file (trafficking sheet) provides a DCM compliant upload of your media plan.  This will eliminate the need to manually input placements into DCM.  By uploading the file, it will also enable results to automatically flow back into the media plan.

There are 2 steps necessary to enable this file:

1. Configure the adapter (this only needs to be done once per account)
2. Set up the campaign

Configuring the DCM Adapter

In order for Bionic to connect with your DCM account, the adapter must be configured first.  Instructions for setting up the adapter can be found here.

This is a one-time step for each DCM account.

Configure Campaign Settings for DCM

Identify the DCM account to use

The campaign will need to know which DCM account to connect to. You will identify this in the Ad Serving settings for the campaign.  You can find instructions are here.

DCM Custom Columns

There are 2 fields DCM requires to ensure placements are set up correctly:

• DCM Placement Compatibility
• DCM Tag

You can set these up in the Other Columns section of the Campaign Settings

Click on the Select Columns button

Check mark the DCM Placement Compatibility and DCM Tag columns

Press Done

This will add the fields to your media plan.

If you do not see these 2 columns available in your list, they will need to be activated first.  Follow the instructions for activating columns here.

Populating DCM Columns

Once you have added the DCM columns to your media plan, you will need to populate the data.

DCM Placement Compatibility - Choose 1 of the options from the list, as applicable

DCM Tag - Choose 1 of the options from the list, as applicable

No Tag will opt to not include the placement in the download.

When including the DCM Tag and DCM Placement Compatibility custom columns, these are the values that will then be exported to the DCM spreadsheet.

DCM Tag	DCM Placement Compatibility	Placement Compatibility	Dimensions
Blank/Null	Blank/Null	Display	[Ad Unit]
Blank/Null	None Blank	[Selected DCM Placement Compatibility]	[Ad Unit]
Ad Serving	Blank/Null	Display	[Ad Unit]
Ad Serving	None Blank	[Selected DCM Placement Compatibility]	[Ad Unit]
Tracking Only	Any value including blank	Display	1x1
No Tag	Any value	Placement not exported

Exporting the DCM Placement Import File

To export the DCM Placement Import file, press the Export button on the upper right side of your media plan.

From the Export options, select the DCM Placement Import option

Press Export

The file will automatically output in a DCM compatible format.

When exporting data from Bionic into the DCM spreadsheet, Bionic will convert the Bionic cost methods to DCM cost methods. The translations are shown below, where you see N/A the cost method field in the DCM spreadsheet will be left blank.

Bionic Cost Method	Description	DCM Cost Method
CPA	Cost Per Action	CPA
CPM	Cost per 1000 impressions	CPM
CPC	Cost Per Click	CPC
CPL	Cost Per Lead	CPA
CPCV	Cost Per Completed View	CPA
CPP	Cost Per Point	N/A
CPV	Cost Per View	CPM
dCPM	Dynamic CPM	CPM
Each	Per Item	N/A
Flat	Flat Rate	Flat Imps
Make Good		CPM
PCI	Per Column Inch	N/A
Per Spot		N/A
Value Add	Included at no charge	CPM
vCPM	viewable CPM	vCPM
/Day	per Day	N/A
/Week	per Week	N/A
/Month	per Month	N/A
/4wk Period	per 4wk Period	N/A

When including the DCM Tag and DCM Placement Compatibility custom columns, these are the values that will then be exported to the DCM spreadsheet.

DCM Tag	DCM Placement Compatibility	Placement Compatibility	Dimensions
Blank/Null	Blank/Null	Display	[Ad Unit]
Blank/Null	None Blank	[DCM Placement Compatibility]	[Ad Unit]
Ad Serving	Blank/Null	Display	[Ad Unit]
Ad Serving	None Blank	[DCM Placement Compatibility]	[Ad Unit]
Tracking Only	Any value including blank	Display	1x1
No Tag	Any value	Placement not exported

Only Digital Channels will be exported to the DCM spreadsheet:

Audio
E-Newsletter
Native
Online Display
Search
Social
Video
Mobile Display
SMS