# 1.0.86 ## New Tool Usage Metrics Marts; Updates to Utility Tables; Updates to LTI Tool Mart | Version | 1.0.86 | | ------------ | ------------- | | Release Date | July 15, 2025 | ## Key Features ### [Tool Usage Metrics Archive](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/tool-usage-metrics/tool-usage-metrics-archive) The Tool Usage Metrics Archive mart is now available. The purpose of this mart is to keep an archive of the [Tool Usage Metrics](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/tool-usage-metrics/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. ### [Tool Low Events](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/tool-usage-metrics/tool-low-events) 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](https://nces.ed.gov/ipeds/cipcode/resources.aspx?y=56). 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.' ### [LTI Tool ](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/lti-tool-use) 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 '.' 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 '.'