Structured Data File (SDF) Format

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.

An SDF file is of a format specific to a version and Display & Video 360 resource type.

Format Types

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:

v7.1

Format and File type
Standard
Campaign
Insertion Order
Inventory Source
Line Item
Media Product
YouTube Ad Group
YouTube Ad
QA
Line Item
YouTube Ad Group

v7

Format and File type
Standard
Campaign
Insertion Order
Inventory Source
Line Item
Media Product
YouTube Ad Group
YouTube Ad
QA
Line Item
YouTube Ad Group

v6

Format and File type
Standard
Campaign
Insertion Order
Inventory Source
Line Item
Media Product
YouTube Ad Group
YouTube Ad
QA
Line Item
YouTube Ad Group