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 DT 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:
- On the DT FairBid Console on the App Placements page, click Upload CSV.
- Select the CSV file you want to upload. On this page, you are able to download the CSV template file, as well as a CSV file displaying your current Placement and Instance setup. These should help you create the CSV file.
- 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 update for an existing Placement or Instance. Any existing Placement or Instance, even without any changes in the uploaded file, is considered updated.
-
If an error is found in the CSV file, it is displayed in this section with the reason for the error. Fix the error and upload the file again.
-
Click Confirm. The new Placements and Instances have successfully been created
Any new 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 or instance ID) as part of the row information.
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 |
One of the following ad formats: Banner, Interstitial, Rewarded. Important: MREC placements are not currently supported in the CSV tool. |
|
Entity Type |
Both |
Placement or Instance. |
|
Entity Status |
Both |
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 letter 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 here 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.
|
Examples
Creation of a Banner Placement
- Placement_1 os set to a Worldwide Floor Price of $1.5, active only in Canada, the United States of America, and the United Kingdom.
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
- Instance_4 is set to be active for users who do not share their Advertising ID.
- 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.
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 |