Using a CSV file to update or create campaigns is an easier way to work, especially when you run several campaigns at a time. It allows you to create or update campaigns without the need to go through the platform.

 

You can start by downloading the existing campaigns into a CSV file that includes all the campaigns’ data, adjusting the file as necessary, then uploading it back into the system. Your campaigns will then be automatically updated according to your modifications. Alternatively, you can download an empty template and fill it with the relevant data in order to create new campaigns. 


You can use the same file for for both updating existing campaigns and creating new campaigns. For example, you can download the existing campaigns into a CSV file, and in the same file, add new rows for the campaigns that you wish to create. 


General Concept

In the CSV file, each row represents one campaign.

You can either create a new campaign or update an existing one. When you export campaigns, existing campaigns will have an ID in the ID field. When you upload a CSV file, if there’s an ID in the ID column, the system knows that it’s an existing campaign that you are updating. If the ID field is empty, the system will create a new campaign based on the information in that specific line. 


It's important to note that the CSV bulk upload system supports only files in which values are delimited by a comma (","), such as CSV files.Uploading files that are not in that format will result in data error.


Download Existing Campaigns into a CSV file

Download All Campaigns

In order to export your existing campaigns into a CSV file, navigate to Campaigns, click on ‘Download CSV’ button and choose ‘Download Campaigns’. This action will download all your campaigns into a CSV file, except for your Removed campaigns. If you want the file to also include the Removed campaigns, choose the option ‘Download Campaigns (including Removed)’.


Download Group’s Campaigns

In order to export the campaigns of a specific group, navigate to a specific group, click on ‘Download CSV’ button and choose ‘Download Campaigns’. This action will download all your campaigns into a CSV file, except for the Removed campaigns. If you want the file to also include the Removed campaigns, click on ‘Show Removed’ and then click on ‘Download CSV’. 


Download an Empty Template

In order to download an empty template, navigate to ‘Tools’ > ‘CSV Campaign Update’. On the right hand side, under ‘Did You Know?’, click on ‘Download a CSV template’.


Upload a CSV File

In order to upload a CSV file: 

  1. Navigate to ‘Tools’ > ‘CSV Campaign Update’.

  2. Choose a CSV file to upload.

  3. Review the information in the Preview screen.

  4. Press the ‘Update/Create Campaigns’ button in order to complete the upload and update/create process.

In case of errors in the file, you should fix the errors and upload the file again in order to be able to complete the update/upload process.


Column Description and Valid Values

Below is the list of columns in the CSV file. Fields marked in * are mandatory.

 

Field Name

Type

ID

A unique ID which is issued by the system, in order to uniquely identify the campaign. This field should not be altered by the user. 

When creating a new campaign, leave this field empty. If the ID field is left empty, the system will create a new campaign.

GroupName*

This is the group’s name. You can create a new group with the CSV feature, by writing in this field a group name that does not yet exist in the system. 

Name*         (A.K.A. Campaign name)

The name of the campaign. You can create a new campaign name or update the existing one.

Status

This reflects the status of the current campaigns and will be filled only when exporting existing campaigns.
When updating a campaign, this field should not be changed.

In order to change the campaign’s status use the ‘Action’ field (see below).

When creating a new campaign, this field should be: Pending

Action

Use this field to change the status of existing campaigns.

Available values are: Pause, Remove, Resume.
You can change the status of an existing campaign.

Active Keywords

Current Keywords or Keywords you want to add.

Each Keyword should be separated by a pipe (“|”)

Example: casino|casino offer|online casino

Blocked Keywords

Current Keywords or Keywords you want to block.

Each keyword should be separated by a pipe (“|”)

Example: casino|casino offer|online casino

Daily Budget*

The daily budget per campaign, in USD.

CPV*

The bid per view/Impression, in USD.

Full page PPV*

Can be TRUE/FALSE

Domain Redirect*       

Can be TRUE/FALSE (mutually exclusive with Full Page PPV)

Destination URL*

The URL of your Landing page. You can use the @@SOURCE@@ or @@CAMPAIGN-KEYWORD@@ tokens in your URLs, and we'll provide you the source (site) ID or the campaign Keyword that was matched to your landing page for easy tracking. If conversion tracking is enabled, the URL must also include the @@CLICK-ID@@ token.

Track Conversions*

Can be TRUE/FALSE.

If you want to track conversions, select TRUE, alternatively select FALSE.

If you are tracking conversion, make sure to implement the @@CLICK-ID@@ token in your destination URL.

Default Conversion Value

In case you wish to track conversions, please insert the value of conversion. If you are not tracking conversions, leave it blank.

Black List

Add the source IDs you wish to block. Each source should be separated by a pipe (“|”)

Example: 4228595|6828797|7426531

White List

Add specific sources (Whitelist) you want the campaign to run on.

Each source should be separated by a pipe (“|”)

Example: 4228595|6828797|7426531

Countries

A two letter country code (ISO Alpha 2)

For multiple GEOs, use a pipe (“|”) as separator.

To target all GEOs, you can either leave the field empty or type ALL.

Example: MX|PL|SG|TR|ZA

Desktop       

Type ALL or leave blank.

Tablet

Type ALL or leave blank.

Smartphone

Type ALL or leave blank.

Windows

Type ALL to target all Windows versions, or type a specific version. Values should be separated by a pipe ("|"). To detarget this option, leave this field blank.

List of valid versions:

WINDOWS_10, WINDOWS_81, WINDOWS_RT, WINDOWS_8, WINDOWS_7, WINDOWS_VISTA, WINDOWS_2000, WINDOWS_XP, WINDOWS_10_MOBILE, WINDOWS_PHONE10, WINDOWS_PHONE8_1, WINDOWS_PHONE8, WINDOWS_MOBILE7, WINDOWS_PHONE, WINDOWS_MOBILE, WINDOWS_98,XBOX_OS

*To target a specific versions and higher versions add '+' after the OS name. For example: WINDOWS_7+

Mac

Write ALL to select this option or leave it blank to detarget it.

Linux

Type ALL to target all Linux versions, or type a specific version. Values should be separated by a pipe (“|”). To detarget this option, leave this field blank.

List of valid versions:

UBUNTU, UBUNTU_TOUCH_MOBILE

Android

Write ALL to target all Android versions, or enter a specific version. Values should be separated by a pipe ("|") .To detarget this option please leave the field blank.

List of valid values:

ANDROID7, ANDROID7_SETTOPBOX, ANDROID7_TABLET, ANDROID6, ANDROID6_SETTOPBOX, ANDROID6_TABLET, ANDROID5, ANDROID5_SETTOPBOX, ANDROID5_TABLET, ANDROID4, ANDROID4_SETTOPBOX, ANDROID4_TABLET, ANDROID4_WEARABLE, ANDROID3_TABLET, ANDROID2, ANDROID2_TABLET, ANDROID1, ANDROID_MOBILE, ANDROID_TABLET

*To target a specific versions and higher versions add '+' after the OS name. For example: ANDROID6+

Chrome OS

Write ALL to select this option or leave it blank to detarget it.

iOS

Write ALL target all iOS versions or type a specific version. Values should be separated by a pipe (“|”) .To detarget this option please leave the field blank.

List of valid values:

iOS10_IPHONE, iOS10_IPOD, iOS9_IPHONE, iOS9_IPOD, iOS8_4_IPHONE, iOS8_3_IPHONE, iOS8_3_IPOD, iOS8_2_IPHONE, iOS8_1_IPHONE, iOS8_IPHONE, iOS7_IPHONE, iOS7_IPOD, iOS6_IPHONE, iOS6_IPOD, iOS5_IPHONE, iOS5_IPOD, iOS4_IPHONE, iOS4_IPOD, iOS3_IPHONE, MAC_OS_X_IPAD, iOS10_IPAD, iOS9_IPAD, iOS8_4_IPAD, iOS8_3_IPAD, iOS8_2_IPAD, iOS8_1_IPAD, iOS8_IPAD, iOS7_IPAD, iOS6_IPAD, iOS5_IPAD, iOS4_IPAD, iOS3_IPAD, MAC_OS_X_IPOD, MAC_OS_X_IPHONE

*To target a specific versions and higher versions add '+' after the OS name. For example: iOS9_IPHONE+

Other OS

Write ALL to select this option or leave it blank to detarget it.  

Chrome

Write ALL to target all Chrome versions or type a specific version. Values should be separated by a pipe (“|”). To detarget this option, please leave the field blank.

List of valid values:

CHROME_MOBILE, CHROME62, CHROME61, CHROME60, CHROME59, CHROME58, CHROME57, CHROME56, CHROME55, CHROME54, CHROME53, CHROME52, CHROME51, CHROME50, CHROME49, CHROME48, CHROME47, CHROME46, CHROME45, CHROME44, CHROME43, CHROME42, CHROME41, CHROME40, CHROME39, CHROME38, CHROME37, CHROME36, CHROME35, CHROME34, CHROME33, CHROME32, CHROME31, CHROME30, CHROME29, CHROME28, CHROME27, CHROME26, CHROME25, CHROME24, CHROME23, CHROME22, CHROME21, CHROME20, CHROME19, CHROME18, CHROME17, CHROME16, CHROME15, CHROME14, CHROME13, CHROME12, CHROME11, CHROME10, CHROME9, CHROME8

*To target a specific versions and higher versions add '+' after the browser name. For example: CHROME62+

Microsoft Edge

Write ALL o target all Microsoft Edge versions or type a specific version. Values should be separated by a pipe (“|”). To detarget this option, please leave the field blank.

List of valid values:

EDGE_MOBILE, EDGE_MOBILE17, EDGE_MOBILE16, EDGE_MOBILE15, EDGE_MOBILE14, EDGE_MOBILE13, EDGE_MOBILE12, EDGE17, EDGE16, EDGE15, EDGE14, EDGE13, EDGE12

*To target a specific versions and higher versions add '+' after the browser name. For example: EDGE_MOBILE15+

Firefox

Write ALL to target all FireFox versions or type a specific version. Values should be separated by a pipe (“|”). To detarget this option please leave the field blank.

List of valid values:

FIREFOX3MOBILE, FIREFOX_MOBILE, FIREFOX_MOBILE23, FIREFOX_MOBILE_IOS, FIREFOX58, FIREFOX57, FIREFOX56, FIREFOX55, FIREFOX54, FIREFOX53, FIREFOX52, FIREFOX51, FIREFOX50, FIREFOX49, FIREFOX48, FIREFOX47, FIREFOX46, FIREFOX45, FIREFOX44, FIREFOX43, FIREFOX42, FIREFOX41, FIREFOX40, FIREFOX39, FIREFOX38, FIREFOX37, FIREFOX36, FIREFOX35, FIREFOX34, FIREFOX33, FIREFOX32, FIREFOX31, FIREFOX30, FIREFOX29, FIREFOX28, FIREFOX27, FIREFOX26, FIREFOX25, FIREFOX24, FIREFOX23, FIREFOX22, FIREFOX21, FIREFOX20, FIREFOX19, FIREFOX18, FIREFOX17, FIREFOX16, FIREFOX15, FIREFOX14, FIREFOX13, FIREFOX12, FIREFOX11, FIREFOX10, FIREFOX9, FIREFOX8, FIREFOX7, FIREFOX6, FIREFOX5, FIREFOX4, FIREFOX3, FIREFOX2, FIREFOX1_5

*To target a specific versions and higher versions add '+' after the browser name. For example: FIREFOX57+


Internet explorer

Write ALL to target all Internet Explorer versions or type a specific version. Values should be separated by a pipe (“|”). To detarget this option please leave this field blank.

List of valid values:

OUTLOOK_EXPRESS7, IEMOBILE11, IEMOBILE10, IEMOBILE9, IEMOBILE7, IEMOBILE6, IE_XBOX, IE11, IE10, IE9, IE8, IE7, IE6, IE5_5, IE5

*To target a specific versions and higher versions add '+' after the browser name. For example: IEMOBILE11+

Opera

Write ALL to target all Opera versions or type a specific version. Values should be separated by a pipe (“|”). To detarget this option please leave this field blank.

List of valid values:

OPERA_MOBILE, OPERA_MINI, OPERA46, OPERA45, OPERA44, OPERA43, OPERA42, OPERA41, OPERA40, OPERA39, OPERA38, OPERA37, OPERA36, OPERA35, OPERA34, OPERA33, OPERA32, OPERA31, OPERA30, OPERA29, OPERA28, OPERA27, OPERA26, OPERA25, OPERA24, OPERA23, OPERA20, OPERA19, OPERA18, OPERA17, OPERA16, OPERA15, OPERA12, OPERA11, OPERA10, OPERA9

*To target a specific versions and higher versions add '+' after the browser name. For example: OPERA46+

Safari

Write ALL to target all Safari versions or type a specific version. Values should be separated by a pipe (“|”). To detarget this option please leave blank.

List of valid values:

BLACKBERRY10, MOBILE_SAFARI, SILK, SAFARI10, SAFARI9, SAFARI8, SAFARI7, SAFARI6, SAFARI5, SAFARI4

*To target a specific versions and higher versions add '+' after the browser name. For example: SAFARI10+

Other browsers

Write ALL to select this option or type a specific version as listed in the UI. To detarget this option, please leave this field blank.

After approval

The selected campaign status after approval. Valid values are:  START, PAUSED

Frequency Capping

Control how often your ad will be displayed to the same visitor. A visitor is defined using a combination of IP address and user agent. A valid value is a number between 1-24.

Traffic Distribution

Valid values can be EVENLY (Evenly throughout the day) or EAGER (As soon as possible)

 

 


Separator

Whenever you add multiple values into a single cell, the separator between those values should be a pipe (“|”).


Mandatory Values, Approval Process and Compliance

Campaigns that are created or updated using a CSV file upload, have the same requirements in terms of mandatory/optional values, and will go through the same approval process as if they were created through the platform. The campaigns should comply to the same terms and conditions as campaigns that were created through the platform.



Advanced Instructions and Known Limitations

  1. The CSV file update functionality is currently available only for Pay-Per-View (PPV) campaigns and not for Pay-Per-Click (PPC) campaigns. 

  2. Some advanced capabilities, such as Carrier Targeting and Day Parting, which are available when creating or updating campaigns in the platform, are not available using the CSV file update.

  3. When editing a downloaded file, it must be saved as a CSV (Comma delimited) file only.

  4. Excel limits the number of characters per one cell to 32,700. If you have a long black/white list or a long KW list, make sure it doesn’t exceed 32,700 characters.

  5. When creating or editing a Whitelist campaign, it is not allowed to add blacklist sources.

  6. When creating a new campaign, it is not possible to choose both Traffic types: Full page PPV and Domain Redirect. You should select either Full Page PPV (TRUE) – which means domain redirect will be FALSE, or Domain redirect (TRUE), which means that Full page PPV will be (FALSE).

  7. The same as in the platform, a whitelist campaign can’t be changed into a blacklist campaign and vice versa.