Reporting

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.

: 14 min read
: Updated May 26, 2026

Enterprise Help

This guide covers an Enterprise administration feature. For the latest ClearXP guides, see Help Guides.

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.

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

Field	Type	Description
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

Field	Type	Description
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

Field	Type	Description
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

Interaction	Description
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

Interaction	Description
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

Interaction	Description
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

Interaction	Description
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

Interaction	Description
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)

Social Interactions

Interaction	Description
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.

Achievement Interactions

Interaction	Description
Earned Badge User earned (Badge)
Earned Points User earned (Points)
Earned Voucher User earned (Points)
Earned Certificate User earned (Certificate)

Task Interactions

Interaction	Description
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)

Payment Interactions

Interaction	Description
Made a Purchase User purchased (Activity)
Charged Payment User created (Charge)
Refunded Payment User refunded (Charge)
Settled Purchase System settled (Charge)
Transferred Payment System created (Transfer)