Automated Heavy Haul On-Time Performance Report
Every Monday, WebRun opens ProMiles, pulls completed moves from the prior week, compares planned versus actual delivery times for each, calculates on-time performance by route and customer, logs the results to a Google Sheet, and posts a summary to Slack.
How do I automatically generate a weekly on-time performance report for heavy haul moves?
WebRun opens ProMiles every Monday and pulls all moves completed in the prior week, comparing planned against actual delivery dates for each. It calculates on-time performance by route and customer, logs results to Google Sheets, and posts a concise summary to Slack so your ops team can identify patterns and act on them.
- Weekly on-time rate calculated automatically without manual data pulls
- Late routes and repeat offender customers identified each Monday
- Historical trend data accumulates in Google Sheets for quarterly reviews
Built for heavy haul carriers · ops managers · customer service teams · transport operations leads
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.promiles.com/permit-managerin a real browser with your saved login - no setup, no API keys. -
1
ProMiles - pull completed moves from the prior week
promiles.com
WebRun opens ProMiles to pull completed moves from the prior week. - Open ProMiles and navigate to the completed moves section
- Filter for moves completed in the prior 7 days
- For each move, capture the load ID, customer, route, planned delivery date, and actual delivery date
Done when All completed moves from the prior week are captured with planned and actual delivery dates.
-
2
Google Sheets - calculate and log on-time performance metrics
google.com
WebRun opens Google Sheets to calculate and log on-time performance metrics. - Open the on-time performance tracking sheet
- Append rows for each completed move with load ID, customer, route, planned date, actual date, and on-time status
- Calculate the on-time percentage for the week overall and broken down by customer and route
Done when The performance sheet is updated with this week's moves and on-time rates are calculated.
-
3
Slack - post weekly performance summary
slack.com
WebRun opens Slack to post weekly performance summary. - Post a summary to the ops Slack channel with the weekly on-time rate
- Highlight the top 3 on-time routes and the 3 routes with the most delays
- Note any customers with back-to-back late deliveries for follow-up
Done when The ops team has this week's on-time performance summary in Slack.
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
How does it determine if a move was on time?
It compares the planned delivery date recorded in ProMiles against the actual delivery date. Any move that delivered on or before the planned date is counted as on time.
Can it send the report to customers as well?
The automatic report goes only to your internal Slack channel. If you want to share performance data with a customer, your team would review the Google Sheet first and send it manually.
How far back does the historical data go?
The Google Sheet accumulates each week's results, so your trend data grows over time. You can filter the sheet by any date range, customer, or route for ad-hoc analysis.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.