Weekly On-Time Delivery Report
Every Monday, WebRun opens ShipStation, pulls all shipments delivered in the past 7 days, calculates on-time delivery rates by carrier and service level, updates your performance scorecard in Google Sheets, and posts the weekly summary to Slack so you can spot trends and hold carriers accountable.
How can I automatically get a weekly on-time delivery report by carrier?
Every Monday, WebRun opens ShipStation, pulls all shipments delivered in the past seven days, calculates on-time delivery rates by carrier and service level, updates your performance scorecard in Google Sheets, and posts the weekly summary to Slack — so you can hold carriers accountable with data.
- On-time delivery rates calculated per carrier every week without manual effort
- Trends visible over time so underperforming carriers are easy to spot
- Team briefed in Slack before the week begins
Built for logistics managers · e-commerce operations teams · supply chain analysts · fulfilment managers
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
ship.shipstation.comin a real browser with your saved login — no setup, no API keys. -
1
ShipStation — pull last week's delivered shipments
shipstation.com
WebRun opens ShipStation to pull last week's delivered shipments. - Open ShipStation and filter to Orders delivered in the past 7 days
- For each delivered order, capture the carrier, service level, ship date, promised delivery date, and actual delivery date
- Flag any shipment where the actual delivery date is after the promised date
Done when All last-week deliveries are captured with on-time status by carrier and service level.
-
2
Google Sheets — calculate on-time rates and update scorecard
google.com
WebRun opens Google Sheets to calculate on-time rates and update scorecard. - Open the Carrier Scorecard sheet and add a new weekly row
- Calculate on-time delivery rate per carrier and service level
- Update the rolling 4-week trend columns so you can see if performance is improving
- Highlight any carrier or service falling below your SLA threshold in red
Done when The scorecard is updated with this week's rates and 4-week trends.
-
3
Slack — post weekly performance summary
slack.com
WebRun opens Slack to post weekly performance summary. - Post a weekly summary to #logistics with each carrier's on-time rate and a comparison to last week
- Call out any carrier or service below your SLA with a flag so your team can follow up
Done when Your team has this week's carrier scorecard and knows which relationships need attention.
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?
Delivery on or before the carrier's promised delivery date. You can tighten this to "by the customer-promised date" — just tell WebRun which date field to use as the benchmark.
Can I compare my own warehouses, not just carriers?
Yes — add an origin filter to break out performance by fulfilment location. Useful if you ship from multiple sites and want to compare pick-and-pack speed.
How far back does the history go?
ShipStation stores your full order history, but WebRun processes one week at a time and appends to your scorecard sheet. Over time you build a complete trend dataset you own.
Related templates
Put this on autopilot.
Turn it on in minutes — or have our team set it up for you.