The common metrics and definitions used in customised FreightIQ screens are documented below.

Definition of metrics

Consignments

Number of consignments created in this period

Freight cost

Total freight cost for consignments created in this period

Dead weight

Total dead weight of items for consignments created in this period

Items shipped

Total number of items shipped in consignments created in this period

Quotes

Total number of quotes requested by users in the period

Average linehaul util./Linehaul Utilisation

The percentage used of total linehaul capacity available in a given time period. This is calculated by taking the total used deadweight capacity and dividing it by the total available deadweight capacity in a given period (i.e. summing across individual trucks). In order to include cases where the capacity is listed in pallets, we assume one pallet represents 1,000kg of capacity

Recovery

The freight sales amounts charged to customers as a percentage of total freight costs paid to carriers for the period

DIFOT
The percent of all consignments delivered on time and in full for the period.  DIFOT calculations can only be proded when the carrier or receiver can confirm the date the goods were received.

Performance: dispatched

Full scan

Number of consignments with confirmed pick-up scan in this period

Partial scan

The number of consignments for which we have a partial dispatch scan in the given period. A partial scan is defined as a scan which implies that the job was picked up. 

For example, a carrier may fail to provide a pickup scan but still sends a delivery scan, implying the job was picked up. In these cases, the date is associated with the first such scan that implies pickup (delivery in the above example), but this may not be the actual date of pickup.

E.N.S: expected but no scan

The number of consignments which were expected to be dispatched in the given period but for which no pickup scan, full or partial, was received. 

Performance: delivered

Confirmed

Number of consignments with a final delivery scan in this period

% on time

The percentage of confirmed delivered consignments on or before the expected delivery date.

E.N.S: expected but no scan

The number of consignments which were expected to be delivered in the given period but for which we received no delivery scan

Item quantity, weight, and cost distribution graphs

These plots represent the number of jobs for which the given metric, e.g. total job item weight, falls within a given bin for jobs created in the given time period. The individual plot bars can be mouse-over to show the precise value being plotted, and the bins themselves are easily customisable. 

By default, we choose the bins which best represent the variation in the data but are more than happy to use custom definitions if you provide them to us.

Recovery and utilisation time series

This plot shows the change over time of the linehaul capacity utilisation % and freight cost recovery. Linehaul utilisation is defined as above but the recovery rate is presented as follows:

  • Daily recovery % (*) as defined above
  • 30d rolling recovery %: this takes the daily recovery %(*) as defined above and
  • Computes a 30 day rolling average

(*) Note that this recovery percentage is only calculated on a daily basis if the unit of time in the x-axis is a single day. When ‘Previous 6 months’ time period is selected, the x-axis is shown in units of months and the recovery is calculated by taking the freight cost recovered over a given month, divided by the total freight cost in that month. When this time period option is selected we expect the rolling 30d average and the ‘daily’ value to be quite close.

Interactivity

Daily recovery is expected to be quite volatile and so is hidden from the plot by default. This can be restored by clicking the green ‘Daily recovery %’ legend. Similarly, other series’ can be hidden by clicking their legend label.

Consignment map

This map shows the location of the origin and destination (and shortest path route) for each consignment created in the given period. This includes not-yet completed consignments, but does not include cancelled or otherwise invalid consignments.

A location is defined as a unique suburb-postcode pair.

Click the words in the legend to turn off individual data sets . For example, clicking the green ‘Origin’ text will fade out all the origin data, which can be returned by clicking again.

Origin and destination

The size of the circles placed at the locations reflect the number of consignments departing/arriving at that location, and the scale is shown next to the map legend. Please note this scale is logarithmic, meaning that if one location has double the circle size of another, it has 10 times as many consignments associated with it, not 2 times as many.

Route

These routes are simply the shortest paths between a given origin and destination. The thickness reflects the number of consignments associated with that route.

FreightIQ Exclusions

Consignments allocated to carriers that do not provide tracking are excluded from all Pickup & Delivery totals. Consignments are included in all other totals.