1.0.86
New Tool Usage Metrics Marts; Updates to Utility Tables; Updates to LTI Tool Mart
Release Date
July 15, 2025
Key Features
The Tool Usage Metrics Archive mart is now available. The purpose of this mart is to keep an archive of the Tool Usage Metrics mart. The Tool Usage Metrics mart is overwritten hourly and only presents the tool metrics for the most recent hour. These metrics are appended to the Tool Usage Metrics Archive mart every hour, so that a historical record is available for users.
The Tool Low Events mart is now available. This mart tracks any occurrences of low event volume for tools. This mart is dependent on the Tool Usage Metrics Archive mart, and a tool is considered to have low event volume based on the low events flag defined in that mart.
Utility Tables
The utility tables, defined as part of the mart_helper dataset, have been updated to further improve the contextual information included in the marts. We have also created a new EdApp Reporting utility table named mart_helper.utility__ed_app_reporting, which defines reporting names for EdApp IDs. This table supports the Tool Usage Metrics mart. The tables updated are:
mart_helper.utility__cip_codes
mart_helper.utility__tool_from_name
mart_helper.utility__tool_from_url
The CIP Codes table is now populated from the National Center for Education Statistics (NCES) CIPCode 2020 table, available here. The Tool From Name and Tool From URL tables are updated to include more tool names and URLs. These tables support the LTI Tool mart and specifically are used to map various launch_app_url and launch_app_name values to common tool_name values. For example, these mapping tables associate a URL of 'tophat.com' with a tool name of 'TopHat.'
The logic to classify tools as LTI or redirect tools, defined in the is_lti_tool and is_redirect_tool flags, has been updated in the LTI Tool mart. Originally, tools were defined as redirect tools if the domain of the tool was empty and the URL of the tool was 'https://www.edu-apps.org/redirect.' By specifying that the domain of the tool needed to be empty, some tools that should have been considered as redirect tools were not being flagged. The updated logic only considers if the URL of the tool is 'https://www.edu-apps.org/redirect.'
Last updated