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. |
- 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.
Navigation through the Directions report
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:
- KPI's tiles - showing the values of the entire company
- Directions chart - showing costs for the top 5 directions.
- Exact directions table - showing costs in exact directions.
- Maps with places of loading and unloading.
- 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.
- Click the filter symbol in the right column to open the filter settings of the Directions report.
Filter settings
- 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.
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).
In the table, you will find detailed data presented using indicators and columns:
- Name of direction - 5 most popular directions are displayed by default.
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.
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.
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 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
- The "i" icon - hover over the icon to see detailed information about the range of data.
