Analytics (sometimes referred to as Insights) now has a new data model. This new data model should bring the need for 2 data models (depending on what information you want to display) into 1, which covers both the LXP & xAPI Data Models.
Below is a breakdown of all the information that can be found as standard within the data that can be displayed on a dashboard within Analytics. These are broken down by tables as displayed within Analytics.
Content
Data Table Name
What is it pulling?
All Content
The column is automatically set to 0 for all records
Current Version
Returns a boolean value based on whether the hidden field "end_ts" is equal to'3000-01-0'
Content - Course Tags
Data Table Name
What is it pulling?
Course Tag Description
Description given to tags within the LXP (created at Org level), then tagged at LX level
Course Tag Name
Name given to the tag (created at Org level), then tagged at LX level
Content - Courses
Note: Those
highlighted
in red will show automatically in Years (E.g. 2022), use the More option
to change this to days, months, weeks etc.)
Data Table Name
What is it pulling?
Activity Object
Short version of Game Type (online course)
Activity Type
Longer version of Game Type (Study an online course)
Activity Verb
Descriptive of what the LX is (study or learn)
Comment XP
If the user places a comment, how much XP will they gain
Continuous Professional Development
How much CPD points are attached to the LX
Course Alias
Identifier for the LX (normally the name of the LX in lowercase letters and no spaces)
Course Category
Category that the LX sits within (Formal, Informal or Social)
Course Closing Date
Close date added to the LX settings
Course Creation Date
Date in which the LX was created
Course Deletion Date
Date in which the LX was deleted
Course ID
Identifier given to the LX by the LXP (not visible on the front end)
Course Name
Name given to the LX
Course Start Date
Date given when the LX will start (different from creation date)
Days to Complete
Due after days within the LX settings
Durations (Minutes)
Duration set at LX settings (How long the LX will take to complete)
Expiry Method
Will tell if set up to be a recurrence (no_expiry, completion_date etc)
External Reference
Held in the LX settings (Normally given for content ingestions or Completion Import)
Is Promoted
Tickbox within the LX settings
Language
Language of the LX (not seen on the front end)
Mandatory
Tick box within the LX settings
Provider
Name of the course provider (LinkedIn Learning for example)
Short Description
Provided at LX level
View XP
Once the object has been completed how much XP is awarded. This is at LX level but can be changed at Object Level
Visibility
Public or Secret
Content - Level Groups
Data Table Name
What is it pulling?
Level Group Name
Level Group name (only applicable with the Branching game type)
Level Group Order
The order of the level group names (1,2 etc)
Level Group Type
Indicates either if the group is a a group or a workspace.
1 = Group & 2 = Workspace
Content - Levels
Note: Those
highlighted
in red will show automatically in Years (E.g. 2022), use the More option
to change this to days, months, weeks etc.)
Data Table Name
What is it pulling?
Level Deletion Date
Date in which the level was deleted
Level Description
Description set at the level (Manage content in the LXP)
Level Difficulty
Percentage added to the level/s within the LX
Level ID
ID given to the Level (Typically not visible within the LXP, but can be seen in the LRS)
Level Name
Name given to the level
Level Order
Order in which the levels are ordered within the LX
Level Start Date
Date in which the level started (can be used to prevent people from entering until the date has passed)
Level Target Points
XP that the user must achieve to pass the level
Level Total Points
Total points available within the level
Content - Object Tags
Data Table Name
What is it pulling?
Object Tag Description
Description given to tags within the LXP (created at Org level) then tagged at Object level
Object Tag Name
Name given to the tag (created at Org level) then tagged at Object level
Content - Objects
Note: Those
highlighted
in red will show automatically in Years (E.g. 2022), use the More option
to change this to days, months, weeks etc.)
Data Table Name
What is it pulling?
Comment XP
XP that the user achieves if they comment (can be disabled per LX and changed per LX). May be different from what is set at LX level.
Object Completion Type
Completion type set within the Game Settings (Timed or xAPI)
Object Creation Date
Date in which the object was created
Object Deletion Date
Date in which the object was deleted
Object Description
Description given to the object within the LX.
Object External ID
Held in the Manage Content section (Normally given for content ingestions or Completion Import)
Object ID
ID given to the object. Visible by hovering over the object in the LXP or in the LRS
Object Name
Name given to the Object within the LX
Object Order
Order in which each object is laid out
View Time
If set to Timed, what is the view time
View XP
Once complete, how much XP will the user obtain
Content - Playlists
Data Table Name
What is it pulling?
Mandatory Course
If there are any LX’s within the playlist that are marked as mandatory.
Playlist Description
Description given to the Playlist - Set at Playlist settings.
Playlist Name
Name given to the Playlist - Set at Playlist settings.
Playlist Order
Order in which the Playlist shows on learner’s dashboards - Set at Playlist settings.
Playlist UUID
Unique ID given by the LXP to the Playlist - not typically seen on the front end.
Recommended Course
If there are any recommended courses attached to the Playlist the course will show as true.
Content - Resources
Note: Those
highlighted
in red will show automatically in Years (E.g. 2022), use the More option
to change this to days, months, weeks etc.)
Data Table Name
What is it pulling?
Resource Activity ID
If there are a custom ID set at resource level it would appear here. Think of Rise content for this.
Resource Content
Resource Creation Date
Date the resource was created
Resource Deletion Date
Date the resource was deleted
Resource Description
Description provided at resource level then carries through to Object level.
Resource ID
ID given by the LXP to the Resource
Resource Name
Name given to the Resource
Resource Type
Type of resource, this will appear as numbers. What they mean can be found at the bottom of this page.
Content - Custom Fields
Note: These will be the custom fields added to the Learning Experience Custom Fields within the LXP.
Content - Date Filter
Note: Those
highlighted
in red will show automatically in Years (E.g. 2022), use the More option
to change this to days, months, weeks etc.)
Data Table Name
What is it pulling?
Date
Dates since the LXP was running from
Day
Days of the week
Day Name
Days of the week (in text form)
Month
Month of the year
Weekend?
Tells if the date is a weekend or weekday - can be used to tell how many completions happen on the weekend
Events - Comments
Data Table Name
What is it pulling?
Depth
Number of Comments
Count for the specific scope. Say if you report on "User Name", "Number of Comments", you will get the number of comments by user.
Presence
Private Comment
Score
How many XP does the user get from commenting.
Sentiment
A number (to 2 decimal places) showing how positive or negative the comment was. With a value above 0 being a positive comment and below 0 being a negative comment.
Word Count
How many words does the comment have.
Events - Course Launches
Note: Those
highlighted
in red will show automatically in Years (E.g. 2022), use the More option
to change this to days, months, weeks etc.)
Data Table Name
What is it pulling?
Course Launch Hour
Hours of the day (24 hours)
Course Visit Date
Date of the visit to the course (can be used in conjunction with ‘Number of Course Launches’
Number of Course Launches
Count of how many times the course has been launched
Events - Course Ratings
Data Table Name
What is it pulling?
Is Downvoted
If the LX has received a thumbs down from a learner
Is Upvoted
If the LX has received a thumbs up from a learner
Number of Down Votes
Total amount of thumbs up
Number of Up Votes
Total amount of thumbs down
Rating
Overall rating of the LX (done once an LX is complete).
Events - Enrolments
Note: Those
highlighted
in red will show automatically in Years (E.g. 2022), use the More option
to change this to days, months, weeks etc.)
Data Table Name
What is it pulling?
Completion Note
If manually marked as complete - this will be the note provided (visible in the Enrolments table in the LXP).
Completion Reason
List of reasons given when a user is manually marked as complete.
Compliance - Due Date
When the user who is assigned an LX with a recurrence attached will Expire.
Different from due date on the enrolments report within the LX.
Compliance - Expiry Date
When the user who is assigned an LX with a recurrence attached will Expire.
Compliance - Status
Whether the LX is Due, Completed or overdue
Compliance - Status Code
Numerical for the above statues:
1 - Completed, 2 - Due & 3 - Overdue
Days since Completion
Total count of days since the users completion.
Days since Enrolment
Total count of days since the users enrolment.
Days to Complete
Total count of days taken from enrolment to completion.
Enrolment Completion Date
Date in which the Enrolment was complete.
Enrolment Completion Status
Shows if the LX was completed late, completed on time, outstanding or overdue.
Enrolment Creation Date
Date the user was enrolled onto the Learning Experience.
Enrolment Deletion Date
Date the user was un-enrolled from the Learning Experience (If applicable)
Enrolment Due Date
Due date set within the enrolments table within the Learning Experience.
Can be set via ‘Due after (days)’ within the LX Settings.
Enrolment Expiration Date
Date in which the users enrolment will expire (no longer have access to the LX).
Can be set via Enrolment Length (days) within the LX settings.
Enrolment ID
Unique ID given to each person enrolled onto the LX.
Enrolment Start Date
Date set within the enrolments table within the Learning Experience.
This will dynamically change with recurrences & un-enrolment and re-enrolment
Levels Completed
Sum of all total levels completed within the enrolment.
Mandatory
0 or 1 representing if the LX have been marked as mandatory within the LX settings.
Number of Completed Enrolments
Total number of Completed enrolments per user.
Number of Enrolments
Total number of Enrolments per user.
Points
Overall XP obtained within the LX.
Score
Total score obtained within the LX
With Enrolments
Boolean field automatically set to true for all records
Event Level Progress
Note: Those
highlighted
in red will show automatically in Years (E.g. 2022), use the More option
to change this to days, months, weeks etc.)
Data Table Name
What is it pulling?
Level Completion Date
Date in which the level was completed by the user.
Level Start Date
Date in which the level was started by the user.
Points
Total amount of XP obtained from the level
Events - Object Completions
Note: Those
highlighted
in red will show automatically in Years (E.g. 2022), use the More option
to change this to days, months, weeks etc.)
Data Table Name
What is it pulling?
Completion Date
Data in which the object was completed by the user.
Number of Object Completions
Total amount of object completions per user or overall.
Events - Object Launches
Note: Those
highlighted
in red will show automatically in Years (E.g. 2022), use the More option
to change this to days, months, weeks etc.)
Data Table Name
What is it pulling?
Number of Object Launches
Number of times a user has launched the object within an LX.
Object Launch Date
Date in which the user had launched the object.
Events - xAPI
Note: Those
highlighted
in red will show automatically in Years (E.g. 2022), use the More option
to change this to days, months, weeks etc.)
Data Table Name
What is it pulling?
Completion
LRS Store ID
Store within the LRS that the statement is stored within.
Max Score
Max score available (for example within an Assessment).
Raw Score
Score that the user has achieved.
Response
Response provided by the end user to a question given to them.
Response (Numeric)
If the response is numeric.
Scaled Score
Percentage correct (will show as 0.8 for example, but can be put to a percentage in Analytics).
Statement ID
Unique identifier that is given to the statement within the LRS.
Success
If the action has been successful.
Timestamp
Date in which the action was triggered. Remember, this is different from the stored date which is the date in which the statement was stored.
Users
Note: Those
highlighted
in red will show automatically in Years (E.g. 2022), use the More option
to change this to days, months, weeks etc.)
Data Table Name
What is it pulling?
Is Deleted
If the user is deleted within the LXP
Skill Builder User
Is the user attached to Skill’s Builder - typically this would always be Yes.
User Creation Date
Date in which the user was created within the LXP.
User Deletion Date
Date in which the user was deleted within the LXP.
User Email
Email address of the user.
User Expiration Date
Expires at field within the users profile.
User First Name
First name of the user.
User Full Name
User’s first and last name.
User Function
Field within the users profile.
User Language
User Language set within their profile.
User Last Login
Last time the user logged in.
User Last Name
User’s last name.
User Location
Users location set within their profile.
User Org Ref
Field within the users profile.
User SSO ID
User SSO ID held within the users profile - if applicable.
User Seniority
The seniority of the user within their organisation
User Timezone
Timezone of the user set within their profile.
User UUID
ID given to the user from the LXP when created.
Username
Username of the user held within their profile
Users - Custom Fields
Note: These will be the custom fields added to the User Profile Custom Fields within the LXP.
Users - Framework 1
Data Table Name
What is it pulling?
Entity Chained Name
Flow of the hierarchy of where the user sits within the organisation without needing to add seperate fields.
Entity Description
Description provided when an entity is created. * Not typically used so may appear as N\A.
Entity External Reference
Reference provided to the users job within the LXP.
Entity Name
Held within the users job role (Job title typically).
Users - Framework 2
Data Table Name
What is it pulling?
Entity Chained Name
Flow of the hierarchy of where the user sits within the organisation without needing to add seperate fields.
Entity Description
Description provided when an entity is created. * Not typically used so may appear as N\A.
Entity External Reference
Reference provided to the users job within the LXP.
Entity Name
Held within the users job role (Job title typically).
Users - Group Tags
Data Table Name
What is it pulling?
Group Tag Description
Description given to the Tag.
Group Tag Name
Tag attached at group level.
Users - Hierarchy
Data Table Name
What is it pulling?
All Users
Column automatically set to 0 for all records
Current Version
Returns a boolean value based on whether the hidden field "end_ts" is equal to'3000-01-0'
Users - Manager
Data Table Name
What is it pulling?
Manager Email
The email address of the user's manager.
Manager First Name
First name of the users manager.
Manager Full Name
Managers full name.
Manager Function
Held within the Manager’s profile.
Manager Last Name
Managers last name.
Manager Location
Managers location held in their profile.
Manager SSO ID
Managers SSO ID held in their profile.
Manager Username
Managers username held in their profile
Users - Organisation
Data Table Name
What is it pulling?
Organisation Language
The default language is set at the Org Level (Held at Settings > Edit Organisation).
Organisation Name
Name given to the LXP site (Held at Settings > Edit Organisation).
Users - Primary Positions
Note: Those
highlighted
in red will show automatically in Years (E.g. 2022), use the More option
to change this to days, months, weeks etc.)
Data Table Name
What is it pulling?
Position Description
Description given to the users Primary Job Role.
Position End Date
End date added to the users Primary Job Role.
Position External ID
Role ID added to the user Primary Job Role.
Position Start Date
Start Date added to the users Primary Job Role.
Title
Typically job title added to the users Primary Job Role.
Users - User Groups
Data Table Name
What is it pulling?
User Group Description
Description given to the Group.
User Group External ID
External ID given to the group (set at Group settings).
User Group ID
ID given by the LXP to the group (Can be seen in the URL when within the group).
User Group Name
Name given to the group.
User - User Types
Data Table Name
What is it pulling?
User Tag Description
Description given to the Tag.
User Tag Name
Tag attached at user level.
xAPI - Activities
Data Table Name
What is it pulling?
Activity Description
If there is a question being asked of the user.
Activity ID
ID provided to the activity (Resource, Level or Object ID for example).
Activity Name
Name given to the activity (Assessment Question for example).
Activity Number
Numeric value detected in the Activity Name. Say if an activity name is "Question 18", it will be 18.