Search

Columns and filters available on custom reports

  • Updated

Platform admins, group admins, coaches, authors, and managers can export a variety of reports from the export interface. This article describes the different custom report types as well as the available columns and filters available for each type.

General stats reports

The general stats report shows in particular the average score of the user, as well as the number of completed and assigned paths, the number of published posts, and the groups to which they belong. 

Each row of this report corresponds to one user.

Columns available on General stats reports

Column title Default Description
**Assigned programs ✅ Number of assigned program sessions (either individually, or through their group).
Avg score ✅ Average score for the user, computed as the mean average of all scores on courses and assessments.
Completed courses ✅ Number of courses in which the user has reached 100% completion rate.
Completed paths ✅ Number of paths in which the user has reached 100% completion rate.
**Completed programs ✅ Number of programs in which the user has reached 100% completion rate.
Email ✅ Email address of the user.
First name ✅ First name of the user.
Last name ✅ Last name of the user.
Messages ✅ Number of published posts.
Total time spent ✅ Total time spent by the user on all course and classroom blocks.
If the learner has made multiple attempts on a course within a path session, the platform only includes the duration of the most recent attempt.
Account creation date   Creation date of the user account, in the format YYYY/MM/DD HH:mm.
Additional information   Contents of the field Additional information in the user profile.
Automatic deletion date   If an automatic deletion date is set to the user, this columns contains the date when the user account is scheduled for deletion, in the format YYYY/MM/DD HH:mm.
External id

(External id - XXX", where XXX is the platform name)		  

Value of the External ID of the user if there is one.
The report includes one column per platform.

 

If no value is given by the Identity Provider (IdP), this cell is empty.
Groups of the user, 1 column per group

(Group name)		   Indicates with an "x" that the user belongs to the group.
The report only includes a group column for groups that the exporter has coach or admin permissions for.
Managers   Emails of the user's managers, separated by a comma.
First activity date   Date when the user first opened a course, in the format YYYY/MM/DD.
Last activity date   Date when the user last opened a course, in the format YYYY/MM/DD.
Role title   Contents of the field Role title in the user profile.
User ID   Unique identifier for the user.
User custom fields   Title of the user custom fields (one column per custom field, prefixed with "User custom field -", then ordered alphabetically). All custom fields are displayed by default, unless filtered in the report settings.
User’s groups - separated by comma   List of the name of groups to which the learner belongs, separated by a comma.

Filters available on General stats reports

Filter Type Description Additional Filters
Date filters When using a static date range, the export will only include data between the selected dates and times.
When using a dynamic date range, the export will automatically update to include data from a selected time frame relative to the current date, such as the last seven days.		 -
Groups selection Limits the exported data to only users belonging to the selected groups.
  • If no group is selected, the report will contain data for all groups that the exporter can view the data of.
  • If you select 1 to 99 groups, the export will include the main CSV plus one CSV file for each group.
  • If you select 100 or more groups, the export will include only the main CSV file.
 -
**Sessions filter
(Programs)		 The export will only include data from the selected program sessions.
  • Tags
  • Session dates
Sessions filters
(Paths)		 The export will include data only for the content played in the context of the selected path sessions.
  • Tags
  • Session dates
Users selection

Limits the exported data to include only the users you specifically select. When you filter by users, you are choosing a fixed list of users that does not change once the report is saved or automated.

If no user is selected, the report will contain data for all users that the exporter can view the data of.
This filter is cumulative with the Groups filter. For example, if you used the Groups filter to select Group A and the Users filter to select the user John Doe who does not belong to Group A, the report will show all users from Group A and John Doe.

Note: This method is appropriate for one-time reports. If you anticipate automatic updates, for example if you create an audience to enroll learners in a path session, we recommend using other filters, such as the Groups filter.
  • User status
  • User Custom Field
  • User Registration Date
  • Last activity date
  • Groups
After filtering users in the dialog box, don’t forget to click Select all to include all the users who match the filter in the report.

** Denotes a field related to the deprecated Programs feature, available for historical reporting only

OPCO logs reports

OPCO statistics track the connection duration of users on path and program sessions. The downloaded file shows one line per user per connection.

Columns available on OPCO logs reports

Column title Default Description
Classroom slot title ✅ Title of the classroom slot.
Connected ✅ Date and hour when the user connected to the course, in the format YYYY/MM/DD HH:mm.
Course ✅ Name of the course.
Disconnected ✅ Date and hour when the user left the course, or completed it, in the format YYYY/MM/DD HH:mm.
Email ✅ Email address of the user.
First name ✅ First name of the user.
Last name ✅ Last name of the user.
Path ✅ Name of the path.
Path session ✅ Name of the path session.
Time spent ✅

Difference in hours between the time the user connected to and disconnected from the course, in the format DD: HH: mm.

If available, this is calculated using the reported attendance duration from Zoom/Microsoft Teams.

If Zoom/Teams data is not available, this is a cumulative sum of time spent on all steps.
Account creation date   Creation date of the user account, in the format YYYY/MM/DD HH: mm.
Additional information   Contents of the field Additional information in the user profile.
Automatic deletion date   If an automatic deletion date is set to the user, this columns contains the date when the user account is scheduled for deletion, in the format YYYY/MM/DD HH: mm.
Classroom slot end date   Date and hour of the end of the classroom slot, in the format YYYY/MM/DD HH: mm.
Classroom slot start date   Date and hour of the start of the classroom slot, in the format YYYY/MM/DD HH: mm.
External id

(External id - XXX", where
XXX is the platform name)		  

Value of the External ID of the user if there is one.

The report includes one column per platform.
Groups of the user, 1 column
per group 

(Group name)		  

Indicates with an "x" that the user belongs to the group.

The report only includes a group column for groups that the exporter has coach or admin permissions for.

Managers		   Emails of the user's managers, separated by a comma.
Path ID   Unique identifier for the path.
Path session ID   Unique identifier for the path session.
Progression  

Percentage of course completion after the learner logs out of the path session.

Displays "-" when a learner connects to a session but doesn't complete any activity.
Role title   Contents of the field Role title in the user profile.
User custom fields   Title of the user custom fields (one column per custom field, prefixed with "User custom field -", then ordered alphabetically). All custom fields are displayed by default, unless filtered in the report settings.
User ID   Unique identifier for the user.
User's groups - separated by
comma		   List of the name of groups to which the learner belongs, separated by a comma.
Estimated training duration   Estimated time for the course (in HH:MM:ss format).
Time progression   Cumulated time spent on the course, up to the attempt described in the row (in other words: the sum of the time spent for all past attempts).

Filters available on OPCO logs reports

Filter Type Description Additional Filters
Date filters When using a static date range, the export will only include data between the selected dates and times.
When using a dynamic date range, the export will automatically update to include data from the selected time frame relative to the current date, such as the last seven days.		 -
Enrollment type Limits the exported data by Self enrollment or Assigned trainings.
By default, the report selects All enrollment types.		  
Groups selection Limits the exported data to only users belonging to the selected groups.
  • If no group is selected, the report will contain data for all groups that the exporter can view the data of.
  • If you select 1 to 99 groups, the export will include the main CSV plus one CSV file for each group.
  • If you select 100 or more groups, the export will include only the main CSV file.
 -
**Sessions filter
(Programs)		 The export will only include data from the selected program sessions.
  • Tags
  • Session dates
Sessions filters
(Paths)		 The export will include data only for the content played in the context of the selected path sessions.
  • Tags
  • Session dates
Users selection

Limits the exported data to include only the users you specifically select. When you filter by users, you are choosing a fixed list of users that does not change once the report is saved or automated.

If no user is selected, the report will contain data for all users that the exporter can view the data of.
This filter is cumulative with the Groups filter. For example, if you used the Groups filter to select Group A and the Users filter to select the user John Doe who does not belong to Group A, the report will show all users from Group A and John Doe.

Note: This method is appropriate for one-time reports. If you anticipate automatic updates, for example if you create an audience to enroll learners in a path session, we recommend using other filters, such as the Groups filter.
  • User status
  • User Custom Field
  • User Registration Date
  • Last activity date
  • Groups
After filtering users in the dialog box, don’t forget to click Select all to include all the users who match the filter in the report.

** Denotes a field related to the deprecated Programs feature, available for historical reporting only

Paths reports

Platform admins, group admins, coaches and authors of the path’s owner group, the main author and co-authors of the path, and the instructors of a path session can view and download the statistics of all sessions of a path (within bounds of group visibility rules).

Columns available on Paths reports

Column title Default Description
Due date ✅ Due date of the step with the latest date, in the format YYYY/MM/DD HH:mm.
Email ✅ Email address of the user.
First name ✅ First name of the user.
Last name ✅ Last name of the user.
Learner completion date ✅ Date and time when the learner completed the path (if applicable) in the format YYYY/MM/DD HH:mm. If the learner completed the path several times, only the first completion date is kept.
Learner enrollment date ✅ Date and time when the user was enrolled in the path session, in the format YYYY/MM/DD HH:mm.
Learner status ✅
  • Pending session opening: The learner is enrolled in a path session which hasn't started yet.
  • Not yet started: The learner is enrolled in an ongoing path session but they haven't started the path yet.
  • On time: The path session is ongoing, and the learner fulfills all the following conditions:
    • They started the path.
    • They completed all the mandatory steps with a past due date.
    • They haven't completed all the mandatory steps either without a due date, or with a due date that has not passed yet.
  • Awaiting correction: The learner has started the path and is waiting for the validation of an assessment before continuing the path.
  • Late: The path session is ongoing, and the learner fulfills all the following conditions:
    • They started the path.
    • They haven't completed at least one mandatory step with a past due date.
  • To retake: The path session is ongoing, and the learner fulfills at least one of the following conditions:
    • They haven't reached the minimum score for at least one mandatory course, and they haven't reached the maximum number of authorized attempts for mandatory courses.
    • They haven't completed the path within the time limits, and they haven't reached the maximum number of attempts for mandatory courses.
    • They completed at least one step outside of the path context with mandatory replay.
  • Unsuccessful: Either the path session ended when the status was Not yet started, Late, On time, To retake, or the learner fulfills at least one of the following conditions:
    • They haven't reached the minimum score for at least one mandatory step, and they reached the maximum number of attempts for the mandatory steps.
    • They haven't completed the path within the time limits, and they reached the maximum number of attempts for the mandatory steps.
  • Successful: The learner fulfills all the following conditions:
    • They completed all the mandatory steps in the path.
      • If the path has the mandatory replay option activated, the learner must have completed all the mandatory steps within the path session, even if they already completed the courses elsewhere.
    • They reached the minimum score in all the mandatory courses that have one.
    • They completed the path within the time limits.
Path title ✅ Name of the path.
Progress ✅ Percentage (in integer number) of the completion rate of the learner in the path.
Score ✅ Average of the score of all steps in the path, including classrooms (a step has a score if it is a course with at least one question).
Self enrollment ✅ Indicates with an "x" if the learner was self-enrolled in the path session.
Session name ✅ Title of the path session.
Time spent ✅

Time spent by the learner on steps within the path, in the format DD:HH:mm.

If available, this is calculated using the reported attendance duration from Zoom/Microsoft Teams.

If Zoom/Teams data is not available, this is a cumulative sum of time spent on all steps within the path.
Account creation date   Creation date of the user account, in the format YYYY/MM/DD HH:mm.
Additional information   Contents of the field Additional information in the user profile.
Additional path information   Contents of the field Additional path information in the advanced settings of the path.
Additional path session information   Contents of the field Additional session information in the advanced settings of the path.
Author   Email of the path author.
Automatic deletion date   If an automatic deletion date is set to the user, this columns contains the date when the user account is scheduled for deletion, in the format YYYY/MM/DD HH:mm.
Certificate delivered  
  • yes: the learner earned the certificate.
  • no: the learner didn’t earn the certificate.
  • -: the path doesn’t contain a certificate.
Certificate expiry date   Expiry date of the certificate.
Co-authors   List of path co-authors.
Detail per classroom slot   Various columns for each classroom slot
Details per step   Columns for each step included in the path:
  • Step # type
  • Step # title
  • Step # status
  • Step # progress
  • Step # score
  • Step # time spent
Enrollment status  

Indicates if a user is actively enrolled in a path session or not.

If a user was enrolled in a path session in the past, but they were unenrolled from the path session, that user will display in the path sessions report. In this example, the user is not actively enrolled in the path session, so this column would show as Unenrolled.
Estimated duration   Value of the field Estimated duration in the path settings (under the Build your training section) converted to absolute time, in the format HH:MM:SS. For example:
  • 1 day in the path settings is converted to 24:00:00 on the path report. To convert the estimated duration in the report to days, divide it by 24.
  • 1 week in the path settings is converted to 168:00:00 on the path report. To convert the estimated duration in the path report to weeks, divide by 168.
  • 1 month in the path settings is converted to 720:00:00 on the path report. To convert it to months, divide by 720.
External id

(External id - XXX", where XXX is the platform name)		   Value of the External ID of the user if there is one.
The report includes one column per platform.
Groups of the user, 1 column per group

(Group name)		   Indicates with an "x" that the user belongs to the group.
The report only includes a group column for groups that the exporter has coach or admin permissions for.
Learner deletion date   Date when the user was deleted (the cell is empty if the user is active).
Learner start date  

Date and time when the learner clicked START in the path page, in the format YYYY/MM/DD HH:mm. If the learner played the path several times, only the last attempt is kept.

This column remains empty:

  • If the learner hasn't clicked on at least one path step on the platform.
  • If the learner has started a path step before the path session start date for a path where mandatory replay is not activated. For example, for a path without mandatory replay:
    • When a learner starts a course step before the path session started, the time spent is specified, but the learner has no start date in the report.
    • When a learner completes all the steps before the path session started, the path is marked as successful, the time spent and completion date are specified in the report, but the learner's start date remains empty.
Linear  
  • true: the path is linear.
  • false: the path is non-linear.
Managers   Emails of the user's managers, separated by a comma.
Managers   Emails of the user's managers, separated by a comma.
Path ID   Unique identifier for the path.
Session end date   Date and time when the path session ends, if there is one, in the format YYYY/MM/DD HH:mm.
Session ID   Unique identifier for the path session.
Session instructors   List of emails of instructors for the path session, separated by a comma.
Session start date   Date and time when the path session starts, in the format YYYY/MM/DD HH:mm.
Tags   List of tags added to the path session.
Step # progress   Completion rate of the learner in the step. Classrooms and assessments will have only 0 or 100%
This column is added to the report when Details per step is selected.
Step # score   Score for the step. Empty for classrooms and assessments.
This column is added to the report when Details per step is selected.
Step # status  
  • On time: the step has not been completed, and is either optional, has no due date, or has a due date that isn’t passed yet.
  • Late: the step has a due date that is passed, and has not been completed.
  • Completed: the step has been completed.
This column is added to the report when Details per step is selected.
Step # time spent  

Time spent by the learner on the step, in the HH:mm format.

This is calculated using the reported attendance duration from Zoom/Microsoft Teams.


If the Zoom/Teams attendance is unavailable, the calculation will be as follows:

  • Course: Actual duration.
  • Classroom: Difference between the end date and start date for the classroom slot (for virtual classrooms it will be the time the learner spent in the call).
  • Path: Sum of all steps duration
  • Assessment: 0 by default (no time is computed for assessments).

This column is added to the report when Details per step is selected.
Step # title   Title of the step.
This column is added to the report when Details per step is selected.
Step # type  

Type of the step:

  • Course
  • Classroom
  • Path
  • Assessment

This column is added to the report when Details per step is selected.
Role title   Contents of the field Role title in the user profile.
User Custom Field   Title of the user custom fields (one column per custom field, prefixed with "User custom field -", then ordered alphabetically). All custom fields are displayed by default, unless filtered in the report settings.
User ID   Unique identifier for the user.
User’s groups - separated by comma   List of the name of groups to which the learner belongs, separated by a comma.

Filters available on Paths reports

Filter Type Description Additional Filters
Date filters

You can filter by:

  • Enrollment date: Limits the exported data to learners who were enrolled during the selected time frame.
  • Completion date: Limits the exported data to learners who completed paths during the selected time frame.
  • Learner start date: Limits the exported data to learners who took their first action on the platform in the context of a given path during the selected time frame.

When using a static date range, the export will only include data between the selected dates and times.
When using a dynamic date range, the export will automatically update to include data from a selected time frame relative to the current date, such as the last seven days.

 -
Enrollment type Limits the exported data by Self enrollment or Assigned trainings.
By default, the report selects All enrollment types.		  
Groups selection Limits the exported data to only users belonging to the selected groups.
  • If no group is selected, the report will contain data for all groups that the exporter can view the data of.
  • If you select 1 to 99 groups, the export will include the main CSV plus one CSV file for each group.
  • If you select 100 or more groups, the export will include only the main CSV file.
 -
Sessions filters
(Paths)

The export will include data only for the content that is part of the selected path sessions.

If a session does not require mandatory replay, it will also include statistics for content played outside of the selected path sessions. This could involve courses accessed directly from the catalog or those completed within the context of other path sessions with the same courses as the selected ones.
  • Tags
  • Session dates
Users selection

Limits the exported data to include only the users you specifically select. When you filter by users, you are choosing a fixed list of users that does not change once the report is saved or automated.

If no user is selected, the report will contain data for all users that the exporter can view the data of.
This filter is cumulative with the Groups filter. For example, if you used the Groups filter to select Group A and the Users filter to select the user John Doe who does not belong to Group A, the report will show all users from Group A and John Doe.

Note: This method is appropriate for one-time reports. If you anticipate automatic updates, for example if you create an audience to enroll learners in a path session, we recommend using other filters, such as the Groups filter.
  • User status
  • User Custom Fields
  • User Registration Date
  • Last activity date
  • Groups
After filtering users in the dialog box, don’t forget to click Select all to include all the users who match the filter in the report.

Program session reports

Click here to learn more about program session reports →

Courses reports

You can download the statistics of several courses. The downloaded file will display one line per learner per course attempt (if a learner attempted a course twice, there will be two lines in the file).

Columns available on Courses reports

Column title Default Description
**Assigned programs ✅ Number of assigned program sessions (either individually, or through their group).
Course ✅ Name of the course.
Email ✅ Email address of the user.
End ✅ Date and hour of the end of the attempt by the learner, in the format YYYY/MM/DD HH:mm.
First name ✅ First name of the user.
Last name ✅ Last name of the user.
Messages ✅ Number of published posts.
Path Session ✅ Title of the path session, if the course was played as part of a path session (otherwise -).
**Program Session ✅ Title of the program session, if the course was played as part of a program session (otherwise -).
Progress ✅ Completion rate of the learner on the attempt.
Score ✅ Score of the learner on the attempt.
Start ✅ Date and hour of the start of the attempt by the learner, in the format YYYY/MM/DD HH:mm.
Total time spent ✅ time spent by the learner on the attempt.
Account creation date   Creation date of the user account, in the format YYYY/MM/DD HH:mm.
Additional information   Contents of the field Additional information in the user profile.
Automatic deletion date   If an automatic deletion date is set to the user, this columns contains the date when the user account is scheduled for deletion, in the format YYYY/MM/DD HH:mm.
Course ID   Unique identifier for the course.
Expected duration   Value of the field Estimated duration, defined in the course settings.
External id

(External id - XXX", where XXX is the platform name)		   Value of the External ID of the user if there is one.
The report includes one column per platform.
Groups of the user, 1 column per group

(Group name)		   Indicates with an "x" that the user belongs to the group.
The report only includes a group column for groups that the exporter has coach or admin permissions for.
Language   Language in which the user played the course.
Managers   Emails of the user's managers, separated by a comma.
Path   Name of the path, if the course was played as part of a path (otherwise -).
Path ID   Unique identifier for the path, if the course was played as part of a path (otherwise -).
Path session ID   Unique identifier for the path session, if the course was played as part of a path (otherwise -).
**Program session custom fields   Contents of the field Additional session information in the advanced options of the session, if the course was played as part of a program (otherwise -).
**Program session ID   Unique identifier for the Program session, if the course was played as part of a program (otherwise -).
**Program template   Name of the program template, if the course was played as part of a program (otherwise -).
**Program template ID   Unique identifier for the program template, if the course was played as part of a program (otherwise -).
Result  

Result of the course, with the following possible values:

  • Success when the learner has completed the course and they have reached the minimum score in courses that have one.
  • To retry when the learner has completed a course with a minimum score but has not reached the minimum score.
  • Failed when the learner has completed a course, has not reached the minimum score and either the session is closed or the learner has reached the maximum number of attempts.
  • Awaiting correction when the learner has completed a course with a minimum score and with questions that require a correction.

The column remains empty when the result is undefined due to:

  • The learner not completing the course.
  • The course being migrated.
Tags   List of tags added to the course.
Text description   Summary of presentation in plain text format. If the summary is longer than the maximum number of characters allowed by Excel, the text is truncated at the character limit of 32 767 characters.
Role title   Contents of the field Role title in the user profile.
User Custom Field   Title of the user custom fields (one column per custom field, prefixed with "User custom field -", then ordered alphabetically). All custom fields are displayed by default, unless filtered in the report settings.
User ID   Unique identifier for the user.
User’s groups - separated by comma   List of the name of groups to which the learner belongs, separated by a comma.

Filters available on Courses reports

Filter Type Description Additional Filters
Courses filter The export will only include user activities that happened in the selected courses.
  • Tags
Date filters When using a static date range, the export will only include data between the selected dates and times.
When using a dynamic date range, the export will automatically update to include data from a selected time frame relative to the current date, such as the last seven days.		 -
Enrollment type Limits the exported data by Self enrollment or Assigned trainings.
By default, the report selects All enrollment types.		  
Groups selection Limits the exported data to only users belonging to the selected groups.
  • If no group is selected, the report will contain data for all groups that the exporter can view the data of.
  • If you select 1 to 99 groups, the export will include the main CSV plus one CSV file for each group.
  • If you select 100 or more groups, the export will include only the main CSV file.
 -
**Sessions filter
(Programs)		 The export will only include data from the selected program sessions.
  • Tags
  • Session dates
Sessions filters
(Paths)		 The export will include data only for the content played in the context of the selected path sessions.
  • Tags
  • Session dates
Users selection

Limits the exported data to include only the users you specifically select. When you filter by users, you are choosing a fixed list of users that does not change once the report is saved or automated.

If no user is selected, the report will contain data for all users that the exporter can view the data of.
This filter is cumulative with the Groups filter. For example, if you used the Groups filter to select Group A and the Users filter to select the user John Doe who does not belong to Group A, the report will show all users from Group A and John Doe.

Note: This method is appropriate for one-time reports. If you anticipate automatic updates, for example if you create an audience to enroll learners in a path session, we recommend using other filters, such as the Groups filter.
  • User status
  • User Custom Field
  • User Registration Date
  • Last activity date
  • Groups
After filtering users in the dialog box, don’t forget to click Select all to include all the users who match the filter in the report.

** Denotes a field related to the deprecated Programs feature, available for historical reporting only

Classrooms reports

Columns available on Classroom reports

Column title Default Description
Block title ✅ Title of the classroom block.
Email ✅ Email address of the user.
End ✅ Date and hour of the end of the classroom slot, in the format YYYY/MM/DD HH:mm.
First name ✅ First name of the user.
Last name ✅ Last name of the user.
Reported duration ✅ Number of hours (as integer) for the reported duration of the classroom slot.
Slot title ✅ Title of the classroom slot.
Start ✅ Date and hour of the start of the classroom slot, in the format YYYY/MM/DD HH:mm.
Status ✅
  • registered: the learner is registered to a classroom slot for which attendance was not filled.
  • attended: the learner was added to the attendance list.
  • missed: the learner was not added to the attendance list (and at least one other learner was added to the list).
Type ✅
  • on-site: the classroom slot is on-site.
  • virtual: the classroom slot is virtual.
Account creation date   Creation date of the user account, in the format YYYY/MM/DD HH:mm.
Automatic deletion date   If an automatic deletion date is set to the user, this columns contains the date when the user account is scheduled for deletion, in the format YYYY/MM/DD HH:mm.
External id

(External id - XXX", where XXX is the platform name)		   Value of the External ID of the user if there is one.
The report includes one column per platform.
Groups of the user, 1 column per group

(Group name)		   Indicates with an "x" that the user belongs to the group.
The report only includes a group column for groups that the exporter has coach or admin permissions for.
Session ID   Unique identifier for the path session to which the classroom slot belongs.
Slot ID   Unique identifier for the classroom slot.
Role title   Contents of the field Role title in the user profile.
Trainers   Email addresses of the classroom trainers at the time of the report generation, separated by a comma.
The report includes the email addresses of the trainers deleted from the platform if they have not been previously deleted from the classroom.
User Custom Field   Title of the user custom fields (one column per custom field, prefixed with "User custom field -", then ordered alphabetically). All custom fields are displayed by default, unless filtered in the report settings.
User ID   Unique identifier for the user.
User’s groups - separated by comma   List of the name of groups to which the learner belongs, separated by a comma.

Filters available on Classrooms reports

Filter Type Description Additional Filters
Classrooms filter The export will only include user activities that happened in the selected classrooms.
  • Classroom type
  • Path sessions
Date filters When using a static date range, the export will only include data between the selected dates and times.
When using a dynamic date range, the export will automatically update to include data from a selected time frame relative to the current date, such as the last seven days.		 -
Groups selection Limits the exported data to only users belonging to the selected groups.
  • If no group is selected, the report will contain data for all groups that the exporter can view the data of.
  • If you select 1 to 99 groups, the export will include the main CSV plus one CSV file for each group.
  • If you select 100 or more groups, the export will include only the main CSV file.
 -
Users selection

Limits the exported data to include only the users you specifically select. When you filter by users, you are choosing a fixed list of users that does not change once the report is saved or automated.

If no user is selected, the report will contain data for all users that the exporter can view the data of.
This filter is cumulative with the Groups filter. For example, if you used the Groups filter to select Group A and the Users filter to select the user John Doe who does not belong to Group A, the report will show all users from Group A and John Doe.

Note: This method is appropriate for one-time reports. If you anticipate automatic updates, for example if you create an audience to enroll learners in a path session, we recommend using other filters, such as the Groups filter.
  • User status
  • User Custom Fields
  • User Registration Date
  • Last activity date
  • Groups
After filtering users in the dialog box, don’t forget to click Select all to include all the users who match the filter in the report.

Questions reports

Questions reports will only include questions that are part of at least one course at the moment of the report. If you need to see statistics for a question that was part of a course but not anymore, you can create a new course and reuse the question in that course (it does not need to be added to any path, nor shared in any catalog).

Columns available on Questions reports

Column title Default Description
Answer ✅ Details of the answer of the Learner (except for question types: Open-ended with Document, Video pitch, Screencast demo and Pick-a-point).
Answered at ✅ Date and time when the question was answered, in the format YYYY/MM/DD HH:mm.
Course ✅ Name of the course containing the question.
Email ✅ Email address of the user.
First name ✅ First name of the user.
Last name ✅ Last name of the user.
Path session ✅ Name of the path session (- if the question wasn't answered in the context of a path session).
**Program session ✅ Name of the program session (- if the question wasn’t answered in the context of a program session, or if the answer was made in a course attempt that did not reach the minimum score in a program session).
Question ✅ Title of the question.
Score ✅
  • 0 if the Learner answered incorrectly.
  • 1 if the Learner answered correctly
  • Blank if the question is an Opinion question, or an Open-ended question that has not been corrected yet.
Account creation date   Creation date of the user account, in the format YYYY/MM/DD HH:mm.
Additional information   Contents of the field Additional information in the user profile.
Automatic deletion date   If an automatic deletion date is set to the user, this columns contains the date when the user account is scheduled for deletion, in the format YYYY/MM/DD HH:mm.
Criterion   If the question is open-ended and has assessment criteria, title of the criterion, one column per criterion: rating from 0 to 5 on the criterion.
Didn’t get it   Number of users who clicked I HAVE A QUESTION in the question.
External id

(External id - XXX", where XXX is the platform name)		   Value of the External ID of the user if there is one.
The report includes one column per platform.
Groups of the user, 1 column per group

(Group name)		   Indicates with an "x" that the user belongs to the group.
The report only includes a group column for groups that the exporter has coach or admin permissions for.
Learned something   Number of users who clicked I LEARNED SOMETHING in the question.
Likes   Number of users who clicked I LIKED IT in the question.
Managers   Emails of the user's managers, separated by a comma.
Outdated   Number of users who clicked THIS IS OUTDATED in the question.
Path   Name of the path. (- if the question wasn’t answered in the context of a path).
Path ID   Unique identifier for the path. (- if the question wasn’t answered in the context of a path).
Path session ID   Unique identifier for the path session. (- if the question wasn’t answered in the context of a path session).
**Program session custom fields   Contents of the field Additional session information in the advanced options of the program session (- if the question wasn’t answered in the context of a program session, or if the answer was made in a course attempt that did not reach the minimum score in a program session).
**Program session ID   Unique identifier for the program session. (- if the question wasn’t answered in the context of a program session, or if the answer was made in a course attempt that did not reach the minimum score in a program session).
**Program template   Name of the program template (- if the question wasn’t answered in the context of a program session, or if the answer was made in a course attempt that did not reach the minimum score in a program session).
**Program template ID   Unique identifier of the program template corresponding to the session, as a string of characters (- if the question wasn’t answered in the context of a program session, or if the answer was made in a course attempt that did not reach the minimum score in a program session).
Tags   List of the tags linked to the question.
Role title   Contents of the field Role title in the user profile.
User Custom Field   Title of the user custom fields (one column per custom field, prefixed with "User custom field -", then ordered alphabetically). All custom fields are displayed by default, unless filtered in the report settings.
User ID   Unique identifier for the user.

Filters available on Questions reports

Filter Type Description Additional Filters
Date filters When using a static date range, the export will only include data between the selected dates and times.
When using a dynamic date range, the export will automatically update to include data from a selected time frame relative to the current date, such as the last seven days.		 -
Groups selection Limits the exported data to only users belonging to the selected groups.
  • If no group is selected, the report will contain data for all groups that the exporter can view the data of.
  • If you select 1 to 99 groups, the export will include the main CSV plus one CSV file for each group.
  • If you select 100 or more groups, the export will include only the main CSV file.
 -
Questions filter The export will only include data from the selected questions.
  • Tags
  • Question type
  • Courses
Sessions filter
(Paths)		 The export will include data only for the content played in the context of the selected path sessions.
  • Tags
  • Session dates
**Sessions filter
(Programs)		 The export will only include data from the selected program sessions.
  • Tags
  • Session dates
Users selection

Limits the exported data to include only the users you specifically select. When you filter by users, you are choosing a fixed list of users that does not change once the report is saved or automated.

If no user is selected, the report will contain data for all users that the exporter can view the data of.
This filter is cumulative with the Groups filter. For example, if you used the Groups filter to select Group A and the Users filter to select the user John Doe who does not belong to Group A, the report will show all users from Group A and John Doe.

Note: This method is appropriate for one-time reports. If you anticipate automatic updates, for example if you create an audience to enroll learners in a path session, we recommend using other filters, such as the Groups filter.
  • User status
  • User Custom Field
  • User Registration Date
  • Last activity date
  • Groups
After filtering users in the dialog box, don’t forget to click Select all to include all the users who match the filter in the report.

** Denotes a field related to the deprecated Programs feature, available for historical reporting only

Check out our blog for more L&D resources.

Was this article helpful?

1 out of 2 found this helpful

Have more questions? Submit a request