Generate a weekly on-time performance report for your yard
Every Monday, WebRun opens YardView, pulls gate arrival, dock assignment, and departure timestamps for all loads from the prior week, calculates on-time performance by carrier, writes the results to a Google Sheet, and sends your team a Telegram summary with the top and bottom performers.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically generate a weekly carrier on-time performance report from my yard management system?
Every Monday, WebRun pulls gate arrival and departure timestamps from YardView for the prior week, calculates on-time performance by carrier, writes a ranked report to Google Sheets, and sends your ops team a Telegram summary of the top and bottom performers before the morning meeting.
- Weekly carrier OTP report is ready in Google Sheets before Monday morning ops meetings
- Bottom-performing carriers are flagged automatically for follow-up
- Week-over-week trend is visible without manual spreadsheet work
Built for yard managers · logistics operations teams · carrier relations managers · warehouse operations
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.yardview.comin a real browser with your saved login - no setup, no API keys. -
1
YardView - pull gate and dock timestamps
yardview.com How to Automate YardView
WebRun opens YardView to pull gate and dock timestamps. - Open YardView and filter completed loads for the prior calendar week
- Extract gate arrival time, scheduled arrival time, dock assignment time, and departure time for each load
- Group the data by carrier for performance calculation
Done when All prior-week loads have timestamps captured and grouped by carrier.
-
2
Google Sheets - write ranked OTP report
google.com How to Automate Google Sheets
WebRun opens Google Sheets to write ranked OTP report. - Open the on-time performance sheet and add a new tab for the reporting week
- Calculate on-time percentage for each carrier: loads arriving within the scheduled window divided by total loads
- Rank carriers from highest to lowest OTP and highlight any carrier below 90 percent
Done when The OTP sheet has a ranked, highlighted carrier report for the prior week.
-
3
Telegram - share top and bottom performers
telegram.org How to Automate Telegram
WebRun opens Telegram to share top and bottom performers. - Send a Telegram message to the ops channel with the top three and bottom three carriers by OTP
- Include each carrier's on-time rate, total loads, and week-over-week change
- Link to the full Google Sheet for the complete ranked list
Done when Ops team has a Telegram summary of carrier OTP with the best and worst performers highlighted.
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
What counts as on time in the report?
It compares the actual gate arrival time in YardView against the scheduled appointment window. You can adjust the tolerance window in your WebRun setup.
Does it send the report to carriers?
No. The report is posted internally to Google Sheets and Telegram for your ops team only. Any carrier communication would need to be drafted and sent by your team.
How many weeks of history does the sheet keep?
Each Monday run adds a new tab for the prior week, so the workbook builds a rolling history automatically. You can archive or reference any prior week without losing the current view.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.