Create or edit entities with Structured Data Files

Structured Data Files can be useful if you need to:

  • Quickly create many campaigns, insertion orders, or line items
  • Bulk edit across multiple campaigns, insertion orders, or line items at the same time

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.

We strongly suggest you don't use Excel to edit or create SDF files

In many cases, Excel may corrupt your targeting settings and/or edit timestamp values, which will prevent you from being able to upload your files or could change your targeting settings in unexpected ways.

Create new campaigns, insertion orders, and line items

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

Create new campaigns, line items, and insertion orders using SDFs
  1. Start by reviewing the SDF specifications.

  2. In Display & Video 360, upload your SDF files (for insertion orders, line items, TrueView ad groups, and TrueView ads) from your advertiser's insertion orders page by clicking More > Upload.

    Use temporary identifiers to link files

    If you're simultaneously creating new line items within a new insertion order—or new TrueView ads in a new TrueView ad group—make sure you upload SDF files with temporary, custom identifiers (temporary IDs) to link your files together.

    The format for temporary IDs is "ext[custom identifier]" (for example, ext123). Temporary IDs go in the Io Id field (for linking line items to insertion orders) and Ad Group Id field (for linking TrueView ads to TrueView ad groups).

    Once your files are uploaded and processed, all temporary IDs will be replaced with unique, Display & Video 360-generated IDs, and all items will retain their proper associations based on your temporary identifiers.

    Remember to upload any interdependent files at the same time.

  3. Choose your CSV file then click Upload.

  4. Display & Video 360 will verify your files and show a status for each file. (You will also receive an email confirming that the insertion orders, line items, TrueView ads, and TrueView ad groups have been successfully created or notify you of any errors that were encountered while creating your campaign.)

    • 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.

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

Add new line items to existing insertion orders

  1. In Display & Video 360, make sure the insertion order (or insertion orders) you want to use for your line items have been created.

    If you're able to create properly formatted structured data files own your own, you can skip ahead to step 4 (below).
  2. Navigate to the list of line items underneath your advertiser, then click Actions > Download SDF.

  3. In the window that opens, select the types of items you'd like to create (line items, TrueView ad groups, and/or TrueView ads), then click the Download button to download the appropriate SDFs.

    You can also use these SDFs to edit existing items at the same time.

    Download SDFs from the Action menu

  4. Populate your SDF (SDF specification here) with all of the details of the line items you want to create.

  5. In Display & Video 360, upload your SDF from your advertiser's insertion orders page by clicking Actions > Upload.

  6. Choose your CSV file then click Upload.

  7. Display & Video 360 will verify your files and show a status for each file. (You will also receive an email confirming that your items have been successfully created or notify you of any errors that were encountered)

    • 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.

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

 

Edit existing campaigns, insertion orders, and line items

Save time with the Bid Manager Read API

There are two ways to download insertion orders and line items, by using the Bid Manager API and from the Display & Video 360 UI. For reference on using the Bid Manager API, see the sdf/download() API specification.

You can skip to step 3 (below) if you're comfortable downloading your existing line items using Display & Video 360's API.

  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 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

    Start by navigating to any of the following locations:

    • Advertiser > Insertion orders
    • Advertiser > Line items
    • Advertiser > Insertion order > Line items

    Then, click Action > Download in the menu bar.

    Download Structured Data Files window

    Your line items will be downloaded into a SDF.

    Individual line items
    1. Start in the list of line items under your advertiser (or the list of line items an individual insertion order), then select the checkboxes next to the line items you want to edit.

    2. Click Actions > Download in the menu bar at the top of the list of line items.

      Your line items will be downloaded into a SDF.

  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. Also, 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 > 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.

 

Downloading 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 > 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.

Creating, modifying, and uploading 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. 

Inventory sources can't be changed from being one type of inventory source to another once the inventory source has been created.
 
For example, you can't change a "non-guaranteed auction" inventory source to being a "programmatic guaranteed" inventory source or a "non-guaranteed fixed price" inventory source.
  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:
    Creating a new tag guaranteed order
    Note: Rows with the same Seller Name and Order Name will be grouped together in the same order.
    1. Create a new row for each product.
    2. Fill out the following fields for each product:
      • Name
      • Seller Name
      • Deal Type (enter Tag reservation)
      • Order Name
      • Min Impressions
      • Creative Type (enter DISPLAY or VIDEO)
      • Required Creative Dimensions (For display, separate multiple dimensions with a comma e.g. "300x250, 728x90". For video, enter the duration of the creative in seconds e.g. "30")
  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 > 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.

Limitations

The following features are not supported by SDF:

  • Installed app category targeting
  • Geofenced business targeting
  • GRP buying for partner select line items
  • Mobile app install 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

Can Display & Video 360 send emails to other people when my SDFs are processed?

Yes. All SDF emails can also be sent to an administrator email address. This might be useful if you want a team distribution list to see SDF processing emails or if you want to parse these emails by a system. “Administrator” emails can be set in the Structured Data Files section in your partner or advertiser's Basic Details.

Can I use SDFs at the partner-level to manage data for multiple advertisers?

Yes. To download and upload files that span multiple advertisers under the same partner, navigate to your partner's list of advertisers, select your advertisers, then download a SDF from the Actions menu. Once you're done editing your SDFs, return to the list of advertisers to upload your files. 

You can download up to 90,000 line items in an individual Structured Data File.
Can I change or upgrade the version of Structured Data Files I use?

Yes. The SDF version can be changed in both the Partner and Advertiser level.

  • Partner level:  The version of SDF can be changed at the Partner level by navigating to [Partner name] > Settings > Basic Details. From the Structured Data Files section of the page, select the SDF Version by clicking on the dropdown menu.


     
  • Advertiser level: The version of SDF can be changed at the Advertiser level by navigating to [Advertiser name] > Settings > Basic Details. From the Structured Data Files section of the page, select the SDF Version by clicking on the dropdown menu. In addition, you have the option to override Partner level settings.

We recommend that you use the latest version of SDF as much as possible.

How do I download objects from Display & Video 360 using the API?

There are two methods for downloading line items: via the Bid Manager API and manually from within Display & Video 360.

1. Use the API: To download SDFs using the API, see Structured Data  on developers.google.com.

2. Use the UI: To manually download line items from the Display & Video 360 UI, navigate to any of the following in Display & Video 360:

  • Advertiser > Insertion orders > Actions > Download
  • Advertiser > Line items > Actions > Download
  • Advertiser > Insertion order > Line items > Download
How do I upload insertion orders or line items? Can I upload multiple SDF files?

Yes. Display & Video 360 will queue and process SDF files in the order with which they are uploaded. Make sure you're familiar with how to use temporary identifiers to link files.

However, to avoid errors, avoid uploading multiple files at the same time if they include the same line item.

How do I copy line items?

Download an SDF of line items that you want to copy, then remove their Line Item Id in the SDF. An SDF row without a Line Item Id will instruct Display & Video 360 to create a new line items. Change the names of these line items to the new names.

If you'd like to copy line items between insertion orders, make sure to update the Io Id field.

What are "Entity Read Files"?

Entity Read Files are flat files in Google Cloud Storage that contain lookup values for Display & Video 360 entities like geographies, creatives, audience lists, and more. These lookup values can be used to assign creatives and targeting to line items by ID.

Can I use SDFs to move things from one advertiser to another?

Yes, however, some targeting settings are proprietary to the advertiser, such as channels, audience lists, and advertiser-specific inventory sources (such as deals).

So, if you download an SDF of line items from "Advertiser A" and then upload the line items into "Advertiser B", make sure you remove any channels or first-party audience lists from the SDF first, since they can't be used with a different advertiser.

What targeting options are supported in SDFs?

Please see Display & Video 360 Structured Data File on developers.google.com for information on supported targeting options.

Was this helpful?
How can we improve it?