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 Benchmark report is a price summary for accepted freights sent to subcontractor groups defined on the Platform, Fixed routes, and Smart Match.

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:

  1. KPI - in the upper part of the report presenting aggregated values.
  2. 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.
  3. Price vs Offers chart - a line chart showing the trend line of freight prices together with the number of offers on a given day
  4. Exact route list - allowing you to select a specific direction.
  5. 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.​

  1. ​Click the filter symbol in the right column to open the filter settings for the Benchmark report.

Filter settings
In the filters you can set:

- 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).

  1. 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.

​After clicking on the code of the selected loading country in the top bar, the remaining report charts will automatically adjust, displaying data corresponding to that loading location.
  1. 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.

If you accept more than 1 freight on a single day, the trend will present the median price of accepted freights.

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.

Example: If you are looking for a route from Spain to Poland , select ES-PL at the top right of the report. This will narrow down the list and make it easier for you to find the route you want.

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.

The data displayed in the Exact Route list is affected by filters from the Price vs Offers chart.

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.

When you select a particular route, the data in these categories will be narrowed down to your choice.

Additional functions

  1. "i" icon - hover the mouse cursor over the icon to see details of the data range.


How Did We Do?

UP!
Powered by HelpDocs (opens in a new tab)