See your margin on every load without building a spreadsheet
Every morning, WebRun opens DAT One, pulls the previous day's completed loads with buy and sell rates, calculates the gross margin on each, and appends the results to your Google Sheets margin tracker so you can spot your best and worst-performing lanes at a glance.
- No credit card
- Under $0.01 per run
- Cancel anytime
How do I automatically track margin per load from DAT?
WebRun opens DAT One every morning and pulls the previous day's completed loads, including buy rates, sell rates, and accessorials. It logs each load to Google Sheets, calculates gross margin and margin percentage per row, and flags loads below your target threshold so you can see exactly which lanes and carriers are driving profit.
- Every load's margin visible in Google Sheets by 7:30 AM
- Low-margin loads flagged automatically for review
- Lane and carrier profitability trends visible week over week
Built for freight brokers · brokerage owners · operations managers · carrier sales reps
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
one.dat.comin a real browser with your saved login - no setup, no API keys. -
1
DAT - pull completed loads with buy and sell rates
dat.com How to Automate DAT
WebRun opens DAT to pull completed loads with buy and sell rates. - Open DAT One and filter completed loads from the previous business day
- Capture load ID, lane, carrier, equipment type, buy rate, and sell rate for each completed load
- Note any accessorial charges that affect margin
Done when All previous-day completed loads are captured with their buy and sell rate data.
-
2
Google Sheets - log margin per load to tracker
google.com How to Automate Google Sheets
WebRun opens Google Sheets to log margin per load to tracker. - Append each load as a new row in the margin tracker sheet
- Calculate gross margin (sell rate minus buy rate) and margin percentage for each row
- Flag any loads where margin fell below your configured threshold
Done when All yesterday's loads are logged in Google Sheets with margin calculated and low-margin loads flagged.
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 rates does it use to calculate margin?
It reads the buy rate (carrier cost) and sell rate (customer charge) directly from DAT One for each completed load, then calculates gross margin and percentage in Google Sheets.
Can it flag loads below a target margin?
Yes. Set your minimum acceptable margin percentage in the sheet, and WebRun highlights any load that falls below that threshold so you can investigate the lane or carrier pricing.
Does it include accessorial charges?
It captures any accessorial charges recorded in DAT One and includes them in the margin calculation so the numbers reflect your true net on each load.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.