Introduction
Once your video has been shared with viewers*, you can generate reports to provide you with data relating to video engagement. This data includes information about the viewers, their device type, scenes viewed, time spent viewing, and much more.
The data collected in the reports can provide you with important insights regarding both the performance of your video and the attributes of the viewers watching. You can also merge the SundaySky report data with your business data to analyze the impact of the video on your business KPIs.
Reports can be generated ad hoc on an as-needed basis or be scheduled to run automatically at regular intervals.
* Reports can also be generated during the testing phase to verify that the report is structured correctly and that the relevant data is being pulled.
Report Format
All reports are generated in CSV format. The CSV file that is created is sent to email recipients (zipped) or to a server address. Depending on your needs, the CSV file can be analyzed manually by an individual or be automatically ingested into a database.
The column headers and values in the CSV file are all enclosed by quotes, in order to avoid any potential issues relating to commas.
At the end of this article, you will find a link to download a sample report. After downloading the file, note the following:
- The sample report is a CSV file. As automatic formatting is applied in Excel, the data in this file is easy to read but does not reflect how the data actually looks in the report file that is sent. For this reason, we recommend that you also open the file with a basic text editor (such as Notepad) to see the actual CSV file format (with column headers and values enclosed by quotes).
- The sample report is solely for demonstration purposes and the values in the columns are examples only.
Creating a New Report
| 1. |
On the Home Page, click Analytics in the sidebar. |
| 2. |
At the top left of the page, click the Reports tab. |
|
|
|
| 3. |
Click the plus sign on the left side of the Reports page. |
| 4. |
Select Owned media. |
|
|
| 5. |
Select the video (one or more) that you want to report on and then click Continue. |
|
|
|
The new report is created with a default name and columns as described below. In addition, you'll see a sample of how the data will appear for each column. Note that the data displayed is not yours; it is data displayed for demonstration purposes only. |
|
| a. |
This is the default name for the report. The syntax is [Account Name] [Video Name] Detailed Report |
| b. |
These are the default columns (fields) in the report: user id, device type, page url, video duration, video start time, video completion, unique scenes viewed, is button displayed, is button clicked. |
| 6.a. |
(Optional) If you want to change the default time zone, click the pencil icon and then select the time zone that you want to use for this report. |
| 6.b. |
Click Save. |
|
|
| 7. |
(Optional) If you'd like, you can now add or remove report columns following the steps below. See Descriptions of Report Columns (Owned Media) for detailed information regarding all the columns that can be included in your report. |
▶ Before selecting, you can hover over the column name to read a description of the data that is pulled for the report.
| 1. |
Click the X by the column name. |
|
|
|
| 2. |
If you are sure that you want to remove the column, click Remove. |
| 8.a. |
(Optional) If you want to edit the name of a column, click the pencil icon by the column name. |
| 8.b. |
Edit the Column name. |
| 8.c. |
Click Apply. |
| 9. |
(Optional) Reorder the columns by dragging and dropping the column headers. |
Note:
If you need to include a blank column in the report to accommodate future data while retaining the current report structure, you can use a placeholder column for this purpose.
| 10. |
Click Save to save the new report. |
| 11. |
Click Close at the top right of the page. |
The report is added to your account.
| 12. |