# 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: {% stepper %} {% step %} [Download a base CSV file](#downloading-a-base-csv-file) from DT Console. {% endstep %} {% step %} [Modify the downloaded CSV file](#modifying-the-base-csv-file) in an external tool. {% endstep %} {% step %} [Upload the modified CSV file](#uploading-a-csv-file-with-multiple-placements) to the DT Console. {% endstep %} {% endstepper %} ## 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: 1. Select your app from the [Apps Dashboard](https://docs.digitalturbine.com/dt-console/app-management/apps-dashboard). 2. On the **Placements** tab of the **App Details** screen, click the **Add placement** drop-down.
Drop-down for CSV Uploads
2. To download your current placement settings, click **Download CSV**. 3. To download a blank template, click **Upload CSV**, and then click **Download CSV template** from the **Upload a CSV file** dialog box.
CSV file download options
## Modifying the Base CSV File Once you [download the base CSV file](#h_01J59CPBAA7TKMQBAMMNDKY2Z7) (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.
SETTINGDESCRIPTION
Placement IDUnique 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 NameThe name of the placement. Placement names must be unique.
Placement TypeEnter 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.
StatusDetermines whether placement receives traffic. Indicate one of the following statuses:
Active. Placement receives traffic
Inactive. Placement does not receive traffic.
Floor PriceThe 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 ModeMode 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 CodesThe 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 DirectedIndicate 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: 1. On the **Placements** tab of the **App Details** screen, click the **Add placement** drop-down.
Drop-down for CSV Uploads
2. Click **Upload CSV**.\ The **Upload a CSV file** dialog box displays.
CSV Upload dialog box
3. Drag and drop your CSV file to the upload area, or, alternatively, click the upload area to browse to your CSV file.
Active CSV Upload Button
4. Click **Upload**. A message displays to confirm the upload and the **Placements** tab of the **App details** screen gets updated. {% hint style="info" %} 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. {% endhint %} #### **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