Structured Data - v6 - Line Items

This SDF version has been deprecated. Users should migrate to SDF v7 or higher before April 30, 2025 in order to continue using structured data files.

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
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	No	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	No	string, list of lists	Yes	Specify the Floodlight activities used for conversions as a list of lists. Each activity is specified as an activity ID, post-view window (in minutes) and post-click window (in minutes). List format = (Pixel.dcm_floodlight_id; view_window_minutes; click_window_minutes;). TrueView for action line items will not serve without at least one TrueView-enabled Floodlight activity.
Primary Attribution Model Id	No	integer	Yes	The attribution model id used for the associated line item.
Fees	No	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	No	string, list	Yes	List of Creative IDs to assign to the entry. List format = (Creative.common_data.id; Creative.common_data_id; etc.). 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	No	string, list	Yes	List of geographies to include in targeting. List format = (GeoLocation.id; GeoLocation.id;etc.).
Geography Targeting - Exclude	No	string, list	Yes	List of geographies to exclude in targeting. List format = (GeoLocation.id; GeoLocation.id; etc.).
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	No	string, list	Yes	List of languages to include in targeting. List format = (Language.id;Language.id;etc.).
Language Targeting - Exclude	No	string, list	Yes	List of languages to exclude in targeting. List format = (Language.id;Language.id;etc.).
Device Targeting - Include	No	string, list	Yes	List of devices to include in targeting. List format = (DeviceCriteria.id; DeviceCriteria.id; etc.).
Device Targeting - Exclude	No	string, list	Yes	List of devices to exclude in targeting. List format = (DeviceCriteria.id; DeviceCriteria.id; etc.).
Browser Targeting - Include	No	string, list	Yes	List of browser to include in targeting. List format = (Browser.id; Browser.id; etc.).
Browser Targeting - Exclude	No	string, list	Yes	List of browser to exclude in targeting. List format = (Browser.id; Browser.id; etc.).
Digital Content Labels - Exclude	No	string, list	Yes	List of the digital content labels to exclude. List format = (G;PG; etc.). G PG T MA ?
Brand Safety Sensitivity Setting	No	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	No	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	No	string, list	Yes	List of channels to include in targeting. List format = (UniversalChannel.id; UniversalChannel.id; etc.).
Channel Targeting - Exclude	No	string, list	Yes	List of channels to exclude in targeting. List format = (UniversalChannel.id; UniversalChannel.id; etc.).
Site Targeting - Include	No	string, list	Yes	List of sites to include in targeting. The list can include a set of site IDs or strings of URLs, if not found in the Universal Site table. List format = (UniversalSite.Id; 'http://someurl.com'; etc.).
Site Targeting - Exclude	No	string, list	Yes	List of sites to exclude in targeting. The list can include a set of site IDs or strings of URLs, if not found in the Universal Site table. List format = (UniversalSite.Id;'http://someurl.com';etc.).
App Targeting - Include	No	string, list	Yes	List of apps to include in targeting. The list can include a set of UniversalSite IDs or strings of app packages, if not found in the Universal Site table. List format = (UniversalSite.Id; 'some.app.package'; etc.).
App Targeting - Exclude	No	string, list	Yes	List of apps to exclude in targeting. The list can include a set of UniversalSite IDs or strings of app packages, if not found in the Universal Site table. List format = (UniversalSite.Id; 'some.app.package'; etc.).
App Collection Targeting - Include	No	string, list	Yes	List of app collections to include in targeting. List format= App Collection ID; App Collection ID;
App Collection Targeting - Exclude	No	string, list	Yes	List of app collections to exclude in targeting. List format= App Collection ID; App Collection ID;
Category Targeting - Include	No	string, list	Yes	List of categories to include in targeting, from AdX vertical IDs. List format = (Verticals.Id;Verticals.Id;etc.).
Category Targeting - Exclude	No	string, list	Yes	List of categories to exclude in targeting, from AdX vertical IDs. List format = (Verticals.Id;Verticals.Id;etc.).
Content Genre Targeting - Include	No	string, list	Yes	List of content genres to include in targeting, from API or metadata download. List format = (ContentGenre.Id;ContentGenre.Id;etc.).
Content Genre Targeting - Exclude	No	string, list	Yes	List of content genres to exclude in targeting, from API or metadata download. List format = (ContentGenre.Id;ContentGenre.Id;etc.).
Keyword Targeting - Include	No	string, list	Yes	List of keyword strings to include in targeting.
Keyword Targeting - Exclude	No	string, list	Yes	List of keyword strings to exclude in targeting.
Keyword List Targeting - Exclude	No	string, list	Yes	List of negative keyword lists to exclude in targeting. List format = (Negative Keyword List ID; Negative Keyword List ID;)
Optimized Targeting	No	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	No	string, list of list of pairs	Yes	List of audience lists to include in targeting. For first-party audience lists, each audience is listed as a pair of UserList ID 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	No	string, list of list of pairs	Yes	List of audience lists to exclude in targeting. Each audience is listed as a pair of UserList ID 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 = ((UserList.id; recency optional;); (UserList.id; 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	No	string, list	Yes	List of affinity and/or in-market audience lists to include. List format= UserList ID; UserList ID;
Affinity & In Market Targeting - Exclude	No	string, list	Yes	List of affinity and/or in-market audience lists to exclude. List format= UserList ID; UserList ID;
Combined Audience Targeting	No	string, list	Yes	List of combined audience lists to target. List format = (Audience ID; Audience ID; etc.)
Custom List Targeting	No	string, list	Yes	List of custom lists to target. List format = (UserList ID; UserList ID; etc.).
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 to include in targeting. List format = (InventorySource.id; InventorySource.id;).
Inventory Source Targeting - Exclude	No	string, list	Yes	List of inventory to exclude in targeting. List format = (InventorySource.id; InventorySource.id;).
Inventory Source Targeting - Target New Exchanges	No	string	Yes	Setting to target new exchanges. True False
Private Deal Group Targeting Include	No	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;)
Daypart Targeting	No	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.
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	No	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	No	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	No	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	No	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	No	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	No	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	No	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	No	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	No	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	No	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	No	string, list	Yes	List of genders to target. Select one or more of the acceptable values: Female Male Unknown
Demographic Targeting Age	No	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: 18 25 35 45 55 65 Acceptable values for To: 25 35 45 55 65 +
Demographic Targeting Household Income	No	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	No	string	Yes	Target to a specific connection speed. Select one of the acceptable values: All 2G 3G DSL 4G
Carrier Targeting - Include	No	string, list	Yes	List of ISPs or Carriers to target. List format = {ISP.id; ISP.id;}
Carrier Targeting - Exclude	No	string, list	Yes	List of ISPs or Carriers to exclude. List format = {ISP.id; ISP.id;}
Bid Multipliers	No	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/Site The app criteria ID (= universal site ID). If the criteria ID is not found in the Universal Site table, replace it with a string of app package. eg. (app;UniversalSite.id;1.0);(app;'some.app.package';2.5); site App/Site The site criteria ID (= universal site ID). If the criteria ID is not found in the Universal Site table, replace it with a string of site url. eg. (site;UniversalSite.id;1.0);(site;'http://someurl.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 In-stream / In-feed Video In-stream / Bumper Bumper Non Skippable
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	No	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	No	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	No	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	No	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	No	string, list	No	List of categories to exclude. List format = Embedded Videos; Families; etc. Embedded Videos Live Streaming Games Families
TrueView Content Filter	No	string	Yes	TrueView content filter. Limited Standard Expanded
TrueView Inventory Source Targeting	No	string, list	Yes	Lists of TrueView inventory sources to include YouTube 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.