Overview
The Batch Rates feature lets you request predictions for up to 2500 lanes at once by uploading a spreadsheet or .csv. Results will be emailed to you as a spreadsheet.
Requesting Batch Rates
This looks like a lot of steps, but that's only because we've listed all of the many available options for customizing your batch prediction. It's actually pretty easy, as you'll see when you start to use it. The short version is that, starting from the Batch tab in your Rates Intelligence UI, you'll be downloading a template, filling it out with lane information, and uploading it again.
At the top of your screen, click the Batch tab.
Under How it Works, click Download Template. (If you've used Universal Batch Rating before, you can update your existing file. You can also download the template below under Templates).
Open the template spreadsheet and fill in details on your lanes. The headers (load_id, pickup_date, etc.) need to stay the same. Some fields are required, and some are optional. Required fields are in bold on the table below.
Save your spreadsheet with a new file name, as either an .xslx or .csv file.
Back on the Batch tab, select your upload options. To divide your report into tabs by region, toggle on Split Batch by Pages.
Field | Description |
load_id | A unique identifier for the load (PRO#, ID). This field is optional. |
pickup_date | The pickup date in YYYY-MM-DD format. If this field is empty, the system will default to the next calendar date. |
pickup_time | The pickup time in 24-hour format. For instance, 2:30 PM would be 14:30. This field is optional. |
transport_type: | VAN, REEFER, or FLATBED. This field is required. |
origin_city origin_state OR origin_zip | An origin city and state are required, but if you leave these fields blank and fill in only origin_zip, the city and state will be upated automatically. |
destination_city destination_state OR destination_zip | A destination city and state are required, but if you leave these fields blank and fill in only destination_zip, the city and state will be upated automatically. |
weight | Total weight of the load in pounds |
commodity | Description of the cargo |
Adding historical data to your results
Toggle on Add Statistics to the Report.
Click the cog wheel icon to open the Output Configuration window. Note that the historical data you select here will not appear unless Add Statistics to the Report is toggled on.
In the Output Configuration window, check any historical information you’d like to include for each predicted lane:
Historical average, minimum and maximum buy rate & number of reports
Historical average margin, markup and sell rate
Last rate and date
Select a geography range for your historical information. Note that this will apply not to your predictions, but only to any historical information you opt to include., and rate mode you’d like to include. Note that the statistics you select will not appear unless Add Statistics to the Report is toggled on:
Mkt: includes the larger market area
3d ZIP: includes lanes that share their first 3 ZIP code digits with the lane predicted
Lane: only data on the lanes in the spreadsheet
Select a date range for your historical information
Select whether to include historical data by Flat Rate or Per Mile
Click Save.
Click Choose and Upload File. If the system doesn't automatically download your predictions spreadsheet, click Download.
That's it! Your batch prediction is ready to go!
Reading Your Batch Prediction
Your batch prediction will include:
Miles
Fuel Surcharge: a prediction of fuel cost for the load based on market averages. The Fuel Surcharge is included in case you need to itemize costs for a customer. It may differ from the fuel cost already included in the Verified Buy Rate, which is based on data from your specific brokerage.
Verified Buy Rate: the predicted buy rate on a lane for your particular brokerage. This rate is influenced by your historical data and reflects your company’s individual buying behavior against the current market conditions, but is also often influenced by external data, such as the data we receive from the Triumph network. It does include fuel cost.
Low Rate: the lowest rate that the AI predicts might result in a successful booking
High Rate: the highest rate that the AI predicts could be possible for the load
Confidence Level: a prediction of each rate's accuracy
Network Rate: the expected rate in the market based on data from the Triumph network. It can be lower or higher than the Verified Buy Rate, depending on how your brokerage books freight on the underlying lane or similar lanes.
Network Confidence Level: an AI-generated score representing the likelihood that any brokerage within the Triumph network will be able to buy a specific lane at a specific price.
Any historical data you selected in Step 7 will also be included.
If the AI cannot provide a prediction for a particular lane, you'll find the reason the lane couldn't be calculated in the Description column.