Generating Video Links (CSV)

If you have created a landing page on your own, continue reading. If you are using the SundaySky Landing Page Builder to create your landing page, see Using the Landing Page Builder to learn how to generate the video links.

In this article:

➤ Generating the Video Links

➤ Preparing the Data File

Once your video has been published, you can generate unique links to the video for all your viewers.

Each of your viewers will see a video tailored specifically to them. The video content is based on how you have configured the scenes together with the data in each viewer's data record. To learn more, see Video Personalization—How it Works.

Generating the Video Links

1.	Access the relevant program in SundaySky.
2.	Click the three dots by Edit Program and then select Generate video links. ▶ If you do not see this option, the program has not yet been published.

3.

Upload your data file using either of the following options:
a. Drag and drop the file to the area bordered by the dotted lines.
b. Click Upload From Computer and then locate and upload the file from your local or cloud storage.
▶ See Preparing the Data File for specific guidelines on how to structure and prepare this file.

4.	Enter the URL of the landing page where the video will be played and then click Next. ▶ This is the webpage in which the SundaySky video player is embedded.

5.	Click Download Video Links. ▶ At this stage, the data is saved in the SundaySky platform and the unique video links are generated.

6.	Open the downloaded file with the video links. ▶ This file can also be sent to your email service provider.

In the SundaySky player, the video appears similar to the example below:

Preparing the Data File

1.	Click Your customized CSV Template to download the data file template.

2.	Open the data file template on your desktop. This template includes the data elements used for personalizing your video. Each data element 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 casing must also match. ▶ In the example below, there are three column headings: id, First Name, and Customer Type. According to 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.

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 element). 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 format 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 program.
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.

Generating Video Links (CSV)

Generating the Video Links

Preparing the Data File

Important Notes:

Articles in this section

Comments