Benchmark report

Updated 4 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 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:

  1. KPI - in the upper part of the report presenting aggregated values.
  2. Employee Summary table.
  3. Exact address table ​- a list that will help you choose a specific direction.
  4. 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.​

  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.
Under KPI, you will find a note about the Median Market Price (MMP) - this is the middle value of all transaction prices on the Trans.eu Platform. It shows the historical price value for similar freights.

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.

Once you click on the name, the remaining parts of the chart will adapt to your selection.

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.

Click on the selected direction to see detailed data in the Price Offers section.

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.

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.

MMP chart legend

Brown bar - number of freights above MMP.

Yellow bar - number of freights below MMP.

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)