Carrier Performance by Delivery Date

Objective of the report

The Carrier Performance by Delivery Data report uses 50-day transactional data but allows you to display it from the consumer viewpoint of Guaranteed Delivery Date - i.e. it looks back from this date to see how carriers performed in meeting consumer promises.

The report provides both volume and time period breakdowns by delivery status (Tracked, Early, On Time, Late and In Transit), and a pie chart breakdown of the Reasons for Lates.

You can drill through to specific orders in a trade lane and display them in a separate Parcel Details tab. This allows you to look up the parcels on your Metapack shipping platform.

There is also an Aggregated Performance tab that allows you to see the same performance breakdowns but for aggregated parcel counts for the last 3 years. However, as it is not transactional data, there is no drill through on this tab.

Specific switches

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

Carrier_Performance_by_Delivery_Date.png

Note

For information on how to populate the Aggregated Performance and Parcel Details tabs shown at the top of the screen, refer to Aggregated Performance tab and Parcel Details tab respectively.

Date View

This switch has two settings: Exact Date and Weekday.

Performance_Date_View.png

The switch allows you to determine whether the Performance by Manifest Date area chart on the right should show the exact dates at the bottom of the graph, or else group the values by days of the week, e.g.

Days_of_the_Week.png

Note

Going from top to bottom, the colours correspond to the delivery statuses Early, On Time, Late and In Transit, respectively.

Performance Metric

You can set the metric against which lateness in the report is to be measured:

Performance_Metric.png

This determines whether the actual delivery against which the Guaranteed Delivery Date is measured, is to be taken as the First Delivery Attempt (the default), or else the Actual Delivery into the consumer's hands.

Scanned into Carrier Network?

This filter allows you to determine whether or not to include data for 'non-scanned' parcels (i.e. parcels that were not tracked and those for which labels were printed but which were never shipped):

Scanned.png

This flag has been implemented as a Boolean indicator. You can select Yes to filter out 'non-scanned' parcels, No to show data for just the non-scanned parcels, or All (the default) to find all parcels (regardless of whether they were scanned into the carrier network).

Trade Lane

You can also filter by trade lane.

Each trade lane has an on-time delivery SLA that has been agreed with the particular carrier. For each selected trade lane, values are supplied for the following:

  • Parcel Count

    The total number of parcels manifested within the criteria set by the switches.

  • Parcel Count (with SLA)

    The total number of parcels manifested that are subject to an SLA (typically, the same as Parcel Count).

  • No SLA Information

    The total number of parcels for which there are no SLA details (typically, Parcel Count minus Parcel Count (with SLA)).

  • Average Predicted SLA Target

    The average number of days calculated as the delivery SLA in the selected trade lane.

  • Tracked

    Those parcels for which at least one tracking scan has been received from the carrier. Where tracked services are used exclusively by the carrier, this value is expected to be identical to the Parcel Count or the Parcel Count (with SLA).

  • In Transit

    The number of parcels that have received tracking events from the carrier but that have not yet had a 'stop the clock 'event.

  • Early

    The number of parcels that had a 'stop the clock' event prior to the carrier's Earliest Delivery Date.

  • On Time

    The number of parcels that received a 'stop the clock' event between the carrier's Earliest Delivery Date and Guaranteed Delivery Date.

  • Late

    The number of parcels that received a 'stop the clock' event after the Guaranteed Delivery Date, plus any that have passed the carrier's Guaranteed Delivery Date and are still in transit.

If you hover over the trade lane, or any of the above columns, you will see the Drillthrough link that takes you to the Parcel Details tab, e.g.

In_Transit.png

Note

For the Keep Only and Exclude options that are displayed when you hover over the filter, refer to the Keep Only/Exclude switch.

Weekly Volume

This 'quick filter' allows you to select an individual ISO week for which you wish to show data:

Weekly_Volume_Big.png

When you click on the week, the report data is filtered to show only the results for the particular week. If you hover over the link, you will see the Drillthrough link that takes you to the Parcel Details tab.

You simply click again to clear the filter. To clear a multiple selection, click multiple times. You can also select Undo to clear a filter.

Note

For the Keep Only and Exclude options that are displayed when you hover over the filter, refer to the Keep Only/Exclude switch.

Parcels Details tab

If you click on Drillthrough, the individual parcels are displayed on the Parcel Details tab, e.g.

Parcel_Details_Filtered.png

This allows you to look at individual parcels. You can also redefine the Performance Metric at the top of the screen, and select the status for which you wish to view parcels (via the Parcel Status switch).

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

Aggregated Performance Tab

You can also click on the Aggregated Performance Tab to view a version of the Carrier Performance Report combining up to 3 years' manifested parcels data, e.g.

Performance_Aggregated.png

Under this tab, there is no Performance Metric switch, and the Date View switch has the following selections:

Date_View_Different.png

Use cases

  1. Detect where SLAs (Service Level Agreements) are not being met in terms of delivery date.

    The Transport Manager can view the performance of a carrier or their individual services by selecting the required trade lanes and looking at the associated Performance by Volume chart to see the number of parcels that were late or are still in transit. If this is viewed in conjunction with the Performance by Manifest Date chart, the Manager can view the pattern over time and use it as the basis of a discussion with the carrier.

    Where there are many late deliveries or unexpected variances from expected on time delivery targets, the Manager could escalate these to Carrier Account Management to seek a detailed explanation from the carrier for the perceived drops in performance.

  2. Identify reasons for late delivery.

    The Transport Manager reviews the Reason For Lates bar chart to see why packages have been flagged as late - for example, a certain percentage could have been caused by Late Pickup, which is down to failings in the warehouse as the seller did not provide the carrier with the parcels prior to the cut-off time.

  3. Compare carrier performance against consumer delivery promise.

    Customer Service Operatives can use the Actual Delivery performance metric in conjunction with the Performance by Manifest Date chart to view Late and In Transit deliveries in terms of both Exact Date and Weekday (i.e. days of the week), for specific trade lanes. They can then drill through to the Parcel Details tab to look up individual parcels and follow up on consumer refund requests.

Example

Let us say that you were concerned about a carrier service's late deliveries in the Swedish market. You might select the filters shown in the video below.

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