Placement Setting Columns in Downloaded/Uploaded Spreadsheets
TIP
In a downloaded spreadsheet, all editable columns are highlighted in blue.
Campaign-level Spreadsheets
Section
Column
Description
Editable?
Basic
Placement ID
The numeric ID of the placement.
—
Basic
Placement Name
The name of the placement.
Yes
Basic
Labels
Any applied labels, for reporting.
—
Basic
Edit Link
A link to open the placement in Edit mode.
—
Basic
Status
The placement status: active or inactive.
Yes
Basic
Placement Type
The placement type.
—
Basic
Package Name
The name of the parent package, when applicable.
—
Goals
Start Date
The start date of the placement.
—
Goals
End Date
The end date of the placement.
—
Goals
Day parting
Whether dayparting is ON or OFF.
Note: To check the actual dayparting schedule, open the placement settings in DSP.
Note: To check the actual dayparting schedule, open the placement settings in DSP.
—
Goals
Budget
The placement budget, if there is one.
Yes
Goals
Budget Interval
The budget interval: Daily*, Weekly, Monthly, or All Time.
Yes
Goals
Optimization Goal
The objective of the package.
—
Goals
Optimization Target
The target value of the goal.
—
Goals
Pace on
Whether the placement is pacing towards the Budget or Impressions.
—
Goals
Max Bid
The maximum bid for the placement.
Yes
Goals
Flight Pacing
The flight pacing strategy for the placement: Even, slightly ahead, frontload, or aggressive frontload.
Yes
Goals
Intraday Pacing
The intraday pacing strategy for the placement: Even or ASAP.
Yes
Goals
Pre-Bid Filters
Any pre-bid filter criteria to be applied.
—
Goals
Bidding Rules
Whether bidding rules (deprecated) are ON or OFF.
—
Goals
Frequency Cap
The primary frequency cap for the placement during the specified Frequency Cap Interval.
Yes
Goals
Frequency Cap Interval
The interval for the primary frequency cap: Day, Week, or Month.
Yes
Goals
Secondary Frequency Cap
The secondary frequency cap for the placement during the specified Secondary Frequency Cap Interval
Yes
Goals
Secondary Frequency Cap Interval
The type of interval for the secondary frequency cap: Week, Day, Hour, or Minute. The applicable number of weeks, days, hours, or minutes is indicated by the Secondary Frequency Cap Interval Value.
Yes
Goals
Secondary Frequency Cap Interval Value
The number of weeks, days, hours, or minutes for which the Secondary Frequency Cap applies. For example, if the secondary cap is three impressions per six hours, then the value here would be
6.Yes
Audience Location
Audience Location - Included #
The number of targeted geographical locations, All, or None.
—
Audience Location
Audience Location - Included
The targeted geographical locations, separated by semi-colons,or All Locations.
—
Audience Location
Audience Location - Excluded #
The number of excluded geographical locations or None.
—
Audience Location
Audience Location - Excluded
The excluded geographical locations, separated by semi-colons, or None.
—
Inventory
Public Inventory - Included
The number of targeted public inventory deals, if any are specified, All, or None.
—
Inventory
Public Inventory - Excluded
The number of excluded public inventory deals, if any are specified, or None.
—
Inventory
Private Inventory - Included #
The number of targeted private inventory deals, if any are specified, All, or None.
—
Inventory
Private Inventory - Excluded #
The number of excluded private inventory deals, if any are specified, or None.
—
Inventory
On Demand Inventory - Included #
The number of targeted On-Demand Inventory deals, if any are specified, All, or None.
—
Inventory
On Demand Inventory - Excluded #
The number of excluded On-Demand Inventory deals, if any are specified, or None.
—
Sites
Traffic Type
The targeted type of traffic: Website and/or Apps
—
Sites
Exclude out-stream
Whether the Inventory Targeting option to exclude outstream traffic is ON* or OFF.
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.
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.
—
Sites
Site Tier
The quality of the sites to target: Tier 1, Tier 2, Tier 3, or All Sites.
—
Sites
Categories - Included #
The number of targeted site categories, if any are specified, or All.
—
Sites
Categories - Excluded #
The number of excluded site categories, if any are specified, or All.
—
Sites
Excluded Sites
The excluded sites, if any are specified, or None.
—
Sites
Language
The targeted site languages.
—
Sites
Allow unscreened sites
(Standard display placements only) Whether or not to allow ad delivery on non-audited sites: ON or OFF. When the placement targets private inventory, this option may deliver ads on blocked sites.
—
Sites
Targeted Sites
The number of targeted sites, if any are specified, or None.
—
Audience Targeting
Audience - Included
The targeted audiences, if any are specified, or None.
—
Audience Targeting
Audience - Excluded
The excluded audiences, if any are specified, or None.
—
Audience Targeting
Demographic booster
Whether or not Comscore demographic segments are enabled for the placement (and other placements in the campaign): ON or OFF. This feature may be enabled only for campaigns for which the Audience Verification feature is enabled for Nielsen and/or Comscore. It incurs additional fees.
—
Audience Targeting
Extend across screens
Whether or not to extend the ad targeting across devices: ON or OFF. Cross-device targeting extends your targeting across all of a person’s known device, per the device graph specified in the campaign settings.
—
Audience Targeting
Topic Targeting - Included
The number of targeted topic codes, if any are specified, or All.
—
Audience Targeting
Topic Targeting - Excluded
The number of excluded topic codes, if any are specified, or None.
—
Audience Targeting
Device Targeting - Included
The number of targeted device targets, if any are specified, or All.
—
Audience Targeting
Device Targeting - Excluded
The number of excluded device targets, if any are specified, or None.
—
Audience Targeting
ISP Targeting - Included #
The number of targeted ISP providers, if any are specified, or *All/i>.
—
Audience Targeting
ISP Targeting - Excluded #
The number of excluded ISP providers, if any are specified, or None.
—
Brand Safety
Brand Safety - Contextual Filtering #
The number of brand safety filters applied, if any are specified, or None.
—
Brand Safety
Brand Safety - Pre-Bid Fraud blocking #
The number of pre-bid fraud blocking filters applied, if any are specified, or None.
—
Brand Safety
Brand Safety - Pre-Bid Viewability #
The number of pre-bid viewability filters applied, if any are specified, or None.
—
Brand Safety
Site Safety Block
Whether or not Site Safety Block is enabled: ON or OFF.
—
Tracking
Tracking Pixels #
The number of third-party event-tracking pixels attached to the placement, or None.
—
Tracking
Conversion Pixels #
The number of conversion tracking pixels attached to the placement, or None.
—
Tracking
3rd-party fees
A static, third-party fee rate to be tracked as a non-billable cost per 1000 impressions, if applicable.
—
Ads
# of Ads Attached
The number of ads attached to the placement, if any are attached, or None.
—
Ads
Ad Names
The names of any ads attached to the placement, or None.
—
Ads
Attached Ad ID
The unique DSP-generated Ad IDs of any ads attached to the placement, separated by semi-colons. To download a list of ad names and associated Ad IDs from the Ads view, create a custom view that includes the Ad ID metric, and then export the data.
Yes
Placement-level Spreadsheets
Column
Description
Editable?
Placement ID
The numeric ID of the placement.
—
Placement Name
The name of the placement.
Yes
Package Name
The name of the parent package, when applicable.
—
Start Date
The start date of the placement.
—
End Date
The end date of the placement.
—
Status
The placement status: active or inactive.
—
Max Bid
The maximum bid for the placement.
Yes
Budget
The placement budget, if there is one.
Yes
Budget Interval
The budget interval: Daily*, Weekly, Monthly, or All Time.
Yes
Primary Frequency Cap
The primary frequency cap for the placement during the specified Primary Frequency Cap Interval.
Yes
Primary Frequency Cap Interval
The interval for the primary frequency cap: Day, Week, or Month.
Yes
Secondary Frequency Cap
The secondary frequency cap for the placement during the specified Secondary Frequency Cap Interval
Yes
Secondary Frequency Cap Interval
The type of interval for the secondary frequency cap: Week, Day, Hour, or Minute. The applicable number of weeks, days, hours, or minutes is indicated by the Secondary Frequency Cap Interval Value.
Yes
Secondary Frequency Cap Interval Value
The number of weeks, days, hours, or minutes for which the Secondary Frequency Cap applies. For example, if the secondary cap is three impressions per six hours, then the value here would be
6.Yes
Attached Ad ID
The unique DSP-generated Ad IDs of any ads attached to the placement, separated by semi-colons. To download a list of ad names and associated Ad IDs from the Ads view, create a custom view that includes the Ad ID metric, and then export the data.
Yes
recommendation-more-help
9ff4800f-94be-45f0-a5bf-09d0d7e96baa