Clear search
Close search
Google apps
Main menu

Create ad units in bulk

Upload a spreadsheet to create multiple ad units at one time

You can create multiple ad units at one time by uploading a CSV file into DoubleClick for Publishers. If you need to update existing ad units or create more than 1,000 ad units at one time, use the DFP API.

  1. Sign in to DoubleClick for Publishers.
  2. Click Inventory and then Ad units and then Bulk upload new ad units.
  3. Click Download sample CSV file to download a file that you can use to define your ad units. Open the CSV file and make changes based on the examples and the descriptions in the table below. When you're done, save the CSV file using your file editor.
  4. Click Choose File to find the CSV file you saved in step 2.
  5. Click Upload and validate to verify that the ad unit settings are correct. If you identify an issue with any of the ad units defined in your CSV file, click Back to re-upload a corrected CSV file.
  6. Click Confirm upload to create all of the ad units from your CSV file.
If there is a problem with your upload, a message is displayed to let you know. The "View users, roles, and teams" user role permission is required to see this detailed message.

The sample CSV file

The sample CSV file contains fields and examples relevant to your network. Don't change the column order or the column headings. Any rows that begin with the pound (#) character are ignored when you upload the file.

Remove semicolon (;) from your file editor's list of delimiter or separator characters to ensure the sample file renders columns and values correctly.

Columns in the sample CSV file

As of April 2016, "Target platform" and "Mobile platform" are deprecated as inventory settings and no longer available as bulk upload criteria. Do not include these columns in your bulk upload files.

The values for each column must follow the same formatting rules as when you create a single ad unit. Refer to the Create an ad unit article for definitions of each ad unit setting.

Column Description

The ad unit code, used in the tags. Only letters, numbers, underscores, hyphens, periods, asterisks, forward slashes*, backslashes, exclamations, left angle brackets, colons and parentheses are allowed. Maximum length: 100 characters.

Top-level ad unit: For a top-level ad unit, use the code name.
Example: News_International_BoxATF

Hierarchical ad unit: For ad units that are part of an inventory hierarchy, the full path of the ad unit is required.
Example: NewsApp/Sports/Cricket_320x50

* Note: the forward slash character is reserved to indicate the hierarchy relationship between ad units. This character cannot be used in an individual ad unit's code. 


Ad unit name.

Example: International News Section (Box Above the Fold)


List of ad unit sizes, in pixels, entered in WIDTHxHEIGHT format, separated by semicolon. For "Out-of-page," use out-of-page. Other acceptable values include fluid and custom rendering. Do not enter duplicate sizes (example: 300x250;300x250). Video sizes such as 640x480v are not supported.

Use a standard AdSense ad unit size to enable an ad unit for AdSense. Otherwise, any size is acceptable.

Example: 728x90;300x250;out-of-page

Description Free-form ad unit description. Maximum length: 4,000 characters.

List of placement names to be associated with the ad unit, separated by semicolon. If a placement name does not currently exist in your network, DFP will automatically create a new placement and associate your ad unit.

Example: My first placement;All news pages

Target window

The target window setting for the ad unit. Acceptable values include: _top or _blank. If not defined, the value defaults to your network's default AdSense inventory settings.

Example: _blank


List of label IDs to be associated with the an ad unit, separated by semicolon.

Example: 14225;54848;55658


If your network uses Teams, list Team IDs to be associated with the an ad unit, separated by semicolon.

Example: 45792;84645

Special ad unit
If the ad unit should be marked as a special ad unit, enter Yes; otherwise, No.
Was this article helpful?
How can we improve it?