On Time Delivery Reporting in Freightview
One of the big advantages to using Freightview is that fact we gather and compile meaningful analytics for you as you ship that can be exported into a CSV that you can put to work based on your needs.
Export Data
On-time delivery will now show up in your Freightview export. We have added a column that will show TRUE or FALSE based on whether we show a delivery date on or before the day the carrier calculated delivery based on transit times. This is column CQ on the export.
Report Indicators
TRUE means it was delivered on time; FALSE means it was not. If the carrier doesn’t provide the delivery date, we will leave the field blank.
Data Modeling
You can manipulate this data into a report that is meaningful to you. In this sample. I created a pivot table in Excel that shows how many shipments delivered on time and how many delivered late, per carrier.
This dataset below is just an example configured with fake data, this isn’t a real report, and doesn’t reflect real shipments with the carriers listed.
Highlights
You can manipulate your export in whatever way is most meaningful to you, this is just one example. To create this report, you’d choose to create a pivot table in Excel and select the following data points and put them in the corresponding fields when building your table:
- On-time delivery (Columns)
- Carrier (Rows)
- Shipment ID (Values)
Pivot Table
You can go further and convert these into percentages to see how often a carrier delivers on time. To turn these into percentages, you will click the i in the values section where you placed “Shipment ID.”
Then you will choose to Show data as % of Parent Column Total.
Then your data will look like this:
If you need more information about pivot tables and how they work this article is really helpful.
This is just another way Freightview helps you make the best choices for your freight operations. Not utilizing Freightview yet? Sign up for a Free Trial today and see what we’re all about.