Migrate to Structured Data Files v7

Last update: 2023-10-18

This guide walks you through the process of migrating to Structured Data Files (SDF) v7 from a previous version and the changes, both required and suggested, that you can make to better optimize your integration.

See the release notes for an exhaustive list of differences between v6 and v7.

Migrate your Structured Data Files version

Migrating to Structured Data Files v7 from a previous version requires you to specify the new version, update the ID spaces for a subset of existing columns, and add integration with new columns.

Update Structured Data Files version

In order to update to a new Structured Data Files version, you need to update the version you assign to your parent Partner and Advertiser resources and your individual download tasks in the Display & Video 360 API.

Update parent resource settings

A default Structured Data Files version is set at the partner and advertiser resource level. This version is used as the default when downloading Structured Data Files through the interface or API.

Set in the interface

At the partner level

Navigate to the intended partner. Go to the Basic Details page under the Partner Settings menu in the left-hand navigation. Update the SDF version configuration in the Structured Data Files section to v7.

At the advertiser level

Navigate to the intended advertiser. Go to the Basic Details page under the Advertiser Settings menu in the left-hand navigation. Update the SDF version configuration in the Structured Data Files section to v7. If the default version is set at the Partner level, this setting may not be editable.

Set in the API

At the advertiser level

Make an advertisers.patch request to update the dataAccessConfig.sdfConfig.sdfConfig.version to SDF_VERSION_7 and, if needed, dataAccessConfig.sdfConfig.overridePartnerSdfConfig to True.

Update sdfdownloadtasks.create requests in the API

When making a sdfdownloadtasks.create request using the Display & Video 360 API, set the version field of the request body to SDF_VERSION_7.

Update IDs in required columns

In v7, the ID spaces used by a subset of columns have been updated to decouple Structured Data Files from the deprecated Entity Read Files product and further align with supported tools, such as the Display & Video 360 API.

Warning: Updated IDs may not be compatible with custom bidding scripts. We recommend reviewing the custom bidding scripts signals reference documentation for the latest information on the IDs that should be used before migrating.

This section lists every column using different IDs than v6 and instructions on how to retrieve reference information on the new values.

Insertion Order

v7 Migration instructions for columns
App Targeting - Exclude App Targeting - Include	These columns have been updated to use app identifiers following the format "App Platform:App ID". Examples include: "APP:com.google.android.gm", "APP:422689480", "ANDROID_TV_APP:com.google.android.youtube.tvunplugged" App platforms are identified by a string value. App IDs are the IDs provided by the relevant platform, such as a bundle ID from Android's Play store or App ID from Apple's App store.
Browser Targeting - Exclude Browser Targeting - Include	This column has been updated to use targetingOptionId values of the Display & Video 360 API TargetingOption resources under targeting type TARGETING_TYPE_BROWSER. Retrieve TargetingOption resources individually or in paginated lists using the targetingTypes.targetingOptions service.
Carrier Targeting - Exclude Carrier Targeting - Include	This column has been updated to use targetingOptionId values of the Display & Video 360 API TargetingOption resources under targeting type TARGETING_TYPE_CARRIER_AND_ISP. Retrieve TargetingOption resources individually or in paginated lists using the targetingTypes.targetingOptions service.
Channel Targeting - Exclude Channel Targeting - Include	This column has been updated to use the channelId value of the Display & Video 360 API Channel resource. Retrieve Channel resources individually or in paginated lists using the advertisers.channels and partners.channels services.
Device Targeting - Exclude Device Targeting - Include	This column has been updated to use targetingOptionId values of the Display & Video 360 API TargetingOption resources under the following targeting types: TARGETING_TYPE_DEVICE_TYPE TARGETING_TYPE_DEVICE_MAKE_MODEL TARGETING_TYPE_OPERATING_SYSTEM Retrieve TargetingOption resources individually or in paginated lists using the targetingTypes.targetingOptions service.
Measure DAR Channel	This column has been updated to use the channelId value of the Display & Video 360 API Channel resource. Retrieve Channel resources individually or in paginated lists using the advertisers.channels and partners.channels services.
Site Targeting - Exclude Site Targeting - Include	This column has been updated to identify sites through URL strings.

Line Item

v7 Migration instructions for columns
App Targeting - Exclude App Targeting - Include	These columns have been updated to use app identifiers following the format "App Platform:App ID". Examples include: "APP:com.google.android.gm", "APP:422689480", "ANDROID_TV_APP:com.google.android.youtube.tvunplugged" App platforms are identified by a string value. App IDs are the IDs provided by the relevant platform, such as a bundle ID from Android's Play store or App ID from Apple's App store.
Bid Multipliers	This column has been updated to use new Criteria IDs for app and site row types. The app row type has been updated to use concatenated string values of app platform and app platform ID, separated by a colon, for the criteria IDs. App platforms are identified by a string value. App IDs are the IDs provided by the relevant platform, such as a bundle ID from Android's Play store or App ID from Apple's App store. The site row type has been updated to use URL strings as Criteria IDs.
Browser Targeting - Exclude Browser Targeting - Include	This column has been updated to use targetingOptionId values of the Display & Video 360 API TargetingOption resources under targeting type TARGETING_TYPE_BROWSER. Retrieve TargetingOption resources individually or in paginated lists using the targetingTypes.targetingOptions service.
Carrier Targeting - Exclude Carrier Targeting - Include	This column has been updated to use targetingOptionId values of the Display & Video 360 API TargetingOption resources under targeting type TARGETING_TYPE_CARRIER_AND_ISP. Retrieve TargetingOption resources individually or in paginated lists using the targetingTypes.targetingOptions service.
Channel Targeting - Exclude Channel Targeting - Include	This column has been updated to use the channelId value of the Display & Video 360 API Channel resource. Retrieve Channel resources individually or in paginated lists using the advertisers.channels and partners.channels services.
Device Targeting - Exclude Device Targeting - Include	This column has been updated to use targetingOptionId values of the Display & Video 360 API TargetingOption resources under the following targeting types: TARGETING_TYPE_DEVICE_TYPE TARGETING_TYPE_DEVICE_MAKE_MODEL TARGETING_TYPE_OPERATING_SYSTEM Retrieve TargetingOption resources individually or in paginated lists using the targetingTypes.targetingOptions service.
Site Targeting - Exclude Site Targeting - Include	This column has been updated to identify sites through URL strings.

Media Product

v7 Migration instructions for columns
Channel Targeting - Exclude Channel Targeting - Include	This column has been updated to use the channelId value of the Display & Video 360 API Channel resource. Retrieve Channel resources individually or in paginated lists using the advertisers.channels and partners.channels services.
Device Targeting - Include	This column has been updated to use targetingOptionId values of the Display & Video 360 API TargetingOption resources under the following targeting types: TARGETING_TYPE_DEVICE_TYPE TARGETING_TYPE_DEVICE_MAKE_MODEL TARGETING_TYPE_OPERATING_SYSTEM Retrieve TargetingOption resources individually or in paginated lists using the targetingTypes.targetingOptions service.

Add integration with columns added since v6

If migrating from v6 to v7, you need to add the following columns to the relevant files:

File type	Column
Line Item	TrueView Target Frequency Count
Line Item	TrueView Target Frequency Time Window
YouTube Ad Group	Optimized Targeting

If you are migrating from a prior Structured Data Files version, reference the Structured Data Files release notes for information on additional columns added between your current version and SDF v6.

Additional changes

In v7, we've also instituted some superficial changes that should help you simplify your integration and move away from using deprecated Entity Read Files for reference.

New list ordering for a subset of columns

SDF v7 guarantees a stable ordering of certain list columns upon file generation. This results in more consistent behavior and easier review. This ordering is not enforced upon file upload, but is applied subsequently when generating the updated file.

Review the v7 release notes for a full list of columns that are now generated in either ascending numerical or alphabetical order.

New ID reference recommendations

We've updated the definitions of a number of columns to remove reference to deprecated Entity Read Files and instead recommend other means of ID lookup.

The values returned by the following columns are no different than in SDF v6, but we suggest that you update your integration to retrieve the IDs using the new recommended method, which can be found in their v7 column descriptions.

File types and their columns
Campaign	Geography Targeting - Exclude Geography Targeting - Include Inventory Source Targeting - Exclude Inventory Source Targeting - Include Language Targeting - Exclude Language Targeting - Include
Insertion Order	Affinity & In Market Targeting - Exclude Affinity & In Market Targeting - Include App Collection Targeting - Exclude App Collection Targeting - Include Audience Targeting - Exclude Audience Targeting - Include Category Targeting - Exclude Category Targeting - Include Content Genre Targeting - Exclude Content Genre Targeting - Include Custom List Targeting Geography Targeting - Exclude Geography Targeting - Include Inventory Source Targeting - Exclude Inventory Source Targeting - Include Keyword List Targeting - Exclude Language Targeting - Exclude Language Targeting - Include
Line Item	Affinity & In Market Targeting - Exclude Affinity & In Market Targeting - Include App Collection Targeting - Exclude App Collection Targeting - Include Audience Targeting - Exclude Audience Targeting - Include Category Targeting - Exclude Category Targeting - Include Combined Audience Targeting Content Genre Targeting - Exclude Content Genre Targeting - Include Conversion Floodlight Activity IDs Creative Assignments Custom List Targeting Geography Targeting - Exclude Geography Targeting - Include Inventory Source Targeting - Exclude Inventory Source Targeting - Include Keyword List Targeting - Exclude Language Targeting - Exclude Language Targeting - Include
Media Product	Audience Targeting - Exclude Audience Targeting - Include Category Targeting - Exclude Category Targeting - Include Geography Targeting - Include Language Targeting - Exclude Language Targeting - Include
YouTube Ad Group	Affinity & In Market Targeting - Exclude Affinity & In Market Targeting - Include Audience Targeting - Exclude Audience Targeting - Include Category Targeting - Exclude Category Targeting - Include Custom List Targeting