Clear search
Close search
Google apps
Main menu

Preview many dynamic creatives side by side

Dynamic creatives offer the ability to generate a single tearsheet that includes multiple previews with the click of a button. Use tearsheets when you have many different creative iterations you wish to preview side by side. 

Studio provides a .csv template, unique to each profile, which you fill out with the preview parameters you want. After you fill out the template and import it, Studio automatically generates a tearsheet containing all of the previews. The .csv file can also be used in conjunction with forced preview to speed up the preview process even more.

Import a tearsheet

  1. Navigate to Step 5: Preview in the Studio workflow.
  2. Click on the + Import Tearsheet button. The Import Preview Sheet popup window opens.
  3. Click Preview sheet template
    1. A csv template designed specially for your dynamic profile will be downloaded to your local machine.
    2. Each of the column headers in the .csv template should match one of the preview parameters in the Step 5: Preview UI. 
    3. Dates/times must be formatted as follows: MM DD YYYY, HH:MM PST (zz:zz). For example, 10 29 2013, 00:00 PST (-08:00)
      1. MM is the two-digit month (for example, 01 for January). 
      2. DD is the two-digit day.
      3. YYYY is the 4-digit year.
      4. HH:MM is the time in 2-digit hour and minutes.
      5. Replace PST with your timezone abbreviation (see a list of timezones).

      6. (zz:zz) is for the time difference from the UTC time (refer to the UTC offset column in the list of timezones above).

  4. Fill out the columns in the .csv template with the corresponding preview parameters and save the file (make sure the file is in .csv format).
  5. Navigate back to Step 5: Preview and under the Creatives section, check/uncheck the appropriate boxes for the creative sizes you wish to preview.
  6. Click the + Import Tearsheet button. The Import Preview Sheet popup window opens.
  7. Click the Browse for file button.
  8. Select the .csv file from your local machine. 
  9. Click Import Tearsheet. A tearsheet is generated in the saved tearsheets table. It is titled "Imported untitled tearsheet - Date/Time".

Using tearsheets with forced preview

When the .csv template is generated, it will include an additional column header for the forced preview parameter. Fill out the forced preview column in the .csv with the unique IDs you wish to preview and import the file.

If both forced preview and regular preview parameters (e.g. Placement ID, Location, etc.) are filled out in the .csv file, the forced preview parameters trump the regular preview parameters.


Can I delete or re-order columns in the .csv template?

Yes, as long as the .csv file imported to Studio contains at least one column header that matches the preview parameters for that profile, the tearsheets can be successfully generated. Therefore, you can change the order of the columns or delete columns if desired.

Can I generate tearsheets by importing Excel files?

No, this feature does not work with Excel files. 

I am trying to generate a tearsheet using dates and times, but it's not working. What's wrong?

The date values must be formatted in a specific way in the .csv file. The format must be: MM DD YYYY, HH:MM PST (-zz:zz). For example, a correct date format looks like: 10 29 2013, 00:00 PST (-08:00). If the date is not formatted in this way, no preview is generated.

What is the best practice when uploading tearsheets for campaigns that use dependent selection?

When using multiple feeds with dependent selection, we recommend only inputting values for the child feed. If you input values for both parent and child feed, the preview will show related content for rows in the child feed that would never get triggered based on the input from the parent feed. Dynamic preview does not understand the dependency between feeds, so in order for a proper preview to be generated, ignore the parent feed and only choose values for the child feed, e.g. using forced preview values.

If you upload tearsheets that only have values assigned for the filterable column from the parent feed, then you might miss out on all eligible content that could be shown in the preview from the child feed. 


Was this article helpful?
How can we improve it?