Tool Usage Metrics Archive

The tool_usage_metrics_archive mart is an archive of the tool_usage_metrics 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 repository. More information on the repository and diagram can be found on this marts page.

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.

Last updated