> [!CAUTION]
> This SDF version has been deprecated. Users must [migrate to SDF v10](https://developers.google.com/display-video/api/structured-data-file/v10-migration-guide) before January 28, 2026 in order to continue using structured data files.
See the [overview](https://developers.google.com/display-video/api/structured-data-file/format) for an explanation of format.
| Field | Required | Type | Writable | Description |
|---|---|---|---|---|
| Io Id | Required only when editing existing insertion orders | integer | No | Numeric ID value of the insertion order. If left blank, a new Insertion Order ID will be created and a unique ID will be assigned. Optionally, when creating a new Insertion Order, you can use a custom identifier for the purpose of assigning Line Items to the new Insertion Order. 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, Line Item to Insertion Order) based on the custom identifiers. |
| Campaign Id | No | integer | No | Numeric ID value of the campaign. You can specify a custom identifier (for example, "ext\[custom campaign identifier\]") for a campaign that you are creating at the same time as this insertion order. |
| 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 |
| Io Type | Yes | string | Yes | The type of the insertion order. Only settable on creation. - standard |
| Io Subtype | Yes | string | Yes | Field required for Insertion Orders to distinguish between different formats. If the field is left empty 'default' value will be used' - Default - Regular Over The Top |
| Io Objective | No | string | Yes | The objective of the Insertion Order. **This field is in beta and currently only available to participating clients. This column will always be empty for customers not participating in the beta.** - Brand Awareness - Click - Conversion - Custom - No Objective |
| 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) | **Note:** Adloox was a previous name for the provider now known as Scope3. |
| Integration Code | No | string | Yes | An optional code for tracking purposes. |
| Details | No | string | Yes | Entry details in string format. |
| Pacing | Yes | string | Yes | The time period used to spend to the pacing amount. - Daily - Monthly - Flight |
| Pacing Rate | Yes | string | Yes | The rate of pacing for this entry. - ASAP - Even - Ahead
'ASAP' is not compatible with 'Flight' pacing. |
| Pacing Amount | Yes | 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 insertion order. - 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. - Minutes - Hours - Days - Weeks - Months |
| 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'. Frequency cap time periods must be 30 days or less. |
| Kpi Type | Yes | string | Yes | The KPI unit for the insertion order - CPM - CPA - CPC - CPV - CPIAVC - CTR - % Viewability - CPE - Click CVR - Impression CVR - VCPM - VTR - Audio CR - Video CR - CPCL - CPCV - TOS10 - Maximize Pacing - Custom impression value / cost - None - Other |
| Kpi Value | Yes | string | Yes | The KPI value in currency (CPM, CPA, CPC, CPV, CPIAVC, CPE, VCPM), percentage (% Viewability, CTR, Click CVR, Impression CVR, VTR, Audio CR, Video CR, CPCL, CPCA, TOS10), unitless (Custom impression value / cost), or as a string (Other). If the provided KPI type is 'Maximize Pacing' or 'None' then this column is ignored. |
| Kpi Algorithm Id | Required when "Kpi Type" is "Custom impression value / cost" | integer | Yes | The custom bidding algorithm ID associated with the Kpi if the Kpi type is CUSTOM_BIDDING_VALUE_COST. Otherwise, this column is ignored. |
| Measure DAR | Yes | string | Yes | Enables/disables audience measurement using Nielsen Digital Ad Ratings - TRUE - FALSE |
| Measure DAR Channel | Required when "Measure DAR" is "TRUE" | integer | Yes | The channel to measure with Nielsen Digital Ad Ratings. This column uses the Display \& Video 360 API [`Channel`](https://developers.google.com/display-video/api/reference/rest/current/advertisers.channels#Channel) resource ID. Format = Channel.channelId |
| Budget Type | Yes | string | Yes | Specifies the type of budget in terms of an amount of "revenue" to spend (amount) or a number of impressions (impressions) to purchase. - Amount - Impressions |
| Budget Segments | Yes | string, list of lists | Yes | Specifies the specific budget segments. List format = (Budget, Start Date, End Date, Campaign Budget ID, Description). Budget is in currency floating format. Dates are in MM/DD/YYYY format. Campaign Budget ID is empty if not specified. Description cannot be empty for any budget segments. If an existing budget segment has an empty description, a description will need to be provided for the row to be uploaded. Example: "(100.50;01/01/2016;03/31/2016;12345;budget segment 1;);(200.00;04/01/2016;06/30/2016;;updated budget segment 1;);" |
| Auto Budget Allocation | Yes | string | Yes | Enables/disables auto-budget allocation - TRUE - FALSE |
| Geography Targeting - Include | No | string, list | Yes | List of geographies to include in targeting. This column uses Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/current/targetingTypes.targetingOptions#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.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Geography Targeting - Exclude | No | string, list | Yes | List of geographies to exclude in targeting. This column uses Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/current/targetingTypes.targetingOptions#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.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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; ;);".
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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;);".
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Language Targeting - Include | No | string, list | Yes | List of languages to include in targeting. This column uses Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/current/targetingTypes.targetingOptions#TargetingOption) resource IDs for targeting type `TARGETING_TYPE_LANGUAGE`. List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Language Targeting - Exclude | No | string, list | Yes | List of languages to exclude in targeting. This column uses Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/current/targetingTypes.targetingOptions#TargetingOption) resource IDs for targeting type `TARGETING_TYPE_LANGUAGE`. List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Device Targeting - Include | No | string, list | Yes | List of devices to include in targeting. This column uses Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/current/targetingTypes.targetingOptions#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.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Device Targeting - Exclude | No | string, list | Yes | List of devices to exclude in targeting. This column uses Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/current/targetingTypes.targetingOptions#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.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Browser Targeting - Include | No | string, list | Yes | List of browsers to include in targeting. This column uses Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/current/targetingTypes.targetingOptions#TargetingOption) resource IDs for targeting type `TARGETING_TYPE_BROWSER`. List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Browser Targeting - Exclude | No | string, list | Yes | List of browsers to exclude in targeting. This column uses Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/current/targetingTypes.targetingOptions#TargetingOption) resource IDs for targeting type `TARGETING_TYPE_BROWSER`. List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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 - ?
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Third Party Verification Services | No | string | Yes | Third party verification services provider. - None - Integral Ad Science - DoubleVerify - Adloox **Note:** Adloox was a previous name for the provider now known as Scope3.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Third Party Verification Labels | No | string, list | Yes | If Third Party Verification Services is not "None", specify a list of [labels](https://developers.google.com/display-video/api/structured-data-file/third-party-verification) supported by the selected provider.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Channel Targeting - Include | No | string, list | Yes | List of channels to include in targeting. This column uses Display \& Video 360 API [`Channel`](https://developers.google.com/display-video/api/reference/rest/current/advertisers.channels#Channel) resource IDs. List format = (Channel.channelId; Channel.channelId; etc.).
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Channel Targeting - Exclude | No | string, list | Yes | List of channels to exclude in targeting. This column uses Display \& Video 360 API [`Channel`](https://developers.google.com/display-video/api/reference/rest/current/advertisers.channels#Channel) resource IDs. List format = (Channel.channelId; Channel.channelId; etc.).
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Site Targeting - Include | No | 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.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Site Targeting - Exclude | No | 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.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| App Targeting - Include | No | 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.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| App Targeting - Exclude | No | 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.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| App Collection Targeting - Include | No | string, list | Yes | List of app collections to include in targeting. This column uses Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/current/targetingTypes.targetingOptions#TargetingOption) resource IDs for targeting type `TARGETING_TYPE_APP_CATEGORY`. List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.).
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| App Collection Targeting - Exclude | No | string, list | Yes | List of app collections to exclude in targeting. This column uses Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/current/targetingTypes.targetingOptions#TargetingOption) resource IDs for targeting type `TARGETING_TYPE_APP_CATEGORY`. List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.).
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Category Targeting - Include | No | string, list | Yes | List of categories to include in targeting. This column uses Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/current/targetingTypes.targetingOptions#TargetingOption) resource IDs for targeting type `TARGETING_TYPE_CATEGORY`. List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Category Targeting - Exclude | No | string, list | Yes | List of categories to exclude in targeting. This column uses Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/current/targetingTypes.targetingOptions#TargetingOption) resource IDs for targeting type `TARGETING_TYPE_CATEGORY`. List format = (TargetingOption.targetingOptionId; TargetingOption.targetingOptionId; etc.). This list is generated in ascending numerical order.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Content Genre Targeting - Include | No | string, list | Yes | List of content genres to include in targeting. This column uses Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/current/targetingTypes.targetingOptions#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.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Content Genre Targeting - Exclude | No | string, list | Yes | List of content genres to exclude in targeting. This column uses Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/current/targetingTypes.targetingOptions#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.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Keyword Targeting - Include | No | string, list | Yes | List of keyword strings to include in targeting. This list is generated in ascending alphabetical order.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Keyword Targeting - Exclude | No | string, list | Yes | List of keyword strings to exclude in targeting. This list is generated in ascending alphabetical order.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Keyword List Targeting - Exclude | No | string, list | Yes | List of negative keyword lists to exclude in targeting. This column uses Display \& Video 360 API [`NegativeKeywordList`](https://developers.google.com/display-video/api/reference/rest/current/advertisers.negativeKeywordLists#NegativeKeywordList) resource IDs. List format = (NegativeKeywordList.negativeKeywordListId; NegativeKeywordList.negativeKeywordListId; etc.). This list is generated in ascending numerical order.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Audience Targeting - Include | No | string, list of list of pairs | Yes | List of audience lists to include in targeting. This column uses Display \& Video 360 API [`FirstPartyAndPartnerAudience`](https://developers.google.com/display-video/api/reference/rest/current/firstPartyAndPartnerAudiences#FirstPartyAndPartnerAudience) resource IDs. For first-party audience lists, each audience is listed as a pair of FirstPartyAndPartnerAudience.firstPartyAndPartnerAudienceId and recency setting. A pair is (1;1d;), where 1d is a sample recency representing 1 day recency. Recency is not available for third-party audiences, so the list format is (3;);(4;);. To "AND" and "OR" groups of audiences, follow this example: To combine pairs with and without recency: '((1;1d;);(2;365d;));((3;);(4;5m;);(5;all;));'. This means (list 1 with 1 day recency OR list 2 with 365day recency ) AND (list 3 without a specified recency OR list 4 with 5 minute recency OR list 5 with all users). Valid recency values are: - all - 1m - 5m - 10m - 15m - 30m - 1h - 2h - 3h - 6h - 12h - 1d - 2d - 3d - 5d - 7d - 10d - 14d - 15d - 21d - 28d - 30d - 45d - 60d - 90d - 120d - 180d - 270d - 365d
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Audience Targeting - Exclude | No | string, list of list of pairs | Yes | List of audience lists to exclude in targeting. This column uses Display \& Video 360 API [`FirstPartyAndPartnerAudience`](https://developers.google.com/display-video/api/reference/rest/current/firstPartyAndPartnerAudiences#FirstPartyAndPartnerAudience) resource IDs. Each audience is listed as a pair of FirstPartyAndPartnerAudience.firstPartyAndPartnerAudienceId and recency setting, if the audience list is a 1P audience list. A pair is (1;1d;), where 1d is a sample recency representing 1 day recency. However, for 3P audiences, recency is not available, so the list format is (3;);(4;);. List format = ((FirstPartyAndPartnerAudience.firstPartyAndPartnerAudienceId; recency optional;); (FirstPartyAndPartnerAudience.firstPartyAndPartnerAudienceId; recency optional;);) Example: "(1;1d;);(2;);". Valid recency values are: - all - 1m - 5m - 10m - 15m - 30m - 1h - 2h - 3h - 6h - 12h - 1d - 2d - 3d - 5d - 7d - 10d - 14d - 15d - 21d - 28d - 30d - 45d - 60d - 90d - 120d - 180d - 270d - 365d
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Affinity \& In Market Targeting - Include | No | 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.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Affinity \& In Market Targeting - Exclude | No | 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.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Custom List Targeting | No | string, list | Yes | List of custom lists to target. This column uses Display \& Video 360 API [`CustomList`](https://developers.google.com/display-video/api/reference/rest/current/customLists#CustomList) resource IDs. List format = (CustomList.customListId; CustomList.customListId; etc.). This list is generated in ascending numerical order.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Inventory Source Targeting - Include | No | string, list | Yes | List of inventory sources, exchanges, and sub-exchanges to include in targeting. This column uses Display \& Video 360 API [`InventorySource`](https://developers.google.com/display-video/api/reference/rest/v2/inventorySources#InventorySource) resource IDs, [published exchange IDs](https://developers.google.com/display-video/api/structured-data-file/exchange-reference), and Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/v2/targetingTypes.targetingOptions#TargetingOption) resource IDs of targeting type `TARGETING_TYPE_SUB_EXCHANGE`. List format = (InventorySource.inventorySourceId; exchangeId; TargetingOption.targetingOptionId; etc.)
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Inventory Source Targeting - Exclude | No | string, list | Yes | List of inventory sources, exchanges, and sub-exchanges to exclude in targeting. This column uses Display \& Video 360 API [`InventorySource`](https://developers.google.com/display-video/api/reference/rest/v2/inventorySources#InventorySource) resource IDs, [published exchange IDs](https://developers.google.com/display-video/api/structured-data-file/exchange-reference), and Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/v2/targetingTypes.targetingOptions#TargetingOption) resource IDs of targeting type `TARGETING_TYPE_SUB_EXCHANGE`. List format = (InventorySource.inventorySourceId; exchangeId; TargetingOption.targetingOptionId; etc.)
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Inventory Source Targeting - Target New Exchanges | No | string | Yes | Setting to target new exchanges. - True - False
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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 Variable limits: - 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.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Daypart Targeting Time Zone | Required when "Daypart Targeting" is included | string | Yes | Timezone to use for daypart targeting. - Local - Advertiser
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Viewability Omid Targeting Enabled | No | string | Yes | Enables targeting only impressions that are measurable through the open Measurement standard. If the entity does not support OMID targeting, leave this column empty. - TRUE - FALSE
If OMID targeting is enabled at the advertiser level and supported for the entity, this column cannot be set to 'FALSE'. If this column is not set at resource creation for a supported entity, it will default to the advertiser level setting.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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}
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Position Targeting - Display On Screen | No | string, list | Yes | On screen display ad positions targeting. Select one or more of the acceptable values: - Above the fold - Below the fold - Unknown
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Position Targeting - Video On Screen | No | string, list | Yes | On screen video ad positions targeting. Select one or more of the acceptable values: - Above the fold - Below the fold - Unknown
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Demographic Targeting Gender | No | string, list | Yes | List of genders to target. Select one or more of the acceptable values: - Female - Male - Unknown
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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 - +
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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%
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| 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
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Connection Speed Targeting | No | string | Yes | Target to a specific connection speed. Select one of the acceptable values: - All - 2G - 3G - DSL - 4G
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Carrier Targeting - Include | No | string, list | Yes | List of ISPs or Carriers to target. This column uses Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/current/targetingTypes.targetingOptions#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.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Carrier Targeting - Exclude | No | string, list | Yes | List of ISPs or Carriers to exclude. This column uses Display \& Video 360 API [`TargetingOption`](https://developers.google.com/display-video/api/reference/rest/current/targetingTypes.targetingOptions#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.
> [!WARNING] > **This column has sunset with the deprecation of insertion order-level targeting.** Entries populating this column value will fail to create or update the resource on file upload. [Read more about this announced change](https://developers.google.com/display-video/api/deprecations#features.io_campaign_targeting).
|
| Insertion Order Optimization | Yes | string | Yes | Enables/disables insertion order optimization If this column is set to 'TRUE', the line items under this insertion order will use the insertion order's bid strategy. - TRUE - FALSE |
| Bid Strategy Unit | Required when "Insertion Order Optimization" is "True" | string | Yes | Select bid strategy unit to optimize bidding: - CPA - CPC - custom impr. value/cost - CIVA - IVO_TEN - AV_VIEWED |
| Bid Strategy Do Not Exceed | Required when "Insertion Order Optimization" is "True" | float | Yes | Set a 'do not exceed' CPM value. If 0, 'do not exceed' is not enabled. |
| Apply Floor Price For Deals | Required when "Insertion Order Optimization" is "True" | 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. Any floodlight activies used in the algorithm assigned to this column must be included in the 'Conversion Floodlight Activity Ids' column. Attempts to assign an algorithm without properly updating the 'Conversion Floodlight Activity Ids' column will result in an error. |