Creating a New Report (Owned Media)

In this article:
Introduction
Report Format
Creating a New Report

Introduction

Once your video has been published and 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.

Click Analytics in the sidebar.

Click_analytics.jpg

2.

Click the Reports tab.

 

click_the_reports_tab.png

3.

Click the plus sign on the left side of the Reports page.

Click_add_to_create_a_report.jpg

4.

Select Owned media.

 

Select_owned_media.jpg

5.

Select the video (one or more) that you want to report on and then click Continue.
▶ If All is selected, any new videos added to your account after this report is created will also be included.

 

Select_video.jpg

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
▶ If you'd like, you can edit this name.
▶ If the report includes more than one video, the default name is [Account Name] Multi-Video 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.
▶ If the report includes more than one video, the following columns are also included: video id, video name.

New_report_added_updated.jpg

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.
▶ The time zone you select determines:
     a. When a day starts and ends for reporting purposes
     b. The value transformation for date and time columns (fields).
         For example: session start time will display according to the time zone you
         selected.

Edit_time.jpg

6.b.

Click Save.

 

Changed_time_zone.jpg

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.

Add Column Remove Column
Select (by clicking) the column that you want to include in the report.
▶ Before selecting, you can hover over the column name to read a description of the data that is pulled for the report.

video_id.jpg
8.a.

(Optional) If you want to edit the name of a column, click the pencil icon by the column name.

Click_pencil_by_column_name.jpg

8.b.

Edit the Column name.

Edit_column_name.jpg

8.c.

Click Apply.

9.

(Optional) Reorder the columns by dragging and dropping the column headers.

Rearranging_columns.gif

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.

Placeholder_column.jpg

10.

Click Save to save the new report.

Click_save_new.jpg

11.

Click Close at the top right of the page.

The report is added to your account.

Saved_report_new_interface_110.jpg

 

Sample Report:

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

Comments

0 comments

Article is closed for comments.