Automated Ocean Freight Lane Capacity Digest
Every Monday, WebRun opens Terminal49, reviews recent shipment milestones across your active trade lanes, calculates average transit times and ETA deviation trends by lane for the past 4 weeks, logs the results to a Google Sheets lane performance tracker, and sends a capacity and transit time digest to your Telegram operations group.
How do I get a weekly report on ocean freight transit times and capacity trends by trade lane?
WebRun reviews your active trade lanes in Terminal49 every Monday, calculates 4-week rolling average transit times and ETA deviation rates for each lane, logs the results to a Google Sheets performance tracker, and sends a digest to your Telegram ops group flagging lanes where transit times are extending. Freight planners get a data-backed picture of capacity pressure each week without manual lookups.
- Lanes with worsening transit times are flagged every Monday before they affect delivery commitments
- 4-week trend data gives freight buyers evidence for carrier conversations and routing decisions
- Lane performance history accumulates in Google Sheets so seasonal patterns become visible over time
Built for ocean freight importers · logistics planners · freight procurement teams · 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
app.terminal49.comin a real browser with your saved login - no setup, no API keys. -
1
Terminal49 - pull transit time and milestone trends by trade lane
terminal49.com
WebRun opens Terminal49 to pull transit time and milestone trends by trade lane. - Open Terminal49 and filter shipments by each active trade lane: origin port to destination port
- For each lane, retrieve the last 4 weeks of completed shipments with their actual vessel transit times
- Compare transit times against the prior 4-week average to identify lanes where times are extending
- Note any lanes with a high proportion of ETA revisions in the past 2 weeks, which signals reliability pressure
- Capture carrier, lane, average transit time this week, 4-week average, and deviation in days
Done when Transit time and ETA deviation data for the past 4 weeks is captured for every active trade lane.
-
2
Google Sheets - update the lane performance tracker with 4-week trends
google.com
WebRun opens Google Sheets to update the lane performance tracker with 4-week trends. - Open the Lane Capacity and Performance tracker sheet
- Upsert each lane row with this week's average transit time, the 4-week rolling average, and the week-over-week change
- Color-code lanes where average transit time has increased by more than 2 days week over week
- Log the weekly data point in a historical tab so long-term trends are visible
Done when The lane performance tracker is updated with this week's transit time data and trend indicators for all active lanes.
-
3
Telegram - send the weekly lane capacity and transit time digest
telegram.org
WebRun opens Telegram to send the weekly lane capacity and transit time digest. - Send the weekly lane digest to the freight operations Telegram group
- Lead with lanes where average transit times have increased most versus last week
- Include the current average, the 4-week baseline, and the deviation for each highlighted lane
- End with a short list of lanes that are performing above the 4-week average for positive context
Done when The freight ops Telegram group has the weekly lane digest with transit time trends and flagged capacity pressure points.
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 trade lanes does it monitor?
It monitors the lanes your active Terminal49 shipments are routed on. The lanes are derived automatically from your shipment data, so you do not need to configure them manually.
Is transit time calculated from port of loading or vessel departure?
Transit time is measured from the vessel departure milestone at the origin port to the vessel arrival milestone at the destination port, which reflects true ocean transit time.
Can it alert me when a specific lane passes a transit time threshold?
Yes. When you set up the automation, specify a threshold in days for any lane you want to monitor closely. WebRun will flag that lane in the digest whenever the current average exceeds your threshold.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.