Follow

Export Program Reports

Jump to a report:

All time User Engagement | Last Week User EngagementUser Engagement Program Overview

Room Collaboration Report | Collaboration Overview

Micro-credential Submission Status | Micro-credentials in Program or Rooms

 

You can easily export program Engagement, Collaboration and Competency program data to csv files. Exported data contains all historical data for a program's current members. Members who have been removed from the program will not show up on the export.

Once you download the csv, you can sort and filter the data to extract the information you want to see using a spreadsheet application, such as Excel.

  1. 3-tabs-all-highlighted.pngFrom a program's Analytics tab, open the Engagement, Collaboration or Competency report.
  2. Scroll down the page to click the Download button to download a zip file of requested data.

Each downloaded file contains two or three csv files. Definitions for the fields (columns) in each csv are provided below.

 


 

All Time User Engagement

The All Time User Engagement csv shows individual users' engagement data collected across the program since the start of the program.

First Name
Last name
Email
The program member's first and last names and email are provided in three separate fields (columns).
Status
Number of rooms joined Displays total number of rooms member joined since the start of the program.
Number of posts in discussions Displays total number of posts that the member made in Discussion tabs across the program since the start of the program.
Number of comments in discussions Displays total number of comments that the member made in Discussion tabs across the program since the start of the program.
Number of files uploaded in discussions Displays total number of files that the member made in Discussion tabs across the program since the start of the program.
Number of kudos in discussions Displays total number of kudos that the member made in Discussion tabs across the program since the start of the program.
Number of unique collections viewed Provides a tally of the number of unique (distinct) collections the member viewed since the start of the program. Each viewed collection is counted just once, no matter how many times it is viewed.
Total views on all collections Provides the total number of collection views since the start of the program. Collections may be tallied multiple times.
Number of unique micro-credentials viewed Displays a tally of the number of unique (distinct) micro-credentials viewed since the start of the program. Each viewed micro-credential is counted just once, no matter how many times it is viewed.
Total views on all micro-credentials Displays the total number of micro-credential views since the start of the program. Micro-credentials may be tallied multiple times.
Number of unique resources viewed Provides a tally of the number of unique (distinct) resources the member viewed since the start of the program. Each viewed resource is counted just once, no matter how many times it is viewed.
Total views on all resources Displays the total number of resource views since the start of the program. Resources may be tallied multiple times.

 

Last Week User Engagement

 

First Name
Last name
Email
The program member's first and last names and email are provided in three separate fields (columns).
Status
Number of rooms joined Displays total number of rooms that members joined within the past 7 days.
Number of posts in discussions Displays total number of posts that the member made in Discussion tabs across the program within the past 7 days.
Number of comments in discussions Displays total number of posts that the member made in Discussion tabs across the program within the past 7 days.
Number of files uploaded in discussions Displays total number of posts that the member made in Discussion tabs across the program within the past 7 days.
Number of kudos in discussions Displays total number of posts that the member made in Discussion tabs across the program within the past 7 days.
Number of unique collections viewed Provides a tally of the number of unique (distinct) collections the member viewed within the past 7 days. Each viewed collection is counted just once, no matter how many times it is viewed.
Total views on all collections Provides the total number of collection views within the past 7 days. Collections may be tallied multiple times
Number of unique micro-credentials viewed Displays a tally of the number of unique (distinct) micro-credentials viewed within the past 7 days. Each viewed micro-credential is counted just once, no matter how many times it is viewed.
Total views on all micro-credentials Displays the total number of micro-credential views within the past 7 days. Micro-credentials may be tallied multiple times.
Number of unique resources viewed Provides a tally of the number of unique (distinct) resources the member viewed within the past 7 days. Each viewed resource is counted just once, no matter how many times it is viewed.
Total views on all resources Displays the total number of resource views within the past 7 days. Resources may be tallied multiple times.

 

User Engagement Program Overview

 

This report provides an aggregate view of current users' engagement across the program.
Total number of program members

Displays the total number of current members. 

Number of users active since start of program Displays the total number of current members who have engaged in activity Activities are posts, comments, file uploads and kudossince the start of the program.
Number of users inactive since start of program Displays the total number of current members who have not engaged in activity Activities are posts, comments, file uploads and kudos since the start of the program.
Number of users who were active this week Displays the total number of current members who have engaged in activity Activities are posts, comments, file uploads and kudos within the past 7 days.
Number of users who were inactive this week Displays the total number of current members who have not engaged in activity Activities are posts, comments, file uploads and kudos within the past 7 days.

 

Room Collaboration.csv download-collab-button.png

The Room Collaboration csv contains collaboration data collected in program rooms since the start of the program. Data on actions or activities (posts, comments, files uploaded or kudos) display after the database updates, typically 2 hours after the action is taken.

Note: The csv includes all data from the Collaboration report for current program members.

Room ID 

System-generated, alphanumeric ID for the room.

This field can be helpful when sorting and filtering identically named rooms.

Room Name Name that a member or admin gave the room.
Type

Identifies whether a room is Open or Closed.

  • Closed room is restricted to members invited by the room creator or Room Admin. An Open room is open to all program members.
  • To learn more about rooms and Room Type, see the articles in this help section.
Date Created Date the room was created.
Number of Members The current number of members in the room.
Activity Status

Provides the current activity status of individual rooms, defined by the number of comments, posts, file uploads and kudos created since the room was created

You can find this value in the Activity field of a room's record at the bottom of the Collaboration tab in Program Analytics

  • Active - At least one action (comment, post, file upload or kudo) by more than one distinct room member.
  • Less Active - Any actions are performed by a single user.
  • Inactive - No action by any users.

Number of
...Posts
...Comments
...File Uploads
...Kudos

These fields present the total number of identified activities for the room since the room was created.

You can also find these values in the Collaboration Report by hovering on the Discussion field of a room's record, as seen below.

collab-tab-hover-activity-graphbar-may2017-sm.png

   

Collaboration Overview .csv

The Collaboration Overview csv contains high level aggregate collaboration data collected across the program and across all program rooms since the start of the program.

Note: The csv includes all data from the Collaboration report for current program members.

 

Overall Program Collaboration Statistics

    

The rooms data in the csv corresponds to the data presented under Are members collaborating together? in the Collaboration tab of Analytics.

collab-platform-room-metrics-smaller.png

Total number of rooms in program since start of program - count of all rooms created in the program.

Total number of rooms created in last 30 days - count of all rooms created in the last 30 days.

Total number of less/inactive rooms in last 30 days - combined tally of all rooms where there has been no activity Activities are posts, comments, fIle uploads and kudosin the past 30 days or any activity has been performed by only one user.

Total number of active rooms in last 30 days - count of all rooms where at least one actionActions are posts, comments, file uploads and kudos has been taken by more than one distinct room member in the last 30 days.

The program-level discussion data in the csv corresponds to the graphics presented under Program Activity in the Collaboration tab of Analytics.

discussion-tab-activity-graphic.png

Total number of posts across program-level discussion - count of all posts made in the program discussion tab since the start of the program.

Total number of comments across program-level discussion - count of all comments made in the program discussion tab since the start of the program.

Total number of files uploaded across program-level discussion - count of all uploaded files in the program discussion tab since the start of the program.

Total number of kudos given across program-level discussion - count of all kudos made in the program discussion tab since the start of the program.

The rooms activity data in the csv corresponds to the graphics presented under Rooms Activity in the Collaboration tab of Analytics.

Total number of posts across all discussions in rooms aligned to program - count of all kudos made across all room discussions since the start of the program.

Total number of comments across all discussions in rooms aligned to program -  count of all comments made across all room discussions since the start of the program.

Total number of files uploaded across all discussions in rooms aligned to program -  count of all files uploaded across all room discussions since the start of the program.

Total number of kudos given across all discussions in rooms aligned to program -  count of all kudos made across all room discussions since the start of the program.

 

 

Micro-credentials Submissions Status csv  download-competency-button.png

The Micro-credentials Submissions Status csv contains individual educators' progress on program-aligned micro-credentials. Data related to newly added program-aligned micro-credentials or collections display after the database updates, typically 24 hours after the micro-credential or collection is added.

Note: The csv includes all data from the competency report for current program members. You can find much of this data in the Member Progress area.

mc-data-indiv-user-award.png

Submission ID Unique, system-generated, alphanumeric ID for the micro-credential submission.
First Name
Last name
Email
The applicant's first and last names and email are provided in three separate fields (columns).
Status

Provides the current status of all current members' micro-credential applications.  
The four statuses are:

  • In Progress - applicant has clicked apply and have uploaded 1 or more pieces of evidence.
  • Submitted - applicant has submitted the micro-credential application.
  • Granted - the micro-credential was awarded.
  • Denied - the micro-credential was not awarded.
Status Last Modified Date of the last status update.
Micro-credential Name of the micro-credential.
Micro-credential ID System-generated, alphanumeric for the micro-credential.

 

Micro-credentials in Program or Rooms.csv

The Micro-credentials in Program or Rooms csv contains a list of all program-aligned micro-credentials selected by the organization to display in their programs or rooms.

Micro-credential ID

Unique, system-generated, alphanumeric ID for the program-aligned micro-credential.

Title

Title of the program-aligned micro-credential.

Description The micro-credential's short description that appears under the micro-credential title.
Requirements Document The Requirements pdf URL.
Formal PD Credit (if applicable) Value of professional development credits, if available for the micro-credential.

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.