Enterprise Reporting
  • Introduction
  • Understanding reports with clarity (Definitions)
  • Optimizing key performance indicators (via the Groups tab)
    • Dashboard
    • Reporting section
      • Progress report
      • Adoption report
      • Engagement report
      • Content insights
        • XP
        • Courses
        • Projects
        • Tracks
      • Assessments
      • Certifications
      • Time in Learn
      • DataLab
      • Export
    • Skill Matrix
  • Integrating our data into your tools (via Data Connector 2.0)
    • Explore the data model
      • Fact tables
      • Dimension tables
      • Bridge tables
      • Metrics tables
    • Common use cases
    • Sample queries
    • Queries to recreate key reports in the Groups tab
      • Dashboard
        • Members who have earned XP
      • Reporting section
        • Progress report
        • Content insights
        • Assessments
        • Certification Insights
        • Time in Learn
    • Domain Gotchas
    • Getting started with Data Connector 2.0
      • Enable Data Connector 2.0
      • Your credentials
      • Storing your credentials
    • Using Data Connector 2.0
      • Integrating with your BI tools
        • Microsoft Power BI
        • Tableau
        • Looker
        • DataLab
      • Downloading your data
        • S3 Browser (Windows)
        • Cyberduck (Mac or Windows)
        • AWS CLI (Linux)
    • Changelog
    • Migrating from Data Connector 1.0
  • FAQ
  • Data Connector 1.0 - Documentation
    • [Data Connector 1.0] Explore Data Model
      • [Data Connector 1.0] Data Model
      • [Data Connector 1.0] Changelog
      • [Data Connector 1.0] Example queries
    • [Data Connector 1.0] Getting started
      • [Data Connector 1.0] Enabling the Data Connector
      • [Data Connector 1.0] Your Credentials
      • [Data Connector 1.0] Storing your Credentials
    • [Data Connector 1.0] Using the Data Connector
      • [Data Connector 1.0] Analyzing data
        • [Data Connector 1.0] DataLab
        • [Data Connector 1.0] Microsoft Power BI
        • [Data Connector 1.0] Tableau
      • [Data Connector 1.0] Downloading data
        • [Data Connector 1.0] S3 Browser (Windows)
        • [Data Connector 1.0] 3Hub (Mac)
        • [Data Connector 1.0] AWS CLI (Linux)
    • [Data Connector 1.0] Data Connector FAQ
      • [Data Connector 1.0] Deprecating dcdcpy and dcdcr
Powered by GitBook
On this page
  • group_detail
  • user_engagement_detail
  • track_engagement_detail
  1. Integrating our data into your tools (via Data Connector 2.0)
  2. Explore the data model

Metrics tables

PreviousBridge tablesNextCommon use cases

Last updated 18 days ago

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