Last-Mile Delivery Efficiency Tracker

This dataset provides a comprehensive, event-level view of last-mile delivery operations for e-commerce logistics, capturing detailed timestamps, route information, delivery outcomes, package attributes, and customer feedback. It enables advanced analytics to identify operational bottlenecks, measure delivery efficiency, and optimize customer satisfaction. Ideal for logistics managers seeking to drive continuous improvement and data-driven decision-making in last-mile delivery.

  • last updated 2 Jan 2026
  • by GoMask
The brief that made it

Monitor and benchmark last-mile delivery efficiency across regions and personnel

Sample rows

preview · 8 of 175 rows · all 31 columns
delivery_idstringdelivery_statusstringdelivery_attemptsintegerorder_idstringcustomer_idstringdelivery_person_idstringvehicle_idstringroute_idstringscheduled_pickup_datetimedatetimeactual_pickup_datetimedatetimescheduled_delivery_datetimedatetimeactual_delivery_datetimedatetimefailure_reasonstringdistance_kmfloatestimated_travel_time_minutesintegeractual_travel_time_minutesintegerroute_start_latitudefloatroute_start_longitudefloatroute_end_latitudefloatroute_end_longitudefloatdelivery_address_streetstringdelivery_address_citystringdelivery_address_statestringdelivery_address_postal_codestringdelivery_address_countrystringpackage_weight_kgfloatpackage_dimensions_cm_lfloatpackage_dimensions_cm_wfloatpackage_dimensions_cm_hfloatcustomer_feedback_scoreintegercustomer_feedback_commentsstring
DLV000001delivered1ORD10001CUS00001DPR001VEH0011RTE10012024-06-03T09:00:00Z2024-06-03T09:08:00Z2024-06-03T10:10:00Z2024-06-03T10:16:00Zblank16.7656840.7128-74.00640.7306-73.9866123 Madison AveNew YorkNY10016US3.43726125Fast and friendly delivery, thanks!
DLV000002delivered1ORD10002CUS00002DPR002VEH0012RTE10022024-06-02T13:30:00Z2024-06-02T13:33:00Z2024-06-02T15:00:00Z2024-06-02T15:04:00Zblank8.1444651.5074-0.127851.5136-0.098375 BishopsgateLondonENGEC2N 3ARUK5.24432174Arrived on time, package intact.
DLV000003delivered1ORD10003CUS00003DPR003VEH0013RTE10032024-06-01T17:15:00Z2024-06-01T17:17:00Z2024-06-01T18:10:00Z2024-06-01T18:20:00Zblank5.6333748.85662.352248.85892.37722 Rue de RivoliParisIDF75004FR1.9221875Excellent service, very quick.
DLV000004delivered1ORD10004CUS00004DPR004VEH0014RTE10042024-06-05T10:00:00Z2024-06-05T10:02:00Z2024-06-05T12:30:00Z2024-06-05T12:50:00Zblank27.49010835.6895139.691735.7283139.71478-1 DogenzakaTokyoTK150-0043JP8.76645224Package arrived a bit late, but OK.
DLV000005delivered1ORD10005CUS00005DPR005VEH0015RTE10052024-06-04T08:00:00Z2024-06-04T08:01:00Z2024-06-04T09:40:00Z2024-06-04T09:41:00Zblank2.8212052.5213.40552.512313.412717 AlexanderplatzBerlinBE10178DE0.8181265Very prompt and professional.
DLV000006delivered1ORD10006CUS00006DPR006VEH0016RTE10062024-06-06T14:00:00Z2024-06-06T14:15:00Z2024-06-06T16:30:00Z2024-06-06T16:55:00Zblank145.912016041.8781-87.629842.0334-88.0834212 N State StChicagoIL60654US12.79258313Arrived late due to traffic.
DLV000007delivered1ORD10007CUS00007DPR007VEH0017RTE10072024-06-07T07:00:00Z2024-06-07T07:00:00Z2024-06-07T07:45:00Z2024-06-07T07:44:00Zblank0.51111-33.8688151.2093-33.8721151.2153231 Pitt StSydneyNSW2000AU0.313845Super fast hand delivery!
DLV000008delivered1ORD10008CUS00008DPR008VEH0018RTE10082024-06-08T18:00:00Z2024-06-08T18:05:00Z2024-06-08T23:30:00Z2024-06-08T23:35:00Zblank452.232033019.4326-99.133221.1619-86.8515Av. Tulum 150CancúnQROO77500MX52.3240120874Large item delivered safely.

What the 175 rows show

from the 175-row sample

Failed (delivery status) stands out: mean delivery_attempts is 2.2, against 1.1 for the rest.

  • 1median delivery_attempts
  • 41delivery address countries
  • 9.2median distance_km
  • 52median estimated_travel_time_minutes
  • 75median actual_travel_time_minutes
  • 2.6median package_weight_kg
Mean delivery_attempts by delivery_status175 rows
0241.0pendi…23 rows1.0in_tr…6 rows1.0deliv…111 ro…2.2failed17 rows2.3retur…8 rows1.0cance…10 rows
delivery_attempts175 rows, in bands of 0.2
0751501500000190006123delivery_attempts →

Median 1, from 1 to 3.

31 columns by typefrom the column list below
  • string 14
  • integer 4
  • float 9
  • datetime 4

Columns

31 columns in three groups
blueprint · 31 columns
columntypedescriptionexample
Text 14 columns
delivery_idstringUnique identifier for each delivery eventuniqueDLV000001
order_idstringUnique identifier for the associated customer orderORD10001
customer_idstringUnique identifier for the customer receiving the deliveryCUS00001
delivery_person_idstringUnique identifier for the delivery personnel assigned to the deliveryDPR001
vehicle_idstringUnique identifier for the vehicle used for deliveryoptionalVEH0011
route_idstringUnique identifier for the planned delivery routeoptionalRTE1001
delivery_statusstringCurrent status of the delivery6 valuesdelivered
failure_reasonstringReason for delivery failure, if applicable9 reasons · optionalCustomer not at home
delivery_address_streetstringStreet address for the delivery location123 Madison Ave
delivery_address_citystringCity for the delivery locationNew York
delivery_address_statestringState or province for the delivery locationNY
delivery_address_postal_codestringPostal or ZIP code for the delivery location10016
delivery_address_countrystringCountry for the delivery locationUS
customer_feedback_commentsstringOptional customer comments or feedback about the deliveryoptionalVery smooth process.
Numbers 13 columns
delivery_attemptsintegerNumber of attempts made to deliver the package1 or more1
distance_kmfloatTotal distance covered during the delivery route in kilometers0 or more · optional16.7
estimated_travel_time_minutesintegerEstimated travel time for the delivery route in minutes0 or more · optional65
actual_travel_time_minutesintegerActual travel time taken for the delivery in minutes0 or more · optional68
route_start_latitudefloatLatitude coordinate of the route starting point-90 to 90 · optional40.7128
route_start_longitudefloatLongitude coordinate of the route starting point-180 to 180 · optional-74.006
route_end_latitudefloatLatitude coordinate of the route end point (delivery location)-90 to 90 · optional40.7306
route_end_longitudefloatLongitude coordinate of the route end point (delivery location)-180 to 180 · optional-73.9866
package_weight_kgfloatWeight of the package in kilograms0 or more · optional3.4
package_dimensions_cm_lfloatLength of the package in centimeters0 or more · optional37
package_dimensions_cm_wfloatWidth of the package in centimeters0 or more · optional26
package_dimensions_cm_hfloatHeight of the package in centimeters0 or more · optional12
customer_feedback_scoreintegerCustomer satisfaction score for the delivery (e.g., 1-5)1 to 5 · optional5
Dates and times 4 columns
scheduled_pickup_datetimedatetimePlanned date and time for package pickup from the warehouse or hub2024-06-03T09:00:00Z
actual_pickup_datetimedatetimeActual date and time when the package was picked upoptional2024-06-03T09:08:00Z
scheduled_delivery_datetimedatetimePlanned date and time for package delivery to the customer2024-06-03T10:10:00Z
actual_delivery_datetimedatetimeActual date and time when the package was delivered to the customeroptional2024-06-03T10:16:00Z

Use it for

  • median deliver…1175 rowsmean delivery attempt…1.0pend…1.0in_t…1.0deli…2.2fail…

    A logistics dashboard

    Delivery_attempts by delivery_status. Excel, Power BI or Tableau.

  • Why do the 17 failed rows have a mean delivery_attempts of 2.2?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable deliveries with order_id, customer_id and delivery_person_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 31 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset175 rows31 columns
Yours1,000 rows31 columnsdelivery_address_street: UK only

blueprint · last-mile-delivery-efficiency-tracker

Behind this dataset

Same schema. As many rows as you need.

These 175 rows came out of a blueprint — 31 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Each row represents a single delivery attempt.
  • Delivery status must be 'Completed', 'Delayed', or 'Failed'.
  • Include time taken (minutes), route distance (km), and driver ID.
  • If delivery failed, specify failure reason from a controlled list.
  • Mandatory fields: Delivery ID, Timestamp, Customer ZIP code, Vehicle Type.
  • Only include deliveries within urban areas (ZIP codes specified).
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
last-mile-delivery-efficiency-tracker

More in Logistics

Browse all
Also in LogisticsLast-mile Delivery Route RecordsDelivery Route Optimization DatasetSupply Chain Delivery Delay LogsAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.