Tracking In-transit exception rate with Eshopbox shipping
The in-transit exception rate refers to the percentage of orders stuck in transit, lost, or damaged for the forward journey.
The in-transit exception rate dashboard provides you with the following insights:
The number of orders that have experienced in-transit exceptions.
Ageing of the stuck orders.
In transit exception rate across various zones and routes.
You can also compare the current shipping performance against the previous months, filter the data using various filters and export the same for further analysis.
In this article, you will learn
How to check the in-transit exception rate report?
What are the various filters you can use?
What are the various analyses you can get from this report?
Steps to check the in-transit exception rate report
From the header, navigate to Reports > In Transit Exception rate. You will be redirected to the In-transit exception rate dashboard.
In-transit exception rate dashboard filters
On the top pane, you can find the following filters
Duration: It is the time period for which you want to calculate the in-transit exception rate. It defines when the shipping provider picked up the item.
Shipping mode: It is the type of shipping used to deliver an order. You can use this filter to select the shipping mode as standard, express, or priority.
Zone: Zone refers to a geographical area to which an order is to be delivered. You can use this filter to select the delivery zone as local, zonal, national, metro, or remote.
Origin: It is the location from where the orders are dispatched. This displays the list of origin locations.
Destination: It is the location to which the orders are delivered. This filter displays the list of delivery locations.
Detail oriented reports
How many orders have experienced In-transit exceptions over time?
In this report, you can analyse the following:
Exception rate: This is calculated by adding the stuck, lost and damaged orders and dividing them by the total number of orders picked up by the courier.
Stuck: These are orders for which there has been no update in the last 48 hours or if the order has been misrouted.
Lost: These are orders that are lost during the delivery process, preventing them from reaching the intended customers.
Damaged: These are the orders that get damaged in transit while delivering it to the customer.
A summary of the data is also available along with the report for the orders that encountered exceptions during transit, got lost, damaged or are currently stuck.
What is the ageing of stuck orders?
The ageing of stuck orders refers to the amount of time taken for an order to progress from one stage to another. This could be taking longer time than expected due to different reasons, such as delays in delivery, the customer being unavailable, or the delivery address being incorrect/incomplete.
What is the In-transit exception rate across various zones?
The in-transit exception rate is a metric used to gauge the percentage of orders that got stuck in transit. It provides insights into details like the geographic region with a higher exception rate, the courier service employed for delivery, as well as the specific types of exceptions encountered.
What is the In-transit exception rate across different routes?
In this report, the in-transit exception rate will be shown depending on the selected route. This information can assist in identifying delivery delays, routes that are taking the longest time for delivery and where more attention needs to be given.
Note: The data for the ten most frequent routes will be visible by default. To view the complete list of routes and the corresponding details, you need to click on View All.
Exporting the In-transit exception rate report
You can also export this report after applying the necessary filters for analysis. To do so, click on Export in the top right corner.
A pop-up will appear on your screen. Click on Export.
