Structured Data - v7.1 - Line Items

See the overview for an explanation of format.

Field Required Type Writable Description

Line Item Id Required only when editing existing Line Items integer No Numeric ID value of the line item. If left blank, a new line item will be created and a unique ID will be assigned. Optionally, when creating new Line Items, you can use a custom identifier for the purpose of assigning TrueView Ad Groups to the new Line Item. The format for a custom identifier is "ext[custom identifier]", for example, ext123. When the file is uploaded and processed, all custom identifiers will be replaced with DBM-assigned IDs and the objects will be associated (for example, Ad Group to Line Item) based on the custom identifiers.

Io Id Yes integer No Numeric ID value of the insertion order. You can specify a custom identifier (for example, "ext[custom IO identifier]") for an insertion order that you are creating at the same time as this line item.

Io Name No string No Insertion Order Name

Type

Yes

string

Yes

The type of entry. Only writable when creating, not editing.

Display
Video
TrueView
Audio

Subtype

Yes

string

Yes

Field required for line items to distinguish between different formats

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

Name Yes string Yes The name of the entry.

Timestamp Required when editing existing entries integer No The timestamp for the entry, this is used by the system to verify that the entry has not changed between downloading and uploading.

Status

Yes

string

Yes

The status setting for the entry.

Active
Paused
Draft
Archived

Start Date Yes string Yes A timestamp for the flight start date of the entry in the format MM/DD/YYYY or "Same as Insertion Order" to use the same start date as the parent Insertion Order.

End Date Yes string Yes A timestamp for the flight end date of the entry in the format MM/DD/YYYY or "Same as Insertion Order" to use the same end date as the parent Insertion Order.

Budget Type

Yes

string

Yes

Specifies whether the budget is monetarily based or impression-based. If the IO for this entry is enabled for auto-budget allocation, you can set this to 'Automatic' to allow DBM to automatically budget for this entry.

Amount
Impressions
Unlimited
Automatic
TrueView Budget

Budget Amount Required when "Type" is "Display" or "Video" or "Audio" float Yes A positive budget amount for the budget type. This could be a simple integer impression value, or a float for a currency amount. Currencies will be shown in the advertiser's currency in standard units (not in 1/1,000,000s of a currency unit). If 'Automatic' budget allocation is set on the entry, you can specify a minimum amount to spend (for example, 'spend at least' this amount).

Pacing

Yes

string

Yes

The time period used to spend to the pacing amount.

Daily
Monthly
Flight

TrueView Line Items can only be 'Daily' or 'Flight'

Pacing Rate

Yes

string

Yes

The rate of pacing for this entry.

ASAP
Even
Ahead

TrueView Line Items can only be 'ASAP' or 'Even'

Pacing Amount Required when 'Type' is 'Display' or 'Video' or 'Audio'. Required when 'Type' is 'TrueView' and 'Pacing' is 'Daily'. float Yes The amount to spend per the time period set by the pacing type.

Frequency Enabled

Yes

string

Yes

Enables/disables impression-based frequency capping on the line item.

TRUE
FALSE

Frequency Exposures Required when "Frequency Enabled" is "TRUE" integer Yes A positive integer amount for the number of impressions in a given Frequency Amount, that is, the x in 'Show x impressions over y period'.

Frequency Period

Required when "Frequency Enabled" is "TRUE"

string

Yes

Specifies the time period unit for the frequency cap. For TrueView line items, supported periods are Days, Weeks, Months.

Minutes
Hours
Days
Weeks
Months
Lifetime

Frequency Amount Required when "Frequency Enabled" is "TRUE" integer Yes A positive integer amount for length of time of the Frequency Period type, that is, the y in 'Show x impressions over y period'. This amount is not supported for TrueView line items.

TrueView View Frequency Enabled

Required when "Type" is "TrueView"

string

Yes

Enables/disables view-based frequency capping on the TrueView line item

TRUE
FALSE

TrueView View Frequency Exposures Required when "TrueView View Frequency Enabled" is "TRUE" integer Yes A positive integer amount for the number of TrueView views, that is, the x in 'Show x views over the period'

TrueView View Frequency Period

Required when "TrueView View Frequency Enabled" is "TRUE"

string

Yes

Specifies the time period unit for the TrueView view-based frequency cap

Days
Weeks
Months

Partner Revenue Model

string

Yes

A partner revenue model is the mechanism for controlling how revenue is calculated in Bid Manager. Use the partner revenue model to track the markup for your service fees. Column Partner Revenue Amount should be specified when column Partner Revenue Model is included.

TMCM - Total Media Cost Markup
MCM - Media Cost Markup
CPM - Cost Per thousand impressions

Partner Revenue Amount Required only when column Partner Revenue Model is specified. float Yes A positive float value corresponding to the Partner Revenue Model. Only applicable when column Partner Revenue Model is specified.

Conversion Counting Type

Required when "Type" is "Display" or "Video" or "Audio" or "TrueView"

string

Yes

Choose the kinds of conversions that are counted.

Count all
Count post-click
Count %

Conversion Counting Pct Required when "Type" is "Display" or "Video" or "Audio" or "TrueView" float Yes Specify the % for 'Count %' Conversion Counting Type. Format the % as a float (3.123% = 3.123), with precision limited to the thousands (3 decimal places).

Conversion Floodlight Activity Ids

string, list of lists

Yes

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;);).

Primary Attribution Model Id No integer Yes The attribution model id used for the associated line item.

Fees

string, list of lists

Yes

All fees for this entry. List format = (Fee category; Fee amount; Fee type; Invoiced;).

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)

Integration Code No string Yes An optional code for tracking purposes.

Details No string Yes Entry details in string format.

Bid Strategy Type

Required when "Type" is "Display" or "Video" or "Audio"

string

Yes

Select one of the applicable bid strategies:

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

Bid Strategy Value Required unless "Bid Strategy Type" is "Minimize", "Maximize" or "Type" is "TrueView" float Yes For Beat, Optimize VCPM, Fixed strategy types, choose a value for the goal bid.
Note that no Bid Strategy Value is required for the Bid Strategy Type 'Minimize' or 'Maximize'

Bid Strategy Unit

Required when "Bid Strategy Type" is "Beat" ,"Minimize" or "Maximize"

string

Yes

For Beat, Minimize or Maximize strategy types, select the corresponding unit:

CPA
CPC
custom impr. value/cost
CIVA
IVO_TEN
AV_VIEWED

Bid Strategy Do Not Exceed Required when "Type" is "Display" or "Video" or "Audio" float Yes Set a 'do not exceed' CPM value. If 0, 'do not exceed' is not enabled. This is available only if the Bid Strategy is 'Minimize', 'Maximize' or 'Beat'.

Apply Floor Price For Deals

Required when "Bid Strategy Type" is "Minimize" or "Maximize"

string

Yes

Whether to prioritize deals over open auction inventory

TRUE
FALSE

Algorithm Id Required when 'Bid Strategy Unit' custom impr. value/cost . integer Yes This corresponding algorithm ID must be used when Bid Strategy Unit is set to custom impr. value/cost.

Creative Assignments

string, list

Yes

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;).

Geography Targeting - Include

string, list

Yes

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.

Geography Targeting - Exclude

string, list

Yes

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.

Geography Regional Location List Targeting - Include No string, list Yes List of geo regional location list ids to include. List format = (11; 22; 33;).

Geography Regional Location List Targeting - Exclude No string, list Yes List of geo regional location list ids to exclude. List format = (11; 22; 33;).

Proximity Targeting No string, list of lists Yes List of proximity targets each in the format "(Latitude; Longitude; Radius; Unit; FullAddress;);". Latitude is between -90 and 90 degrees (inclusive); Longitude is between -180 and 180 degrees (inclusive); Radius is a distance between 1 and 500 (inclusive) in Unit; Unit can be "mi" or "km"; FullAddress is optional. For example: "(38.907192; -77.03687; 1.0; mi; Washington D.C., DC, USA;); (40.712775; -74.005972; 20.5; km; 40.712775, -74.005972;); (20.000234; -56.675423; 5.0; mi; ;);".

Proximity Location List Targeting No string, list of lists Yes List of proximity list targets for insertion orders or Non-TrueView line items, each in the format "(ProximityListId; Radius; Unit; );". ProximityListId is a location list id under an advertiser's resources. Radius is a distance between 1 and 500 (inclusive) in Unit; Unit can be "mi" or "km"; There is a limit of targeting two location lists per entity along with Geography Regional Location Lists. For example: "(10041691678; 20.0; mi;); (10038858567; 20.5; km;);".

Language Targeting - Include

string, list

Yes

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.

Language Targeting - Exclude

string, list

Yes

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.

Device Targeting - Include

string, list

Yes

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.

Device Targeting - Exclude

string, list

Yes

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.

Browser Targeting - Include

string, list

Yes

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.

Browser Targeting - Exclude

string, list

Yes

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.

Digital Content Labels - Exclude

string, list

Yes

List of the digital content labels to exclude. List format = (G;PG; etc.).

Brand Safety Sensitivity Setting

string

Yes

Choose the sensitivity setting to block inventory based on the subject matter of its surrounding content.

Do not block
Use Campaign Manager 360 Verification
Use custom

Brand Safety Custom Settings

Required when "Brand Safety Custom Setting" is "Use Custom"

string, list

Yes

If the Brand Safety Sensitivity Setting is 'Use custom', specify the list of standard content classifiers. For example, (Sexual;Alcohol;Tobacco;etc.).

Sexual
Derogatory
Downloads & Sharing
Weapons
Gambling
Violence
Suggestive
Profanity
Alcohol
Drugs
Tobacco
Politics
Religion
Tragedy
Transportation Accidents
Sensitive social issues
Shocking

Third Party Verification Services

string

Yes

Third party verification services provider.

None
Integral Ad Science
DoubleVerify
Adloox

Third Party Verification Labels No string, list Yes If Third Party Verification Services is not "None", specify a list of labels supported by the selected provider.

Channel Targeting - Include

string, list

Yes

List of channels to include in targeting.

This column uses Display & Video 360 API Channel resource IDs.

List format = (Channel.channelId; Channel.channelId; etc.).

Channel Targeting - Exclude

string, list

Yes

List of channels to exclude in targeting.

This column uses Display & Video 360 API Channel resource IDs.

List format = (Channel.channelId; Channel.channelId; etc.).

Site Targeting - Include

string, list

Yes

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.

Site Targeting - Exclude

string, list

Yes

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.

App Targeting - Include

string, list

Yes

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 ID is provided by the relevant platform, such as a bundle ID from Android's Play store (example: com.google.android.gm) or a App ID from Apple's App store (example: 422689480).

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.

App Targeting - Exclude

string, list

Yes

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 ID is provided by the relevant platform, such as a bundle ID from Android's Play store (example: com.google.android.gm) or a App ID from Apple's App store (example: 422689480).

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.

App Collection Targeting - Include

string, list

Yes

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.).

App Collection Targeting - Exclude

string, list

Yes

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.).

Category Targeting - Include

string, list

Yes

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.

Category Targeting - Exclude

string, list

Yes

List of categories to exclude 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.

Content Genre Targeting - Include

string, list

Yes

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.

Content Genre Targeting - Exclude

string, list

Yes

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.

Keyword Targeting - Include

string, list

Yes

List of keyword strings to include in targeting.

This list is generated in ascending alphabetical order.

Keyword Targeting - Exclude

string, list

Yes

List of keyword strings to exclude in targeting.

This list is generated in ascending alphabetical order.

Keyword List Targeting - Exclude

string, list

Yes

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.

Optimized Targeting

string

Yes

Enable optimized targeting.

TRUE
FALSE

Optimized targeting is not compatible with all bid strategies. This column must be 'FALSE' if:

'Bid Strategy Type' is 'Optimized vCPM'
'Bid Strategy Type' is 'Maximum' and 'Bid Strategy Unit' is 'CIVA', 'IVO_TEN', or 'AV_VIEWED'

Audience Targeting - Include

string, list of list of pairs

Yes

List of audience lists to include in targeting.

This column uses Display & Video 360 API FirstAndThirdPartyAudience resource IDs.

For first-party audience lists, each audience is listed as a pair of FirstAndThirdPartyAudience.firstAndThirdPartyAudienceId 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

Audience Targeting - Exclude

string, list of list of pairs

Yes

List of audience lists to exclude in targeting.

This column uses Display & Video 360 API FirstAndThirdPartyAudience resource IDs.

Each audience is listed as a pair of FirstAndThirdPartyAudience.firstAndThirdPartyAudienceId 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 = ((FirstAndThirdPartyAudience.firstAndThirdPartyAudienceId; recency optional;); (FirstAndThirdPartyAudience.firstAndThirdPartyAudienceId; 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

Affinity & In Market Targeting - Include

string, list

Yes

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.

Affinity & In Market Targeting - Exclude

string, list

Yes

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.

Combined Audience Targeting

string, list

Yes

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.

Custom List Targeting

string, list

Yes

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.

Inventory Source Targeting - Authorized Seller Options

Required when "Type" is "Display" or "Video" or "Audio"

string

Yes

Setting to target authorized direct sellers, authorized direct seller and resellers, or authorized seller + unknown. "Authorized Direct" means only authorized sellers will be targeted. "Authorized Direct Sellers And Resellers" means targeting the authorized sellers and resellers. "Authorized and Non-Participating Publisher" means it will target authorized sellers, resellers, and unknown sellers.

Authorized Direct Sellers
Authorized Direct Sellers And Resellers
Authorized and Non-Participating Publisher

Inventory Source Targeting - Include

Required when "Type" is "Display" or "Video" or "Audio"

string, list

Yes

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.)

Inventory Source Targeting - Exclude

string, list

Yes

List of inventory sources, exchanges, and sub-exchanges to exclude in targeting.

List format = (InventorySource.inventorySourceId; exchangeId; TargetingOption.targetingOptionId; etc.)

Inventory Source Targeting - Target New Exchanges

string

Yes

Setting to target new exchanges.

True
False

Private Deal Group Targeting Include

string, list

Yes

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.

Daypart Targeting

string, list

Yes

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.

Daypart Targeting Time Zone

Required when "Daypart Targeting" is included.

string

Yes

Timezone to use for daypart targeting.

Local
Advertiser

TrueView Line Items can only be 'Advertiser.'

Environment Targeting

string, list

Yes

List of environments to target. Select one or more of the acceptable values. Please note that 'Web Not Optimized' cannot be selected without selecting 'Web'.

Web
Web Not Optimized
App

Viewability Omid Targeting Enabled

string

Yes

Enables targeting only impressions that are measurable through the open Measurement standard.

TRUE
FALSE

Viewability Targeting Active View No string Yes Target predicted viewability percentages. Percentages are represented as floats. One of {0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9}

Position Targeting - On Screen

string, list

Yes

On screen ad positions targeting. Select one or more of the acceptable values:

Above the fold
Below the fold
Unknown

Position Targeting - Display Position In Content

string, list

Yes

Display ad content positions to target. Select one or more of the acceptable values:

In-Article
In-Feed
In-Banner
Interstitial
Unknown

Position Targeting - Video Position In Content

string, list

Yes

Video ad content positions to target. Select one or more of the acceptable values:

In-Article
In-Feed
In-Banner
Interstitial
Unknown Out-Stream
Pre-Roll
Mid-Roll
Post-Roll
Unknown In-Stream

Position Targeting - Audio Position In Content

string, list

Yes

Audio ad content positions to target. Select one or more of the acceptable values:

Pre-Roll
Mid-Roll
Post-Roll
Unknown

Video Player Size Targeting

string, list

Yes

List of video ad player size to target. Select one or more of the acceptable values:

unknown
small
large
HD

Content Duration Targeting

string, list

Yes

List of content durations to target. Unit value is minutes. Select one or more of the acceptable values:

0-1
1-5
5-15
15-30
30-60
60+
unknown

Content Stream Type Targeting

string, list

Yes

List of content stream types to target. Select one or more of the acceptable values:

livestream
on-demand

Audio Content Type Targeting

string, list

Yes

List of audio content type to target. Select one or more of the acceptable values:

unknown
online radio
streaming music
podcasts

Demographic Targeting Gender

string, list

Yes

List of genders to target. Select one or more of the acceptable values:

Female
Male
Unknown

Demographic Targeting Age

string, list

Yes

Target to a user age range. Specify a from/to range by selecting a single From age and a single To age and whether to include unknown ages true/false. See the list of acceptable From/To ages.
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:

Acceptable values for To:

Demographic Targeting Household Income

string, list

Yes

Target a household income range. Specify a from/to range by selecting a single Top_of_Range income range and a single Bottom_of_Range income range and whether to include households with unknown income true/false. See the list of acceptable Top_of_Range/Bottom_of_Range ranges.
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%

Demographic Targeting Parental Status

Yes

string, list

Yes

List of parental status to target. Select one or more of the acceptable values.

Parent
Not a parent
Unknown

Connection Speed Targeting

string

Yes

Target to a specific connection speed. Select one of the acceptable values:

Carrier Targeting - Include

string, list

Yes

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.

Carrier Targeting - Exclude

string, list

Yes

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

string, list of lists

Yes

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:

Row Type	Dimension	Criteria ID
app	App	A concatenated string of app platform and app platform ID. The concatenated string of app platform and ID is separated by a colon, for example: `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` The concatenated string of app platform and ID is separated by a colon. eg. (app;APP:com.google.android.gm;1.0);(app;APP:422689480;2.5);
site	URL	String of site URL. eg. (site;'someurl.com';1.0);(site;'someurltwo.com';2.5);
user_list	Audience List	The user list ID. eg. (user_list;UserList.id;1.0);(user_list;UserList.id;2.5);
user_interest	Audience List	The user interest ID. eg. (user_interest;UserList.id;1.0);(user_interest;UserList.id;2.5);
custom_affinity	Audience List	The custom affinity ID. eg. (custom_affinity;CustomAffinity.id;1.0);(custom_affinity;CustomAffinity.id;2.5);
day_part	Day Part	The day part ID is defined in the Daypart Targeting column. eg 314159 represents "Tuesday, 10:15 AM - 2:45 PM." eg. (day_part;314159;1.0);(day_part;302312;2.5);
age_range	Demographics	The age range, separated as From-To. Acceptable values are: 18-24 25-34 35-44 45-54 55-64 65+ Unknown eg. (age_range;55-64;1.0);(age_range;65+;2.5);
gender	Demographics	The gender. Acceptable values are: Male Female Unknown eg. (gender;Male;1.0);(gender;Female;2.5);
parental_status	Demographics	The parental status. Acceptable values are: Parent Not a parent Unknown eg. (parental_status;Not a parent;1.0);
household_income	Demographics	The household income percentile range. Acceptable values are: Top 10% 11-20% 21-30% 31-40% 41-50% Lower 50% Unknown eg. (household_income;Top 10%;1.0);(household_income;Unknown;2.5);
device_type	Device Type	The device type. Acceptable values are: Computer Smartphone Tablet Connected TV Connected Device eg. (device_type;Computer;1.0);(device_type;Tablet;2.5);
geo	Geography	The geography location ID. eg. (geo;2840;1.0);
private_deal	Private Deal	The private deal targeting ID. eg. (private_deal;1016301;1.0);
private_deal	Private Deal	The private deal targeting ID. eg. (private_deal;1016301;1.0);
public_exchange	Public Exchange	The public exchange ID. eg. (public_exchange;17;1.0);
unclassified_exchange	Unclassified Exchange	The unclassified exchange target ID (= 5000 + exchange_id).eg. (unclassified_exchange;5017;1.0);
sub_exchange	Sub-exchange	The format is [exchange_id]-[sub_exchange_targeting_id].eg. (sub_exchange;38-4515403;1.0);

TrueView Video Ad Formats

Yes for TrueView Line Items

string

Yes

The video ad format of the line item.

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. Responsive video ads are ad types that serve as multiple formats.

In-stream
In-stream / In-feed Video
In-stream / Bumper
Bumper
Non Skippable
In-stream / Bumper / Non-skippable
Responsive

TrueView Bid Strategy Type

Yes for TrueView Line Items

string

Yes

Select one of the applicable TrueView bid strategies:

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.

TrueView Bid Strategy Value Yes for TrueView Line Items float Yes For the Target CPA or Target ROAS bid strategy type, choose a value for the target bid. For the other "TrueView Bid Strategy Type" values or non-TrueView line items this column should be 0 when uploading. For Target ROAS, this column should be the percentage as a fraction, e.g., if you want Target ROAS to be 150%, put 1.5 to this column.

TrueView Mobile Bid Adjustment Option

string

Yes

Either 'Increase' or 'Decrease'

Increase
Decrease

TrueView Mobile Bid Adjustment Percentage Yes when TrueView Bid Strategy Type is Target CPA or Maximize Conversions integer Yes Bid adjustment to increase chances of showing ads on mobile. Acceptable adjustments are for Bid Adjustment Option 'Increase': [0;900%]; and for 'Decrease': [0;90%] or 100%.
When TrueView Bid Strategy Type is Target CPA or Maximize Conversions, acceptable adjustments are for Bid Adjustment Option 'Increase': 0; and for 'Decrease': 100%.

TrueView Desktop Bid Adjustment Option

string

Yes

Either 'Increase' or 'Decrease'

Increase
Decrease

TrueView Desktop Bid Adjustment Percentage Yes when TrueView Bid Strategy Type is Target CPA or Maximize Conversions integer Yes Bid adjustment to increase chances of showing ads on desktop. Acceptable adjustments are for Bid Adjustment Option 'Increase': [0;900%]; and for 'Decrease': [0;90%] or 100%.
When TrueView Bid Strategy Type is Target CPA or Maximize Conversions, acceptable adjustments are for Bid Adjustment Option 'Increase': 0; and for 'Decrease': 100%.

TrueView Tablet Bid Adjustment Option

string

Yes

Either 'Increase' or 'Decrease'

Increase
Decrease

TrueView Tablet Bid Adjustment Percentage Yes when TrueView Bid Strategy Type is Target CPA or Maximize Conversions integer Yes Bid adjustment to increase chances of showing ads on tablet. Acceptable adjustments are for Bid Adjustment Option 'Increase': [0;900%]; and for 'Decrease': [0;90%] or 100%.
When TrueView Bid Strategy Type is Target CPA or Maximize Conversions, acceptable adjustments are for Bid Adjustment Option 'Increase': 0; and for 'Decrease': 100%.

TrueView Connected TV Bid Adjustment Option

string

Yes

Either 'Increase' or 'Decrease'

Increase
Decrease

TrueView Connected TV Bid Adjustment Percentage Yes when TrueView Bid Strategy Type is Target CPA or Maximize Conversions integer Yes Bid adjustment to increase chances of showing ads on connected TVs. Acceptable adjustments are for Bid Adjustment Option 'Increase': [0;900%]; and for 'Decrease': [0;90%] or 100%.
When TrueView Bid Strategy Type is Target CPA or Maximize Conversions, acceptable adjustments are for Bid Adjustment Option 'Increase': 0; and for 'Decrease': 100%.

TrueView Category Exclusions Targeting

string, list

List of categories to exclude. List format = Embedded Videos; Families; etc.

Embedded Videos
Live Streaming
Games
Families

TrueView Content Filter

string

Yes

TrueView content filter.

Limited
Standard
Expanded

TrueView Inventory Source Targeting

string, list

Yes

Lists of TrueView inventory sources to include

YouTube
Google TV
Video Partners

TrueView Third-Party Viewability Vendor

Required only when editing existing TrueView line items

string, list of lists

Yes

Third-party vendor measuring viewability for TrueView line item. If this is left empty during TrueView line item creation and there is a default viewability vendor enabled at the advertiser level, the line item will be created with the advertiser-level default vendor enabled.

None
Moat
DoubleVerify
Integral Ad Science

TrueView Third-Party Viewability Reporting ID Yes when third-party viewability vendor is not 'None'. string Yes ID used by your third-party viewability vendor to identify events for specific reports. An empty string is valid for this column, which sets the reporting ID to empty.

TrueView Third-Party Brand Safety Vendor

Required only when editing existing TrueView line items

string, list of lists

Yes

Third-party vendor measuring brand safety for TrueView line item. If this is left empty during TrueView line item creation and there is a default brand safety vendor enabled at the advertiser level, the line item will be created with the advertiser-level default vendor enabled.

None
DoubleVerify
Integral Ad Science
Zefr

TrueView Third-Party Brand Safety Reporting ID Yes when third-party brand safety vendor is not 'None'. string Yes ID used by your third-party brand safety vendor to identify events for specific reports. An empty string is valid for this column, which sets the reporting ID to empty.

TrueView Third-Party Reach Vendor

Required only when updating existing TrueView line items

string, list of lists

Yes

Third-party vendor measuring reach for TrueView line item. If this is left empty during TrueView line item creation and there is a default reach vendor enabled at the advertiser level, the line item will be created with the advertiser-level default vendor enabled.

None
Nielsen
Comscore
Kantar
Gemius
Video Research
Media Scope
Audience Project
iSpot TV
VideoAmp

TrueView Third-Party Reach Reporting ID Yes when third-party reach vendor is not 'None'. string Yes ID used by your third-party reach vendor to identify events for specific reports. An empty string is valid for this column, which sets the reporting ID to empty.

TrueView Third-Party Brand Lift Vendor

Required only when updating existing TrueView line items

string, list of lists

Yes

Third-party vendor measuring brand lift for TrueView line item. If this is left empty during TrueView line item creation and there is a default brand lift vendor enabled at the advertiser level, the line item will be created with the advertiser-level default vendor enabled.

None
Kantar
Dynata
Intage
Nielsen
Macromill

TrueView Third-Party Brand Lift Reporting ID Yes when third-party brand lift vendor is not 'None'. string Yes ID used by your third-party brand lift vendor to identify events for specific reports. An empty string is valid for this column, which sets the reporting ID to empty.

TrueView Target Frequency Count Yes when the line item subtype is Target Frequency integer Yes The target frequency count set for a Target Frequency type YouTube line item. This field can only be set with value 2, 3, or 4. For YouTube line items that are not of type Target Frequency, this field should be empty.

TrueView Target Frequency Time Window

Yes when the line item subtype is Target Frequency

string

Yes

The target frequency time window for a Target Frequency type YouTube line item. This field can only be set to Weekly for now. For YouTube line items that are not of type Target Frequency, this field should be empty.

Weekly

TrueView Video Ad Inventory Control

Yes when the TrueView line item subtype is Reach and using in-feed and shorts ads

string, list

Yes

The video ad inventory control for this line item. Select one or more of the acceptable ad format values:

In-stream
In-feed
Shorts