See the overview for an explanation of format.
- Display
- Video
- TrueView
- Audio
- Simple
- Non Skippable
- Action
- Reach
- View
- Audio
- Over The Top
- Mobile App Install
- Mobile App Buying
- Simple Over The Top
- Non Skippable Over The Top
- Reach Over The Top
- Target Frequency
'Action' is not compatible with TrueView line items.
New line items can't use 'Reach'.
- Active
- Paused
- Draft
- Archived
- Amount
- Impressions
- Unlimited
- Automatic
- TrueView Budget
- Daily
- Monthly
- Flight
- ASAP
- Even
- Ahead
- TRUE
- FALSE
- Minutes
- Hours
- Days
- Weeks
- Months
Frequency cap time periods must be 30 days or less.
- TRUE
- FALSE
- Days
- Weeks
- Months
- TMCM - Total Media Cost Markup
- MCM - Media Cost Markup
- CPM - Cost Per thousand impressions
- Count all
- Count post-click
- Count %
The floodlight activities used for conversions and related settings.
This column uses Display & Video 360 API FloodlightActivity
resource IDs and measurements, in minutes, of post-view and post-click windows.
List of list format = ((FloodlightActivity.floodlightActivityId; view_window_minutes; click_window_minutes;);(FloodlightActivity.floodlightActivityId; view_window_minutes; click_window_minutes;);).
This field cannot be update if the 'Algorithm Id' column is set. Attempts to do so will result in an error
- Fee category
- CPM
- Media
- Fee amount
- Float
- Pct as float
- Fee type
- (string, see table in fees)
- Invoiced
- True
- False
- blank
Example '(CPM; 2; Display & Video 360 Fee; False) ; (Media; 13; Default; True);'Acceptable values are provided in the following table:
Fee category | Fee Type | Invoiced option |
---|---|---|
CPM/Media
|
Default | Not permitted (leave blank) |
CPM/Media
|
Third-Party Ad Server | Not permitted (leave blank) |
CPM/Media
|
DoubleVerify | Permitted (True/False) |
CPM/Media
|
Adsafe | Not permitted (leave blank) |
CPM/Media
|
Adxpose | Not permitted (leave blank) |
CPM/Media
|
Vizu | Not permitted (leave blank) |
CPM/Media
|
Aggregate Knowledge | Not permitted (leave blank) |
CPM/Media
|
Teracent | Not permitted (leave blank) |
CPM/Media
|
Evidon | Not permitted (leave blank) |
CPM/Media
|
Agency Trading Desk Fee | Not permitted (leave blank) |
CPM/Media
|
Adloox | Permitted (True/False) |
CPM
|
ShopLocal | Required (True) |
CPM
|
TrustMetrics | Not permitted (leave blank) |
CPM
|
Integral Ad Science Video | Permitted (True/False) |
CPM
|
MOAT Video | Not permitted (leave blank) |
Media
|
Display & Video 360 Fee | Required (True) |
Media
|
Media Cost Data | Not permitted (leave blank) |
Media
|
Scibids Fee | Required (True) |
- Minimize: While spending the full budget, minimize CPA/CPC
- Maximize: While spending the full budget, maximize Impression Value or Quality Impression
- Beat: Meet or beat a goal of X CPA/CPC
- Optimize vCPM: Optimize for viewable CPM bid of X
- Fixed: Specify a fixed bid of X
Note that no Bid Strategy Value is required for the Bid Strategy Type 'Minimize' or 'Maximize'
- CPA
- CPC
- custom impr. value/cost
- CIVA
- IVO_TEN
- AV_VIEWED
- TRUE
- FALSE
This corresponding algorithm ID must be used when Bid Strategy Unit is set to custom impr. value/cost.
Any floodlight activies used in the algorithm assigned to this column must be included in the 'Conversion Floodlight Activity Ids' column. Attempts to assign an algorithm without properly updating the 'Conversion Floodlight Activity Ids' column will result in an error.
List of Creative IDs to assigned to the entry.
This column uses Display & Video 360 API Creative
resource IDs.
List format = (Creative.creativeId; Creative.creativeId; etc.). This list is generated in ascending numerical order.
On upload, users can also include Campaign Manager 360 Placement IDs
. Placement IDs should be preceded by the letters 'CM', ex 'CM789'.
Ex. (123;CM789;).
List of geographies to include in targeting.
This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_GEO_REGION
.
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
List of geographies to exclude in targeting.
This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_GEO_REGION
.
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
List of languages to include in targeting.
This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_LANGUAGE
.
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
List of languages to exclude in targeting.
This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_LANGUAGE
.
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
List of devices to include in targeting.
This column uses Display & Video 360 API TargetingOption
resource IDs for the following targeting types:
-
TARGETING_TYPE_DEVICE_TYPE
-
TARGETING_TYPE_DEVICE_MAKE_MODEL
-
TARGETING_TYPE_OPERATING_SYSTEM
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
List of devices to exclude in targeting.
This column uses Display & Video 360 API TargetingOption
resource IDs for the following targeting types:
-
TARGETING_TYPE_DEVICE_TYPE
-
TARGETING_TYPE_DEVICE_MAKE_MODEL
-
TARGETING_TYPE_OPERATING_SYSTEM
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
List of browsers to include in targeting.
This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_BROWSER
.
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
List of browsers to exclude in targeting.
This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_BROWSER
.
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
- G
- PG
- T
- MA
- ?
- Do not block
- Use Campaign Manager 360 Verification
- Use custom
- Sexual
- Derogatory
- Downloads & Sharing
- Weapons
- Gambling
- Violence
- Suggestive
- Profanity
- Alcohol
- Drugs
- Tobacco
- Politics
- Religion
- Tragedy
- Transportation Accidents
- Sensitive social issues
- Shocking
- None
- Integral Ad Science
- DoubleVerify
- Adloox
List of channels to include in targeting.
This column uses Display & Video 360 API Channel
resource IDs.
List format = (Channel.channelId; Channel.channelId; etc.).
List of channels to exclude in targeting.
This column uses Display & Video 360 API Channel
resource IDs.
List format = (Channel.channelId; Channel.channelId; etc.).
List of sites to include in targeting. The list is strings of URLs.
List format = (someurl.com; someurltwo.com; etc.). This list is generated in ascending alphabetical order.
List of sites to exclude in targeting. The list is strings of URLs.
List format = (someurl.com; someurltwo.com; etc.). This list is generated in ascending alphabetical order.
List of apps to include in targeting. The list is concatenated strings of app platform and app platform ID.
The following values are used to define the app platform:
-
APP
(This encompasses both Android Play store and Apple App store platforms) -
ROKU_APP
-
AMAZON_FIRETV_APP
-
XBOX_APP
-
PLAYSTATION_APP
-
APPLE_TV_APP
-
SAMSUNG_TV_APP
-
ANDROID_TV_APP
-
GENERIC_CTV_APP
-
LG_TV_APP
-
VIZIO_TV_APP
The concatenated string of app platform and ID is separated by a colon, for example: APP:com.google.android.gm
.
List format = (APP:com.google.android.gm; APP:422689480; etc.). This list is generated in ascending alphabetical order.
List of apps to exclude in targeting. The list is concatenated strings of app platform and app platform ID.
The following values are used to define the app platform:
-
APP
(This encompasses both Android Play store and Apple App store platforms) -
ROKU_APP
-
AMAZON_FIRETV_APP
-
XBOX_APP
-
PLAYSTATION_APP
-
APPLE_TV_APP
-
SAMSUNG_TV_APP
-
ANDROID_TV_APP
-
GENERIC_CTV_APP
-
LG_TV_APP
-
VIZIO_TV_APP
The concatenated string of app platform and ID is separated by a colon, for example: APP:com.google.android.gm
.
List format = (APP:com.google.android.gm; APP:422689480; etc.). This list is generated in ascending alphabetical order.
List of app collections to include in targeting.
This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_APP_CATEGORY
.
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.).
List of app collections to exclude in targeting.
This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_APP_CATEGORY
.
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.).
List of categories to include in targeting. This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_CATEGORY
.
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
TargetingOption
resource IDs for targeting type TARGETING_TYPE_CATEGORY
. List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
List of content genres to include in targeting.
This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_CONTENT_GENRE
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
List of content genres to exclude in targeting.
This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_CONTENT_GENRE
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
List of keyword strings to include in targeting.
This list is generated in ascending alphabetical order.
List of keyword strings to exclude in targeting.
This list is generated in ascending alphabetical order.
List of negative keyword lists to exclude in targeting.
This column uses Display & Video 360 API NegativeKeywordList
resource IDs.
List format = (NegativeKeywordList.negativeKeywordListId; NegativeKeywordList.negativeKeywordListId; etc.). This list is generated in ascending numerical order.
- TRUE
- FALSE
Optimized targeting is not compatible with all bid strategies. This column must be 'FALSE' if:
- 'Bid Strategy Type' is 'Fixed'
- 'Bid Strategy Type' is 'Optimized vCPM'
- 'Bid Strategy Type' is 'Maximum' and 'Bid Strategy Unit' is 'CIVA', 'IVO_TEN', or 'AV_VIEWED'
List of audience lists to include in targeting.
This column uses Display & Video 360 API FirstPartyAndPartnerAudience
resource IDs.
For first-party audience lists, each audience is listed as a pair of FirstPartyAndPartnerAudience.firstPartyAndPartnerAudienceId and recency setting. A pair is (1;1d;), where 1d is a sample recency representing 1 day recency. Recency is not available for third-party audiences, so the list format is (3;);(4;);. To "AND" and "OR" groups of audiences, follow this example: To combine pairs with and without recency: '((1;1d;);(2;365d;));((3;);(4;5m;);(5;all;));'. This means (list 1 with 1 day recency OR list 2 with 365day recency ) AND (list 3 without a specified recency OR list 4 with 5 minute recency OR list 5 with all users).
Valid recency values are:
- all
- 1m
- 5m
- 10m
- 15m
- 30m
- 1h
- 2h
- 3h
- 6h
- 12h
- 1d
- 2d
- 3d
- 5d
- 7d
- 10d
- 14d
- 15d
- 21d
- 28d
- 30d
- 45d
- 60d
- 90d
- 120d
- 180d
- 270d
- 365d
List of audience lists to exclude in targeting.
This column uses Display & Video 360 API FirstPartyAndPartnerAudience
resource IDs.
Each audience is listed as a pair of FirstPartyAndPartnerAudience.firstPartyAndPartnerAudienceId and recency setting, if the audience list is a 1P audience list. A pair is (1;1d;), where 1d is a sample recency representing 1 day recency. However, for 3P audiences, recency is not available, so the list format is (3;);(4;);.
List format = ((FirstPartyAndPartnerAudience.firstPartyAndPartnerAudienceId; recency optional;); (FirstPartyAndPartnerAudience.firstPartyAndPartnerAudienceId; recency optional;);)Example: "(1;1d;);(2;);".
Valid recency values are:
- all
- 1m
- 5m
- 10m
- 15m
- 30m
- 1h
- 2h
- 3h
- 6h
- 12h
- 1d
- 2d
- 3d
- 5d
- 7d
- 10d
- 14d
- 15d
- 21d
- 28d
- 30d
- 45d
- 60d
- 90d
- 120d
- 180d
- 270d
- 365d
List of affinity and/or in-market audience lists to include.
Audience list IDs can be retrieved from the Display & Video 360 interface.
List format = (Audience ID; Audience ID; etc.). This list is generated in ascending numerical order.
List of affinity and/or in-market audience lists to exclude.
Audience list IDs can be retrieved from the Display & Video 360 interface.
List format = (Audience ID; Audience ID; etc.). This list is generated in ascending numerical order.
List of combined audience lists to target.
This column uses Display & Video 360 API CombinedAudience
resource IDs.
List format = (CombinedAudience.combinedAudienceId; CombinedAudience.combinedAudienceId; etc.). This list is generated in ascending numerical order.
List of custom lists to target.
This column uses Display & Video 360 API CustomList
resource IDs.
List format = (CustomList.customListId; CustomList.customListId; etc.). This list is generated in ascending numerical order.
- Authorized Direct Sellers
- Authorized Direct Sellers And Resellers
- Authorized and Non-Participating Publisher
List of inventory sources, exchanges, and sub-exchanges to include in targeting.
This column uses Display & Video 360 API InventorySource
resource IDs, published exchange IDs
, and Display & Video 360 API TargetingOption
resource IDs of targeting type TARGETING_TYPE_SUB_EXCHANGE
.
List format = (InventorySource.inventorySourceId; exchangeId; TargetingOption.targetingOptionId; etc.)
List of inventory sources, exchanges, and sub-exchanges to exclude in targeting.
This column uses Display & Video 360 API InventorySource
resource IDs, published exchange IDs
, and Display & Video 360 API TargetingOption
resource IDs of targeting type TARGETING_TYPE_SUB_EXCHANGE
.
List format = (InventorySource.inventorySourceId; exchangeId; TargetingOption.targetingOptionId; etc.)
- True
- False
List of Grouped Deal IDs to include in targeting. Grouped Deal IDs can be found in the Grouped Deals section of My Inventory and the Groups section of Inventory Source settings in line items, insertion orders, and campaigns.
List format = (DealGroupId; DealGroupId; etc.). This list is generated in ascending numerical order.
List of IDs, where each daypart ID is constructed in the following format:
daypart_id = base_dayparting_id
+ days_since_monday * 10000
+ start * 100
+ end
base_dayparting_id = 300000
days_since_monday: 0=Monday, 1=Tuesday, ..., 6=Sunday
start: 0..95 (00:00--23:45) an integer from 0-95, representing 15min slots
end: 1..96 (00:15--24:00); an integer from 0-95, representing 15min slots
start < end
For new entities, times will be set in the timezone of your users(i.e., "Local"). For existing entities, the timezone will not be changed.
This list is generated in ascending numerical order.
- Local
- Advertiser
- Web
- Web Not Optimized
- App
- TRUE
- FALSE
- Above the fold
- Below the fold
- Unknown
- In-Article
- In-Feed
- In-Banner
- Interstitial
- Unknown
- In-Article
- In-Feed
- In-Banner
- Interstitial
- Unknown Out-Stream
- Pre-Roll
- Mid-Roll
- Post-Roll
- Unknown In-Stream
- Pre-Roll
- Mid-Roll
- Post-Roll
- Unknown
- unknown
- small
- large
- HD
- 0-1
- 1-5
- 5-15
- 15-30
- 30-60
- 60+
- unknown
- livestream
- on-demand
- unknown
- online radio
- streaming music
- podcasts
- Female
- Male
- Unknown
Example 1: to target 18-55 and include unknown ages, specify the format {From; To ; Include unknown True/False} = 18;55;true;
Example 2: to target only users >35 years old and exclude unknown ages, specify the following = 35;+;false;.
Acceptable values for From:
- 18
- 25
- 35
- 45
- 55
- 65
Acceptable values for To:
- 25
- 35
- 45
- 55
- 65
- +
Example 1: to target the top 10% to 50% of households and include households with unknown income, specify the format {Top_of_Range; Bottom_of_Range; Include unknown True/False} = Top 10%;41-50%;true;
Example 2: to target only the lower 50% of households and exclude households with unknown income, specify the format {Top_of_Range; Bottom_of_Range; Include unknown True/False} = Lower 50%;Lower 50%;true;
Acceptable values for Top_of_Range/Bottom_of_Range:
- Top 10%
- 11-20%
- 21-30%
- 31-40%
- 41-50%
- Lower 50%
- Parent
- Not a parent
- Unknown
- All
- 2G
- 3G
- DSL
- 4G
List of ISPs or Carriers to target.
This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_CARRIER_AND_ISP
.
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
List of ISPs or Carriers to exclude.
This column uses Display & Video 360 API TargetingOption
resource IDs for targeting type TARGETING_TYPE_CARRIER_AND_ISP
.
List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
Bid multipliers are no longer supported for new line items. This column is no longer writable.
All bid multipliers for this entry. List format = (row type;criteria ID;bid multiplier value); (row type;criteria ID;bid multiplier value);. Bid multiplier values can range between 0.1 and 10.0. Acceptable row types and their corresponding criteria ID's are listed in the following table:APP:com.google.android.gm
. The following values are used to define the app platform: -
APP
(This encompasses both Android Play store and Apple App store platforms) -
ROKU_APP
-
AMAZON_FIRETV_APP
-
XBOX_APP
-
PLAYSTATION_APP
-
APPLE_TV_APP
-
SAMSUNG_TV_APP
-
ANDROID_TV_APP
-
GENERIC_CTV_APP
-
LG_TV_APP
-
VIZIO_TV_APP
- 18-24
- 25-34
- 35-44
- 45-54
- 55-64
- 65+
- Unknown
- Male
- Female
- Unknown
- Parent
- Not a parent
- Unknown
- Top 10%
- 11-20%
- 21-30%
- 31-40%
- 41-50%
- Lower 50%
- Unknown
- Computer
- Smartphone
- Tablet
- Connected TV
- Connected Device
In-stream / In-feed Video are TrueView video ad types sold on a CPV basis. In-stream / Bumper are TrueView video ad types sold on a CPM basis. Bumpers are 6-second or less video ads sold on a CPM basis. Non-skippable video ads are in-stream ads between 6 and 15 seconds sold on a CPM basis. In-stream / Bumper / Non-skippable video ads are acceptable TrueView video ad types for Target Frequency line items sold on a CPM basis.
- In-stream
- In-stream / In-feed Video
- In-stream / Bumper
- Bumper
- Non Skippable
- In-stream / Bumper / Non-skippable
- Manual CPV: Manual view-based bidding where you pay per view.
- Manual CPM: Manual impression-based bidding where you pay per thousand impressions. This value is unsupported for new TrueView line items.
- Target CPM: Automated bid strategy that optimizes bids to help get as many impressions as possible using a target amount for how much you're willing to pay every thousand times your ad is shown.
- Maximize Conversions: Automated bid strategy that optimizes bids to help get as many conversions as possible.
- Target CPA: Automated bid strategy that optimizes bids to help get as many conversions as possible using a target amount for how much you're willing to pay per conversion.
- Maximize Conversion Value: Automated value-based bidding strategy that optimizes for the higher value conversions.
- Target ROAS: A value-based bidding strategy that optimizes for higher value of a conversion.
- Increase
- Decrease
When TrueView Bid Strategy Type is Target CPA or Maximize Conversions, acceptable adjustments are for Bid Adjustment Option 'Increase': 0; and for 'Decrease': 100%.
- Increase
- Decrease
When TrueView Bid Strategy Type is Target CPA or Maximize Conversions, acceptable adjustments are for Bid Adjustment Option 'Increase': 0; and for 'Decrease': 100%.
- Increase
- Decrease
When TrueView Bid Strategy Type is Target CPA or Maximize Conversions, acceptable adjustments are for Bid Adjustment Option 'Increase': 0; and for 'Decrease': 100%.
- Increase
- Decrease
When TrueView Bid Strategy Type is Target CPA or Maximize Conversions, acceptable adjustments are for Bid Adjustment Option 'Increase': 0; and for 'Decrease': 100%.
- Embedded Videos
- Live Streaming
- Games
- Families
- Limited
- Standard
- Expanded
- YouTube
- Video Partners
'Video Partners' must be included for Demand Gen line items.
- None
- Moat
- DoubleVerify
- Integral Ad Science
- None
- DoubleVerify
- Integral Ad Science
- Zefr
- None
- Nielsen
- Comscore
- Kantar
- Gemius
- Video Research
- Media Scope
- Audience Project
- iSpot TV
- VideoAmp
- None
- Kantar
- Dynata
- Intage
- Nielsen
- Macromill
- Weekly, Monthly