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](https://support.google.com/displayvideo/answer/6301070). SDFs can
also be generated and downloaded using the [Display \& Video 360 API](https://developers.google.com/display-video/api/guides/downloading-sdfs/create).

> [!IMPORTANT]
> **Important:** SDFs have a limit of 10,000 entries. Attempting to upload files exceeding this limit will result in an error.

An SDF file is of a format specific to a [version and Display \& Video 360 resource
type](https://developers.google.com/display-video/api/structured-data-file/format#supported_versions).

## 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;);`

## Partial upload

Structured Data Files can be uploaded with a subset of supported columns. This
lets you manage and upload smaller files that can contain more resources
and be processed more quickly.

Partial upload is supported in all versions for the following SDF types:

- Line item

Only some columns are supported in Partial SDFs. All supported columns are
part of a column group. If you want to include a specific columns in your
partial SDF, all columns in its column group must be included or the upload will
fail.

Column groups are identified in the reference documentation by the "Partial
Group" value. If that value is "None", the column is not supported in Partial
SDFs.

See the [Partial SDF Upload guide](https://developers.google.com/display-video/api/guides/concepts/structured-data-files/partial-sdf-upload) for more details.

## Supported versions

The following versions and file types are supported:

### v11

Format and File type Standard [Campaign](https://developers.google.com/display-video/api/structured-data-file/v11/Campaign) [Insertion Order](https://developers.google.com/display-video/api/structured-data-file/v11/InsertionOrder) [Inventory Source](https://developers.google.com/display-video/api/structured-data-file/v11/InventorySource) [Line Item](https://developers.google.com/display-video/api/structured-data-file/v11/LineItem) [Media Product](https://developers.google.com/display-video/api/structured-data-file/v11/MediaProduct) [YouTube Ad Group](https://developers.google.com/display-video/api/structured-data-file/v11/AdGroup) [YouTube Ad](https://developers.google.com/display-video/api/structured-data-file/v11/AdGroupAd) QA [Line Item](https://developers.google.com/display-video/api/structured-data-file/v11/LineItemQA) [YouTube Ad Group](https://developers.google.com/display-video/api/structured-data-file/v11/AdGroupQA)

### v10.1

Format and File type Standard [Campaign](https://developers.google.com/display-video/api/structured-data-file/v10-1/Campaign) [Insertion Order](https://developers.google.com/display-video/api/structured-data-file/v10-1/InsertionOrder) [Inventory Source](https://developers.google.com/display-video/api/structured-data-file/v10-1/InventorySource) [Line Item](https://developers.google.com/display-video/api/structured-data-file/v10-1/LineItem) [Media Product](https://developers.google.com/display-video/api/structured-data-file/v10-1/MediaProduct) [YouTube Ad Group](https://developers.google.com/display-video/api/structured-data-file/v10-1/AdGroup) [YouTube Ad](https://developers.google.com/display-video/api/structured-data-file/v10-1/AdGroupAd) QA [Line Item](https://developers.google.com/display-video/api/structured-data-file/v10-1/LineItemQA) [YouTube Ad Group](https://developers.google.com/display-video/api/structured-data-file/v10-1/AdGroupQA)

### v10

Format and File type Standard [Campaign](https://developers.google.com/display-video/api/structured-data-file/v10/Campaign) [Insertion Order](https://developers.google.com/display-video/api/structured-data-file/v10/InsertionOrder) [Inventory Source](https://developers.google.com/display-video/api/structured-data-file/v10/InventorySource) [Line Item](https://developers.google.com/display-video/api/structured-data-file/v10/LineItem) [Media Product](https://developers.google.com/display-video/api/structured-data-file/v10/MediaProduct) [YouTube Ad Group](https://developers.google.com/display-video/api/structured-data-file/v10/AdGroup) [YouTube Ad](https://developers.google.com/display-video/api/structured-data-file/v10/AdGroupAd) QA [Line Item](https://developers.google.com/display-video/api/structured-data-file/v10/LineItemQA) [YouTube Ad Group](https://developers.google.com/display-video/api/structured-data-file/v10/AdGroupQA)