Metrics tables

Metrics tables contain aggregated tabular data. They combine data from fact, dimension, and bridge tables to provide an easy-to-use foundation for reports and dashboards.

• The metric tables available are:

  • group_detail

  • user_engagement_detail

  • track_engagement_detail

group_detail

This table aggregates activity information per user and day. It can help you build a flexible activity dashboard or report showing activity for the whole organization or per user for any period. Using only this table, for example, you can quickly create a dashboard like the one below:

Field	Description
group_id	The unique group identifier
user_id	The unique identifier of the user
date	The date for which the statistics are aggregated
total_hours_on_learn	Total time spent by the user on Learn content (assessments, courses, practices, and projects) on that date
total_hours_on_courses	Total time spent by the user on courses on that date
total_xp_earned	The number of xp the user earned on the given date
nb_courses_started	The number of courses the user has started on the given date
nb_courses_completed	The number of courses the user has completed on the given date
nb_chapters_started	The number of chapters the user has started on the given date
nb_chapters_completed	The number of chapters the user has completed on the given date
nb_exercises_completed	The number of exercises the user has completed on the given date
nb_projects_started	The number of projects the user has started on the given date
nb_projects_completed	The number of projects the user has completed on the given date
nb_practices_completed	The number of practices the user has completed on the given date
nb_assessments_started	The number of assessments the user has started on the given date
nb_assessments_completed	The number of assessments the user has completed on the given date
nb_tracks_started	The number of tracks the user has started on the given date
nb_tracks_completed	The number of tracks the user has completed on the given date

user_engagement_detail

This table contains activity information per user at the content-item level. It tracks courses, course chapters, projects, and assessments.

This table shows users' activity for particular technologies, topics, or content items. When assigning content to users, it can help you determine who has done what, when they started, who has finished, and how much time they spent on a given set of content items.

Field	Description
group_id	The unique group identifier
user_id	The unique identifier of the user
content_id	The unique identifier of the content unit
content_title	The title of the content unit
started_at	The timestamp when the user started the content unit, if available
completed_at	The timestamp when the user completed the content unit, if available
hours_engaged	The number of hours the user spent on the content unit
xp_earned	The xp points the user earned on the content unit
pct_completed	The completion ratio (0-1.0) based on the xp earned
content_type	The content type of the content unit (course, chapter, project, assessment)
technology	The technology of the content unit
topic	The topic of the content unit

track_engagement_detail

This table contains information on the track activity for each user and each track they have enrolled in.

It is the companion to user_engagement_detail, but at the track level. Since tracks contain multiple items from different content types (courses, projects, assessments), a different metric table is needed to show the user's progress in the track and its constituent components.

The table shows who has started a track, who has completed it, and each user's detailed progress. It includes the number of courses, chapters, projects, and assessments in the track and the number each user has completed.

Field	Description
group_id	The unique group identifier
user_id	The unique identifier of the user
track_name	The name of the track
category	The category of the track (skills, career)
track_id	The unique identifier of the track
track_version_id	The unique identifier of the track version. A track can have multiple versions, all with the same track_id
is_custom	Whether or not a track is custom. If false, then the track is a regular (public) track
is_current_version	Whether or not the version of the track is the most recently published version
track_started_at	The timestamp when the user started the track.
track_completed_at	The timestamp when the user completed the track. If a user has not completed the track, this field is null
nb_courses	The number of courses that are part of the track
nb_courses_completed	The number of courses the user has completed in this track
nb_chapters	The number of chapters that are part of the track
nb_chapters_completed	The number of chapters the user has completed in this track
nb_projects	The number of projects that are part of the track
nb_projects_completed	The number of projects the user has completed in this track
nb_assessments	The number of assessments that are part of the track
nb_assessments_completed	The number of assessments the user has completed in this track
xp_available	The total XP available for the track
xp_earned	The XP the user has earned in the track
pct_xp_earned	The percentage of XP available the user has earned in this track