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

 

Preview Screen

After choosing a CSV file and uploading it, the content of the CSV will be visible in a Preview screen.

The data that is visible in the Preview screen represents the campaign’s status AFTER the CSV processing is completed. 

The Action column will be seen empty, as the action has already been processed.

 

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.

Group Name*

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). There is no need to change the Status field.

When creating a new campaign, this field should be empty.

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.

When creating a new campaign, this field should be empty.

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       

Can be TRUE/FALSE

Tablet

Can be TRUE/FALSE

Smartphone

Can be TRUE/FALSE

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)

 

 

How to use the Status and Action Columns

 


Status

Action

New Campaign

Leave empty

Leave empty

Existing Campaign

Do not change

Value can be: Pause, Remove, Resume

 

 

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. There is a limit of 1,000 rows per CSV file. In other words, it is possible to update / create up to 1,000 campaigns per one action.

  6. The combination of Campaign Group and Campaign Name is unique per advertiser. It is not possible to create two identical campaign names under the same Campaign Group. The same restriction applies when editing an existing campaign or campaign group name.

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

  8. 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).

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