Partial Structured Data File (SDF) Upload allows Display \& Video 360 users to
update a subset of resource configurations for existing line items in bulk using
[Structured Data Files](https://developers.google.com/display-video/api/structured-data-file/format.md.txt), with fewer columns than normally required by the
[Line Item file format](https://developers.google.com/display-video/api/structured-data-file/v9-2/LineItem.md.txt).

By requiring fewer columns, Partial SDF Upload provides the following benefits:

- Lets you include a greater number of resources in a single uploaded file.
- Makes manual management of SDFs easier.
- No longer requires an uploaded SDF to be created from a previously-downloaded file.
- Reduces the time between initial file upload and the propagation of updates.

Partial SDF is only supported for [Line Item SDFs](https://developers.google.com/display-video/api/structured-data-file/v9-2/LineItem.md.txt).

## How to use Partial SDF Upload

Follow these steps to build and upload a partial SDF:

1. Decide which line items and settings you want to update.

   - Identify line items using the `Line Item Id` column. This column is required in every Partial SDF and must be populated in every file entry.
   - Choose the columns to update from the [Available Column
     Groups](https://developers.google.com/display-video/api/guides/concepts/structured-data-files/partial-sdf-upload#available_column_groups) section.

     - In order to update any column in a column group, all columns in that group must be present in the file.
     - A file can include multiple column groups.
     - Files with any incomplete column groups or columns not specifically supported by Partial SDF Upload will result in an error.
2. Build the file in one of the following ways:

   - Use an existing SDF.

     - Download a Line Item SDF containing the relevant line items, as you would when managing and uploading a standard SDF.
     - Download an initial SDF containing all of the selected line items.
     - Remove all columns that are not in the relevant Partial SDF column groups.
     - Remove all line item entries that you are not going to update.
   - Build a new CSV file.

     - Build a CSV file and only include headers for the columns in the relevant Partial SDF column groups.
     - Add an entry to the file for every line item ID that will be updated.
3. Populate the new Partial SDF.

   - If using a downloaded file, update the existing values for each line item entry. Values that are not going to be updated don't need to be changed. *Partial SDF does not support the `Timestamp` column. Any changes made to a
     line item between file download and partial SDF upload will be overwritten
     if the relevant column is included.*
   - If using a new CSV file, populate all included columns for every line item entry. You can leave the value of a column intentionally empty, but upon upload that empty value will be saved as the new value for that line item setting.
4. Upload the file to Display \& Video 360 in the UI using the [standard SDF
   upload process](https://support.google.com/displayvideo/answer/6301070). No additional configurations are required to
   identify it as a Partial SDF. When the uploaded file is processed, result
   files will be available on the bulk status page noting which line items were
   successfully updated and which failed to update. *Unlike a standard SDF
   upload, emails with result files aren't sent after Partial SDFs are uploaded
   and processed.*

## Sample files

We've provided three sample files that you can use to build your Partial SDF.
Each sample uses a different combination of column groups. Each one includes a
header row identifying the relevant columns and three rows that should be
updated with the intended data before upload.

Download one of the following CSV files with the identified column groups to use
as a template:

- [Sample 1](https://developers.google.com/static/display-video/api/guides/concepts/structured-data-files/sample-files/partial-sdf-name-status.csv)
  - Column groups: [Line Item ID](https://developers.google.com/display-video/api/guides/concepts/structured-data-files/partial-sdf-upload.md.txt#line_item_id), [Name](https://developers.google.com/display-video/api/guides/concepts/structured-data-files/partial-sdf-upload.md.txt#name), [Status](https://developers.google.com/display-video/api/guides/concepts/structured-data-files/partial-sdf-upload.md.txt#status)
- [Sample 2](https://developers.google.com/static/display-video/api/guides/concepts/structured-data-files/sample-files/partial-sdf-budget.csv)
  - Column groups: [Line Item ID](https://developers.google.com/display-video/api/guides/concepts/structured-data-files/partial-sdf-upload.md.txt#line_item_id), [Budget and Pacing
    fields](https://developers.google.com/display-video/api/guides/concepts/structured-data-files/partial-sdf-upload#budget_and_pacing_fields)
- [Sample 3](https://developers.google.com/static/display-video/api/guides/concepts/structured-data-files/sample-files/partial-sdf-targeting.csv)
  - Column groups: [Line Item ID](https://developers.google.com/display-video/api/guides/concepts/structured-data-files/partial-sdf-upload.md.txt#line_item_id), [Geography Region Targeting
    fields](https://developers.google.com/display-video/api/guides/concepts/structured-data-files/partial-sdf-upload#geography_region_targeting_fields), [Proximity Targeting](https://developers.google.com/display-video/api/guides/concepts/structured-data-files/partial-sdf-upload.md.txt#proximity_targeting), [Keyword Targeting fields](https://developers.google.com/display-video/api/guides/concepts/structured-data-files/partial-sdf-upload.md.txt#keyword_targeting_fields)

## Available column groups

The following are available column groups for Partial SDFs. Each group contains
one or more columns from the [SDF Line Item file format](https://developers.google.com/display-video/api/structured-data-file/v9-2/LineItem.md.txt). If a column
group has more than one column, all columns from that group must be included in
the uploaded file.

### Line Item ID

> [!IMPORTANT]
> **Important:** This column group is required for all Partial Structured Data Files.

Included columns:

- `Line Item ID`

### Name

Included columns:

- `Name`

### Status

Included columns:

- `Status`

### Flight fields

Included columns:

- `Start Date`
- `End Date`

### Budget and Pacing fields

Included columns:

- `Budget Type`
- `Budget Amount`
- `Pacing`
- `Pacing Rate`
- `Pacing Amount`

### Frequency Cap fields

> [!CAUTION]
> **Caution:** Some columns in this group are only required if TrueView line items are included in your file. If you are not sure of which types of line item your file will include, we recommend that you include all columns when using this file group.

Included columns for all line item types:

- `Frequency Enabled`
- `Frequency Exposures`
- `Frequency Period`
- `Frequency Amount`

Additional columns, required if TrueView line items are present:

- `TrueView View Frequency Enabled`
- `TrueView View Frequency Exposures`
- `TrueView View Frequency Period`

### Partner Revenue Model fields

Included columns:

- `Partner Revenue Model`
- `Partner Revenue Amount`

### Conversion Tracking fields

Included columns:

- `Conversion Counting Type`
- `Conversion Counting Pct`
- `Conversion Floodlight Activity Ids`
- `Primary Attribution Model Id`

### Reporting Info fields

Included columns:

- `Integration Code`
- `Details`

### Bid Strategy fields

Included columns:

- `Bid Strategy Type`
- `Bid Strategy Value`
- `Bid Strategy Unit`
- `Bid Strategy Do Not Exceed`
- `Apply Floor Price For Deals`
- `Algorithm Id`

### TrueView Bid Strategy fields

Included columns:

- `TrueView Bid Strategy Type`
- `TrueView Bid Strategy Value`

### Creative Assignments

Included columns:

- `Creative Assignments`

### Geography Region Targeting fields

Included columns:

- `Geography Targeting - Include`
- `Geography Targeting - Exclude`

### Proximity Targeting

> [!CAUTION]
> **Caution:** When formatting a file containing this column group, make sure there is no space between the comma before this column and the column values itself.

Included columns:

- `Proximity Targeting`

### Keyword Targeting fields

Included columns:

- `Keyword Targeting - Include`
- `Keyword Targeting - Exclude`

## Considerations

Do the following before attempting to upload a Partial SDF, make sure of the
following:

- The Line Item Id column is present and populated for all entries.
- All included columns are part of a supported Partial SDF column group.
- All columns in the represented column groups are included.
- There are no spaces between commas and the column values they separate.
- Each value in a present entry is the intended value for that column.
- If updating line items from different advertisers, upload your Partial SDF at the shared partner level. *You can't update two line items under different
  partners in the same SDF.*