# 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](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts/tool-usage-metrics/tool-usage-metrics-archive) 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](https://resources.unizin.org/products/data-and-analytics/unizin-data-platform/data-stores/data-marts).

{% 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="https://3709019308-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FKYwtHNGgdPXS3PWAlZUr%2Fuploads%2FMtI5u9ktZDPWAvGPGTiX%2Fmart__general__tool_low_events%20(1).svg?alt=media&#x26;token=4bf643b4-f86d-44de-ac31-039a8a6e9aee" alt=""><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.          |