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.
Schema
mart/general/tool_usage_metrics_archive
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