Automated TeleTracking ED Throughput Scorecard
Every night, WebRun opens TeleTracking, pulls the prior day's boarding hours, LWBS rate, door to provider time, and length of stay, logs them to a Google Sheet scorecard against the 30 day rolling average, and posts the summary to Slack ahead of the morning huddle.
How do I get a daily automated scorecard for ED throughput metrics?
Every night, WebRun pulls the prior day's key throughput metrics from TeleTracking, including boarding hours, LWBS rate, and door to provider time, and logs them to a Google Sheet scorecard alongside the 30 day rolling average. It then posts the summary to Slack before the morning huddle, so ED leadership walks in already knowing what moved and in which direction.
- Leadership walks into the morning huddle already knowing what moved overnight
- Every key metric is compared against its own rolling average, not a raw number in isolation
- A full historical scorecard builds itself with zero manual data entry
Built for ED leadership · hospital throughput committees · quality improvement teams · emergency department directors
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.teletracking.comin a real browser with your saved login - no setup, no API keys. -
1
TeleTracking - pull the day's throughput numbers
teletracking.com
WebRun opens TeleTracking to pull the day's throughput numbers. - Open TeleTracking after midnight and pull the prior day's full set of throughput metrics
- Include average boarding hours, LWBS rate, door to provider time, and average length of stay
- Compare each metric against its 30 day rolling average
- Note which metrics moved in the wrong direction
Done when All key throughput metrics for the prior day are captured and compared to the rolling average.
-
2
Google Sheets - log the scorecard
google.com
WebRun opens Google Sheets to log the scorecard. - Open the Daily ED Throughput Scorecard sheet
- Append yesterday's metrics as a new row alongside the rolling average
- Update the trend chart so the pattern is visible at a glance
Done when The scorecard has yesterday's row logged with an updated trend chart.
-
3
Slack - post the summary for the morning huddle
slack.com
WebRun opens Slack to post the summary for the morning huddle. - Post the scorecard summary to the ED leadership Slack channel before the morning huddle
- Lead with any metric that moved the wrong direction against its rolling average
- Link to the full Google Sheet scorecard for the detail
Done when ED leadership has the scorecard summary in Slack ahead of the morning huddle.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Which metrics does the scorecard track?
Average boarding hours, LWBS rate, door to provider time, and average length of stay, each compared against its own 30 day rolling average so a single bad day does not look like a trend.
Is the scorecard sent anywhere outside the hospital?
No. It is logged to your own Google Sheet and posted only to your internal ED leadership Slack channel.
Can we add our own metrics to the scorecard?
Yes. Tell WebRun which additional TeleTracking metrics you track and it will add them as new columns in the same daily scorecard.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.