SBMTD | Notification for when null IDs surpass given threshold

[Indiajar]

@charlie-costanzo ## User story / feature request

As a demonstration partner for the payments dashboard, the agency would like to receive a notification when null IDs surpass given threshold. This measure will alert agencies if/when the number of missing route ids exceeds the typical amount. It also helps to identify hardware connection issues.

Acceptance Criteria

SBMTD typically expects an absolute count of 20-45 unlabeled routes. 10% has been identified as a satisfactory threshold for metabase alerts. These alerts can be weekly so as to not overwhelm the agency.

Notes

Please enter any additional information that will facilitate the completion of this ticket. For example: Are there any constraints not mentioned above? Are there any alternatives you have considered?

[charlie-costanzo]

hey @Indiajar do we know what email address(es) we want this alert to go to?

[charlie-costanzo]

done!