Benchmark report
Updated 18 hours ago
by
Katarzyna
Who can use this function? Function available to CargoON and Trans for Forwarders users who have purchased the complementary product: Business Intelligence Reports. Reports are visible to users selected by the company ordering access. Learn more about BI Reports. |
The data in the report is grouped into categories, ranging from general to detailed.
Accepted freights are those that ended with a transaction concluded on the Trans.eu Platform. The data is presented according to the unloading date.
Currency exchange rates are calculated on the unloading date.
The Benchmark Report will help you determine the value of freight rates that your company has achieved through negotiations on the Trans.eu Platform.
Based on data from the Benchmark report you can:
- stay up to date and respond to pricing trends within the company,
- compare freight rates,
- compare the performance of your employees,
- verify the progress of negotiations
- optimise costs and minimize the risk of overpaying for freights.
Benchmark report navigation
From the main menu, select the BI Reports module, Prices tab and then open the Benchmark tab.
The report consists of 4 main sections:
- KPI - in the upper part of the report presenting aggregated values.
- Employee Summary table.
- Exact address table - a list that will help you choose a specific direction.
- Price vs Offers chart - a line chart showing the trend line of freight prices together with the number of offers on a given day
Setting the scope of analyzed data
You can define the scope of analyzed data using filters.
- Click the filter symbol in the right column to open the filter settings for the Benchmark report.
Filter settings
- Time range for the displayed data (Unloading date) - you can specify the time range for the unloading date,
- Publication type - including the ones to the exchange (Exchange), to selected/groups (Groups), multi-publications, direct, to a fixed route (Fixed routes), SmartMatch,
- Employee,
- Transport direction of your freight by country (Country directions) - defined by the country code,
- Body type,
- Freight type,
- Capacity range,
- Currency - the currency in which prices are presented is displayed above the KPIs and next to selected indicators. Two currencies are available: EUR and PLN.
- Carrier name,
- Freight number,
- External ID.
KPI - Benchmark
In the upper part of the report, we present the sum of key metrics relating to the entire company. The values are presented for the time period specified in the filters.
Hover over a selected tile, and a tooltip will appear with a description explaining the value presented in the tile.
What do the tiles mean:
- Accepted freights - the total number of published freights, the publication of which resulted in a transaction.
- Freights with negotiation - the total number of freights under negotiation.
- Total km - the number of kilometers traveled.
- Money paid - the total cost of all accepted freights.
- Cost per freight - the cost of one freight in the analyzed time period.
- Cost per km - the average cost of freight calculated for each kilometer traveled.
MMP is marked with a color from yellow to brown - it indicates the difference between our price and the market median. The more intense the color, the greater the difference.
We refer to our transport price - if the difference is bigger, it means a more favorable situation for us. After hovering the cursor over the selected part of the charts in the report, you will find a broader explanation in the tooltip indicating that, for example:
✔ the cost was below the market median,
❌ the cost was above the market median.
Employee Summary table
It allows you to track employee performance in terms of generated turnover and the number of accepted freights.
Exact address table
This part of the report presents the number of accepted freights for a given direction.
The data is presented in the form of a table consisting of the following columns:
- Country Direction - the direction of the route.
- Exact address - addresses of loading and unloading locations.
- Accepted freights - the number of accepted freights.
- Median Accepted Price - the average value of the offers actually accepted.
- Median Market Price - the average value of all rates.
- Cost per km - the average cost of freight calculated for each kilometer traveled.
- MMP per km - the average value of all rates for each kilometer traveled.
- Min. offer - the lowest price offer that was proposed in the negotiation process for a given freight.
- Max. offer - the highest price offer that was proposed in the negotiation process for a given freight.
Price vs Offers chart
In the top bar, you can find a list of the most frequently selected routes along with the number of accepted freights.
Once a given route is selected, the data is narrowed down to that particular choice.
In this section you will find two charts - Price vs offers and MMP chart.
Chart legend:
Blue line - illustrates the median price of accepted freight. These are the values of accepted freights on the days when a formal transaction took place on the Platform. If there is no transaction on a given day, it will not be included on the X axis.
Grey bar - the range of price offers received from carriers. Its amount depends on the range of prices offered by the carriers.
The value above the bar is the number of price offers received for a given freight or freights.
If you click on the bar, the other parts of the report will adjust and display the relevant data.
MMP chart legend
Brown bar - number of freights above MMP.
Yellow bar - number of freights below MMP.
Additional functions
On the right side of the reports, you will find a column with additional features:
- Filters (we explained how they work in the section of the article on defining a data range).
- Initial settings button - with one click you can clear applied filters (except currency) and instantly restore the report to its original appearance.
- "i" icon - hover the mouse cursor over the icon to see details of the data range.
