Create or edit entities with Structured Data Files

This article outlines how to perform some of the most common tasks using Display & Video 360's Structured Data Files (SDFs). Learn more about the different versions of Structured Data Files and their features.

Create new campaigns, insertion orders, and line items

You can create new insertion orders and line items entirely using SDFs or you can add line items using SDFs to preexisting insertion orders.

Edit existing campaigns, insertion orders, and line items

1. In Display & Video 360, navigate to the list of insertion orders under your advertiser, list of line items under your advertiser, or the list of line items under an individual insertion order.
2. Choose one of the following options for information on how to download your existing line items: All line items in one or more insertion orders
   1. Start by navigating to any of the following locations:
      • Advertiser, then Insertion orders
      • Advertiser, then Line items
      • Advertiser, then Insertion order, then Line items
   2. Click More options, then Download on the right and follow the steps to download your line items to an SDF.
      
   3. (Optional) Alternatively you can also export your line items to Google Sheets by clicking Save to Google Sheets.
      
   Individual line items
   1. Start in the list of line items under your advertiser (or the list of line items of an individual insertion order), then select the checkboxes next to the line items you want to edit.
   2. Click Actions, then Download in the menu bar at the top of the list of line items. Your line items will be downloaded into a SDF.
      
   3. (Optional) Alternatively you can also export your line items to Google Sheets by clicking Save to Google Sheets.
      
3. In the downloaded SDF, make changes to your line items then save your file. Make sure you save your SDF as a CSV file. Note that if you're using Excel to make your changes, make sure you don't edit any timestamps in the SDF, because they may get corrupted and prevent your file from being imported by Display & Video 360.
4. In Display & Video 360, upload your SDF from your advertiser's insertion orders page by clicking Actions, then Upload spreadsheet.
5. Choose your CSV file then click Upload.
6. Display & Video 360 will verify your files and show a status for each file. You will also receive an email detailing each file. (This email will either confirm that line items have been successfully created or notify you of any errors that were encountered while creating your line items)

   • Updates applied: Any updates you've made to the SDF have been applied successfully. To confirm the updates, click Download Files to down the SDF-ResultFile.zip file. Then extract it to find the SDF-{EntityName}-Updated-ResultFile.csv file where you can confirm the updates.

   • Partially successful: Some of the updates for one or more files were applied successfully. To determine the errors, click Download Files to download the SDF-ResultFile.zip file. Then extract it to find the SDF-{EntityName}-Updated-ResultFile.csv and SDF-{EntityName}-Failed-ResultFile.csv files. Open the SDF-{EntityName}-Failed-ResultFile.csv file to find and correct the error(s). When you are done, upload your file again.

   • Failed: The updates you've made to the SDF were not applied successfully. To determine the errors, click Download Files to download the SDF-ResultFile.zip file. Then extract it to find the SDF-{EntityName}-Failed-ResultFile.csv file. Open it to find and correct the error(s). When you are done, upload your file again.

7. When you are finished, click Close to finalize your changes.

Download inventory sources

1. Navigate to the list of inventory sources under the My inventory page.
2. Choose from the following options for information on how to download your inventory sources to a SDF: All inventory sources
   1. Click More options, then Download SDF. The entire list of inventory sources will be downloaded into a SDF.
   Individual inventory sources
   1. Select the checkboxes next to the inventory sources you want to download.
   2. Click Download SDF in the blue bar at the top of the list of inventory sources. Your inventory sources will be downloaded into a SDF.

Create, modify, and upload inventory sources

Learn more about the different rows in the SDF, including when which fields are available, the different types, and if the values can be written when uploading.

1. After downloading your inventory sources as a SDF, open the CSV file in an application of your choice to make your changes. If you are using Excel to make your changes, make sure you don't edit any timestamps in the SDF, because they may become corrupted and prevent your file from being imported by Display & Video 360.
2. Choose from the following options for information on how to create and modify inventory sources: Modifying an existing inventory source
   1. Locate the row of the inventory source you want to modify and make changes to the inventory source fields as necessary.
   Archiving an existing inventory source
   Note: A reservation deal can only be archived after the deal's end date.

   1. Locate the row of the inventory source you want to archive.
   2. For the "Status" field, enter Archived.
   Pausing an existing inventory source (Reservation deals only)
   1. Locate the row of the inventory source you want to pause.
   2. For the "Status" field, enter Paused.
   3. For the "Pause Reason" field, enter the reason why you are pausing the inventory source.
   Unpausing an existing inventory source
   1. Locate the row of the inventory source you want to unpause.
   2. For the "Status" field, enter Active.
   3. (Optional) For the "Pause Reason" field, delete the reason why you paused the inventory source prior to unpausing it.
   Creating a new non-guaranteed inventory source
   1. Create a new row for each new inventory source.
   2. Fill out the following fields for each new inventory source:
      • Exchange (Note: cannot be updated once saved)
      • Deal ID (Note: cannot be updated once saved)
      • Name
      • Deal Type
      • (Optional) Seller Name
      • Floor CPM (follow format: $X.XX)
      • Currency Code
      • Start Date
      • End Date
      • Permissioned Advertiser
3. After you've finished, save your CSV file.
4. Back on the My inventory page in Display & Video 360 (the same page where you downloaded your inventory sources), click More options, then Upload SDF. Choose your CSV file then click Upload. (Remember to upload the SDF to the same partner you downloaded it from)
5. Display & Video 360 will verify your files and show a status for each file:

   • Updates applied: Any updates you've made to the SDF have been applied successfully. To confirm the updates, click Download Files to down the SDF-ResultFile.zip file. Then extract it to find the SDF-{EntityName}-Updated-ResultFile.csv file where you can confirm the updates.

   • Partially successful: Some of the updates for one or more files were applied successfully. To determine the errors, click Download Files to download the SDF-ResultFile.zip file. Then extract it to find the SDF-{EntityName}-Updated-ResultFile.csv and SDF-{EntityName}-Failed-ResultFile.csv files. Open the SDF-{EntityName}-Failed-ResultFile.csv file to find and correct the error(s). When you are done, upload your file again.

   • Failed: The updates you've made to the SDF were not applied successfully. To determine the errors, click Download Files to download the SDF-ResultFile.zip file. Then extract it to find the SDF-{EntityName}-Failed-ResultFile.csv file. Open it to find and correct the error(s). When you are done, upload your file again.

6. When you are finished, click Close to finalize your changes.

Download metadata

1. Navigate to Advertiser, then Campaigns, then More options, then Download metadata to download a file with name to ID mappings for various entities used by SDFs.
   • Metadata files can be very large depending on your advertiser setup.
2. You can track the progress of your metadata download by clicking Bulk status at the top of the page. Learn more about tracking the edit history of bulk actions.

Limitations

The following features are not supported by SDF:

• Installed app category targeting
• Geofenced business targeting
• GRP buying for partner select line items
• Digital out-of-home (DOOH) line items

We recommend you regularly compare the campaign settings in Display & Video 360 with the available SDF fields found on developers.google.com.

Frequently asked questions