Samsung DSP provides a workflow to simultaneously import multiple creatives in batch, reducing the time required to upload all the creatives for a campaign.

Requirements & Specifications

Batch Import supports the following creative types:

Access & Setup

1. On the left panel, click the Creatives icon.
2. On the Creatives page, click Batch Import located in the upper right-hand corner.
   

This page is composed of three sections that describe the workflow involved when importing Creatives.

• General Settings provides you with the latest Spreadsheet Template Samsung DSP relies on to proceed.
• Upload Spreadsheet ensures that the Spreadsheet Template you submit is properly completed, where all required information has been entered (Advertiser ID, Assets information, etc.).
• Upload Assets remains inactive until it receives the information coming from the uploaded Spreadsheet template. It validates that the mapping between the assets defined in the Spreadsheet Template and those you upload in this section match.

General Settings

• Batch Operation Name: Enter a name for this batch operation task. Once you click Import, you will be able to check its status on the Batch Actions page.
• Advertisers: This field helps you to directly retrieve the Advertiser ID that will be assigned to the campaign where the creatives will be used for. You can either enter the advertiser’s name or look for it using the drop-down list. Once selected, you will see its ID below the Advertiser ID column. For this example, we take the advertiser ID 1423 which refers to Ad.

• Spreadsheet Template: Click Download Spreadsheet Template to save the template on your computer.

Fill out the Spreadsheet Template

• Once downloaded on your computer, open the Excel file.

Each column corresponds to a field you would find on the creative form in Samsung DSP.
Each sheet (tab) refers to a creative type (except for the Creative Group tab which refers to a feature allowing you to gather multiple creatives into one group. Refer to Import Creatives assigned to a Creative Group for more details.).

The following table helps you to fill in the fields of each sheet using their respective documentation.

• Fill out the Excel spreadsheet by taking into consideration the following color code:
  • Green = Mandatory
  • Orange = Optional
  • Red = Must be blank

• Once you have entered the values into the spreadsheet in the first row:
  • Click the number indicating the row position then press CTRL or CMD (on Mac) + C to copy the line.
    • Click the number indicating the row position of the line below and press CTRL or CMD (on Mac) + V to paste the content.
  • From this point, you can either edit the row by changing only some cells in the columns if the settings are similar OR right-click on the number indicating the row position and select Clear Content to start from scratch while preserving the data validation formulas.
• Once you finished completing the spreadsheet, save and close the file.

Import Creatives assigned to a Creative Group

Creative Group allows you to gather the creatives of a specific type into the same group (See Creative Group for more details). Using the Batch Import feature to create a Creative Group enables you to create both the creative(s) and the creative group in the same import.

To add creative(s) of a specific type (i.e., sheet) to a Creative Group:

• In the creative_group sheet:
  • Add a name in the cell of the name column and enter the same advertiser ID as the one used by the creatives in the cell of the advertiser_id column.
  • In the cell of the type column, select the creative type assigned to this group (i.e. the sheet on which you assigned an ID in the cell of the creative_group_mapping_id column).
  • In the cell of the format column, select the format that matches the type. Refer to the table below for more details.
  • In the cell of the creative_group_mapping_id column, make sure to assign the same ID in the cell of the creative_group_mapping_id column of both the said creative type and the creative_group sheets.
  • In the cell of the creative_group_weights column, enter 100 if you left the cell of the existing_creative_ids column blank. If you did not, make sure that the numbers you entered for the cells of both creative_group_weights and existing_creative_weights columns equal 100.
  • [OPTIONAL] In the cell of the existing_creative_ids column, enter the ID of an existing creative in Samsung DSP if you want to include it as part of creative groups.
  • In the cells of the start_date, start_time, and start_at_time_zone columns, enter the date as YYYY-MM-DD, time as HH:MM:SS, and select the time zone in the drop-down list to define the time frame during which the creatives should be active. The same applies to the cells of the end_date, end_time, and end_at_time_zone columns.
  • In the cells of the time_zone_daypart and daypart_day X columns, select the daypart time zone in the drop-down list and specify the time of the day (hourly slots) for different days of the week when the impressions will take place. For the time of the day you can enter a time, a time range, or a combination of both using a 24H format. For instance 5,6, 15-19 would mean at 5 and 6 o’clock then from 3PM to 7PM.

• Once you finish completing the spreadsheet, save and close the file.

Validation Checks

Upload Spreadsheet

• Once you have completed the Spreadsheet Template, drag the file and drop it in the grey-dotted rectangle OR click Browse to navigate to the place where the template is located.
  

If the Excel file is valid:

• The following message “excel_file_name.xls was uploaded successfully” will be displayed.
• The Upload Assets section is made available and should have populated a list of all the assets you defined in the template.
  

Upload Assets

This section is the last validation step Samsung DSP performs before proceeding to the uploading of all creatives.

• Drag the assets (picture and video files) and drop them in the blue-dotted rectangle OR click Browse to navigate to the place where they are located.

In the table, you will see four columns:

• Asset Name: This column displays the name of the assets that were extracted from the template.
• State: This column indicates the status regarding the file analysis.
  • To be validated means that the file is on a waiting list.
  • Validated means that Samsung DSP has validated the data against what was defined in the template.
• Errors: This column gives you details about the reasons why Samsung DSP detected an error.
• Actions: Click the trash bin to delete the file you uploaded as an asset.

Run the batch import task

Once the spreadsheet and assets have been validated, the Import button will become available. If not, make sure you filled the required fields in the General Settings section.

• Click Import to run the batch import task.
• The following message will be displayed: The batch import was successfully enqueued. See details in the batch actions page.
• You will be directed automatically to the Batch Import page to check the task progress. Once finished, the table will be populated with all the details (Title, Type, and Format) related to the creatives you entered in the template. Each of them will get assigned an ID.

• If you don’t want to wait for the process to finish, you can leave this page and works on something else in the meantime. You will receive an email when the task is complete and will be able to click the click here to review link to be directed to the Batch Action page (Also accessible via Setup > Batch Actions).

Upload Spreadsheet Troubleshooting

If the spreadsheet is found to have errors, they must ALL be corrected in order to proceed with the next step (i.e. upload assets). This section provides you with guidance to fix the most common issues you may encounter when uploading the spreadsheet.

Permission Denied

If you attempt to upload a creative type that was not enabled for your account, you will see the following message:

• Write down the creative type(s) mentioned in the error message and contact your account manager to solve this issue OR if you’re not supposed to create a creative for this type, clear the content from this creative sheet (tab).

Input Errors

If Samsung DSP has discovered error(s) in the spreadsheet, a three columns table is generated:

• Tab: This column indicates the sheet where the error was detected.
• Cell:This column indicates the location in the sheet where you should fix the detected error. The letter refers to the column and the number refers to the row number.
• Error Type: This column gives you details about the reasons why Samsung DSP detected an error. It is possible to download this table by clicking Download Error Report. The error report will be downloaded as a CSV file.

To fix input errors:

• Refer to the message in the Error Type column to understand what is expected to solve them.
• If required, use the respective documentation of the affected creative type(s) to enter the right value.

Creative ID provided is invalid or not found: XXXXXX

If you receive this message, this means that the creative ID you set in the cell of the existing_creative_ids column in the creative_group sheet (tab) was entered incorrectly or did not exist in Samsung DSP.

To fix this issue, go to your creative list and make sure to enter the right ID number in the spreadsheet.

Upload Assets Troubleshooting

If the spreadsheet is found to have errors, they must ALL be corrected in order to proceed with the import. This section provides you with guidance to fix the most common issues you may encounter when uploading the assets.

Errors although the filename is correct

During the validation, Samsung DSP analyzes each asset and does not stop at just validating if the names entered in the template match.

In this case, the error came from the fact the image resolution of the file did not match the value in the template.

To solve this issue, resize your asset (image or video) by changing the width and length values accordingly.