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 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

The following visualization shows the construction of this data mart defined in the UDP marts repository. More information on the repository and diagram can be found on this marts page.

Click here to open the interactive chart.

mart_general.tool_low_events

Schema

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.