Carrier activity report

Updated 9 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 Carrier activity report is a part of a group of freight reports that provide a comprehensive insight into the company's activity in the Freights module.
With these reports, you can:
- Identify key trends and periods in which the company operates most effectively,
- Assess the efficiency of the best employees,
- Optimize actions related to freight publication.

Data source: data comes from the Freights module.
Data scope: the reports include published freights, covering the full process of their creation, contractors' responses, negotiations and final acceptance, as well as those that ended with the conclusion of a transaction on the platform.

The report presents the distribution of loads among individual carriers that execute your transport orders. It also shows the activity of these carriers in a given period and on a specific route.

The Carrier activity report data allows you to:

  • identify the most and least attractive destinations for carriers,
  • see how your employees perform in terms of negotiations, publications and transactions with carriers,
  • quickly review the history of cooperation with carriers,
  • track the cooperation with contractors in detail - how many of them your company works with on a given route and on which directions it works with the selected carrier.

Go to the BI Reports module and select the Carrier activity tab.

The report consists of 4 main sections:

  1. KPIs - key performance indicators.
Each value is calculated using data from a specific time period that you set using filters. By default, the report shows data from the last 30 calendar days.
  1. List of carriers - a list of all the carriers your company has approached with freight offers.
  2. Carrier's profile - a section where you can see details of your cooperation with the carrier.
  3. Carriers on the route chart - a chart showing how many carriers we work with on a given route.

Set the range of analysed data

Above the bar with KPIs, you can find information about the range of analyzed data.

You can specify it using the filters located on the right side of the report.

Filter settings

In the filters you can set:

- the time range for the displayed data (Choose calendar) - you can specify the time range for the publication date or 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,
- Offer status: Freights with response (Is response?), freights in negotiation (Is negotiation?), accepted freights  (Is accepted?). 

Note! This type of filter is contextual. If you do not have offers in negotiation, for example, this filter will not appear in your report. In case of multifreight publications, if the offer is partially accepted, it will be included in the accepted freights.

- Carrier name,
- Freight number,
- External ID.

KPI - Carrier activity

The report's top section displays the total value for your entire company.

Hover your mouse cursor over the KPI to see an additional hint:

  • Freights published - number of all freights published to carriers.
  • Freights with responses - number of freights in which carriers were interested,
  • Freights with Negotiations - total number of price offers received from carriers.
  • Accepted freights - total number of transactions concluded with carriers on the Platform.
  • Not accepted - total number of published freights for which no transaction was made on the Platform.
  • Money paid - total amount of transport costs paid to carriers when concluding a transaction on the Platform. The calculation of costs is based on the date of unloading the freight. Exchange rates are converted according to the date of unloading the freight.

List of carriers table

This is a tabular representation of the list of carriers to which freight offers were sent. It is sorted in descending order, so at the very top you will find the carriers with the greatest number of price offers.

In addition to the carrier's name, the table shows the number of offers made and freights accepted. Clicking on the name of the selected carrier directly affects the display of the next part of the Carrier's Profile report.

Click on the carrier's name to view the history of your cooperation.

Carrier's profile section

The data in this section depends on your selection in the List of carriers section.

Before you select a carrier, information about the first one in the list is displayed.

The carrier's profile includes:

  1. Carrier name
  2. Responses - number of responses from this carrier to the published freights
  3. Negotiations - number of price offers received from this carrier
  4. Accepted freights - number of accepted freights with this carrier
  5. Money Paid - total amount of transport costs paid to the carrier during the transactionConversion to EUR/PLN after the date of unloading.
  6. Average price per freight - average price per freight . Conversion to EUR/PLN after the date of unloading.
  7. A list of employees who have worked with this carrier. Next to the names you can see a chart with the number of freights.
  8. Publication type - where the offers were published.
  9. Pie chart showing the percentage of negotiations completed with freight acceptance, depending on the selected parameter.

  1. List of directions in which you cooperate with this carrier.
Hover the mouse cursor over each value to see what it refers to and what time period it is compared to.

Carriers on the route chart

The chart shows the number of carriers your company works with on specific directions.

On the left-hand side we mark the direction (e.g. PL-PL), on the light blue graph we show the number of carriers that negotiated freight offers in this direction. The dark blue chart shows the number of carriers that negotiated freight offers. The navy blue chart presents the number of freights that resulted in a transaction.

The data is sorted in descending order.

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)