# Tool Usage Metrics Archive The *tool\_usage\_metrics\_archive* mart is an archive of the [tool\_usage\_metrics](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/tool-usage-metrics/tool-usage-metrics.md) mart. Every hour, the current hour's records from the *tool\_usage\_metrics* mart are appended to this mart. This mart can be used to refer to prior hours of tool usage. **BQ Prod Dataset Locations** * mart\_general ## Interactive Mart Dependency Diagram The following visualization shows the construction of this data mart defined in the [UDP marts](https://gitlab.com/unizin-community/unizin-data-platform/marts) repository. More information on the repository and diagram can be found on [this marts page](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts.md). {% hint style="info" %} [Click here to open the interactive chart.](https://assets.public.unizin.org/udp-marts/mart/mart__general__tool_usage_metrics_archive.svg) {% endhint %}

mart_general.tool_usage_metrics_archive

## Schema ### **mart/general/tool\_usage\_metrics\_archive** | Field name | Type | Description | | ---------------------------------- | -------- | --------------------------------------------------------------------------------------------------------------------------------------------- | | ed\_app\_id | STRING | The EdApp ID of the tool. | | run\_hour | DATETIME | The date and hour of when the *tool\_usage\_metrics* mart was updated for the given record. | | total\_events | INTEGER | The total number of events associated with the tool as of the run hour. | | total\_events\_1hour | INTEGER | The total number of events for the tool in the previous hour as of the run hour. | | total\_events\_6hour | INTEGER | The total number of events for the tool in the previous 6 hours as of the run hour. | | total\_events\_12hour | INTEGER | The total number of events for the tool in the previous 12 hours as of the run hour. | | total\_events\_day | INTEGER | The total number of events for the tool over the past day as of the run hour. | | total\_events\_week | INTEGER | The total number of events for the tool over the past week as of the run hour. | | total\_events\_month | INTEGER | The total number of events for the tool over the past month as of the run hour. | | total\_events\_year | INTEGER | The total number of events for the tool over the past year as of the run hour. | | earliest\_event\_time | DATETIME | The overall earliest event time associated with the tool as of the run hour. | | latest\_event\_time | DATETIME | The overall latest event time associated with the tool as of the run hour. | | earliest\_event\_time\_1hour | DATETIME | The earliest event time for the tool in the previous hour as of the run hour. | | latest\_event\_time\_1hour | DATETIME | The latest event time for the tool in the previous hour as of the run hour. | | earliest\_event\_time\_6hour | DATETIME | The earliest event time for the tool in the previous 6 hours as of the run hour. | | latest\_event\_time\_6hour | DATETIME | The latest event time for the tool in the previous 6 hours as of the run hour. | | earliest\_event\_time\_12hour | DATETIME | The earliest event time for the tool in the previous 12 hours as of the run hour. | | latest\_event\_time\_12\_hour | DATETIME | The latest event time for the tool in the previous 6 hours as of the run hour. | | earliest\_event\_time\_day | DATETIME | The earliest event time for the tool over the past day as of the run hour. | | latest\_event\_time\_day | DATETIME | The latest event time for the tool over the past day as of the run hour. | | earliest\_event\_time\_week | DATETIME | The earliest event time for the tool over the past week as of the run hour. | | latest\_event\_time\_week | DATETIME | The latest event time for the tool over the past week as of the run hour. | | earliest\_event\_time\_month | DATETIME | The earliest event time for the tool over the past month as of the run hour. | | latest\_event\_time\_month | DATETIME | The latest event time for the tool over the past month as of the run hour. | | earliest\_event\_time\_year | DATETIME | The earliest event time for the tool over the past year as of the run hour. | | latest\_event\_time\_year | DATETIME | The latest event time for the tool over the past year as of the run hour. | | num\_seconds\_since\_latest\_event | INTEGER | The number of seconds since the latest event for the tool as of the run hour. | | num\_minutes\_since\_latest\_event | INTEGER | The number of minutes since the latest event for the tool as of the run hour. | | num\_hours\_since\_latest\_event | INTEGER | The number of hours since the latest event for the tool as of the run hour. | | num\_days\_since\_latest\_event | INTEGER | The number of days since the latest event for the tool as of the run hour. | | hourly\_low\_events\_threshold | INTEGER | The number of events for an hour under which a tool is considered to have low hourly events and the `low_hourly_events_flag` is raised. | | six\_hr\_low\_events\_threshold | INTEGER | The number of events for 6 hours under which a tool is considered to have low 6 hour events and the `low_six_hr_events_flag` is raised. | | twelve\_hr\_low\_events\_threshold | INTEGER | The number of events for 12 hours under which a tool is considered to have low 12 hour events, and the `low_twelve_hr_events_flag` is raised. | | daily\_low\_events\_threshold | INTEGER | The number of events for a day under which a tool is considered to have low daily events, and the `low_daily_events_flag` is raised. | | low\_hourly\_events\_flag | INTEGER | Flag indicating low event volume for the previous hour of events for the tool as of the run hour. | | low\_six\_hr\_events\_flag | INTEGER | Flag indicating low event volume for the previous 6 hours of events for the tool as of the run hour. | | low\_twelve\_hr\_events\_flag | INTEGER | Flag indicating low event volume for the previous 12 hours of events for the tool as of the run hour. | | low\_daily\_events\_flag | INTEGER | Flag indicating low event volume for the previous day of events for the tool as of the run hour. | | low\_events\_flag | INTEGER | Flag indicating low event volume for the tool overall as of the run hour. | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/tool-usage-metrics/tool-usage-metrics-archive.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.