Directions report

Updated 5 days ago by Katarzyna

Who can use this function?

The function is available for CargoON and Trans for Forwarders users who have purchased a supplementary product: BI reports.

Reports are visible to selected users indicated by the company requesting access.

Learn more about BI reports.

The Directions report is part of a group of price reports that enable comprehensive analysis of freight costs and rates carried out via the Trans.eu Platform. With these reports, you can:
- monitor price trends,
- optimize costs,
- assess the effectiveness of negotiations.

Data source: Data comes from the Freights module.
Data scope: Reports are based on data obtained from the Freights module and cover all freights for which a formal transaction was concluded.

Cost calculation is based on the unloading date.
Currency exchange rates are calculated on the unloading date.

The Directions report will allow you to check in which directions your costs generated using the Trans.eu Platform are increasing and in which they are decreasing.

With the report you can:

  • see how your costs are distributed across:
    • particular countries in which you carry out transports,
    • employees who manage transport directions,
    • amount of freights,
    • kilometers traveled ,​
    • ​time range.
  • monitor cost increases and decreases, analyze where and why they occur.
  • control the number of transactions and related costs.
  • check what share your employees have in the costs related to managing particular directions.

In the main menu, select the BI Reports module, the Prices tab, and then open the Directions tab.

After clicking on the tab, you will see a report consisting of 5 main sections:

  1. KPI's tiles - showing the values of the entire company
  2. Directions chart - showing costs for the top 5 directions.
  3. Exact directions table - showing costs in exact directions.
  4. Maps with places of loading and unloading.
  5. Employees - a table showing the share of employees in the costs in a given direction.

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 of the Directions report.

Filter settings
In the filters you can set:

- Time range of displayed data (Unloading date) - you can specify the time range for the unloading date.
- Publication type - including the ones to the exchange (Exchange), to companies (Company), direct.
- Employee,
- Transport direction of your freight by country (Country directions) - defined by the country code,
- Body type,
- Freight type,
- Capacity range,
- Currency - currency in which prices are shown is displayed above the KPI and with selected indicators. There are two currencies to choose from: EUR and PLN.
- Carrier name,
- Freight number,
- External ID.

KPI's tiles

The upper bar of the report shows the sum of values for the time period specified in the filters. Values ​​are presented for the time period and currency 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.

Directions chart

Above the table, you will find the Select View drop-down list, which allows you to choose from three view options:

  • Loading place - you will get data showing costs at the loading place,
  • Unloading place - you will get data showing costs at the unloading place,
  • Loading-Unloading - data generated based on transport directions (from the loading place to the unloading place).

Choosing the appropriate option automatically adjusts the displayed data in the Directions and Exact Directions tables to the selected context.

In the table, you will find detailed data presented using indicators and columns:

  • Name of direction - 5 most popular directions are displayed by default.
If you want to see values for more directions, use the Show top N slider.
With filters discussed below, you can indicate the directions you are interested in.

  • The total number of accepted freights in a given direction (Accepted freights)
  • The total sum of costs in a given direction (Total km)
  • The total sum of kilometers on routes accepted for a given direction (Money paid) - it is the cost per freight (the quotient of accepted freight and the total cost for the direction),
  • Average cost of one freight on a given route (Costs per freight),
  • Average cost per kilometer - total costs have been converted to the total number of kilometers. These are general estimates.

Remember that the route may have intermediate places between the first and last place of loading. They are included in the costs, although we do not present them in the chart.

Exact Directions Chart

This part of the report is a deeper analysis of the data from the Directions section. You can analyze the number of negotiations and responses, number of accepted freights, their costs and kilometers, based on specific directions, including exact addresses.

The view of this part of the report depends on the settings in Select View in the Directions section.​

Loading/Unloading Countries Maps

On the maps, you can see the countries where freight operations took place.

Loading Countries - the map shows places of  loading. Unloading Countries - places of unloading.

The colors on the map show how many operations have been carried out in a given country - the darker the color, the more freights.

The values shown on the maps depend on the selected parameter - for example, you can specify whether you want to check which countries generate the highest costs for you or where the highest rates apply.

Above the maps, you will find a dropdown list Choose parameter, which allows you to filter the maps by:

  • number of accepted freights,
  • amounts spent on transport ,
  • amounts spent on transport broken down by freight,
  • amounts spent on transport broken down by kilometers traveled,
  • responses to published offers,
  • negotiations held,
  • difference between freight cost and market price.

Accepted vs Median Market Price chart

The bar chart shows the difference between the average accepted price and the average market price over the period specified by the filters.

It shows whether the accepted prices were above or below the average market prices.

Additional features​

  1. ​The "i" icon - hover over the icon to see detailed information about the range of data.​


How Did We Do?

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