Reporting Data
ClearXP collects a lot of data so it's important to understand what that data represents, how to interpret it and find your way to interesting insights. This page provides a detailed overview of the different data sources in the system and what fields exist.
The system conducts a best-effort approach to calculating data fields and that in some cases, many of these fields may be absent if the system cannot reliably determine how to calculate them.
For example, if the system only has two data points on completely different days for a learner completing the activity then it will be unable to determine the duration taken because duration is the time spent within the activity itself (two data points within a short period of time are required).
In general, data may be more reliable the more recent the record has been recorded as efforts to populate these fields improve.
Enrolment Status
The Enrolment Status data source includes the current state of all assignments (admin, manager-assigned, self-registered, etc.) in the system. This is useful for compliance reporting on Due Dates and whether users have completed the learning assigned to them.
Schema
Program Activity
node
Activity
If this assignment belongs to a Program, this will refer to the Program the activity belongs to (othrewise refers to the directly assigned module).
Activity
activity
Activity
The assigned activity (either directly or indirectly underneath a Program).
User
actor
Actor
The learner assigned to complete the activity.
Enrolment Type
enrolmentType
String
How the enrolment was assigned, one of:
- admin - Top-down enrolments created with audience-based rules for assigning ongoing learning.
- activity - Used for face-to-face sessions. Enforces consistency so all learners will be given the same start and end date for a given activity.
- actor - Individuals assigned directly to activities either via Program Owner or automated workflows (including approval processes). Used to give learners different start and end dates.
- manager-assigned - Individuals assigned directly to activities by their manager within the Learning Hub. Automated workflows can also be directed to this type to allow un-assignment by managers.
- self-registered - Any activities the learner has chosen to assign themselves via the Learning Hub.
Enrolment Category
enrolmentCategory
String
The specific category the learning is grouped under. Typically "mandatory" or "recommended" but can include other categories if configured.
Is Mandatory
enrolmentMandatory
Boolean
Whether this is a mandatory assignment for compliance purposes.
Workflow ID
workflowId
String
Reference to the workflow attached to this assignment.
Enrolment Status
status
String
The current status of the assignment, one of:
- assigned - The default status – appears in learning hub as required for completion.
- overdue - Appears as red clock icon indicating the activity has passed its due date.
- expired - Appears as refresh arrow when completed training has been reset.
- locked - Appears locked out until prerequisites have been completed.
- unassigned - Required for completion but not yet visible to the learner. Used prior to Start Date.
- unregistered - Not required for completion, an exception status when a learner is enrolled but does not need to complete the activity.
Enrolled Date
timestampEnrolled
Date
The date the activity was assigned. This may different from the "Start Date" if the learner was assigned the learning after the activity had been rolled out or if they were enrolled ahead of time with a future Start Date.
Start Date
timestampStart
Date
The date the activity was scheduled to launch and become visible in the Learning Hub.
Due Date
timestampDue
Date
The date the activity is scheduled to be completed by for compliance purposes.
Completion Date
timestampCompleted
Date
The date the activity was completed by the learner. If the learner completes multiple times, this will be the date they first completed after being assigned.
Last Accessed
timestampAccessed
Date
The date the learner most recently accessed the activity.
Completions
The Completions data source contains a historical record of all completions for learners for each activity. Learners can contain multiple completions for a single activity if they have completed it multiples times.
Schema
Activity
activity
Activity
The activity that the record pertains to.
User
actor
Actor
The historical agent, including their user profile attributes at the time the completion was recorded.
Attempt Number
attempt
Number
A sequential number representing the Nth time the user has completed this activity. For rolled up completions, this number may not be reliable.
Attempts To Complete
attempts
Number
The number of attempts taken (generally as a result of undertaking a quiz or assessment) before the activity was considered completed. Since all activities have different completion requirements, this number may not be consistent across different activities.
Browser
browser
String
The browser most commonly to complete the activity (Chrome / Safari/ etc.)
Date Completed
dateCompleted
Date
The date the completion was recorded stored in the user’s time zone. Only present if the user has a time zone attached.
Time Spent on Desktop
device.desktop
Number
A breakdown of how long (in milliseconds) was spent on each desktop when completing this activity.
Time Spent on Tablet
device.tablet
Number
A breakdown of how long (in milliseconds) was spent on each tablet when completing this activity.
Time Spent on Mobile
device.mobile
Number
A breakdown of how long (in milliseconds) was spent on each mobile when completing this activity.
Due Date
dueDate
Date
The assigned Due Date for the activity.
Duration
duration
Number
The number of milliseconds taken to complete the activity.
Enrolment Category
enrolmentCategory
String
How the activity was assigned to the user (mandatory / recommended / featured).
Enrolment Type
enrolmentType
String
Representative of who assigned the activity to the user (admin / manager-assigned / self-registered).
Interactions
interactions
Number
The number of interactions the user had when completing the activity (viewing screens, clicking buttons, etc.)
Operating System
os
String
The Operating System most used when completing the activity (Mac OS / Windows / etc.)
Notification Date
notificationDate
Date
The date of the most recent notification to be sent to the learner in regards to the activity. This is indicative of responsiveness to reminder notifications.
Total Notifications
notifications
Number
The number of notifications sent to the learner before they completed the activity.
Registration ID
registration
String
Unique ID to represent a distinct registration into the activity (i.e. if the user is assigned the activity multiple times over a time period).
Total Sessions
sessions
Number
The number of times the learner accessed the activity in separate browser sessions before they completed the activity.
Score
score
Number
The most recent score the user achieved before completing the activity if a quiz exists in the activity.
Start Date
startDate
Date
The enrolment Start Date which represents the date the activity was released to the learner. Note that this date may be prior to when the learner was actually assigned the activity if they joined the business after the enrolment had commenced (see assignedDate instead).
Stored Date
stored
Date
The date this record was most recently updated by the system.
Stored Completed Date
storedCompleted
Date
The date the completion was received by the system. If completions are imported or back-dated, this date will be more recent than the actual completion date.
Time Since Assigned
timeSinceAssigned
Number
The amount of time (in seconds) that passed between the Start Date and the Assigned Date.
Time Since Start Date
timeSinceStartDate
Number
The amount of time (in seconds) that passed between the Start Date and Completion Date.
Time Since Due Date
timeSinceDueDate
Number
The amount of time (in seconds) that passed between the Due Date and the Completion Date. This number will be negative if the learner completed before their Due Date or positive if they completed after the Due Date.
Time Since Notification
timeSinceNotification
Number
The amount of time (in seconds) that passed between the most recent Notification sent and the Completion Date.
Timestamp Accessed
timestamp
Date
The date of the most recent access by the learner.
Timestamp Assigned
timestampAssigned
Date
The date the activity was actually assigned to the learner and would have appeared in their assigned learning. May be absent if the learner was never assigned and the completion was imported.
Timestamp Completed
timestampCompleted
Date
The date the learner completed the activity.
Timestamp Started
timestampStarted
Date
The date the learner first accessed the activity.
Time to Complete
timeToComplete
Number
The amount of time (in seconds) that passed between the learner first accessing the activity and then completing it. Indicative of the learner taking multiple days to complete or if completed on their first access.
Total Score
totalScore
Number
The sum of all quiz scores across all attempts before the learner completed the activity.
Analytics / Interactions
Schema
Activity
activity
Activity
The activity that the record pertains to.
User
actor
Actor
The user that the record pertains to.
Activity Ancestors
ancestors
Object[]
Resolved ancestry tree for the activity including the ID of each ancestor activity and the depth of the tree. For example, if this record pertained to accessing a Dashboard Tab, this object would look like the following: [
{ activity: "(Learning Hub Activity ID)", depth: 0 },
{ activity: "(Dashboard Activity ID)", depth: 1 },
{ activity: "(My Team Activity ID)", depth: 2 }
]
Completed
completion
Number
Whether this record signifies a completion should be recorded or not (0 = not completed, 1 = completed)
contained
Analytics Object
Includes a nested record within this one – with the exception of activity references, all other fields in this table can appear as sub-fields of contained. Used for compound records such as “Manager shared Activity with User” – the “manager shared activity” portion appear as top-level analytics fields but contained will include the “user” portion (along with any other recorded fields).
Time Taken
duration
Number
The duration spent (in milliseconds) when recording this interaction.
Statement ID
id
String
The unique identifier for this record.
Referenced Activity
other
Activity[]
Indirect activity references for this record. Typically includes the screen or an activity a user is viewing when the event is recorded against a different activity to the one the user is currently viewing. I.e. “Launching Induction Training” – Induction Training is the activity, but other will include the activity the user launched from.
Response
response
String
Response data attached to this record, if applicable.
Date
timestamp
Date
The date of the interaction.
Action
verb
String
Action taken by the user against the object (in the form of a "verb").
Taxonomy
System Interactions
Registered into Activity User registered (Activity)
Unregistered from Activity User unregistered (Activity)
Assigned Activity User designated (Activity) as "assigned"
Unassigned Activity User designated (Activity) as "unassigned"
Activity Overdue User designated (Activity) as "overdue"
Activity Expired User expired (Activity)
Sent Notification System reminded User to complete (Activity)
Admin Interactions
Created New Activity Admin created (Activity)
Updated Activity Admin updated (Activity)
Deleted Activity Admin removed (Activity)
Marked Completion Admin recorded (Learner) as completed (Activity)
Notified Manager Admin requested attention (User) for (Interaction)
Published a Decision Admin logged (Decision Activity)
Created New Role Admin created (Role Activity)
Updated Role Admin updated (Role Activity)
Deleted Role Admin deleted (Role Activity)
Created New Label Admin created (Label Activity)
Updated Label Admin updated (Label Activity)
Deleted Label Admin deleted (Label Activity)
Assigned Facilitator Admin assigned Facilitators to (Session)
Removed Facilitator Admin assigned Facilitators from (Session)
Marked Attendance Admin recorded (Learner) registered/cancelled/completed (Session)
Withdrew Registration Learner cancelled (Event)
Portal / Learning Hub Interactions
Launched Activity User launched (Activity) from (Portal Activity / Screen)
Captured when a user launches an activity including the screen (or activity) they were on when they launched it.
Performed Search User searched for “(Search Term)” from (Screen)
Captured when the user searches for learning, including the screen they were on when they initiated the search. Searches can be initiated from the Hub or Portal pages.
Filtered Search User selected (Filter) with “(Filter Value)” from (Screen)
Captured when utilising dropdown filters. The value selected in the dropdown is also recorded as well as the screen the user was on when they selected the filters.
Self-Registered into Activity User registered into (Activity)
Captured when a user registers themselves into an activity via the Learning Hub.
Self-Unregistered from Activity User unregistered from (Activity)
Captured when a user removes a self-registered activity from their assigned learning.
Assigned Activity to User Manager assigned (Activity) to Learner
Captured when a manager assigns an activity to a user in their team.
Unassigned Activity from User Manager removed (Activity) from Learner
Captured when a manager removes a previously assigned activity from a user in their team.
Shared Activity with User User shared (Activity) with User
Captured when the user shares an activity with another user in the system. Learners can share with multiple users at once but a separate event is recorded for each user.
Updated Profile Photo User updated (Photo Activity)
Captured when the user uploads a new profile photo from their Learning Hub profile.
Learning Interactions
Opened Activity User initialised (Activity)
Captured when a user opens a module, program or portal.
Closed Activity User terminated (Activity)
Resumed Activity User resumed (Activity)
Progressed Activity User attempted (Activity)
Completed Activity User completed (Activity) with (Score)
Captured when a user completes an activity, sometimes includes a score if the activity reports a score.
Passed Activity User completed (Activity) and (Success)
Failed Activity User completed (Activity) and (Failed)
Opened Link User followed (Link Activity)
Viewed Screen User experienced (Screen)
Captured when the user navigates to a different screen inside a module or program page.
Completed Screen User completed (Screen)
Uploaded File User uploaded (File)
Played Video User played (Video) at (Timecode)
Paused Video User paused (Video) at (Timecode)
Skipped Video User skipped (Video) to (Timecode)
Watched Video User watched (Video) from (Timecode) to (Timecode)
Finished Video User completed (Video)
Assessment Interactions
Completed Quiz User completed (Quiz)
Passed Quiz User passed/completed (Quiz) and (Success)
Failed Quiz User failed/completed (Quiz) and (Failed)
Answered Question User responded/answered (Question)
Passed Question User responded/answered (Question) and (Success)
Failed Question User responded/answered (Question) and (Failed)
Attached File User attached (Attachments) to (Question)
Answered Self-Assessment Question User responded to (Question) as (Learner)
Completed Self-Assessment User assessed (Assessment) as (Learner)
Answered 180 Assessment Question User responded/commented (Question) as (Manager)
Completed 180 Assessment User assessed (Assessment) as (Manager)
Answered 360 Assessment Question User responded/commented (Question) as (Peer/Team/Observer)
Completed 360 Assessment User assessed (Assessment) as (Peer/Team/Observer)
Achievement Interactions
Earned Badge User earned (Badge)
Earned Points User earned (Points)
Earned Voucher User earned (Points)
Earned Certificate User earned (Certificate)
Task Interactions
Assigned Task User assigned (Task) to (Manager/Peer)
Unassigned Task User removed (Task) from (Manager/Peer)
Deleted Task User removed (Task)
Approved Task Manager/Peer approved (Task) for (Learner)
Declined Task Manager/Peer declined (Task) for (Learner)
Withdrew Task Manager/Peer cancelled (Task) for (Learner)
Last updated
Was this helpful?
Social Interactions
Posted a Message User posted (Social Post)
Commented on a Post User commented on (Social Post)
Liked a Post User liked (Social Post)
Pinned a Post Moderator pinned (Social Post)
Unpinned a Post Moderator unpinned (Social Post)
Awarded Post Moderator awarded (Social Post) with (Reward)
Removed Post/Comment Moderator removed (Social Post)
Rated Activity User rated (Activity) as (Rating)
Captured when a user rates a piece of content with a quality rating (from 1 – 5).
Provided Feedback for Activity User rated (Activity) with (Feedback)
Captured when a user leaves free-text feedback on a piece of content.