Introduction

When using the File Upload data connector, a CSV file containing your source (company) records is uploaded to the SundaySky platform. This CSV file is used for personalizing the video. The source data in the file is merged with the video you created, outputting a file with a personalized link for each viewer.

Note:
The file that you import (steps 2b and 2c below) when you are ready to personalize the video is saved to the data library that you selected for the video. This means that the data imported from the file is used by all videos connected to the same data library.
What happens if you import new records after the initial import? When an id identifier in a new record matches an id identifier in an existing record, the data in the new record is used in all the videos using this data library.

In this article you will find instructions for generating video links whether you are using the SundaySky landing page or a non-SundaySky page.

Generating Video Links for a SundaySky Landing Page

Before Starting:
Make sure that the video is published.

  
1.

On the video page, click Share and then select SundaySky Landing Page.
  Share_menu.png
2. Follow the steps as displayed on the screen.
 
a. Click Import.
  Click_import.png
b. Upload the data file that contains your records.
▶ Refer to Preparing the Data File for guidelines on how this file needs to be structured. If you need a template to get started, click customized CSV Template.
  Click_browse.png
c. Click Import File & Download CSV Links File.
▶ At this stage, the data is saved in the SundaySky platform and the unique video links are generated.
  Import_file_and_download.png
d. Open the downloaded file with the video links.
  landing_page_links.png
e. Share the video using the video links that were downloaded or use the landing page URL and append the unique viewer ID to the end of each URL.
  Landing_page_URL.png

Generating Video Links for a Non-SundaySky Landing Page

Before Starting:
Make sure that the video is published.

  
1.

On the video page, click Share and then select Embed Video.
  Select_Embed_video.png
2. Follow the steps as displayed on the screen.
 
a. Copy and paste the embed code into your website editor.
▶ Skip this step if the code is already embedded.
  Copy_code.png
b. Click Import.
  Import_file.png
c. Upload the data file that contains your records.
▶ Refer to Preparing the Data File for guidelines on how this file needs to be structured. If you need a template to get started, click customized CSV Template.
  Click_browse.png
d. Enter the URL of the landing page where the video will be played and then click Next.
▶ This is the page in which the SundaySky video player is embedded.
  Enter_URL_lp.png
e. Click Import File & Download CSV Links File.
▶ At this stage, the data is saved in the SundaySky platform and the unique video links are generated.
  Import_file_and_download.png
f. Open the downloaded file with the video links.
  video_links.png
g. Share the video using the video links that were downloaded or use the landing page URL and append the unique viewer ID to the end of each URL.
▶ This file can also be sent to your email service provider.
  Last_step.png

Preparing the Data File

1.

Click customized CSV Template to download the data file template.
  customized_csv_template.png
2.

Open the data file template on your desktop. This template includes the data fields that you used for personalizing your video. Each data field name is a column header.
The data file that you upload needs to be in the same format as this file. In addition, the letter case must also match.
▶ In the example below, there are three column headings: id, First Name, and Customer Type. Using this example, the column headings in the uploaded file must exactly match the column headings in the template: id in column A, First Name in column B, and Customer Type in column C.
 

csv_template_example.png
3. Prepare the data file using one of the following methods:
  Method 1 Copy the header columns from the data file template to your company data file. Make sure that the values beneath each column header are relevant to the column header (data field).
  Method 2 Use the data file template as your data file and enter the relevant values in each row.
  Method 3 Use the data file template only as a reference. Compare the column headings in your data file to the template to make sure that the structure is correct.
 

Important Notes:

a.

Every column must have a column header.
b.

The column header name must be unique and differ from the other column header names.
c.

The id column is mandatory and must always be the first column (A). The column header id must always be written in lowercase.
d.

Every row (record) must have an id value. Values for all other column headers (fields) are optional. In the case of an empty value, the message shown in the video will be according to the default message defined in the video.
e.

The id value in each row must be unique. This is for two reasons:
a. A unique video link is created for each record.
b. The id value is used in detailed reports.
4.

Save the file in CSV UTF-8 (Comma delimited) format.

More articles from Data Integration

Was this article helpful?
0 out of 0 found this helpful

Still Have Questions?

SundaySky Support is here for you

contact support