<aside>

This guide is applicable in cases where SEEN renders your videos for you as a part of the video implementation process.

</aside>

1. Make sure the data is clean.
   • Clean all special characters that are not supposed to be present.
   • Remove leading and trailing spaces:
     • If your file includes data as “J.”, we will render as is.
   • Capitalise + lower case names
   • Remove all rows with missing data (e.g. missing first name)
     • You can also replace bad or missing data with a generic option, if the script allows this.
2. Remove all unused data & combine all data to one file
   • Both unused columns and sheets / tabs should be removed.
   • Combine all data into one file, in case you are working with multiple source files (unless otherwise agreed with SEEN).
3. If you are using images in your film, only use direct links that do not require authentication to the images. Do not use redirect links.
4. Rename columns.
   • Do the following changes:
     • Use first_name as the first name column name.
     • Use last_name as the surname column name.
5. Include an internal ID (e.g. ID-number or email address) for you to be able to import the file you receive from SEEN back to your system for distribution.
6. Prepare the file to safely transfer to SEEN.
   • The file should be in CSV-format when transferred to SEEN.
   • Safely transfer the data to SEEN by either using a file transfer service, or send the file directly to SEEN.
     • Remember to encrypt your data to comply with GDPR. You can share the password with your Customer Success Manager by sending the password separately via SMS, or use a safe sharing service.
7. Correct file structure: