CSV Uploader

Introduction

The CSV Upload tool enables you to create and update multiple Placements and Instances for a particular App at once. Once you have added an App and enabled your set of choice of mediated networks in the Console, the CSV Upload button is displayed on the Placements page of that app.

Uploading a CSV File

Follow the steps below to upload your CSV file successfully:

  1. On the DT FairBid Console on the App Placements page, click Upload CSV.
    Screen_Shot_2022-07-25_at_8.38.09.png
  2. Select the CSV file you want to upload.

The CSV file you upload depends on either the existing Placement setups with the new Placements and Instances or using the template file.

Both files can be uploaded directly from this window.
Screen_Shot_2022-07-25_at_8.38.58.png

  1. Verify the uploaded contents

After uploading the file, all the uploaded Placements and Instances are displayed in the lower section of the window. The first column (NEW/UPDATE) specifies whether it's a newly created entity or an updated one for each row.

An entity with no changes in the uploaded file is considered updated.
Screen_Shot_2022-07-25_at_8.41.28.png

Note

If an error is found in the uploaded file, it is displayed in this section with the reason for the error. Fix the error and upload the file again.

4. Click Confirm to complete content creation

The new contents are successfully created and a notification message appears in the top-right corner of the screen.

Note

Uploaded setup for existing Placements or Instances overrides the current setup!

CSV File Structure

Each row in the file represents a Placement or an Instance. Each column represents a required field for creating or updating a Placement or Instance.

An Instance cannot be created on its own. It must be completed in conjunction with the Placement of which it is a part. To create a new Placement or Instance, add a new row and enter the relevant information.

To update an existing Placement or Instance, add a new row and enter the desired new setup for it. Make sure to include the existing entity ID (Placement ID r instance ID) as part of the row information.

CSV_Upload_pic_4.png 

File Columns

Column Name Placement/Instance Description
NEW/UPDATE

 

Both

Whether this row contains a new entity that is about to be created (NEW) or an existing one that is updated (UPDATE).

Existing entities that were uploaded with no changes are given the status UPDATE.

Placement Name

Placement

The name of the Placement.

Placement ID

Placement

DT created the unique identifier for the Placement. 

This field should be left empty when creating a Placement. When updating an existing Placement, this field should include the current DT identifier for this Placement.

Placement Type

Placement

The ad format of the Placement. 

It can be one of the following: Banner, Interstitial, Rewarded, or MREC for DT Marketplace Placements.

Entity Type

Both

The type of entity this row refers to. 

It can be either a Placement or an Instance.

Entity Status

Both

The Status of the created entity.

It can be either Active or Inactive.

Placement Floor Price Country Name

Placement

The country for which the Floor Price value in the next column is set. 

If you are setting different Floor Prices for other countries or setting several countries for the same floor price, add row for each country.

For the list of countries, click here

Placement Floor Price Value ($)

Placement

The Floor Price you wish to set for the Placement and for the specific country in case you chose to set one in the previous column. 

The value can be between 0.01 and 500. In case of setting different Floor Prices for different countries, please add an additional row for each Floor Price. If no value is set in this and the previous column, a Worldwide Floor Price of $0.01 is set for the Placement.

Targeting Country Codes

 

Both

The country or countries for which the entity should be restricted. 

The entity can be included or excluded for these countries depending on the choice in the next column. Country names should be written in two letters code convention. 

In the case of setting several countries, write all the countries in one cell comma separated. The set value should be copied across all the rows of the same entity. If no value is set in this and the previous column, country targeting is disabled for the entity.

See the table at the end of the article for the list of supported countries.

 

Targeting Include/Exclude

Both

The entity should be included or excluded for the selected countries in the previous column. 

The set value should be copied across all the rows of the same entity. If no value is set in this and the following column, country targeting is disabled for the entity.

 

Instance Name

Instance

The name of the Instance you want to create.

Mediated Network

Instance

The name of the Mediated Network the Instance is connected to. 

You can only set networks that were already activated for this app in the Console. The network name needs to be written as in the Console.

Instance ID

Instance

The unique identifier created by the Mediated Network for the Instance after creating it in the network's dashboard. 

When updating an existing Instance, this field should include the existing identifier for this Instance.

Instance CPM Method

Instance 

The CPM prediction method to be used for this Instance. It can be either Auto or Manual. 

On Instance creation, it is recommended to select Auto and add prices for the Instance's top countries in the following two columns to be used while Auto CPM prediction ramps up. If no value is set, the Auto method is applied for the Instance.

Instance CPM Country Name

Instance

The country or countries for which the predicted CPM value in the next column is set for. 

Country names should be written in two letters code convention. In case of setting several countries for the same CPM value, write all the countries in one cell comma separated. If no value is set in this and the following column, a Worldwide CPM price of $0.01 is set for the Instance.

For the list of supported countries, click here

Instance CPM Value ($)

Instance

The predicted CPM value you wish to set for the Instance and for the specific country in case you chose to set one in the previous column.

The value can be between 0.01 and 500. 

In case of setting different CPM values for different countries, please add an additional row for each country. If no value is set in this and the previous column, a Worldwide CPM value of $0.01 is set for the Instance.

Instance User Tracking Status

Instance

Whether the Instance should be restricted only for users who share their IDFA/AAID (Tracking Only), do not share it (No Tracking Only), or with no limitation (No Limitation).

 Accepted values are in the parenthesis. The set value should be copied across all the rows of the same entity. No Limitation status is applied for the Instance if no value is set.

 

File Examples

Creation of a Banner Placement. 

          • The Placement is set with a Worldwide Floor Price of $1.5, and set to be active only for Canada, the United States of America, and the United Kingdom./li>

CSV_Upload_example_1.png  

To create multiple Placements, add another row for every Placement.

Creation of an Interstitial Placement with five Instances. 

        • Instance_1 is set to be active only for certain countries, and with an Auto CPM method alongside different Manual CPM prices to be used while the Auto CPM prediction ramps up.
        • Instance_2 is of a bidding mediated network and therefore no CPM settings are required. 
        • Instance_3 is set to be active only for users who share their Advertising ID, and 
        • Instance_4 for users who do not.
        • Instance_5 is set to be active to all countries except for some, and with a Manual CPM method to force the use of the manually set prices.

CSV_Upload_example_2__2_.png  

List of Supported Countries

Country Name

Country Code

Country Name

Country Code

Afghanistan

AF

Lesotho

LS

Aland Islands

AX

Liberia

LR

Albania

AL

Libyan Arab Jamahiriya

LY

Algeria

DZ

Liechtenstein

LI

American Samoa

AS

Lithuania

LT

Andorra

AD

Luxembourg

LU

Angola

AO

Macau

MO

Anguilla

AI

Madagascar

MG

Antarctica

AQ

Malawi

MW

Antigua & Barbuda

AG

Malaysia

MY

Argentina

AR

Maldives

MV

Armenia

AM

Mali

ML

Aruba

AW

Malta

MT

Australia

AU

Marshall Islands

MH

Austria

AT

Martinique

MQ

Azerbaijan

AZ

Mauritania

MR

Bahama

BS

Mauritius

MU

Bahrain

BH

Mayotte

YT

Bangladesh

BD

Mexico

MX

Barbados

BB

Micronesia

FM

Belarus

BY

Moldova, Republic of

MD

Belgium

BE

Monaco

MC

Belize

BZ

Mongolia

MN

Benin

BJ

Monserrat

MS

Bermuda

BM

Montenegro

ME

Bhutan

BT

Morocco

MA

Bolivia

BO

Mozambique

MZ

Bonaire, Sint Eustatius and Saba

BQ

Myanmar

MM

Bosnia and Herzegovina

BA

Namibia

NA

Botswana

BW

Nauru

NR

Bouvet Island

BV

Nepal

NP

Brazil

BR

Netherlands

NL

British Indian Ocean Territory

IO

Netherlands Antilles

AN

British Virgin Islands

VG

New Caledonia

NC

Brunei Darussalam

BN

New Zealand

NZ

Bulgaria

BG

Nicaragua

NI

Burkina Faso

BF

Niger

NE

Burundi

BI

Nigeria

NG

Cambodia

KH

Niue

NU

Cameroon

CM

Norfolk Island

NF

Canada

CA

Northern Mariana Islands

MP

Cape Verde

CV

Norway

NO

Cayman Islands

KY

Oman

OM

Central African Republic

CF

Pakistan

PK

Chad

TD

Palau

PW

Chile

CL

Palestinian Territory

PS

China

CN

Panama

PA

Christmas Island

CX

Papua New Guinea

PG

Cocos (Keeling) Islands

CC

Paraguay

PY

Colombia

CO

Peru

PE

Comoros

KM

Philippines

PH

Congo

CG

Pitcairn

PN

Congo, Democratic Republic

CD

Poland

PL

Cook islands

CK

Portugal

PT

Costa Rica

CR

Puerto Rico

PR

Côte d'Ivoire (Ivory Coast)

CI

Qatar

QA

Croatia

HR

Réunion

RE

Cuba

CU

Romania

RO

Curaçao

CW

Russian Federation

RU

Cyprus

CY

Rwanda

RW

Czech Republic

CZ

Saint Barthélemy

BL

Denmark

DK

Saint Lucia

LC

Djibouti

DJ

Saint Martin (French part)

MF

Dominica

DM

Samoa

WS

Dominican Republic

DO

San Marino

SM

East Timor

TP

Sao Tome & Principe

ST

Ecuador

EC

Saudi Arabia

SA

Egypt

EG

Senegal

SN

El Salvador

SV

Serbia

RS

Equatorial Guinea

GQ

Seychelles

SC

Eritrea

ER

Sierra Leone

SL

Estonia

EE

Singapore

SG

Ethiopia

ET

Sint Maarten (Dutch part)

SX

F.Y.R.O.M. (Macedonia)

MK

Slovakia

SK

Falkland Islands (Malvinas)

FK

Slovenia

SI

Faroe Islands

FO

Solomon Islands

SB

Fiji

FJ

Somalia

SO

Finland

FI

South Africa

ZA

France

FR

South Georgia and the South Sandwich

GS

French Guiana

GF

South Sudan

SS

French Polynesia

PF

Spain

ES

French Southern Territories

TF

Sri Lanka

LK

Gabon

GA

St. Helena

SH

Gambia

GM

St. Kitts and Nevis

KN

Georgia

GE

St. Pierre & Miquelon

PM

Germany

DE

St. Vincent & the Grenadines

VC

Ghana

GH

Sudan

SD

Gibraltar

GI

Suriname

SR

Greece

GR

Svalbard & Jan Mayen Islands

§

Greenland

GL

Swaziland

SZ

Grenada

GD

Sweden

SE

Guadeloupe

GP

Switzerland

CH

Guam

GU

Syrian Arab Republic

SY

Guatemala

GT

Taiwan, Province of China

TW

Guernsey

GG

Tajikistan

TJ

Guinea

GN

Tanzania, United Republic of

TZ

Guinea-Bissau

GW

Thailand

TH

Guyana

GY

Timor-Leste

TL

Haiti

HT

Togo

TG

Heard & McDonald Islands

HM

Tokelau

TK

Honduras

HN

Tonga

TO

Hong Kong

HK

Trinidad & Tobago

TT

Hungary

HU

Tunisia

TN

Iceland

IS

Turkey

TR

India

IN

Turkmenistan

TM

Indonesia

ID

Turks & Caicos Islands

TC

Iraq

IQ

Tuvalu

TV

Ireland

IE

Uganda

UG

Islamic Republic of Iran

IR

Ukraine

UA

Isle of Man

IM

United Arab Emirates

AE

Israel

IL

United Kingdom (Great Britain)

GB

Italy

IT

United States Minor Outlying Islands

UM

Hong Kong

HK

Trinidad & Tobago

TT

Hungary

HU

Tunisia

TN

Iceland

IS

Turkey

TR

India

IN

Turkmenistan

TM

Indonesia

ID

Turks & Caicos Islands

TC

Iraq

IQ

Tuvalu

TV

Ireland

IE

Uganda

UG

Islamic Republic of Iran

IR

Ukraine

UA

Isle of Man

IM

United Arab Emirates

AE

Israel

IL

United Kingdom (Great Britain)

GB

Italy

IT

United States Minor Outlying Islands

UM

Jamaica

JM

United States of America

US

Japan

JP

United States Virgin Islands

VI

Jersey

JE

Uruguay

UY

Jordan

JO

Uzbekistan

UZ

Kazakhstan

KZ

Vanuatu

VU

Kenya

KE

Vatican City State (Holy See)

VA

Kiribati

KI

Venezuela

VE

Korea, Democratic People's Republic of

KP

Viet Nam

VN

Korea, Republic of

KR

Wallis & Futuna Islands

WF

Kuwait

KW

Western Sahara

EH

Kyrgyzstan

KG

Yemen

YE

Lao People's Democratic Republic

LA

Zaire

ZR

Latvia

LV

Zambia

ZM

Lebanon

LB

Zimbabwe

ZW

Back to Top ⇧