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 make changes to select fields, save the file, and upload the edited bulksheet file back to DSP. Editable fields include most editable settings.
Download Settings for All Placements in a Campaign
-
In the main menu, click Campaigns.
-
Do either of the following:
-
Next to the campaign, click … > Download Bulksheet.
-
Click the campaign name. In the upper right, click … > Download Bulksheet.
-
-
In the Bulksheet Download dialog box, deselect any campaign components whose settings you want to exclude from the downloaded file, and then click Download.
By default, settings for all placements and ads associated with the packages are selected.
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.
-
Download Settings for Specific 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.
To edit any of the settings, edit the file directly and then upload the changes. All editable columns are highlighted in blue. To use the correct format for a field, select and copy the value from the relevant package setting or placement setting. For some target settings, such as dayparting, custom goals, and conversion metrics, a copy option is available within the setting.
-
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.
-
Do any of the following:
-
Next to the parent campaign, click … > Upload Bulksheet.
-
Click the campaign name. In the upper right, click … > Upload Bulksheet.
This option is available from the Packages, Placements, or Ads tab.
-
In the submenu, click Placements, and select the check box for any placement. In the bulk actions toolbar, 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
When any setting update fails, you can download a bulksheet error file with color coding to show which settings (rows) were saved and which failed, with a reason for each failure. You can then address the issues within the same file and upload it again to process the corrected information.