Automated LTL Carrier On-Time Performance Reporting
Every Monday, WebRun pulls the prior week's LTL delivery data from SMC3, calculates on-time performance rates by carrier and lane, writes the scorecard to Google Sheets, and sends the formatted weekly report to your logistics team via Mailchimp.
How do I get an automatic weekly LTL carrier on-time performance report?
WebRun pulls the prior week's LTL delivery data from SMC3 every Monday, calculates on-time performance rates by carrier and lane in Google Sheets, and sends a formatted weekly scorecard to your logistics team via Mailchimp so carrier performance trends are visible and actionable without any manual data pulling.
- Carrier performance is reviewed every Monday without any manual data pulling
- Underperforming carriers are flagged before they become a customer service problem
- Historical trend data accumulates in Google Sheets for quarterly carrier reviews
Built for logistics managers · LTL shippers · 3PLs · supply chain analysts
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.smc3.comin a real browser with your saved login - no setup, no API keys. -
1
SMC3 - pull prior week LTL delivery and transit data
smc3.com
WebRun opens SMC3 to pull prior week LTL delivery and transit data. - Open SMC3 and pull all LTL shipments delivered in the prior calendar week
- Capture carrier SCAC, promised delivery date, actual delivery date, PRO number, and lane
- Flag any shipment where actual delivery exceeded the SMC3 transit time standard
Done when The full set of prior-week deliveries is captured with on-time status for each shipment.
-
2
Google Sheets - calculate on-time rates by carrier and lane
google.com
WebRun opens Google Sheets to calculate on-time rates by carrier and lane. - Open the carrier scorecard spreadsheet in Google Sheets
- Calculate on-time delivery percentage by carrier and by lane for the week
- Append the weekly totals to the historical trend tab
- Highlight any carrier below the 90% on-time threshold
Done when The scorecard sheet is updated with this week's rates and the historical trend is extended.
-
3
Mailchimp - send formatted weekly scorecard to the team
mailchimp.com
WebRun opens Mailchimp to send formatted weekly scorecard to the team. - Populate the weekly scorecard email template in Mailchimp with this week's on-time rates
- Send the report to the logistics team distribution list
- Include a link to the Google Sheets trend view for deeper analysis
Done when The weekly on-time performance report is in the logistics team's inbox.
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 define on-time for each carrier?
It compares the actual delivery date against the transit time standard from SMC3, which carries carrier-published transit commitments for over 300 LTL carriers.
Can I filter the scorecard to specific lanes or customers?
Yes. You can scope the report to a set of origin or destination zip codes, a carrier list, or a customer segment so the scorecard stays relevant to your network.
Will the email go to external stakeholders automatically?
The default setup sends to your internal logistics team list. If you want to share results with customers or carriers, add those recipients to the Mailchimp list and WebRun will include them on the next run.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.