Available columns and filters for 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 programs, the number of published posts, and the groups to which they belong. 

Each row of this report corresponds to one user.

Available columns for 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 program 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.
Title / Employment   Contents of the field Title / Employment in the user profile.
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.

Available filters for 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 group.
If no group is selected, the report will contain data for all groups that the exporter can view the data of.
-
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
  • Custom Fields
  • Registration date
  • Last activity date
  • Group
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.

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.

Available columns for 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. Displays - if the session is a program session.
Path session Name of the path session. Displays - if the session is a program session.
Program session Name of the program session. Displays - if the session is a path session.
Program template Name of the program template. Displays - if the session is a 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. Displays - if the session is a program session.
Path session ID   Unique identifier for the path session. Displays - if the session is a program session.
Program session custom fields   Contents of the field Additional session information in the advanced options of the session. Displays - if the session is a path session.
Program session ID   Unique identifier for the Program session. Displays - if the session is a path session.
Program template ID   Unique identifier for the program template. Displays - if the session is a path session.
Progression  
Percentage of course completion after the learner logs out of the path or program session.
- when a learner connects to a session but doesn't answer any activity.
Title / Employment   Contents of the field Title / Employment in the user profile.
User Custom Fields   Title of the custom fields (one column per custom field, 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).

Available filters for 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 group.
If no group is selected, the report will contain data for all groups that the exporter can view the data of.
-
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
  • Custom Fields
  • Registration date
  • Last activity date
  • Group
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.

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).

Available columns for 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.
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 of the first action taken by the learner on the platform in the context of the path, in the format YYYY/MM/DD HH:mm.

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
  • Program: Time to complete the program.
  • 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
  • Program
  • Assessment
This column is added to the report when Details per step is selected.
Title / Employment   Contents of the field Title / Employment in the user profile.
User Custom Field   Title of the custom field (one column per custom field, 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.

Available filters for 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 group.
If no group is selected, the report will contain data for all groups that the exporter can view the data of.
-
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
  • Custom Fields
  • Registration date
  • Last activity date
  • Group
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 sessions reports

Available columns for Program sessions reports

Column title Default Description
Email Email address of the user.
End Date and time of the user's last activity on a session course
First name First name of the user.
Last name Last name of the user.
Program Session Title of the program session.
Program template Name of the program template.
Progress Completion rate of the user on the session.
Score The user's most recent score.
Start Date and time when the user started the session.
If the first block of the session is a course, the platform tracks duration from the moment when the user clicks Start on the course’s welcome page.
Time spent Total time spent by the user on all course blocks in the session.
If the learner has made multiple attempts on a course, 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.
Additional program information   Description added in the program template’s settings.
Additional program session information   Description added in the program session’s settings.
Author   Email of the user who created the session. If the user was anonymized , the email is replaced by an anonymized email, in the format XXX@360learning.eu (XXX being a random sequence of characters).
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.
Detail per block (title, time, score)  
  • Block title 1: Name of the first course of the session. Displayed if at least one learner started the course.
  • Block score 1: Score of the learner on the first course of the session. Displayed if at least one learner started the course.
  • Block time 1: Time spent by the user on the first course of the session. Displayed if at least one Learner started the course.
  • Block title/score/time X: Identical to the previous three columns, for the next courses.
The number of blocks corresponds to the completion rate of the learner that is furthest along in the session.
Detail per classroom slot   Various columns for each classroom slot.
Expected duration   Duration defined in the session’s parameters.
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.
Instructors   Emails of users who were added as Instructors to the session.
Learner deletion date   Date when the user was deleted (the cell is empty if the user is active).
Managers   Emails of the user's managers, separated by a comma.
Program session custom fields   Contents of the field Additional session information in the advanced options of the session.
Program session ID   Unique identifier for the Program session. Displays - if the session is a path session.
Program template ID   Unique identifier for the program template.
Registered user   Indicates with an "x" that the user is assigned to the session. If the cell is empty, someone unassigned the user from the session
Tags   List of tags added to the program session.
Title / Employment   Contents of the field Title / Employment in the user profile.
User Custom Field   Title of the custom field (one column per custom field, 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.
Verified program   Indicates with an "x" that the user has a 100% completion rate on the session, reached the minimum score on all courses in Examination mode, and passed all assessments.

Available filters for Program sessions 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.
-
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 group.
If no group is selected, the report will contain data for all groups that the exporter can view the data of.
-
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
  • Custom Fields
  • Registration date
  • Last activity date
  • Group
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.

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).

Available columns for 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.
Title / Employment   Contents of the field Title / Employment in the user profile.
User Custom Field   Title of the custom field (one column per custom field, 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.

Available filters for 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 group.
If no group is selected, the report will contain data for all groups that the exporter can view the data of.
-
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
  • Custom Fields
  • Registration date
  • Last activity date
  • Group
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.

Classrooms reports

Available columns for 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 program session to which the classroom slot belongs.
Slot ID   Unique identifier for the classroom slot.
Title / Employment   Contents of the field Title / Employment 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 custom field (one column per custom field, 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.

Available filters for 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
  • Program 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 group.
If no group is selected, the report will contain data for all groups that the exporter can view the data of.
-
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
  • Custom Fields
  • Registration date
  • Last activity date
  • Group
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

Available columns for 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.
Title / Employment   Contents of the field Title / Employment in the user profile.
User Custom Field   Title of the custom field (one column per custom field, ordered alphabetically). All custom fields are displayed by default, unless filtered in the report settings.
User ID   Unique identifier for the user.

Available filters for 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 group.
If no group is selected, the report will contain data for all groups that the exporter can view the data of.
-
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
  • Custom Fields
  • Registration date
  • Last activity date
  • Group
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.
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