Stay organized with collections
Save and categorize content based on your preferences.
A Structured Data File (SDF) is a comma-separated values file used by
Display & Video 360 for bulk retrieval and management of resources. You can
download and upload SDFs through the Display & Video 360 UI. SDFs can
also be generated and downloaded using the Display & Video 360 API.
There are two types of Structured Data Files formats offered by
Display & Video 360:
Standard: This format can be used to retrieve and update Display & Video 360
resources.
QA: This format can only be used to retrieve existing
Display & Video 360 resource settings. QA files provide the same information as
standard format files of the same version, but convey that information using
display name values instead of numeric IDs. Titles of columns changed in the
QA format are appended with "Qa".
Format rules
The following rules apply to all Structured Data File formats:
The first row of the file is always a header row containing the column names.
Except for the first row, all non-missing string values are in quotation
marks.
Missing values are left blank.
For types marked as a list, expect the following:
The list is a collection of strings.
Each string is separated by a semicolon.
A trailing semicolon follows the last string in the list.
Example: one;two;three;four;
For types marked as a list of lists, expect the following:
The list of lists is a collection of lists.
Each sublist is enclosed by parentheses.
Each sublist is separated from other sublists by a semicolon.
A trailing semicolon follows the last list.
Example: (one;two;three;four;);(apples;bananas;);
Supported versions
The following versions and file types are currently supported:
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-09-18 UTC."],[[["Structured Data Files (SDFs) are comma-separated values files used in Display & Video 360 to retrieve and manage resources in bulk, downloadable and uploadable through the Display & Video 360 UI and API."],["SDFs have two formats: Standard, for retrieving and updating resources, and QA, for retrieving resource settings using display names instead of IDs."],["All SDF formats have a header row with column names, use quotation marks for non-missing string values (except the header), leave missing values blank, and follow specific formatting rules for lists and lists of lists."],["Display & Video 360 supports SDF versions v7.1, v7, and v6, with varying file types available for Standard and QA formats, such as Campaign, Insertion Order, and Line Item."],["Links to detailed documentation for each version and file type are provided within the Supported versions section."]]],[]]