Automated Opendock Truck Dwell Time Report
Every Monday, WebRun opens Opendock, calculates the dwell time for every appointment completed in the prior week by subtracting check-in from check-out, groups the results by carrier and door, and writes a ranked dwell time report to Google Sheets so your operations team can pinpoint where loading or unloading is taking longest.
How do I automatically track and report truck dwell time at my dock each week?
WebRun pulls every completed Opendock appointment from the prior week every Monday, calculates each truck's dwell time from check-in to check-out, and writes a ranked report to Google Sheets sorted by average dwell per carrier and door. High-dwell carriers are flagged automatically so your operations team can tackle the worst turnaround times first.
- Highest-dwell carriers are ranked and visible every Monday morning
- Separate inbound and outbound dwell times reveal which direction is slowest
- Weekly data accumulates in Google Sheets for trend analysis and carrier conversations
Built for warehouse managers · operations directors · dock supervisors · transportation 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
opendock.comin a real browser with your saved login - no setup, no API keys. -
1
Opendock - calculate dwell time for each completed appointment
opendock.com
WebRun opens Opendock to calculate dwell time for each completed appointment. - Open Opendock and pull all completed appointments from the prior week
- For each appointment, calculate dwell time as the difference between check-out and check-in
- Group results by carrier, compute average and maximum dwell time per carrier and per door
Done when Average and maximum dwell times are calculated for every carrier and door from the prior week.
-
2
Google Sheets - write ranked dwell time report by carrier and door
google.com
WebRun opens Google Sheets to write ranked dwell time report by carrier and door. - Open the dwell time tracking Google Sheet
- Append the prior week's data with carrier, appointment count, average dwell, and maximum dwell columns
- Sort by average dwell descending and highlight carriers above your target threshold
Done when This week's dwell time data is written to Google Sheets with high-dwell carriers ranked at the top.
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 is dwell time and how is it calculated?
Dwell time is the total elapsed time from when a truck checks in at your dock to when it checks out. WebRun calculates it from the Opendock appointment record for every completed appointment in the week.
Can it separate inbound and outbound dwell times?
Yes. WebRun groups dwell time by appointment type so you can see whether inbound receiving or outbound loading is driving the longest stays at each door.
Will it notify high-dwell carriers about their performance?
No. The dwell report goes to an internal Google Sheet for your operations review. Any carrier-facing communication is drafted for a human to review before sending.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.