Benchmark report
Updated 8 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 minimise the risk of overpaying for freights.
Benchmark report navigation
From the main menu, select the BI Reports module, and then open the Benchmark tab.
The report consists of 5 main sections:
- KPI - in the upper part of the report presenting aggregated values.
- Loading Country and Unloading Country maps
- Loading Country - the map shows the loading countries of accepted freights.
- Unloading Country - the map presents the unloading countries.
- Price vs Offers chart - a line chart showing the trend line of freight prices together with the number of offers on a given day
- Exact route list - allowing you to select a specific direction.
- List of offers - a list of company employees who made transactions on the Platform including information on freights and amount of offers.
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.
Loading Country and Unloading Country maps
The report runs automatically on the largest number of accepted freights at the unloading location (PL in this case).
- Loading Country map displays the number of loadings of accepted freights in each country in the time interval specified by the filter .
The numerical values and color saturation correspond to the number of accepted freights in a particular country.
- Unloading Country map
The map presents the countries in which transactions have been concluded for freights the loading location of which corresponds to the Loading Country indicated on the map. The higher the color saturation, the more transactions have been made. The map is displayed based on the Price per km parameter.
Select the country and the rest of the report data will be adjusted to display the data relevant to the chosen country.
If you do not indicate a country, the rest of the report will include aggregate data for all countries.
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. Please note that when you select a loading country above Loading and Unloading Maps in the top bar, you will find a list of the routes that began in the chosen country.
Once a given route is selected, the data is narrowed down to that particular choice.
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.
Exact route list
As rates can vary from route to route, the most precise result is provided by the Exact route filter. It allows you to filter out a specific route. The filter adapts to the choices you make using maps and the freight negotiation chart.
Once you have selected the direction of your choice, the remaining report data will be narrowed down to the criteria specified by the Exact route.
List of offers
This part of the report presents the number of accepted freights per route.
The data is presented in the form of a table, which consists of the following columns:
- Employee - if you narrow the data to a specific direction, the names of employees publishing in that direction will be displayed.
- Freight number - a list of freights published by a given employee.
- Distance (KM) - the total distance in kilometers. You can check how many kilometers were traveled as part of a given transport order.
- Responses - the number of offers submitted by carriers,
- Accepted price - the final price accepted for the a given freight,
- Average price per KM - the average price per kilometer (depending on the length of the route),
- 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.
Additional functions
- "i" icon - hover the mouse cursor over the icon to see details of the data range.
