Structured Data - v8 - Line Item QA

See the overview for an explanation of format.

This is a QA file format. Files in this format are read-only and cannot be uploaded.

FieldTypeDescription
Line Item Idinteger
Io Idinteger
Io NamestringInsertion Order Name
TypestringThe type of entry.

Only writable when creating, not editing.

Select one of the following values:
  • Display
  • Video
  • TrueView
  • Audio
  • Demand Gen
SubtypestringField required for line items to distinguish between different formats.

Select one of the following values:
  • 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
  • Demand Gen
NamestringThe name of the entry.
TimestampintegerThe timestamp for the entry, this is used by the system to verify that the entry has not changed between downloading and uploading.
StatusstringThe status setting for the entry.
  • Active
  • Paused
  • Archived
  • Deleted
  • Draft
Start DatestringA 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 DatestringA 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 TypestringSpecifies 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 AmountfloatA 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).
PacingstringThe time period used to spend to the pacing amount.
  • Daily
  • Monthly
  • Flight
Pacing RatestringThe rate of pacing for this entry.
  • ASAP
  • Even
  • Ahead
Pacing AmountfloatThe amount to spend per the time period set by the pacing type.
Frequency Enabledstring
Frequency ExposuresintegerA 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 Periodstring
  • Minutes
  • Hours
  • Days
  • Weeks
  • Months
  • Lifetime
Frequency Amountinteger
TrueView View Frequency EnabledstringEnables/disables view-based frequency capping on the TrueView line item
  • TRUE
  • FALSE
TrueView View Frequency ExposuresintegerA positive integer amount for the number of TrueView views, that is, the x in 'Show x views over the period'
TrueView View Frequency PeriodstringSpecifies the time period unit for the TrueView view-based frequency cap
  • Days
  • Weeks
  • Months
Partner Revenue ModelstringA 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 AmountfloatA positive float value corresponding to the Partner Revenue Model. Only applicable when column Partner Revenue Model is specified.
Conversion Counting TypestringChoose the kinds of conversions that are counted.
  • Count all
  • Count post-click
  • Count %
Conversion Counting PctfloatSpecify 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 Qastring, list of lists

The floodlight activities used for conversions and related settings.

This column uses Display & Video 360 API FloodlightActivity resource display name and measurements, in minutes, of post-view and post-click windows.

List of list format = ((FloodlightActivity.displayName; view_window_days; click_window_days;);(FloodlightActivity.displayName; view_window_days; click_window_days;);).

This list is generated in ascending alphabetical order.

Primary Attribution Model Id QastringThe attribution model name for the associated line item.
Feesstring, list of listsAll 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 categoryFee TypeInvoiced option
CPM/MediaDefaultNot permitted (leave blank)
CPM/MediaThird-Party Ad ServerNot permitted (leave blank)
CPM/MediaDoubleVerifyPermitted (True/False)
CPM/MediaAdsafeNot permitted (leave blank)
CPM/MediaAdxposeNot permitted (leave blank)
CPM/MediaVizuNot permitted (leave blank)
CPM/MediaAggregate KnowledgeNot permitted (leave blank)
CPM/MediaTeracentNot permitted (leave blank)
CPM/MediaEvidonNot permitted (leave blank)
CPM/MediaAgency Trading Desk FeeNot permitted (leave blank)
CPM/MediaAdlooxPermitted (True/False)
CPMShopLocalRequired (True)
CPMTrustMetricsNot permitted (leave blank)
CPMIntegral Ad Science VideoPermitted (True/False)
CPMMOAT VideoNot permitted (leave blank)
MediaDisplay & Video 360 FeeRequired (True)
MediaMedia Cost DataNot permitted (leave blank)
MediaScibids FeeRequired (True)
Integration CodestringAn optional code for tracking purposes.
DetailsstringEntry details in string format.
Bid Strategy Typestring 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 ValuefloatFor 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 UnitstringFor Beat, Minimize or Maximize strategy types, select the corresponding unit:
  • CPA
  • CPC
  • custom impr. value/cost
  • CIVA
  • IVO_TEN
  • AV_VIEWED
  • INCREMENTAL_CONVERSIONS
Bid Strategy Do Not ExceedfloatSet 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 DealsstringWhether to prioritize deals over open auction inventory
Algorithm IdintegerThis corresponding algorithm ID must be used when Bid Strategy Unit is set to custom impr. value/cost.
Creative Assignments Qastring, listList of Creatives assigned to the entry. List format = (Creative name; Creative name; etc.). This list is generated in alphabetical order.
Geography Targeting - Include Qastring, listList of geography regions to include in targeting. List format = (Geo Region Name; Geo Region Name; etc.). This list is generated in alphabetical order.
Geography Targeting - Exclude Qastring, listList of geography regions to exclude in targeting. List format = (Geo Region Name; Geo Region Name; etc.). This list is generated in alphabetical order.
Geography Regional Location List Targeting - Include Qastring, listList of regional location lists names to include in targeting. An entity can only target two location lists, including proximity location lists. List format = (Location list name; Location list name;).
Geography Regional Location List Targeting - Exclude Qastring, listList of regional location lists names to exclude in targeting. An entity can only target two location lists, including proximity location lists. List format = (Location list name; Location list name;).
Proximity Targetingstring, list of listsList 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 Qastring, list of listsList of proximity location lists to include in targeting for insertion orders or Non-TrueView line items, each in the format "(Proximity list name; Radius; Unit;);". Radius is a distance between 1 and 500 (inclusive) in Unit; Unit can be "mi" or "km"; An entity can only target two location lists, including regional location Lists. For example: "(Proximity list 1; 20.0; mi;); (Proximity list 2; 20.5; km;);". This list is generated in alphabetical order.
Language Targeting - Include Qastring, listList of languages to include in targeting. List format = (Language name; Language name; etc.). This list is generated in alphabetical order.
Language Targeting - Exclude Qastring, listList of languages to exclude in targeting. List format = (Language name; Language name; etc.). This list is generated in alphabetical order.
Device Targeting - Include Qastring, listList of devices to include in targeting. List format = (Device name; Device name; etc.). This list is generated in alphabetical order.
Device Targeting - Exclude Qastring, listList of devices to exclude in targeting. List format = (Device name; Device name; etc.). This list is generated in alphabetical order.
Browser Targeting - Include Qastring, listList of browsers to include in targeting. List format = (Browser name; Browser name; etc.). This list is generated in alphabetical order.
Browser Targeting - Exclude Qastring, listList of browsers to exclude in targeting. List format = (Browser name; Browser name; etc.). This list is generated in alphabetical order.
Digital Content Labels - Excludestring, listList of the digital content labels to exclude. List format = (G;PG; etc.).
  • G
  • PG
  • T
  • MA
  • ?
Brand Safety Sensitivity SettingstringChoose 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 Settingsstring, listIf 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 ServicesstringThird party verification services provider.
  • None
  • Integral Ad Science
  • DoubleVerify
  • Adloox
Third Party Verification Labelsstring, listIf Third Party Verification Services is not "None", specify a list of labels supported by the selected provider.
Channel Targeting - Include Qastring, listList of channels to include in targeting. List format = (Channel name; Channel name; etc.). This list is generated in alphabetical order.
Channel Targeting - Exclude Qastring, listList of channels to exclude in targeting. List format = (Channel name; Channel name; etc.). This list is generated in alphabetical order.
Site Targeting - Include Qastring, list

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 alphabetical order.

If the total character length of the list exceeds 32700 characters, individual URLs in the list will be truncated as needed. Truncated URLs will be no shorter than 10 characters.

Site Targeting - Exclude Qastring, list

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 alphabetical order.

If the total character length of the list exceeds 32700 characters, individual URLs in the list will be truncated as needed. Truncated URLs will be no shorter than 10 characters.

App Targeting - Include Qastring, list

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.

If the total character length of the list exceeds 32700 characters, individual entries in the list will be truncated as needed. Truncated entries will be no shorter than 10 characters.

App Targeting - Exclude Qastring, list

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.

If the total character length of the list exceeds 32700 characters, individual entries in the list will be truncated as needed. Truncated entries will be no shorter than 10 characters.

App Collection Targeting - Include Qastring, listList of app collections to include in targeting. List format = (App Collection name; App Collection name; etc.). This list is generated in alphabetical order.
App Collection Targeting - Exclude Qastring, listList of app collections to exclude in targeting. List format = (App Collection name; App Collection name; etc.). This list is generated in alphabetical order.
Category Targeting - Include Qastring, listList of categories to include in targeting. List format = (Category name; Category name; etc.). This list is generated in alphabetical order.
Category Targeting - Exclude Qastring, listList of categories to exclude in targeting. List format = (Category name; Category name; etc.). This list is generated in alphabetical order.
Content Genre Targeting - Include Qastring, listList of content genres to include in targeting. List format = (Content genre name; Content genre name; etc.). This list is generated in alphabetical order.
Content Genre Targeting - Exclude Qastring, listList of content genres to exclude in targeting. List format = (Content genre name; Content genre name; etc.). This list is generated in alphabetical order.
Keyword Targeting - Include Qastring, list

List of keyword strings to include in targeting. This list is generated in alphabetical order.

If the total character length of the list exceeds 32700 characters, individual entries in the list will be truncated as needed. Truncated entries will be no shorter than 10 characters.

Keyword Targeting - Exclude Qastring, list

List of keyword strings to exclude in targeting. This list is generated in alphabetical order.

If the total character length of the list exceeds 32700 characters, individual entries in the list will be truncated as needed. Truncated entries will be no shorter than 10 characters.

Keyword List Targeting - Exclude Qastring, list

List of negative keyword lists to exclude in targeting. List format = (Negative keyword list name; Negative keyword list name; etc.). This list is generated in alphabetical order.

Optimized TargetingstringEnable 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 Qastring, list of list of pairs

List of first- and third-party audience lists to include in targeting.

For first-party audience lists, each audience is listed as a pair of display name and recency setting. A pair is (Audience name;1d;), where 1d is a sample recency representing 1 day recency. Recency is not available for third-party audiences, so the list format is (Audience name;);(Audience name;);. To "AND" and "OR" groups of audiences, follow this example: To combine pairs with and without recency: '((audience 1 name;1d;);(audience 2 name;365d;));((audience 3 name;);(audience 4 name;5m;);(audience 5 name;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 Qastring, list of list of pairs

List of first- and third-party audience lists to exclude in targeting.

For first-party audience lists, each audience is listed as a pair of display name and recency setting. A pair is (Audience name;1d;), where 1d is a sample recency representing 1 day recency. Recency is not available for third-party audiences, so the list format is (Audience name;);(Audience name;);. To "AND" and "OR" groups of audiences, follow this example: To combine pairs with and without recency: '((audience 1 name;1d;);(audience 2 name;365d;));((audience 3 name;);(audience 4 name;5m;);(audience 5 name;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
Affinity & In Market Targeting - Include Qastring, listList of affinity and/or in-market audience lists to include. List format = (Audience name; Audience name; etc.). This list is generated in alphabetical order.
Affinity & In Market Targeting - Exclude Qastring, list
Combined Audience Targeting Qastring, listList of combined audience lists to target. List format = (Audience name; Audience name; etc.). This list is generated in alphabetical order.
Custom List Targeting Qastring, listList of custom lists to target. List format = (Custom list name; Custom list name; etc.). This list is generated in alphabetical order.
Inventory Source Targeting - Authorized Seller OptionsstringSetting 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 Qastring, list

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

List format = (Inventory source/Exchange/Sub-exchange name; Inventory source/Exchange/Sub-exchange name; etc.)

Inventory Source Targeting - Exclude Qastring, list

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

List format = (Inventory source/Exchange/Sub-exchange name; Inventory source/Exchange/Sub-exchange name; etc.)

Inventory Source Targeting - Target New ExchangesstringSetting to target new exchanges.
  • True
  • False
Private Deal Group Targeting Include Qastring, list

List of Grouped Deals to include in targeting.

List format = (Grouped deal name; Grouped deal name; etc.). This list is generated in alphabetical order.

Daypart Targeting Qastring, list

List of DayParts to target. Each daypart is constructed in the format "day_of_the_week start_time end_time":

  • "day_of_the_week" is Monday, Tuesday, Wednesday, Thursday, Friday, Saturday or Sunday
  • "start_time" and "end_time" are represented as HH:MM in 24-hour format.

Example list: (Monday 01:20 13:20; Tuesday 09:00 10:00;)

This list is generated in ascending time order, starting with Monday.

Daypart Targeting Time ZonestringTimezone to use for daypart targeting.
Environment Targetingstring, listList 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 EnabledstringEnables targeting only impressions that are measurable through the open Measurement standard.
  • TRUE
  • FALSE
Viewability Targeting Active ViewstringTarget 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 Screenstring, listOn screen ad positions targeting. Select one or more of the acceptable values:
  • Above the fold
  • Below the fold
  • Unknown
Position Targeting - Display Position In Contentstring, listDisplay 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 Contentstring, listVideo 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 Contentstring, listAudio ad content positions to target. Select one or more of the acceptable values:
  • Pre-Roll
  • Mid-Roll
  • Post-Roll
  • Unknown
Video Player Size Targetingstring, listList of video ad player size to target. Select one or more of the acceptable values:
  • unknown
  • small
  • large
  • HD
Content Duration Targetingstring, listList 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 Targetingstring, listList of content stream types to target. Select one or more of the acceptable values:
  • livestream
  • on-demand
Audio Content Type Targetingstring, listList of audio content type to target. Select one or more of the acceptable values:
  • unknown
  • online radio
  • streaming music
  • podcasts
Demographic Targeting Gender Qastring, list

Full list of genders being targeted.

List format = (Female; Male; Unknown;)

  • Female
  • Male
  • Unknown
Demographic Targeting Age Qastring, list

Full list of ages being targeted.

List format = (25-34; 35-44; Unknown;)

  • 18-24
  • 25-34
  • 35-44
  • 45-54
  • 55-64
  • 65+
  • Unknown
Demographic Targeting Household Income Qastring, list

Full list of household incomes being targeted.

List format = (Top 10%; 11-20%; 21-30%;)

  • Top 10%
  • 11-20%
  • 21-30%
  • 31-40%
  • 41-50%
  • Lower 50%
  • Unknown
Demographic Targeting Parental Status Qastring, list

Full list of parental status being targeted.

List format = (Parent;)

  • Parent
  • Not a parent
  • Unknown
Connection Speed TargetingstringTarget to a specific connection speed. Select one of the acceptable values:
  • All
  • 2G
  • 3G
  • DSL
  • 4G
Carrier Targeting - Include Qastring, listList of ISPs or Carriers to include in targeting. List format = (Carrier/ISP name; Carrier/ISP name; etc.). This list is generated in alphabetical order.
Carrier Targeting - Exclude Qastring, listList of ISPs or Carriers to exclude in targeting. List format = (Carrier/ISP name; Carrier/ISP name; etc.). This list is generated in alphabetical order.
Bid Multipliersstring, list of listsAll 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 TypeDimensionCriteria ID
appAppA 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);
siteURLString of site URL. eg. (site;'someurl.com';1.0);(site;'someurltwo.com';2.5);
user_listAudience ListThe user list ID. eg. (user_list;UserList.id;1.0);(user_list;UserList.id;2.5);
user_interestAudience ListThe user interest ID. eg. (user_interest;UserList.id;1.0);(user_interest;UserList.id;2.5);
custom_affinityAudience ListThe custom affinity ID. eg. (custom_affinity;CustomAffinity.id;1.0);(custom_affinity;CustomAffinity.id;2.5);
day_partDay PartThe 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_rangeDemographicsThe 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);
genderDemographicsThe gender. Acceptable values are:
  • Male
  • Female
  • Unknown
eg. (gender;Male;1.0);(gender;Female;2.5);
parental_statusDemographicsThe parental status. Acceptable values are:
  • Parent
  • Not a parent
  • Unknown
eg. (parental_status;Not a parent;1.0);
household_incomeDemographicsThe 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_typeDevice TypeThe device type. Acceptable values are:
  • Computer
  • Smartphone
  • Tablet
  • Connected TV
  • Connected Device
eg. (device_type;Computer;1.0);(device_type;Tablet;2.5);
geoGeographyThe geography location ID. eg. (geo;2840;1.0);
private_dealPrivate DealThe private deal targeting ID. eg. (private_deal;1016301;1.0);
private_dealPrivate DealThe private deal targeting ID. eg. (private_deal;1016301;1.0);
public_exchangePublic ExchangeThe public exchange ID. eg. (public_exchange;17;1.0);
unclassified_exchangeUnclassified ExchangeThe unclassified exchange target ID (= 5000 + exchange_id).eg. (unclassified_exchange;5017;1.0);
sub_exchangeSub-exchangeThe format is [exchange_id]-[sub_exchange_targeting_id].eg. (sub_exchange;38-4515403;1.0);
TrueView Video Ad FormatsstringThe 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 TypestringThe bid strategy used by a TrueView or Demand Gen line item.

Select one of the following values:
  • 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 not supported for new Trueview or Demand Gen 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.
  • Maximize Clicks: Automated bidding strategy that optimizes bids to maximize clicks based on budget
TrueView Bid Strategy ValuefloatFor 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 other line item types, 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 OptionstringEither 'Increase' or 'Decrease'
  • Increase
  • Decrease
TrueView Mobile Bid Adjustment PercentageintegerBid 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', or for Demand Gen ad groups, acceptable adjustments are for Bid Adjustment Option 'Increase': 0; and for 'Decrease': 100%.
TrueView Desktop Bid Adjustment OptionstringEither 'Increase' or 'Decrease'
  • Increase
  • Decrease
TrueView Desktop Bid Adjustment PercentageintegerBid 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%.
'TrueView Bid Strategy Type' is 'Target CPA' or 'Maximize Conversions', or for Demand Gen ad groups, acceptable adjustments are for Bid Adjustment Option 'Increase': 0; and for 'Decrease': 100%.
TrueView Tablet Bid Adjustment OptionstringEither 'Increase' or 'Decrease'
  • Increase
  • Decrease
TrueView Tablet Bid Adjustment PercentageintegerBid 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', or for Demand Gen ad groups, acceptable adjustments are for Bid Adjustment Option 'Increase': 0; and for 'Decrease': 100%.
TrueView Connected TV Bid Adjustment OptionstringEither 'Increase' or 'Decrease'
  • Increase
  • Decrease
TrueView Connected TV Bid Adjustment PercentageintegerBid 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', or for Demand Gen ad groups, acceptable adjustments are for Bid Adjustment Option 'Increase': 0; and for 'Decrease': 100%.
TrueView Category Exclusions Targetingstring, listList of categories to exclude. List format = Embedded Videos; Families; etc.
  • Embedded Videos
  • Live Streaming
  • Games
  • Families
TrueView Content FilterstringTrueView content filter.
TrueView Inventory Source Targetingstring, listLists of TrueView inventory sources to include
  • YouTube
  • Google TV
  • Video Partners
TrueView Third-Party Viewability Vendorstring, list of listsThird-party vendor measuring viewability for TrueView and Demand Gen line items. If this is left empty during TrueView or Demand Gen 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.

Select one of the following values:
  • None
  • Moat
  • DoubleVerify
  • Integral Ad Science
TrueView Third-Party Viewability Reporting IDstringID 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 Vendorstring, list of listsThird-party vendor measuring brand safety for TrueView and Demand Gen line items. If this is left empty during TrueView or Demand Gen 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.

Select one of the following values:
  • None
  • DoubleVerify
  • Integral Ad Science
  • Zefr
TrueView Third-Party Brand Safety Reporting IDstringID 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 Vendorstring, list of listsThird-party vendor measuring reach for TrueView and Demand Gen line items. If this is left empty during TrueView or Demand Gen 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.

Select one of the following values:
  • None
  • Nielsen
  • Comscore
  • Kantar
  • Gemius
  • Video Research
  • Media Scope
  • Audience Project
  • iSpot TV
  • VideoAmp
TrueView Third-Party Reach Reporting IDstringID 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 Vendorstring, list of listsThird-party vendor measuring brand lift for TrueView and Demand Gen line items. If this is left empty during TrueView or Demand Gen 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.

Select one of the following values:
  • None
  • Kantar
  • Dynata
  • Intage
  • Nielsen
  • Macromill
TrueView Third-Party Brand Lift Reporting IDstringID 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 CountintegerThe 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 WindowstringThe 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