Elapsed Time in Transit, Grouped by State

Summary

Elapsed Time In Transit is also known as the time between label creation and parcel delivery. Elapsed Time is often used to evaluate service metrics and can be vital in determining which lanes/regions are having the greatest impact on performance. In this case, it will be demonstrated how you can group tracking units by their Ship-To State and then monitor each unit's Elapsed Time in Transit.

This article will demonstrate multiple ways to find this data, using the Tracking Summary application and the Transit Time Period Analysis application. The first application, Tracking Summary, has the capability to provide detailed information on elapsed days in transit for each package shipped. The second application, Transit Time Period Analysis, will provide a high-level overview of the average days in transit by carrier service.

Solution - Tracking Summary (Detailed) 

In this example we will demonstrate how you can find this information in the Tracking Summary application. 

First, open the Intelligent Logistics Homepage and click on the Tracking Summary tile

Elapsed Days in Transit is calculated when a shipment is delivered, so first we will need to filter by packages that have a transit status of delivered.

From the Transit Status filter, select Delivered. Then click Go to run the initial data.

Next, we will customize the report by adding the necessary data points. Click on the Settings button on the right side of the page.

 

The settings page will open up and you will now be looking at a list of columns, which represent the data fields available to populate in the table. If a box is checked to the left of a data point, that means that the corresponding field will populate as a column in your final data.

Click the box next to the following data points:

• Manifest Scan Date - the time/date of the shipping label creation.
• Origin Scan Date - the time/date of when the package was picked up by the carrier. 
• Delivery Date
• Elapsed Days in Transit - you can also elect to view elapsed weekdays in transit. 
• Ship-to State

Please note: Elapsed Days in Transit is calculated using the In Carrier Possession Date/Time, so it NOT will include the time in which the label has been created but has not been picked up by the carrier.

 

Once selected, these data fields will now populate as columns in your table data: 

Click on the column heading for Ship-to State to sort your data by state: 

Do you see blanks for some packages? It's likely that these are international shipments. Try adding Ship-to Country or Business Sub-Region to view that data.

If you're still seeing blanks, click on the tracking number - if the Ship-to information was not entered at the time of label creation, these fields will be blank.   

To download the table data to Excel, click on the icon next to the Settings button. For a quicker look at the overall trends, click Pivot View: 

From the Pivot Dimensions (drop-downs), select Ship-to State and Elapsed Days in Transit. Then click on the Pivot Settings button to select your desired columns. 

In addition to the default Volume column, you can also elect to see how many packages were On or Before Schedule, and how many experienced an Exception: 

 

 

 

Click the pivot Go button to see the initial volume by state. Click into any of the rows to take a closer look at the details. 

 

 

In the example below, 51 packages were shipped to Arizona. The elapsed days in transit is reflected in the column on the left, the corresponding number of packages in the "Volume" column, followed by the % that were On/Before Schedule and Exceptions. 

 

 

Click into the three dots on the right side of the screen and select the Export button to download the pivot view to Excel. 

 

 

 

 

Solution - Transit Time Period Analysis (Overview)

In this example we will demonstrate how you can find this information in the Transit Time Period Analysis application. 

First, open the Intelligent Logistics Homepage and click on the Transit Time Period Analysis tile

Select the grouping in which you would like to see the data displayed. In this example, we will use the weekly view. Click Go to run the initial data. 

 

 

The average transit times will be displayed for each carrier service by week. Click the Settings button on the right side of the screen. 

 

 

Select Ship-to State as a column, and then click on the Group menu at the top: 

 

 

Select Ship-to State as a grouping, and then click OK

 

 

Now you will see the average transit times grouped by state: 

 

 

Click into each row to see the times by carrier service for that state: