Who can do this?
Administrators and Instructors
Note that the viewing data included in the download is updated approximately once an hour.
The Media Details page for video, audio, and interactive media contains an Analytics tab. This tab provides viewing data for that particular media. The tab also includes a Download Data button, that allows you to download a CSV file containing the same data as seen in the bottom part of the tab.
Specifically, the download includes all of the user view data, by view location. The data in the download, like the data shown on the page, is subject to the Time Range and Media Location drop-down list filters. The data in the downloaded file will MATCH what is shown on the page.
Filtering and Targeting the Data
The Users table lists each user one time, counting all of their views (that conform to the media location and time range selections). The download identifies and separates views from each different location, to provide more granular viewing information.
Typically each user will have viewed the item from ONE location, either an EchoVideo section, or the LMS, or through a public link, or possibly from a Collection (Collection views are classified as Not Course Related). However, it is certainly possible for users to have views from multiple locations.
For example:
- You are using an LMS such as Canvas. And you have your Canvas course linked to your EchoVideo section.
- There is a video that is published to a class in your section.
- Because that video has some important aspects to it, you have also embedded it into a Discussion in the Canvas course, to provide a point of discussion among the class or ask for feedback.
- Your student Thomas viewed the video both in the class and in the Canvas Discussion page. And has done so within the last month.
If you are viewing data for All Locations for the past 30 days (the default view), Tom will appear in the All Users table in the analytics tab, one row with 2 views, with view time durations that reflect his viewing.
In the DOWNLOAD, Tom will have TWO rows, one for the view in the EchoVideo section class, and one for the video embedded in the Canvas course discussion. This is shown in the figure below.
If the video is also in a Group where Tom is a member, he may have THREE entries in the download, to include a Not Course Related view, depending, again, on what is selected in the Media Locations drop-down list.
This might be an unlikely scenario, but it outlines the differences between what may be shown in the analytics data on the screen, and what will appear in the Download of the same targeted/filtered data.
Suggestion for media published to multiple locations: Select a particular course from the Media Location drop-down list. Then select the time range that makes sense. Download the file. If the media has another location, select that location and download the file again. Then rename each file to reflect which Location each refers to. This will show you easily which students have viewed the media, for how long, and from where.
NOTE: If the media location or time range you select results in no viewing data (there are no views for that media/location/time range), the Download Data button is grayed out, as any file generated with no view data would be empty.
Data Download Filename
The filename for the download will look similar to this:
-
media_course-views_<media name - truncated>_<startDate>_<endDate>_<endTime>.csv
The first part of the filename will always be "media_course-views" because the download is of the user views of the media by course.
The first set of numbers is the first applicable date for the data in the download.
The second set of numbers is the date and time you generated the download (in UTC). Both dates are in yyyy-mm-dd format; the time is UTC or "universal time code" in 24-hour format. This is important to keep in mind because it is possible that your download may "cross midnight" to UTC and show a different date than today's date in local time
So in the example filename given, you know that the download was generated on Sept 11, 2020, at 1:30 pm UTC (2020-09-11_13-31). This would translate to 9:30 am ET on the same date. The Time Range selection was set to 30 days (the default), because the first date in the file name is 30 days prior to the generate date, 2020-08-11.
This naming convention is designed to help you know WHEN the data is accurate TO and what date range the data covers. UTC is used to ensure consistency across all the time/date data being shown, and accommodating things like time zones or Daylight vs. Standard time in the US.
You MAY want to change the first part of the downloaded file name to match the media name and/or the Course name, simply for ease of reference later. However, the media name and other details are located IN the download, as described below.
Data in the Download
Each row in the download includes both media information and user view information. The media information includes the media name, creation date, and duration. The user view information includes user name, user email, view counts, view durations, download count, and last viewed date.
The download is a CSV-formatted file for maximum portability. You can open a CSV (comma-separated values) file in a wide range of programs, including any spreadsheet and word processing programs, or as a flat file in a notepad-type viewer. The limitation of this portability, however, is that each bit of information needs to have its own area in the file.
That's a nice way of explaining why the basic media information in the file is repeated on every row.
If this is a problem, you can either delete the duplicated information OR hide those columns for easier viewing.
Each row in the file corresponds to that user's view(s) of the media from a location. Typically this will mean that each user occupies a single row, with their viewing data of this media from wherever they viewed it from. See the above example, however, for how/why a user may occupy multiple rows in the download.
The columns (fields) in the download are as follows:
- Media ID: the system ID for this piece of media
- Media Name: the name or title of this media
- Create Date: the date the media was created or uploaded
- Duration: how long the media is, in hh:mm:ss format
- Owner name: the owner of the media. This might be the instructor of the course where the capture came from, the person who generated the recording, or the person who uploaded the media.
- Course: the location where this student viewed the media from. Not Course Related views can include views in a Group where the media resides, views from the media details page, and views through a posted public link of the media.
- User Name: Name of the user, last name first. The file is sorted by user name, in ascending order by last name.
- User Email: Email address of the user. Where users' names are the same, this field is used as the secondary sort, in ascending order.
- Total Views: the total number of times this media was viewed by this user in this course/location
- Total View Time: the total amount of time this user viewed this media from this course/location
- Average View Time: the average amount of time per view of this media from this course/location
- On Demand Views: how many of the user's total views were "on demand" of a recording (as opposed to views of the live stream if the original media was generated as a live stream)
- Live Views: how many of the user's views were of the Live stream of the media (if applicable)
-
Downloads: how many times this user downloaded this media from this course/location (see note below)
EchoVideo accurately tracks what user downloaded what media, but we cannot always determine if it was downloaded from the EchoVideo course page (class list) or from the Media Details page (which would appear under Not Course Related). The download counts for each user, however, will always be correct.
-
Last Viewed: the date of the last view (or download) of this media, by this user, from this course/location
All viewing dates/times in this download, including the date/time in the file name, are presented in UTC or "universal time code" and not "local time" for either the user's location or the location of the institution.