Skip to main content

Logistics Performance Dashboard

Overview​

The Logistics Performance Dashboard provides you with detailed insights into the return journey of customer orders. It breaks down data at the carrier service level, helping you make informed decisions about carrier and service selection. The report displays the average time (in working days) it takes for return orders to reach the first destination in the journey — depending on whether the return has a single or multi-leg journey. It also highlights the top-performing service mappings based on 1st mile transit time metrics, and the number of returns that are still in transit.

The 1st Mile Transit Time Report contains the following sections:

  • Filters
  • Key Performance Indicators
  • Transit Time (days)
  • 1st Mile Transit Time by Carrier & Service
  • Return Orders By Carrier
  • Origin Country Breakdown
  • Returns Currently In Transit
  • Returns Currently In Transit (Details)

Filters​

The available filters enable you to customise the data displayed in the dashboards based on specific criteria.

logistics_performance_1.png

Date Filters

  • Date - Filters data based on when the return was created.

Retailer Filters

  • Retailer Account - Use this when retailers belong to a larger group using ZigZag’s services.
  • Retailer Name - If you have access to multiple retailers, use this filter to select a specific retailer.
  • Brand - If a retailer has multiple brands, use this filter to select a specific brand.

Shipping Filters

  • Carrier Name - The carrier used to ship the return.
  • Carrier Service - The specific carrier service used for shipping.

Location Filters

  • Origin Country - The country from which the return is sent by the end customer.
  • Destination Country - The final country where the return is delivered.
  • Cross Border Returns - The returns that are cross-border (origin and destination country are different).

Warehouse Filters

  • Destination Warehouse - The final warehouse where the return is delivered.
  • Receiving Warehouse - The warehouse where the return is delivered when the first leg is finished, in case of multi leg returns.

Environment Filter

  • Environment - Filters data by retailer environment.

Key Performance Indicators​

This section provides information on the key performance metrics regarding the return orders for the selected date period:

logistics_performance_2.png

  • Customer Drop Off Time - The average number of days it took for return orders to change status from "Requested" to "In Transit" for the orders that were requested during the selected time period.
  • Avg 1st Mile Transit Time - The average number of days that return orders spend in transit before reaching the first receiving warehouse (excluding weekends) in the case of multi-leg journeys, or the retailer in the case of single-leg journeys. The first day in transit is counted as “0”, that is, transit time is calculated as the difference (in network days) between the first in-transit date and the date the order arrives at its first stop (or final stop, if there is only one). If a return goes into transit on a Friday or during the weekend and is also delivered over the weekend, the transit time will be recorded as “1 day”.
  • Consolidation Time - The average number of days it took for return orders to change status from "Received" to "Consolidation" for the orders that were requested during the selected time period.
  • Avg Final Mile Time - The average number of days that return orders spend in transit before reaching the destination warehouse (excluding weekends).
  • Avg Total Transit Time - The average number of days that return orders spend in transit before reaching the destination warehouse (excluding weekends) . The first day in transit is counted as “0”, that is, transit time is calculated as the difference (in network days) between the first in-transit date and the date the order arrives at its final stop. If a return goes into transit on a Friday or during the weekend and is also delivered over the same weekend, the transit time will be recorded as “1 day”.

Transit Time (days)​

This graph illustrates how the average 1st mile transit time, consolidation time, final mile time, customer drop off time and total transit time of return orders varies over time.

These averages are calculated using weekdays only and include only orders that have already been delivered.

If a return goes into transit on a Friday or during the weekend, and arrives at the first stop over the same weekend, the 1st Mile Transit Time is recorded as 1 day.

logistics_performance_3.png

1st Mile Transit Time by Carrier & Service​

This table displays the Avg of 1st Mile Transit Time and number of Return Orders, grouped by Carrier Name and Service Name.

logistics_performance_6.png

Return Orders By Carrier​

The Return Orders by Carrier chart provides a breakdown of return orders by carrier for the selected filters. It helps you understand how return volume is distributed across carriers, identify the ones most frequently used, and evaluate carrier utilization.

This visual is useful for monitoring carrier mix, identifying operational dependencies, and supporting discussions around carrier performance, capacity planning, and service optimisation.

The size of each segment corresponds to that carrier's share of total return orders. The value in the center displays the total number of return orders included in the chart for the retailer. Hover over the "Other" segment to view the combined contribution of smaller carriers that are grouped together for readability.

logistics_performance_9.png

Origin Country Breakdown​

This section of the dashboard displays a map with Returns' Origin Countries, the total number of return orders and the averages for total transit time, first mile transit time, final mile transit time, consolidation time and customer drop off time per origin country.

logistics_performance_5.png

Returns Currently In Transit​

This section of the dashboard displays a graph bar showing the number of returns currently in transit, grouped by the number of days they have been in transit. The data is organized into time intervals (bins).

The first date interval is fixed, and includes returns that have been in transit for 1–10 days. The following intervals for returns currently in transit are: 11-14 days, 15-18 days, 19-22 days and 23+ days.

This dashboard is based on the date the return went in transit. For example, if you select Previous 7 days in the Date filter, the chart will display returns that went into transit during the last 7 days. In this case, only the first interval (1–10 days) will contain data. To view data in the additional intervals, select a longer time range in the Date Selector.

logistics_performance_4.png

Returns Currently In Transit (Details)​

This table shows the details of the returns that are represented in the Returns Currently In Transit bar graph (i.e., returns without a delivery date).

Fields description
  • Return Order ID - The ID number of a return order.
  • External Outbound Order ID - The ID number of an outbound order.
  • Tracking Reference - The return's tracking reference.
  • Retailer Account - For retailers that are part of a larger group that utilizes ZigZag's services.
  • Retailer Name - In case you have access to multiple retailer's data, this filter allows you to select the specific retailer you would like to see data for.
  • Origin Country - Filters based on the return order origin country, i.e. the country from which the end consumers are sending their returns.
  • Destination Country - The final destination country where the order is returned.
  • Carrier Name - The name of the carrier used to ship the orders.
  • Receiving Warehouse - The middle stop warehouse name in case of multi-leg journeys.
  • Receiving Warehouse Country - The country of the middle stop warehouse in case of multi-leg journeys.
  • Destination Warehouse - The final stop warehouse name in the return journey.
  • Destination Warehouse Country - The country of the final stop warehouse in the return journey.
  • Lane Type - Classifies the return as either single-leg or multi-leg depending on the number of stops the return has during the journey to the retailer.
  • ZZ Carriage - Shows whether the return uses ZZ Carriage or not.
  • Transit Date - The date when the return started the journey and is in transit.
  • Warehouse Date - The date when the return status was changed to Delivered to warehouse.
  • Consolidation Date - The date when the return status was changed to In consolidation.
  • Dispached Date - The date when the return status was changed to Dispached.
  • Consolidated Date - The date when the return status was changed to Consolidated.
  • Retailer Date - The date when the returns status was changed to Despatched to retailer.
  • Return Delivered to Retailer Date - The date when the returns status was changed to delivered to retailer.
  • Transit bins - The bin this return belongs to in the Returns Currently In Transit bar graph section.
  • Total Undelivered Transit Time - The total time undelivered returns have been in transit.
  • Total Return Orders - The total number of return orders per line.

logistics_performance_7.png

Download Results​

To download the results, click the three dots on any of the dashboard section's top right corner, and select Download Results.

logistics_performance_10.png

Select the format and click on Download. To ensure a fast download, try narrowing your date range or applying additional filters before exporting. Bigger data sets will result in a slower download.

logistics_performance_11.png

note

If you download a visualization in the form of a graph, the downloaded file will show the results in a table format.