Automated Intermodal On-Time Performance Reporting
Every Monday, WebRun opens Rail Command, pulls the prior week's completed intermodal shipments, calculates on-time performance by lane and carrier, writes the results to a Google Sheets report, and posts a summary to Slack so your team can spot underperforming lanes fast.
How do I automatically generate a weekly intermodal on-time performance report by lane?
WebRun pulls last week's completed intermodal shipments from Rail Command every Monday, calculates on-time performance by lane and carrier, writes the results to Google Sheets, and posts a Slack summary with underperforming lanes highlighted, so your team can act on service trends before customers raise them.
- Underperforming lanes are surfaced every Monday before customers escalate
- On-time rates are tracked by lane and carrier week over week
- The full team sees a Slack summary without logging into the TMS
Built for intermodal operations managers · freight performance analysts · carrier relations teams · supply chain 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
railinfo.rsilogistics.comin a real browser with your saved login - no setup, no API keys. -
1
RSI Logistics Rail Command - pull completed shipments from the prior week
rsilogistics.com
WebRun opens RSI Logistics Rail Command to pull completed shipments from the prior week. - Open Rail Command and filter completed shipments to the prior 7 days
- For each shipment, capture the lane, carrier, scheduled arrival date, and actual arrival date
- Identify shipments that arrived after their scheduled date and calculate the days late
- Group results by lane and carrier
Done when Last week's completed shipments are grouped by lane and carrier with on-time status for each.
-
2
Google Sheets - write on-time performance report by lane and carrier
google.com
WebRun opens Google Sheets to write on-time performance report by lane and carrier. - Open the OTP report sheet and append last week's data in a new section
- Calculate on-time percentage per lane and per carrier
- Highlight lanes or carriers below the 90 percent on-time threshold
- Add a trend column showing improvement or decline vs. the prior week
Done when The Google Sheets OTP report is updated with last week's performance data.
-
3
Slack - post weekly OTP summary to operations channel
slack.com
WebRun opens Slack to post weekly OTP summary to operations channel. - Post a weekly OTP summary to the operations Slack channel
- Lead with the overall on-time rate, then list the top three underperforming lanes
- Include a link to the full Google Sheets report
Done when The Slack summary with last week's OTP data is posted to the operations channel.
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 for an intermodal shipment?
On time means the actual arrival date at the destination matches or precedes the scheduled delivery date recorded in Rail Command. Anything arriving after that date is counted as late.
Can I set the on-time threshold to something other than 90 percent?
Yes. The threshold is configurable, so you can set it to whatever level your service agreements require and the report will flag lanes below that bar.
Does it send the report to customers?
No. The report and Slack summary are internal only. If you need a customer-facing version, WebRun can draft one for your review before you send it.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.