Review and Edit Campaign Component Settings Using Bulksheets
You can download the settings for the packages, placements, and ads in a single campaign in XLSX (Microsoft Excel spreadsheet) format for review. By default, the downloaded file includes separate tabs for package settings, package flight information, placement settings, and placement ad schedules. You can optionally exclude the settings for some campaign component types.
To update multiple settings at once, upload a valid bulksheet file with the changes. To create the bulksheet, you can 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 save the file to upload it. Editable fields include most settings that are normally editable.
Download Settings for the Packages, Placements, and Ads in a Campaign
-
In the main menu, click Campaigns.
-
In the upper right, click … > Download QA sheet.
-
In the QA Sheet 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 campaign components 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. See “Placement Columns in Downloaded/Uploaded Spreadsheets” for a list of the included columns.
-
Download a Bulksheet Template for a Campaign download-template
Download a blank bulksheet template that includes tabs for each type of campaign component. You can later add rows to any tab on the template and upload the edited file to make changes to the campaign components.
-
Click the name of the campaign.
-
In the upper right, click … > Upload Bulksheet.
-
In the Upload Bulksheet dialog, click Bulksheet Template.
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 Package, Placement, and Ad Settings for a Campaign upload-bulksheet-campaign-components
Upload settings for packages, placements, and ads in a single campaign all at once in a populated bulksheet.
-
Download a bulksheet template if needed, enter or paste package, placement, and/or ad settings on the relevant tabs of a bulksheet template, and then save the file to your device or network.
See the available settings below.
-
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