Review and Edit Placement Settings Using Bulksheets
You can download the settings for one or more placements, or for all placements in a campaign, in XLSX (Microsoft Excel spreadsheet) format for review. Use this feature to quickly review such details as:
- Which audiences the campaign targets.
- When the placements start delivering, and when they stop.
- Which ads are attached to the placements.
To update multiple settings at once, you can do either of the following:
-
Make changes to select fields, save the file, and upload the edited bulksheet file back to DSP.
-
To make changes to additional placements and to the settings for any package, download a blank bulksheet template that includes tabs for each type of campaign component, enter or paste new or updated settings into the template file, and then upload the file to make the changes. For instructions, see “Review and Edit Campaign Component Settings Using Bulksheets.”
Editable fields include the placement names, statuses, bids, budgets, pacing strategies, and frequency caps.
Download Settings for All Placements in a Campaign
-
In the main menu, click Campaigns.
-
In the upper right, click … > Download Setup Excel.
A notification message indicates when the file is available to download.
-
To download the file, do either of the following:
-
In the notification message, click Download.
-
In the right of the top menu bar, click
The file is saved to the browser’s Downloads folder. See “Placement Columns in Downloaded/Uploaded Spreadsheets” for a list of the included columns.
-
Download Settings for One or More Placements
-
In the main menu, click Campaigns.
-
Click the name of the campaign.
-
In the submenu, click Placements.
-
Select the check box next to each placement whose settings you want to download.
-
In the bulk actions toolbar, click … > Download Bulksheet.
A notification message indicates when the bulksheet file is available to download.
-
To download the bulksheet, do either of the following:
-
In the notification message, click Download.
-
In the right of the top menu bar, click
The file is saved to the browser’s Downloads folder. See “Placement Columns in Downloaded/Uploaded Spreadsheets” for a list of the included columns.
-
Upload a Bulksheet with Placement Settings upload-bulksheet-placement
You can upload settings for your placements, and for the ads and packages associated with the placements, in a bulksheet file.
-
In the main menu, click Campaigns.
-
Click the name of the campaign.
-
In the upper right, click … > Upload Bulksheet.
-
In the Upload Bulksheet dialog:
-
Either drag and drop a file into the box, or click inside the box to select a file from your device or network.
-
Click Upload.
-
-
(Optional) To verify that the updates were processed, click
Placement Setting Columns in Downloaded/Uploaded Spreadsheets qa-sheet-columns
Campaign-level Spreadsheets
Note: To check the actual dayparting schedule, open the placement settings in DSP.
6.Public Inventory - Included
Public Inventory - Excluded
Outstream ads usually appear over the content as a pop-up or stuffed into content (in the native experience), rather than as regular video ads in a video player.
Topic Targeting - Included
Topic Targeting - Excluded
Device Targeting - Included
Device Targeting - Excluded
Placement-level Bulksheets
6.