Delivery of receiver data – SEEN Documentation

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

Lower case email addresses (if used).

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.

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

Prepare phone numbers (if applicable).

Add the country code in front of the phone number, and remove all spaces.

Make sure the phone numbers are correct (amount of numbers etc).

If you have Swedish phone numbers in your list, remove the 0 (if present) between +46 and 7.

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.

Rename columns.

Do the following changes:

Use first_name as the first name column name.

Use last_name as the surname column name.

Use email as the email column name.

Use phone as the phone number column name

Special characters and spaces are not allowed in column names.

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.

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.

Correct file structure:

first_name	last_name	email	phone	interest	crm_id
John	Doe	johndoe@example.com	+4712345678	Football	123
Jane	Smith	janesmith@example.com	+4723456789	Tennis	234
Michael	Johnson	michaeljohnson@example.com	+4734567890	Basketball	345
Emily	Davis	emilydavis@example.com	+4725678901	Swimming	456
William	Martinez	williammartinez@example.com	+4756789012	Volleyball	567
Elizabeth	Taylor	elizabethtaylor@example.com	+4767890123	Skiing	678
James	Anderson	jamesanderson@example.com	+4778901234	Golf	890
Jennifer	Thomas	jenniferthomas@example.com	+4789012345	Badminton	020
Robert	Jackson	robertjackson@example.com	+4720123456	Football	046
Linda	Harris	lindaharris@example.com	+4701234567	Rugby	352
David	Martin	davidmartin@example.com	+4712345678	Cricket	782
Barbara	Thompson	barbarathompson@example.com	+4723456789	Ice Hockey	365
Richard	Garcia	richardgarcia@example.com	+4734567890	Baseball	289
Susan	Martinez	susanmartinez@example.com	+4725678901	Table Tennis	033
Joseph	Robinson	josephrobinson@example.com	+4756789012	Cycling	078