After you’ve created your personalized videos or interactive videos in Pirsonal, you may want to export the video data into a CSV file. You can export all the data associated with a template. Downloads can include video IDs, analytics, metadata, contact information, and more.
In this article, you’ll learn how to view and export your personalized and interactive video data and access, including intelligence information for individual templates.
Before you start
Here are some things to know before you begin this process.
- The General Data Protection Regulation (GDPR) is a European Union (EU) privacy law that gives EU citizens the right to ask about how their personal data is stored and used. Make sure you are GDPR compliant.
- Template exports include the following information:
- Video status
- Pirsonal Analytics
- Pirsonal Player configuration
- Pirsonal Pages configuration
- Smart Forms configuration and Responses
- Custom metadata
- CRM data: Email, Last Name, First Name
- Video metadata: Video ID, output profile, processing time, credits, duration, creation date
- Regarding Pirsonal Player’s password protection option, the secure code or password is not included in the CSV.
- All this information is also available to API users. For this, please refer to the Template_Video_List method to access the complete data from a template, or Video_Get to access the complete data from an individual video.
Steps to download a CSV with video data
To download video data from a template, follow these steps:
- Log in to your Pirsonal account
- Go to the My Templates section.
- Find the template you want information about.
- Under the Download column, click on “New CSV” to request a new file with video data.
- Wait a few seconds, refresh the page and click “Download” to download the CSV file.
If you want to generate a new CSV with new data, click “New CSV” again.
Troubleshoot a contact export
My export includes strange or unexpected characters.
If your data contains special characters, your export may not display correctly in Excel or similar applications. To see special characters in Excel, use one of the following workarounds:
- Change the file extension from .csv to .txt. Then, open the file in Excel. When Excel prompts for the file type and character encoding, set encoding to UTF-8.
- Open your CSV file in a text editor. Then, make sure the text editor’s settings are set to UTF-8 encoding. Now, copy all the content from the text editor and paste it into a blank Excel sheet. Once you’ve done this, use the Text-To-Columns function in Excel to split everything into columns.
- Use Google Sheets to open the CSV with the option to automatically detect the separators.
The file shows “queue” and the status doesn’t change after a few minutes.
In some cases, when you request a new CSV, the “queue” status doesn’t change after a few minutes. This couldn’t happen in the following situations:
- The template has a large number of videos. In this case, the file can take many minutes to be ready. Come back after 30-60 minutes while the file is created.
- The template has no videos. In this case, the system will not generate a CSV and the “queue” status will not change.
- There is an issue with the data. If the previous scenarios don’t fit, please contact support (firstname.lastname@example.org).