Overview
The Batch Rating feature lets you request predictions for a large number of lanes at once by uploading a spreadsheet or .csv. Results will be emailed to you as a spreadsheet. The number of lanes is limited only by the size of the CSV, which should be under 100 MB.
Batch rating results are customizable. You can choose parameters for your predictions, such as a geographical level (predictions by lane or KMA) and whether to include market data.
You can also request batch predictions for flatbed hotshots and multi-stop loads, as well as long-term batch predictions.
Customizing your Batch Output
Batch predictions have a lot of flexibility. You can set parameters for both short- and long-term batch prediction in the Output Configuration window. Here's how:
In the Intelligence app, click the Batch tab:
Click Output Configuration:
Select your output options:
Click Save.
These options will remain in place until you change them.
Requesting Batch Rates
To obtain batch rates, you'll be downloading a template, filling it out with lane information, and uploading it again.
Open the template in Excel or Google Sheets and fill in details on your lanes.
The headers (load_id, pickup_date, etc.) must 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.
In the Intelligence app, click the Batch tab:
Follow the UI instructions to upload your .csv:
Click to download your results.
Field Definitions
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 |
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
Market Buy 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.
Market 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.
If the system cannot provide a prediction for a particular lane, you'll find the reason why in the Description column.