Lead Time Statistics report

Objective of the report

For a specified type of transit event, the Lead Time Statistics report tells you how many parcels were processed during the different time bands of the event. For example, if you set the transit type to Carrier pickup to final event, and set the Final Event to Actual Delivery, you can highlight the average numbers of days that a carrier service, or carrier services within a particular service group, took to deliver parcels into a consumer's hands.

The report uses the last 50 days of transactional data, which allows you to drill through to specific orders in a trade lane and display them in a separate Parcel Details tab. This allows you to look them up on your Metapack shipping platform and take the necessary action - e.g. the investigation of orders that have taken too many hours to process within the warehouse, or orders that have taken too many days to deliver and have failed carrier SLAs.

Specific switches

In addition to the global filters previously described, this report provides the specific switches highlighted in the following screenshot:

Lead-Time-Switches.png

Note

The top red line shows the cumulative figure, whilst the blocks below it show the individual figures for each time band.

Once you click away from a switch after changing it, the graph, trade lanes and weekly, 'service group' and market 'slicers' are updated automatically in line with your selection.

For the population of the Parcel Details tab shown at the top of the screen, refer to Drill through.

Data Type

This switch applies to the trade lanes below the graph and allows you to select how the numbers of parcels processed within the different time bands are to be represented:

Data_Type.png

Select the required option:

  • Actual for each number to be shown as a numeric value;

  • Percentage for each number to be shown as a percentage of the overall number of parcels processed;

  • Cumulative for each number to be shown as a percentage after adding in the figures from the previous time periods.

Transit Time

The Transit Time switch allows you to specify how the transit event is to be defined for the current dataset:

Transit_Time.png

The events are self-explanatory. The time bands for the top two events are days, whereas those for the bottom three events are hours.

Creation to End is the default Transit Time.

Final Event

Where Final Event is specified in a Transit Time selection, this switch allows you to determine what the Final Event is for the current dataset - i.e. it can be either the First Delivery Attempt (the default), or the Actual Delivery into the consumer's hands:

Final_Event.png
Service Group Lead Time

You can also slice the data by service group. This allows you to see whether the services within a particular group (e.g. Express Delivery) are fulfilling their SLAs.

Combining the Switches

The combination of the above switches allows you to quickly see where the problems are at any stage in the delivery chain, and, by drilling down, to quote details of specific parcels.

For example, the following report shows the parcels picked up from the German warehouse by services within the Express Delivery service group. It highlights the actual numbers of those parcels that were delivered into consumers' hands during the different time bands, and immediately demonstrates that some services are not fulfilling the Express criteria:

Germany_Lead_Time_2_.png
Drill through

If you select a trade lane in the above example, and hover over one of the time bands, a Drillthrough link is displayed:

Germany_Drillthrough_2_.png

If you click on Drillthrough, the parcels that were delivered during the time band are displayed under the Parcel Details tab, e.g.

Germany_Parcel_Detail_2_.png

This view allows you to to compare delivery with the SLA Target Days (the link in the example was for parcels that took 4 days to be delivered and so they all missed their target). It also allows you to see by how many hours each parcel was delayed between its Guaranteed Delivery and Actual Delivery Date, and the postcodes to which they were delivered. This is information that you can take up with the carrier.

You can use the Order Numbers and Consignment Codes on the left of the tab to identify the packages in Metapack Delivery Manager.

Use cases

  1. Determine the number of days late that parcels are being delivered in particular markets, and which carrier services are responsible.

    The Transport Manager can use the Transit Time of Final Mile, in conjunction with other switches, to see how carrier services are not meeting their SLAs in terms of delivery times.

  2. Adjust customer promise and expectations based on actual past performance.

    The Transport Manager can use the default Transit Time of Creation to End (the default) to see the actual time that most packages take to be delivered from ordering through to Actual Delivery, and then adjust the delivery estimations on the website.

  3. Ascertain how long manifested packages are taking to be picked up.

    The Transport Manager can use the Transit Time of Line Haul to see how many hours it is taking parcels to be picked up after they have been manifested.

  4. Investigate consumer complaints related to individual packages.

    Customer Service Operatives can use the Parcel Details tab to look up individual packages in the shipping platform and take remedial action.

Example

Let us say that you were concerned about a carrier's delayed shipments in the German market. You might select the filters shown in the video below.

The final action is to drill through to the individual packages: