Performance & Analytics Dashboard – User, Vehicle, Route, Facility, and Order KPIs

Route4Me’s Analytics Dashboard is a powerful and easy-to-use performance reporting tool for enterprise businesses. You can customize your Dashboard to filter, sort, group, and visualize detailed, real-time statistics generated by your field team members, vehicle fleet, and routing activities. Drilling down into detailed metrics, KPIs, and analytics enables you to gather actionable last mile intelligence for any part of your business.

Compared to the Routing Dashboard in Route4Me’s Web Software, the Analytics Dashboard provides more in-depth and flexible data filters. For your convenience, you can sign in to the Analytics Dashboard with your Route4Me account, and it’ll automatically collect all necessary information. In this guide, you’ll learn how to use the Dashboard to see data relevant to your needs, use advanced filters and grouping settings, create detailed user, vehicle, route, facility, and order dashboards.

Route4Me’s Analytics Dashboard is a powerful and easy-to-use performance reporting tool for enterprise businesses. You can customize your Dashboard to filter, sort, group, and visualize detailed, real-time statistics generated by your field team members, vehicle fleet, and routing activities.

 

 

Dashboard Overview – Open And Use Performance Analytics Dashboard

To open the Performance Dashboard, go to “Analytics” from the Navigation Menu and click “Performance“.

Open Your Analytics Dashboard

Open the Performance Dashboard from your account navigation menu.

 

At the top of the Dashboard, you can see the Performance Summary panel, which shows aggregate business performance data for the filtered date range. In detail, you can see performance data for order completion, route execution, SLAs, and customer satisfaction. NOTE: Use the scroll bar at the bottom of the Performance Summary to scroll horizontally and view all your aggregate performance statistics.

At the top of the Dashboard, you can see the Performance Summary panel, which shows aggregate business performance data for the filtered date range.

 

Below that is the main analytics data table, where you can find in-depth data and drill down into statistics about the performance of your business. Just like the Performance Summary, you can scroll horizontally to see all the data in your Dashboard.

To sort the table by any column, simply click the corresponding Arrow Icon. Next to it, you can hover over the Information Icon to get a description of the data contained in the respective column.

The double header of the data table enables grouping complex data in an easy-to-use way. For example, the “Performance” header has secondary headers for the percentage of planned and completed distance, route time, destinations, etc. Learn more about customizing the data table further in this guide.

The main analytics data table is where you can find in-depth data and drill down into statistics about the performance of your business.

 

Dashboard Filters – Analytics Filter And Grouping Settings

Dashboard filters narrow down and group data according to a specific timeframe and are always enabled. To make the most of the Performance Summary and analytics data table, adjust filter options for your preferred date range and time frame grouping.

To do so, click the “Date filter” button and select the preferred date range by entering it manually in the respective field, selecting dates on the calendar, or selecting a pre-defined date range type from the dropdown menu. Then, click “Group by” and select how you’d like to group data on your Analytics Dashboard. NOTE: The “Trailing…” date range filter specifies a range up to the current date, i.e. “Trailing year” will show data up to the current date from the same date from the previous year.

Dashboard filters narrow down and group data according to a specific timeframe and are always enabled. Customize Dashboard filters to see only that data relevant to your needs or business use case.

 

Analytics Categories – Dashboard Data Table Tabs And Sections

For your convenience, the Analytics Dashboard has different tabs corresponding to data categories that enable you to easily see the performance data specific to your last mile business management needs. Specifically, you can see KPIs for your entire organization, last mile routing team, transportation fleet, routes, facilities, orders, and more. You can even see data broken down by the different types of vehicles in your fleet or by state if your business operates across the country. Find more details about the different Analytics Dashboard categories in the table below.

For your convenience, the Analytics Dashboard has different tabs corresponding to data categories that enable you to easily see the performance data specific to your last mile business management needs.

CategoryDescription
SummaryPerformance data for your entire organization.
UserPerformance data associated with individual users and team members.
VehiclesPerformance data associated with individual last mile fleet vehicles.
Vehicle TypesPerformance data associated with transportation vehicle profiles. In detail, vehicle profiles contain specific settings related to vehicle dimensions and usage and are different from capacity profiles which define maximum vehicle capacity.
RoutesPerformance data associated with individual last mile routes scheduled for the specified date range in the “Date filter“.
FacilitiesPerformance data associated with individual Facilities on your main Route4Me account. Specifically, Facilities are physical locations such as depots, warehouses, offices, etc.
StatesPerformance data for your entire organization broken down by state.
OrdersPerformance data for your Customer Orders broken down by Order Status.

 

Configure Dashboard – Custom Analytics Display Columns And Data Table Settings

You can customize the Analytics Dashboard to show only data relevant to your unique business use case by customizing data columns and table settings. To do so, simply click the Table Settings button (Gear Icon) and check the boxes next to data columns you want to enable. Additionally, drag column names to re-order the data table according to your preferences.

When you’ve adjusted your table settings, click the “Save” button to update the Analytics Dashboard data table. Alternatively, click the “Reset columns order” button to restore the default table settings for the corresponding category. Learn more about available data columns on the Analytics Dashboard in the table below.

You can customize the Analytics Dashboard to show only data relevant to your unique business use case by customizing data columns and table settings.

ColumnDescription
Arrivals
On TimePercentage of Destinations where the assigned User arrived within 5 minutes of the Planned Destination Arrival Time. Destinations are marked as “Arrived” on the Mobile App or detected as arrived through Geofencing.
EarlyPercentage of Destinations where the assigned User arrived more than 5 minutes earlier than the Planned Destination Arrival Time. Destinations are marked as “Arrived” on the Mobile App or detected as arrived through Geofencing.
LatePercentage of Destinations where the assigned User arrived more than 5 minutes later than the Planned Destination Arrival Time. Destinations are marked as “Arrived” on the Mobile App or detected as arrived through Geofencing.
Departures
On TimePercentage of Destinations the assigned User departed within 5 minutes of the Planned Destination Departure Time. Destinations are detected as departed through Geofencing.
EarlyPercentage of total Destinations the assigned User departed more than 5 minutes earlier than the Planned Destination Departure Time. Destinations are detected as departed through Geofencing.
LatePercentage of total Destinations the assigned User departed more than 5 minutes later than the Planned Destination Departure Time. Destinations are detected as departed through Geofencing.
Performance
Distance (%)Percentage of actual Route Distance from the total Planned Route Distance. Actual Route Distance is the distance traveled by the assigned User between starting and ending the route on the Mobile App.
Total Time (%)Percentage of actual Route Time from the total Planned Route Time. Actual Route Time is the time between the assigned User starting and ending the route on the Mobile App.
Service Time (%)Percentage of actual Service Time from the total Planned Service Time. Actual Service Time is the combined total time the assigned User or Vehicle spent inside Destination Geofences as detected by Geofencing.
Destinations (%)Percentage of Completed Destinations from the total number of Planned Destinations. Destinations are Completed when marked as Done, Skipped, or Failed by the assigned User using the Mobile App. Optionally, a Destination can be automatically marked as Complated (Done) when the assigned user enters the Geofence around it.
Utilization
Cube PlannedTotal planned Cube (volume) amount of all Destinations on planned scheduled routes. (Shown only if Vehicle Capacity Profile of assigned Vehicle has Cube value.)
Cube AvailableTotal available Cube (volume) capacity of assigned Vehicles on planned scheduled routes. Maximum Vehicle Capacity is specified in the associated Vehicle Capacity Profile.
Cube (%)Percentage of the maximum available Cube (volume) capacity of assigned Vehicles that has been filled (loaded). Maximum Vehicle Capacity is specified in the associated Vehicle Capacity Profile.
Weight PlannedTotal planned Weight amount of all Destinations on planned scheduled routes. (Shown only if Vehicle Capacity Profile of assigned Vehicle has Weight value.)
Weight AvailableTotal available Weight capacity of assigned Vehicles on planned scheduled routes. Maximum Vehicle Capacity is specified in the associated Vehicle Capacity Profile.
Weight (%)Percentage of the maximum available Weight capacity of assigned Vehicles that has been filled (loaded). Maximum Vehicle Capacity is specified in the associated Vehicle Capacity Profile.
Pieces PlannedTotal planned Pieces amount of all Destinations on planned scheduled routes, in number of units. (Shown only if Vehicle Capacity Profile of assigned Vehicle has Weight value.)
Pieces AvailableTotal available Pieces capacity of assigned Vehicles on planned scheduled routes, in number of units. Maximum Vehicle Capacity is specified in the associated Vehicle Capacity Profile.
Pieces (%)Percentage of the maximum available Pieces capacity of assigned Vehicles that has been filled (loaded), in number of units. Maximum Vehicle Capacity is specified in the associated Vehicle Capacity Profile.
Totals
RoutesTotal number of planned routes scheduled for the specified timeframe.
DestinationsTotal number of Destinations included in planned routes scheduled for the specified timeframe.
OrdersTotal number of Orders scheduled for the specified timeframe regardless of their current Order Status.
UsersTotal number of Users assigned to routes scheduled for the specified timeframe.
VehiclesTotal number of Vehicles assigned to routes scheduled for the specified timeframe.
CubeTotal Cube (volume) of planned routes scheduled for the specified timeframe. (Vehicle Capacity Profile doesn’t effect this this value)
WeightTotal Weight value of planned routes scheduled for the specified timeframe. (Vehicle Capacity Profile doesn’t effect this this value)
PiecesTotal number of Pieces on planned routes scheduled for the specified timeframe, in number of units. (Vehicle Capacity Profile doesn’t effect this this value)
Cost per DestinationAverage cost per Destination across all routes scheduled for the specified timeframe.
Cost per HourTotal cost of all Destinations divided by the total Route Duration across all routes scheduled for the specified timeframe.
Projected Time
Service TimeTotal planned Service Time of all Destinations across all routes scheduled for the specified timeframe.
Travel TimeTotal planned Travel Time across all routes scheduled for the specified timeframe.
Total TimeTotal Planned Route Duration = Total Travel Time + Total Service Time + Wait Time + Breaks
Projected Distance
TotalTotal Planned Travel Distance across all routes scheduled for the specified timeframe.
Actual Time
SmartphoneActual Route Duration is calculated based on the received Mobile App GPS data. Duration is measured from when the route was started to when the route was ended by the assigned User on the Mobile App.
TelematicsActual Route Duration is calculated based on the received Telematics GPS data.
MergedActual Route Duration is calculated based on the received Mobile App and Telematics GPS data.
Travel TimeActual Travel Time traveled by assigned Users across routes scheduled for the specified timeframe. Actual Travel Time is calculated based on the on-road Travel Time between Destinations and does not include time spent inside Geofences (Actual Service Time).
Service TimeActual Service Time of all Destinations across routes scheduled for the specified timeframe. Actual Service Time is the time assigned Users spend inside Destination Geofences.
Actual Distance
SmartphoneActual Travel Distance traveled by assigned Users across routes scheduled for the specified timeframe. Actual Travel Distance is calculated based on the on-road Travel Distance between Destinations and does not include distance traveled inside Geofences.
TelematicsActual Travel Distance traveled by assigned Users across routes scheduled for the specified timeframe. Actual Travel Distance is calculated based on the on-road Travel Distance between Destinations and does not include distance traveled inside Geofences.
MergedActual Travel Distance traveled by assigned Users across routes scheduled for the specified timeframe. Actual Travel Distance is calculated based on the on-road Travel Distance between Destinations and does not include distance traveled inside Geofences.
Emissions CO2The CO₂ Emissions of assigned Vehicles across routes scheduled for the specified timeframe. Emissions are calculated based on the Vehicle Fuel Type and Fuel Consumption settings. If no Fuel Type is specified in the Vehicle Profile, gasoline is used for the calculation; if no Fuel Consumption is specified, 10mpg is used for the calculation.
Compliance
NotesTotal number of Notes attached to Destinations across routes scheduled for the specified timeframe. Normally, Notes are attached to Destinations by the assigned User using the Mobile App.
SignaturesTotal number of customer signatures attached to Destinations across routes scheduled for the specified timeframe. Normally, customer signatures are captured by and attached to Destination Notes by the assigned User using the Mobile App.
ImagesTotal number of images (photos) attached to Destinations across routes scheduled for the specified timeframe. Normally, images are captured by and attached to Destination Notes by the assigned User using the Mobile App.
FormsTotal number of Forms attached to Destinations across routes scheduled for the specified timeframe. Normally, Forms are attached to Destination Notes by the assigned User using the Mobile App.
Workflows
CompletedPercentage of planned Destination Workflows completed across routes scheduled for the specified timeframe. A Workflow is completed when all mandatory tasks are successfully executed and the Destination is marked as “Done” on the Mobile App.
PendingPercentage of planned Destination Workflows not yet completed across routes scheduled for the specified timeframe. A Workflow is completed when all mandatory tasks are successfully executed and the Destination is marked as “Done” on the Mobile App.
FailedPercentage of failed Destination Workflows across routes scheduled for the specified timeframe. A Workflow is failed when any mandatory tasks are not successfully completed and the Destination is marked as “Failed” on the Mobile App.
Users
NameName of the User associated with the corresponding data or asset.
EmailEmail address of the Userassociated with the corresponding data or asset. This is also the email address used by the user to sign in to Route4Me’s Web Software.
Vehicle
NameAlias or name of the vehicle associated with the corresponding asset or data. Can be used to easily find vehicles in the Vehicles List and other interfaces.
TypeVehicle’s dimensions and usage settings, as well as any specialized regulations or restrictions associated with the vehicle.
License PlateVehicle’s unique license plate number, issued for identification.
VINVehicle Identification Number, a unique code used to identify the vehicle.
VehiclesTotal number of vehicles with the corresponding Vehicle Type. This column is only available in the Vehicle Types category.
Route
NameAlias or name of the route associated with the corresponding asset or data. Can be used to easily find routes in the Routes List and other interfaces.
Scheduled forDate the respective route is scheduled for (Planned Route Start Date).
UserUser assigned to the respective route.
VehicleVehicle assigned to the respective route.
Facility
NameName or alias of the Facility associated with the corresponding asset or data.
TypeCustomizable type of the Facility associated with the corresponding asset or data.
State
State NameName of the state in which the corresponding asset or data is located.
Orders
TotalTotal number of Orders scheduled for the specified timeframe regardless of their current Order Status.
ScheduledTotal number of Orders that currently have the the “Scheduled” status scheduled for the specified timeframe.
Scheduled (%)Percentage of total Orders that currently have the “Scheduled” status scheduled for the specified timeframe.
PendingTotal number of Orders scheduled for the specified timeframe with a Pending status: New, Possession Scan, Sorted, Loaded, Manually Loaded, Routed, Unrouted, Sorted by Route, Route Started, Pick Up Scan, Hold for Pickup.
Pending (%)Percentage of total Orders scheduled for the specified timeframe with a Pending status: New, Possession Scan, Sorted, Loaded, Manually Loaded, Routed, Unrouted, Sorted by Route, Route Started, Pick Up Scan, Hold for Pickup.
SortedTotal number of Orders scheduled for the specified timeframe that currently have or had the “Sorted” status at any point.
Sorted (%)Percentage of total Orders scheduled for the specified timeframe that currently have or had the “Sorted” status at any point.
ScannedTotal number of Orders scheduled for the specified timeframe that currently have or had the “Scanned” status at any point.
Scanned (%)Percentage of total Orders scheduled for the specified timeframe that currently have or had the “Scanned” status at any point.
CompletedTotal number of Orders scheduled for the specified timeframe that currently have the “Closed” (Done) status.
Completed (%)Percentage of total Orders scheduled for the specified timeframe that currently have the “Closed” (Done) status.
CanceledTotal number of Orders scheduled for the specified timeframe that currently have the “Canceled” status.
Canceled (%)Percentage of total Orders scheduled for the specified timeframe that currently have the “Canceled” status.
Unable to deliverTotal number of Orders scheduled for the specified timeframe that currently have the “Unable to Deliver” status.
Unable to deliver (%)Percentage of total Orders scheduled for the specified timeframe that currently have the “Unable to Deliver” status.

 

NOTE: The different Dashboard categories support different data columns. You can see which category supports which data column types in the table below. Specifically, see which top headers are available in which data table tabs.

ColumnSummaryUsersVehiclesVehicle TypesRoutesFacilitiesStatesOrders
Period
Arrivals
Departures
Performance
Utilization
Totals
Projected Time
Projected Distance
Actual Time
Actual Distance
Compliance
Workflows
User
Vehicle
Route
Facility
States
Orders

 

Export Analytics – Download Business Performance Data Spreadsheet

After you’ve filtered and adjusted the Dashboard to your preference, you can easily export a spreadsheet with performance analytics. To do so, simply click the Download Button. The Dashboard will open the “Export Data as File” panel where you can customize which KPI data columns you want to include in your exported performance spreadsheet. Enable data columns by checking the boxes next to them and change their order by dragging column names on the right. When done, click the “Export” button to download your customized analytics file.

After you've filtered and adjusted the Dashboard to your preference, you can easily export a spreadsheet with performance analytics. To do so, simply click the Download Button.

 

 

Was this article helpful?
Still can't find what you're looking for? Contact us
Route4Me

About Route4Me

Route4Me has over 40,000 customers globally. Route4Me's Android and iPhone mobile apps have been downloaded over 2 million times since 2009. Extremely easy-to-use, Route4Me's apps create optimized routes, synchronize routes to mobile devices, enable communication with drivers and customers, offer turn-by-turn directions, delivery confirmation, and more. Behind the scenes, Route4Me's operational optimization platform combines high-performance algorithms with data science, machine learning, and big data to plan, optimize, and analyze routes of almost any size in real-time.