Review and Edit Placement Settings Using Spreadsheets
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.
You can then make changes to select fields and upload them back to DSP all at once. 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.
-
Do either of the following:
-
Next to the campaign name, click … > Download Excel QA sheet.
-
Click the campaign name to view the campaign details. In the upper right, click … > Download Excel QA sheet.
A notification message indicates when the file is available to download.
-
-
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 Edit in Excel Sheet.
The file is automatically saved to the browser’s Download folder. See “Placement Columns in Downloaded/Uploaded Spreadsheets” for a list of the included columns.
Upload Settings for All Placements in a Campaign
-
In the main menu, click Campaigns.
-
Do either of the following:
-
Next to the campaign name, click … > Upload Excel QA sheet.
-
Click the campaign name to view the campaign details. In the upper right, click … > Upload Excel QA sheet.
-
-
In the Edit in Excel 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
Upload 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 upload.
-
In the bulk actions toolbar, click … > Upload Edit in Excel Sheet.
-
In the Edit in Excel 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 Spreadsheets
6.