The CSV Upload tool allows you to create and update multiple Placements and Instances for your FairBid setup by uploading a CSV file to the DT Console.

Uploading a CSV File

In order to upload a CSV file for bulk FairBid Placements and Instances, complete the following tasks:

• Add your app to the DT FairBid.
• Enable the mediated networks you want to use for your app.
• Create a CSV file using the the DT CSV template or download your existing setup and make the appropriate additions and/or modifications.

To upload a bulk CSV file for Placements and Instances:

1. Log in to the DT Console, and click App Management.

2. Select the app for which you want to upload bulk Placements and Instances, and select the Placements tab.

3. Click Upload CSV.
   The Upload CSV page displays.

4. Under Step 1. Upload a CSV file, click Upload CSV, and select your CSV file.

5. Under Step 2, preview the changes and additions found in your CSV file along with any errors.

6. If you find an error in the preview, correct the error in the CSV file, and upload the file again (See Step 4).

7. If the preview is correct, click Confirm.

CSV File Structure

DT provides a template from which you can start building your CSV file. Alternatively, you can download your existing setup (Placement and Instance settings) as a CSV file and make the modifications.

To create or edit your CSV file, use any spreadsheet software capable of rendering and saving CSV files. Each row in the CSV file represents a Placement or an Instance. Each column represents a required field for creating or updating a Placement or Instance. When you complete your CSV file, ensure that you save the file as .CSV format.

To create a new Placement or Instance, add a new row, and enter the relevant settings.

To update an existing Placement or Instance, add a new row and enter the desired settings for it. Ensure each row includes existing entity ID (Placement ID or Instance ID) in the row.

File Columns

The folllowing table provides a list of fields that you must populate via your CSV file for Placements, Instances, or both.

CSV File Examples

The following sections provide examples of some common bulk setup manipulations you can achieve via the CSV Uploader Tool.

Example: Creating a Banner Placement

The following row from a CSV file instructs DT to create a Placement called Placement_1 for a Banner ad format. The Placement should have following settings:

• Worldwide floor price is $1.50 USD.
• The place is active in only Canada, the United States of America, and the United Kingdom.

Example: Creating an Interstitial Placement with Multiple Instances

The following rows instruct DT to create an Insterstitial Placement named Placement_3 with multiple Instances that require the following settings:

• Instance_1 is for the Vungle mediated network and must be use the Auto CPM Method. The Instance should use the following temporary values based on country:
  • In Canada and USA, this Instance should use the CPM value of $1.20 USD while the Auto CPM ramps up.
  • In Germany, France, and Belgium, this Instance should use the the CPM value of $2.00 USD while the Auto CPM ramps up.
• Instance_2 is for the Facebook Bidder mediated network and needs no CPM settings.
• Instance_3 is for the InMobi mediated network and must be active worldwide for users who share their Advertising ID. For these users in the USA, use the Auto CPM method and set a temporary CPM value of $2.20 USD while the Auto CPM ramps up.
• Instance_4 is also for the InMobi mediated network, and must be active worldwide for users who who do not share their Advertising ID. For these users in the USA, use the Auto CPM method with a temporary CPM value of $1.50 USD while the Auto CPM ramps up.
• Instance_5 is for the Pangle mediated network and must be active for all countries except for Denmark and Sweden. In all active countries, set the CPM to $1.80 USD.

List of Supported Countries