Bulk-Importing Placements
In some cases you might want to forgo setting up placement individually in the DT Console and import placement data from a file instead. This can be useful when you have a lot of placements to add/update or when working with data exported from other dashboards.
Complete the following steps to import placement data from a file:
Download a base CSV file from DT Console.
Modify the downloaded CSV file in an external tool.
Upload the modified CSV file to the DT Console.
Downloading a Base CSV File
Start with a base CSV file. This could be either a blank DT template or your current placement settings downloaded from the DT Console.
To download a base CSV template:
Select your app from the Apps Dashboard.
On the Placements tab of the App Details screen, click the Add placement drop-down.
To download your current placement settings, click Download CSV.
To download a blank template, click Upload CSV, and then click Download CSV template from the Upload a CSV file dialog box.
Modifying the Base CSV File
Once you download the base CSV file (either your existing placement configurations or the blank template), modify the CSV file for the placements you want to add or update. Each line in the CSV file represents a placement and its settings, and each placement setting is separated by a comma.
The following table provides a list of fields that you must provide in your CSV file.
Placement ID
Unique identifier for the Placement. If you are creating a placement, leave this field blank. DT assigns a Placement ID when you upload the CSV file. If you are updating an existing placement, enter the ID for the placement you want to modify.
Placement Name
The name of the placement. Placement names must be unique.
Placement Type
Enter one of the following ad formats:
Banner. Placement is for a Banner ad format.
Interstitial. Placement is for an Interstitial ad format.
MREC. Placement is for a Medium Rectangle ad format.
Rewarded. Placement is for a Rewarded ad format.
Status
Determines whether placement receives traffic. Indicate one of the following statuses:
Active. Placement receives traffic
Inactive. Placement does not receive traffic.
Floor Price
The country and floor price you want to apply to this placement. Use the following format: CountryCode:FloorPrice
- CountryCode. Use the alpha-2 country code for the country you want to specify a floor price. To specify a worldwide floor price, use WW as the country code.
- FloorPrice. Specify the floor price (0.01-500.00 USD) you want to apply for the country.
- Separate multiple entries by a space.
Targeting Mode
Mode in which you want to target the country specified in the Targeting Country Codes column. Specify one of the following modes:
Include. Include the entity in the specified country.
Exclude. Exclude the entity from the specified country.
If you leave this field blank, DT disables country targeting for the placement and targets all countries.
Targeting Country Codes
The alpha-2 country code for the country you want to target as specified in the Targeting Mode column.
- Separate multiple countries by a space.
- If you leave this field blank, DT disables country targeting for the placement and targets all countries.
Child Directed
Indicate whether the target audience of this placement includes children or whether this placement may be accessed by children.
TRUE. Children are the target audience for this placement or are likely to see this placement.
FALSE. Children are not the target audience for this placement and are not likely to see this placement.
Uploading a CSV File with Multiple Placements
To upload a CSV file:
On the Placements tab of the App Details screen, click the Add placement drop-down.
Click Upload CSV. The Upload a CSV file dialog box displays.
Drag and drop your CSV file to the upload area, or, alternatively, click the upload area to browse to your CSV file.
Click Upload. A message displays to confirm the upload and the Placements tab of the App details screen gets updated.
If you receive an error message instead of a confirmation message, then DT encountered an error while processing your file. Check your file for structure errors and missing or invalid settings, and then upload the corrected file.
Country Codes
List of country codes
AF Afghanistan
AX Aland Islands
AL Albania
DZ Algeria
AS American Samoa
AD Andorra
AO Angola
AI Anguilla
AQ Antarctica
AG Antigua & Barbuda
AR Argentina
AM Armenia
AW Aruba
AU Australia
AT Austria
AZ Azerbaijan
BS Bahama
BH Bahrain
BD Bangladesh
BB Barbados
BY Belarus
BE Belgium
BZ Belize
BJ Benin
BM Bermuda
BT Bhutan
BO Bolivia
BQ Bonaire, Sint Eustatius and Saba
BA Bosnia and Herzegovina
BW Botswana
BV Bouvet Island
BR Brazil
IO British Indian Ocean Territory
VG British Virgin Islands
BN Brunei Darussalam
BG Bulgaria
BF Burkina Faso
BI Burundi
KH Cambodia
CM Cameroon
CA Canada
CV Cape Verde
KY Cayman Islands
CF Central African Republic
TD Chad
CL Chile
CN China
CX Christmas Island
CC Cocos (Keeling) Islands
CO Colombia
KM Comoros
CG Congo
CD Congo, Democratic Republic
CK Cook Islands
CR Costa Rica
CI Côte d'Ivoire (Ivory Coast)
HR Croatia
CU Cuba
CW Curaçao
CY Cyprus
CZ Czech Republic
DK Denmark
DJ Djibouti
DM Dominica
DO Dominican Republic
TP East Timor
EC Ecuador
EG Egypt
SV El Salvador
GQ Equatorial Guinea
ER Eritrea
EE Estonia
ET Ethiopia
MK F.Y.R.O.M. (Macedonia)
FK Falkland Islands (Malvinas)
FO Faroe Islands
FJ Fiji
FI Finland
FR France
GF French Guiana
PF French Polynesia
TF French Southern Territories
GA Gabon
GM Gambia
GE Georgia
DE Germany
GH Ghana
GI Gibraltar
GR Greece
GL Greenland
GD Grenada
GP Guadeloupe
GU Guam
GT Guatemala
GG Guernsey
GN Guinea
GW Guinea-Bissau
GY Guyana
HT Haiti
HM Heard & McDonald Islands
HN Honduras
HK Hong Kong
HU Hungary
IS Iceland
IN India
ID Indonesia
IQ Iraq
IE Ireland
IR Islamic Republic of Iran
IM Isle of Man
IL Israel
IT Italy
JM Jamaica
JP Japan
JE Jersey
JO Jordan
KZ Kazakhstan
KE Kenya
KI Kiribati
KP Korea, Democratic People's Republic of
KR Korea, Republic of
KW Kuwait
KG Kyrgyzstan
LA Lao People's Democratic Republic
LV Latvia
LB Lebanon
LS Lesotho
LR Liberia
LY Libyan Arab Jamahiriya
LI Liechtenstein
LT Lithuania
LU Luxembourg
MO Macau
MG Madagascar
MW Malawi
MY Malaysia
MV Maldives
ML Mali
MT Malta
MH Marshall Islands
MQ Martinique
MR Mauritania
MU Mauritius
YT Mayotte
MX Mexico
FM Micronesia
MD Moldova, Republic of
MC Monaco
MN Mongolia
MS Monserrat
ME Montenegro
MA Morocco
MZ Mozambique
MM Myanmar
NA Namibia
NR Nauru
NP Nepal
NL Netherlands
AN Netherlands Antilles
NC New Caledonia
NZ New Zealand
NI Nicaragua
NE Niger
NG Nigeria
NU Niue
NF Norfolk Island
MP Northern Mariana Islands
NO Norway
OM Oman
PK Pakistan
PW Palau
PS Palestinian Territory
PA Panama
PG Papua New Guinea
PY Paraguay
PE Peru
PH Philippines
PN Pitcairn
PL Poland
PT Portugal
PR Puerto Rico
QA Qatar
RE Réunion
RO Romania
RU Russian Federation
RW Rwanda
BL Saint Barthélemy
LC Saint Lucia
MF Saint Martin (French part)
WS Samoa
SM San Marino
ST Sao Tome & Principe
SA Saudi Arabia
SN Senegal
RS Serbia
SC Seychelles
SL Sierra Leone
SG Singapore
SX Sint Maarten (Dutch part)
SK Slovakia
SI Slovenia
SB Solomon Islands
SO Somalia
ZA South Africa
GS South Georgia and the South Sandwich
SS South Sudan
ES Spain
LK Sri Lanka
SH St. Helena
KN St. Kitts and Nevis
PM St. Pierre & Miquelon
VC St. Vincent & the Grenadines
SD Sudan
SR Suriname
SJ Svalbard & Jan Mayen Islands
SZ Swaziland
SE Sweden
CH Switzerland
SY Syrian Arab Republic
TW Taiwan, Province of China
TJ Tajikistan
TZ Tanzania, United Republic of
TH Thailand
TL Timor-Leste
TG Togo
TK Tokelau
TO Tonga
TT Trinidad & Tobago
TN Tunisia
TR Turkey
TM Turkmenistan
TC Turks & Caicos Islands
TV Tuvalu
UG Uganda
UA Ukraine
AE United Arab Emirates
GB United Kingdom (Great Britain)
UM United States Minor Outlying Islands
US United States of America
VI United States Virgin Islands
UY Uruguay
UZ Uzbekistan
VU Vanuatu
VA Vatican City State (Holy See)
VE Venezuela
VN Viet Nam
WF Wallis & Futuna Islands
EH Western Sahara
YE Yemen
ZR Zaire
ZM Zambia
ZW Zimbabwe
Last updated