> For the complete documentation index, see [llms.txt](https://resources.unizin.org/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/tool-usage-metrics/tool-low-events.md).

# Tool Low Events

The *tool\_low\_events* mart presents periods of low event volume for tools. This mart is dependent on the [tool\_usage\_metrics\_archive](/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/tool-usage-metrics/tool-usage-metrics-archive.md) mart, filtering for periods of low event volume for a tool based on the *low\_events\_flag* field. If the tool is flagged as having low events for at least one hour, the occurrence is included in the *tool\_low\_events* mart. This mart is updated hourly.

## **BQ Prod Dataset Locations**

* mart\_general

## Interactive Mart Dependency Diagram <a href="#user-content-schema" id="user-content-schema"></a>

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_low_events.svg)
{% endhint %}

<figure><img src="/files/8Od3MQqtnYT3AQi5Ojwy" alt="The construction of the mart_general.tool_low_events data mart defined in the UDP marts repository"><figcaption><p>mart_general.tool_low_events</p></figcaption></figure>

## Schema <a href="#user-content-schema" id="user-content-schema"></a>

### **mart/general/tool\_low\_events**

| Field name         | Type     | Description                                                                                |
| ------------------ | -------- | ------------------------------------------------------------------------------------------ |
| ed\_app\_id        | STRING   | The EdApp ID of the tool.                                                                  |
| ed\_app\_reporting | STRING   | The reporting name for the EdApp ID, i.e. Canvas or Kaltura.                               |
| start\_run\_hour   | DATETIME | The first hour the tool was flagged as having low event counts for a period of low events. |
| end\_run\_hour     | DATETIME | The last hour the tool was flagged as having low event counts for a period of low events.  |
| num\_hours         | INTEGER  | The number of hours the period of low events occurred for the tool.                        |
| is\_ongoing        | BOOLEAN  | If the period of low events for the tool is still ongoing as of the current hour.          |