Review and Edit Package Settings Using Bulksheets
You can download the settings for one or more packages in XLSX (Microsoft Excel spreadsheet) format for review. The bulksheet file includes a separate tab with flight information.
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 packages, placements, or ads in the campaign, download a bulksheet for the campaign. Enter or paste updated settings into the file, and then upload the file to make the changes. For instructions, see 鈥Review and Edit Campaign Component Settings Using Bulksheets.鈥
Editable fields include most settings that are normally editable.
Download Settings for All Packages in a Campaign
When you download settings for all packages in a campaign, the bulksheet includes separate tabs for the package settings and for the flight information. You can optionally include settings for the placements and ads that are associated with the packages; additional tabs are included for placement and ad settings.
-
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鈥檚 Downloads folder.
To edit any of the settings, edit the file directly and then upload the changes. All editable columns are highlighted in blue.
-
Download Settings for Specific Packages
When you download settings for specific packages, the bulksheet file includes separate tabs for the package settings and for the flight information, and the file is editable.
-
In the main menu, click Campaigns.
-
Click the name of the campaign.
-
In the submenu, click Packages.
-
Select the check boxes for the packages 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鈥檚 Downloads folder. See 鈥Placement Columns in Downloaded/Uploaded Bulksheets鈥 for a list of the included columns.
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 Package Settings upload-bulksheet-package
You can upload settings for your packages, including the placements and ads associated with the packages, 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 Packages, and select the check box for any package. 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.