Upload Videos Using CSV

Videos can be uploaded to the AnyClip Platform in several ways: uploading a local file directly, uploading via a video URL, and using a CSV file (Comma-Separated Values File). This section details how video upload from a CSV file should be implemented. For general instructions on how to upload videos to the Platform please check this section.

To upload videos using a CSV proceed as follows:

Create a CSV file with the following columns and data in the order shown below (from left to right):
1. guid - the internal video ID (if there is one) or any other third-party ID. This value is optional.
2. created_at - the date the video was created. If there is no creation date, the upload date and time will be used (displayed). This value is optional.
3. video_title - the title of the video. This value is mandatory.
4. thumbnail_url - a URL of a video's thumbnail. If a video has no thumbnail AnyClip will automatically create a thumbnail from one of the video's frames. This value is optional.
5. video_url - a publicly accessible video URL through which it can be downloaded. This value is mandatory.
6. video_description - the video description. This value is optional.
7. system_tags_keywords - keywords related to the video. This value is optional.
8. custom_tags - labels related to the video. A label is represented as a category and value pair (see example below). This value is optional.
9. system_tags_people - people, related to the video. This value is optional.
10. system_tags_brands - brands, related to the video. This value is optional.
11. system_tags_IAB - IAB Categories (either names or identifiers, so both options “Auto Body Styles” and "1.1.2" mean the same IAB category), related to the video. This value is optional.
12. system_tags_safety - brand safety tags, related to the video. Only values of the list ("accidents", "adult", "alcohol", "crime", "death", "disaster", "drugs", "firearms", "gambling", "mature - explicit", "mature - suggestive", "profanity and hate speech", "tobacco", "violence", "war and terror") are allowed This value is optional.
Proceed to upload the CSV file as described in the section cross-referenced in the introduction above.

An example CSV file content is shown below and by the link:

guid	created_at	video_title	thumbnail_url	video_url	video_description	system_tags_keywords	custom_tags	system_tags_safety
myid1	27/01/2021	My video #1	https://myimageserver.com/thumbnail1.jpg	https://myvideoserver.com/video1.mp4	text	keyword1, keyword2, keyword3, keyword 4	category1:value1, category2:value2	"tobacco, adult"
myid2	27/01/2021 17:21	My video #2	https://myimageserver.com/thumbnail2.jpg	https://myvideoserver.com/video2.mp4	text	keyword1, keyword2, keyword3, keyword 4	category1:value1, category2:value2	"disaster, drugs"
myid3	27/01/21 17:21Z-03	My video #3	https://myimageserver.com/thumbnail3.jpg	https://myvideoserver.com/video3.mp4	text	keyword1, keyword2, keyword3, keyword 4	category1:value1, category2:value2
myid4	DD/MM/YYYY HH:MM	My video #4	https://myimageserver.com/thumbnail4.jpg	https://myvideoserver.com/video4.mp4	text	keyword1, keyword2, keyword3, keyword 4

Caution

The CSV file for uploading videos should be encoded in Unicode (UTF-8) codepage.

Wrong codepage of the file can lead to incorrect symbols appearing in Video attributes (Title, Description, etc.).

To ensure that your CSV file is correctly encoded in UTF-8, you can open it in Notepad (Windows) and ensure that the characters there are readable.

To convert CSV file to Unicode (UTF-8) codepage, open it in Google Sheets and then download it as CSV file. The downloaded file will be automatically saved in Unicode (UTF-8) codepage.