1.0.83
New Links Data Mart; New Fields and Logic in Tool Usage Metrics Mart
Release Date
May 7, 2025
Key Features
The Links data mart is now available. This mart is based on Pennsylvania State University's Links data mart, developed by Jason Heffner. This mart uses Javascript libraries to extract links embedded in LMS content, as well as contextual data about the URL and HTML containing the link. To support this mart, three new utility tables have been added to the mart_helper dataset:
mart_helper.utility__file_extensions
mart_helper.utility__url_shorteners
mart_helper.utility__service_mapping
An error in the source code was causing the hourly counts of events per tool to be underreported. The error is fixed and the hourly counts are correct now.
The logic to flag if a tool is considered to have low events has been changed. The flag is now determined based on the distribution of the number of events during various time frames (hourly, six hours, twelve hours, daily) for a tool. The distribution is defined by grouping the number of events a tool can have during a time frame (0 events, 1-100 events, 101-500 events, and so on) and finding the percentage of occurrences for each group. A low events threshold for each time frame is defined based on this distribution and represents the number of events under which a tool is considered to have low events. The low events flag is defined by comparing the tool's current number of events to this threshold. If the number of events for the tool is less than the threshold, the tool is flagged as having low events. If the number of events is greater than or equal to the threshold, the tool is flagged as not having low events.
A more in-depth explanation of the updated logic can be found in the Tool Usage Metrics documentation.
The following fields have been added to the tool_usage_metrics mart:
run_hour
num_seconds_since_latest_event
num_minutes_since_latest_event
num_hours_since_latest_event
num_days_since_latest_event
hourly_low_events_threshold
six_hr_low_events_threshold
twelve_hr_low_events_threshold
daily_low_events_threshold
low_six_hr_events_flag
low_twelve_hr_events_flag
low_daily_events_flag
low_events_flag
Last updated