/
Failed delivery dashboard (Shipment level)

Failed delivery dashboard (Shipment level)

Owned by ASHITA GUPTA (Unlicensed)
Last updated: Mar 13, 2023
5 min read

FIGMA LINK-WIP Jan 2023

It will be calculated for the orders where Eshopbox shipping is present.

Filters:

 

  • Latest delivery attempt on

    • Date filter (Reference orders date filter)

  • Delivery location (state, city, pin code)

    • This filter will have a search as well.

    • You can filter out delivery locations based on state, city and pin code.

  • Shipping service

    • Express

    • Standard

    • Priority

  • Zone

    • Local

    • Zonal

    • National

    • Remote

    • Metro

MORE FILTERS-

  • Origin

    • List of State + Facility code of Fulfillment centre (Eshopbox + Selffulfilment FC)

      • Example:

        • Haryana: Gurgaon (AGGN)

        • Maharastra: Mumbai (ZMUM)

        • Delhi: DEL101

    • This filter will have a search as well.

    • Sorting A to Z

 

  • Delivery location (state, city, pin code)

    • This filter will have a search as well.

    • You can filter out delivery locations based on state, city and pin code.

  • Risk score

    • High

    • Medium

    • Low

    • This filter will have a search as well

    • You can select all 3 options for risk score.

  • Payment method

    • Prepaid

    • COD

How often do deliveries fail over a given period of time?

  • In this widget will we will calculate the failed delivery rate.

  • Failed delivery rate- The failed delivery percentage indicates how many orders had unsuccessful delivery attempts.

  • Formula - To calculate the failed delivery rate for orders, you need to divide the total number of failed deliveries by the Number of orders for which the latest delivery was attempted in the filtered period and then multiply the result by 100 to get the percentage.

  • Failed Delivery Rate = (Number of Failed Deliveries / Number of orders for which the latest delivery was attempted in the filtered period) x 100%

For example, if delivery was attempted for 1000 orders during the past month and 50 of them failed to be delivered, the failed delivery rate would be 5%.

  • Failed delivery return - The number of orders that failed to be delivered and RTO created.

    • (Orders which are delivered after RTO- won't be considered in the dashboard)

  • Awaiting action - Order failed to be delivered AND not delivered and not RTO.

What are the reasons for failed deliveries?

In this widget, we will show the reasons for the failed delivery.

  • X-axis will show the count of orders.

  • Y-axis to show the reasons for the failed delivery.

 

How many attempts have been made to deliver the order?

 

This widget will show the number of attempts made to deliver the order.

  • X-axis will show the no of delivery attempts

  • Y-axis will show the count of orders

 

What is the split between failed delivery orders for COD vs prepaid?

This will show the bifurcation for failed delivery orders based on the payment method as:

  • COD (Example - The widget above indicates that 700 orders that failed delivery had been paid using the COD payment method)

  • Prepaid

 

How many deliveries failed in each zone?

In this widget, we will show the failed delivery rate across various zones.

EXAMPLE- The local zone has failed delivery rate of 95%.

How does delivery time affect the rate of failed deliveries?

 

  • This widget represents the delivery time taken to deliver the order to the customer.

  • The higher the delivery take taken for an order delivered higher will be the failed delivery rate.

  • Steps for calculation -

    • Based on the primary date filter -the latest delivery attempt on let's say we have 100 orders in the last 30 days.

    • Calculate on shipment level ( Transit time = first delivery attempt on - order handover on )

    • Birfucate the transit time into days - 1 day, 2 days, 3-4 days, 5-7 days, >8 days).

SAMPLE CASE FOR REFERENCE - 100386556-90776 ( TRANSIT TIME - 2 DAYS )

How often do deliveries fail on the most common destinations?

 

 

This widget will show the order grouping at the state and city level. The calculation for the time taken to complete returns, transit time and return processing time.

  • The top 10 records to be shown by default have a maximum of failed deliveries.

  • Sorting will be applicable for all fields as shown in the screenshot. Sorting will happen in total results.

  • The user can click on view all and will be redirected to a new wizard having:

    • Filters

    • Pagination (per page 50 records)

How many orders receive a response when deliveries fail? (coming soon)

This widget will show the response received on the failed delivery order.

Seller - Response received from the seller on the failed delivery order.

Buyer - Response received from the buyer on the failed delivery order.

No response - no action and no response taken on the failed delivery order.

  • The 3 records to be shown by default have a maximum of total orders.

What is to be considered as the seller action and buyer action?

 

What is the performance of different communication channels for getting a response from buyers? (coming soon )

  • This widget will help you to analyze the effective communication channel for getting a response from the buyer.

  • This widget will have 4 records (Email, SMS, Whatsapp, IVR).

  • The 4 records to be shown by default have a maximum of total orders.

  • Sorting will be applicable for all fields as shown in the screenshot. Sorting will happen in total results.

  • No pagination is required.

 

What will the Export template look like?

The format of the Exports will be as follows: https://docs.google.com/spreadsheets/d/11buINQ2B3geOeO4CNUDi4D1QqW1clJIvK_DV6L6RqxM/edit?usp=sharing

Note: The filters shown on the dashboards will also be applicable for the exports.

 

Add label

Related content