Changelog
In this section, we track updates and changes to the data model.
June 5, 2025
We’ve updated the data model to support custom assessments. The dim_content
table now includes a new boolean field: assessment_is_custom
. This field indicates whether an assessment is custom (true
) or standard (false
).
If your group uses custom assessments, you’ll now see corresponding rows reflected in this table.
We have also added a last_sso_nameid
column to the bridge_user_group
table. This field contains the last SSO NameID of the user in the group. Some groups that authenticate with SSO use this field to include custom identification data for their users.
May 28, 2025
We’ve updated the underlying data in the data model (note: this is not a schema change) to improve the accuracy of engagement metrics:
Filtered course activity: We now exclude
course_engagement
events associated with courses that are not in one of the three expected states: Live, Soft Launched, or Archived. Previously, some engagement data from courses in other states may have been included. This change may slightly reduce reported course durations. This does not affect XP calculations.Filtered assessment activity: We now exclude
assessment_engaged
events for assessments that are not in the public state. Previously, engagement data for non-public assessments was included. This change may slightly reduce assessment duration metrics. This does not affect XP calculations.
May 22, 2025
We've enhanced the data model to include the description and short description for courses and chapters. New fields, description
and short_description
has been added to the dim_content
table.
April 22, 2025
We've enhanced the data model to include the estimated time required to complete courses and projects. A new field time_needed_in_hours
has been added to the dim_content
table. This field represents the expected duration (in hours) to complete a given piece of content and is currently populated only for courses and projects.
April 17, 2025
We've added a course_is_skipped
column to fact_learn_events
. This column will contain a boolean (true/false) for course_completed
events, indicating whether the course was skipped. A skipped course is still treated as a completed course. For cases when the course was skipped, the occurred_at
timestamp for the course completion event will reflect the time at which the course was skipped.
April 16, 2025
We’ve updated the data model to support custom certifications. The dim_certification
table now includes a new boolean field: certification_is_custom
. This field indicates whether a certification is custom (true
) or standard (false
).
If your group uses custom certifications, you’ll now see corresponding rows reflected in this table.
March 31, 2025
Launched Data Connector 2.0!!
With Data Connector 2.0, we’ve significantly improved the data model, making it simpler, more efficient, and aligned with the rest of our reporting.
Simplified data model – Fewer tables (29 → 13) for easier querying
Data alignment with Groups tab reporting - Data Connector 2.0 now uses the same source as the rest of our reporting, ensuring consistency across all analytics and no discrepancies.
Includes mobile data - Now includes learner data done via the mobile app
Pre-aggregated metrics – New pre-aggregated metric tables to speed up reporting
Easier querying – Significantly fewer complex joins for common reports
Last updated