Plan / Fact
The Plan / Fact section is designed to work with reports that show the accuracy of planning and information about the actual planning indicators.
In this section, you can prepare and download reports and generate graphs.
Large report in Excel
For more information on working with reports, see Plan / Fact reports.
The report file consists of several sheets.
- Days
-
A comparison of planned and actual indicators for each day of the selected period.
For example, Planned total mileage, km and Actual total mileage, km.
Description of fieldsField name Description Date The date that routes are planned for Company ID The unique identifier of the company that data is collected for Total amount of drivers/couriers The number of couriers that routes were planned for Total amount of routes The number of planned runs Total amount of active routes (where orders status changed) The number of runs where at least one order has a status other than Approved (Delivered, Partially delivered, or Cancelled). For more information, see Order statuses Total amount of active routes in % The share of the total number of runs where at least one order has a status other than Approved Total amount of routes with GPS signal (online); Total amount of routes with GPS signal (online) in % The number of runs that sent coordinates; their share in the total number of planned runs Total amount of routes with no GPS signal (offline); Total amount of routes with no GPS signal (offline) in % The number of runs that didn't send coordinates; their share in the total number of planned runs Total amount of served orders; Total amount of served orders in % The number of orders whose status has been changed; their share in the total number of planned orders Delivered orders; Delivered orders in % The number of delivered orders; their share in the total number of planned orders Planned total distance, km The total mileage on the routes planned for the day for all couriers Actual total distance, km The actual mileage on the routes for the day for all couriers. For more information, see Route tracking Planned total transit time, min The total transit time on the routes planned for the day for all couriers Actual total transit time, min The actual transit time in a day for all couriers. For more information, see Route tracking Planned total service time, min The planned total handling time at depots and at order locations Actual total service time on orders, min The total time that couriers spent on handling orders at order locations (handing over orders, exchanging documents, and parking) Actual total service time at depots, min The total time that couriers spent in depots loading, reloading, and unloading orders and exchanging documents Planned total time, min The total time to complete all routes planned for the day. Includes planned transit time and planned handling time Actual total time, min The actual total time spent completing all routes for the day. Includes transit time and handling time Planned number of time window violations The total number of time window violations in all routes planned for the day Actual number of time window violations The total number of time window violations in routes during the day Planned number of locations The planned number of locations in routes. Includes orders and depots Actual number of locations The actual number of locations visited in routes. Includes orders and depots. For more information, see Detecting visits to route locations Planned number of orders The number of orders planned for the day for all couriers Actual number of orders The number of orders actually delivered during the day by all couriers Number of orders with comments from driver The number of orders where couriers left comments about statuses Number of downtimes on orders The number of long unplanned stops at order locations. For more information, see Courier downtime Total downtime on orders The total amount of long unplanned downtime at order locations Number of downtimes in depots The number of long unplanned stops at depots Total downtime in depots The total amount of long unplanned downtime at depots Number of downtimes in route The number of long unplanned stops between route locations Total downtime in route The total amount of long unplanned stops between route locations Number of events when network connection was lost The number of times when couriers weren't connected to the internet Total time without network connection The total amount of time when couriers weren't connected to the internet Number of routes with a orders manual (logistician) sequence violation The number of runs where couriers violated the planned order sequence Number of routes with a planned orders sequence violation The number of runs with recorded deviations from the planned indicators. The counter increases when the route has a courier_violated_route
flagField name Description Date The date that routes are planned for Company ID The unique identifier of the company that data is collected for Total amount of drivers/couriers The number of couriers that routes were planned for Total amount of routes The number of planned runs Total amount of active routes (where orders status changed) The number of runs where at least one order has a status other than Approved (Delivered, Partially delivered, or Cancelled). For more information, see Order statuses Total amount of active routes in % The share of the total number of runs where at least one order has a status other than Approved Total amount of routes with GPS signal (online); Total amount of routes with GPS signal (online) in % The number of runs that sent coordinates; their share in the total number of planned runs Total amount of routes with no GPS signal (offline); Total amount of routes with no GPS signal (offline) in % The number of runs that didn't send coordinates; their share in the total number of planned runs Total amount of served orders; Total amount of served orders in % The number of orders whose status has been changed; their share in the total number of planned orders Delivered orders; Delivered orders in % The number of delivered orders; their share in the total number of planned orders Planned total distance, km The total mileage on the routes planned for the day for all couriers Actual total distance, km The actual mileage on the routes for the day for all couriers. For more information, see Route tracking Planned total transit time, min The total transit time on the routes planned for the day for all couriers Actual total transit time, min The actual transit time in a day for all couriers. For more information, see Route tracking Planned total service time, min The planned total handling time at depots and at order locations Actual total service time on orders, min The total time that couriers spent on handling orders at order locations (handing over orders, exchanging documents, and parking) Actual total service time at depots, min The total time that couriers spent in depots loading, reloading, and unloading orders and exchanging documents Planned total time, min The total time to complete all routes planned for the day. Includes planned transit time and planned handling time Actual total time, min The actual total time spent completing all routes for the day. Includes transit time and handling time Planned number of time window violations The total number of time window violations in all routes planned for the day Actual number of time window violations The total number of time window violations in routes during the day Planned number of locations The planned number of locations in routes. Includes orders and depots Actual number of locations The actual number of locations visited in routes. Includes orders and depots. For more information, see Detecting visits to route locations Planned number of orders The number of orders planned for the day for all couriers Actual number of orders The number of orders actually delivered during the day by all couriers Number of orders with comments from driver The number of orders where couriers left comments about statuses Number of downtimes on orders The number of long unplanned stops at order locations. For more information, see Courier downtime Total downtime on orders The total amount of long unplanned downtime at order locations Number of downtimes in depots The number of long unplanned stops at depots Total downtime in depots The total amount of long unplanned downtime at depots Number of downtimes in route The number of long unplanned stops between route locations Total downtime in route The total amount of long unplanned stops between route locations Number of events when network connection was lost The number of times when couriers weren't connected to the internet Total time without network connection The total amount of time when couriers weren't connected to the internet Number of routes with a orders manual (logistician) sequence violation The number of runs where couriers violated the planned order sequence Number of routes with a planned orders sequence violation The number of runs with recorded deviations from the planned indicators. The counter increases when the route has a courier_violated_route
flag - Days-Depots
-
A separate comparison of indicators for each depot specified in the routes for the selected period. The indicators for comparison are the same as on the Days sheet, but are linked to a specific depot.
Description of fieldsField name Description Date The date that routes are scheduled for Company ID The unique identifier of the company that data is collected for Depot ID The unique identifier of the depot Depot number An additional depot ID (the depot.ref
field)Depot name The name of the depot (the depot.title
field)Depot address The address of the depot (the depot.address
field)Total amount of drivers/couriers The number of couriers that routes were planned for Total amount of routes The number of planned runs Total amount of active routes (where orders status changed) The number of runs where at least one order has a status other than Approved (Delivered, Partially delivered, or Canceled). For more information, see Order statuses Total amount of active routes in % The share of the total number of runs where at least one order has a status other than Approved Total amount of routes with GPS signal (online); Total amount of routes with GPS signal (online) in % The number of runs that sent coordinates; their share in the total number of planned runs Total amount of routes with no GPS signal (offline); Total amount of routes with no GPS signal (offline) in % The number of runs that didn't send coordinates; their share in the total number of planned runs Total amount of served orders; Total amount of served orders in % The number of orders whose status has been changed; their share in the total number of planned orders Delivered orders; Delivered orders in % The number of delivered orders; their share in the total number of planned orders Planned total distance, km The total mileage on the routes planned for the day for all couriers Actual total distance, km The actual mileage on the routes for the day for all couriers. For more information, see Route tracking Planned total service time, min The total service time on the routes planned for the day for all couriers Actual total service time, min The actual service time in a day for all couriers. For more information, see Route tracking Planned total service time, min The planned total handling time at depots and at order locations Actual total service time on orders, min The total time that couriers spent on handling orders at order locations (handing over orders, exchanging documents, and parking) Actual total service time at depots, min The total time that couriers spent in depots loading, reloading, and unloading orders and exchanging documents Planned total time, min The total time to complete all routes planned for the day. Includes planned transit time and planned handling time Actual total time, min The actual total time spent completing all routes for the day. Includes transit time and handling time Planned number of time window violations The total number of time window violations in all routes planned for the day Actual number of time window violations The total number of time window violations in routes during the day Planned number of locations The planned number of locations in routes. Includes orders and depots Actual number of locations The actual number of locations visited in routes. Includes orders and depots. For more information, see Detecting visits to route locations Planned number of orders The number of orders planned for the day for all couriers Actual number of orders The number of orders actually delivered during the day by all couriers Number of orders with status comments The number of orders where couriers left comments about statuses Number of downtimes during orders The number of long unplanned stops at order locations. For more information, see Courier downtime Total downtime during orders The total amount of long unplanned downtime at order locations Number of downtimes in depots The number of long unplanned stops at depots Total downtime in depots The total amount of long unplanned downtime at depots Number of downtimes in route The number of long unplanned stops between route locations Total downtime in route The total amount of long unplanned stops between route locations Number of events where network connection was lost The number of times when couriers weren't connected to the internet Total time without network connection The total amount of time when couriers weren't connected to the internet Number of routes with a logistician sequence violation The number of runs where couriers violated the planned order sequence Number of routes with a planned orders sequence violation The number of runs with recorded deviations from the planned indicators. The counter increases when the route has a courier_violated_route
flagField name Description Date The date that routes are scheduled for Company ID The unique identifier of the company that data is collected for Depot ID The unique identifier of the depot Depot number An additional depot ID (the depot.ref
field)Depot name The name of the depot (the depot.title
field)Depot address The address of the depot (the depot.address
field)Total amount of drivers/couriers The number of couriers that routes were planned for Total amount of routes The number of planned runs Total amount of active routes (where orders status changed) The number of runs where at least one order has a status other than Approved (Delivered, Partially delivered, or Canceled). For more information, see Order statuses Total amount of active routes in % The share of the total number of runs where at least one order has a status other than Approved Total amount of routes with GPS signal (online); Total amount of routes with GPS signal (online) in % The number of runs that sent coordinates; their share in the total number of planned runs Total amount of routes with no GPS signal (offline); Total amount of routes with no GPS signal (offline) in % The number of runs that didn't send coordinates; their share in the total number of planned runs Total amount of served orders; Total amount of served orders in % The number of orders whose status has been changed; their share in the total number of planned orders Delivered orders; Delivered orders in % The number of delivered orders; their share in the total number of planned orders Planned total distance, km The total mileage on the routes planned for the day for all couriers Actual total distance, km The actual mileage on the routes for the day for all couriers. For more information, see Route tracking Planned total service time, min The total service time on the routes planned for the day for all couriers Actual total service time, min The actual service time in a day for all couriers. For more information, see Route tracking Planned total service time, min The planned total handling time at depots and at order locations Actual total service time on orders, min The total time that couriers spent on handling orders at order locations (handing over orders, exchanging documents, and parking) Actual total service time at depots, min The total time that couriers spent in depots loading, reloading, and unloading orders and exchanging documents Planned total time, min The total time to complete all routes planned for the day. Includes planned transit time and planned handling time Actual total time, min The actual total time spent completing all routes for the day. Includes transit time and handling time Planned number of time window violations The total number of time window violations in all routes planned for the day Actual number of time window violations The total number of time window violations in routes during the day Planned number of locations The planned number of locations in routes. Includes orders and depots Actual number of locations The actual number of locations visited in routes. Includes orders and depots. For more information, see Detecting visits to route locations Planned number of orders The number of orders planned for the day for all couriers Actual number of orders The number of orders actually delivered during the day by all couriers Number of orders with status comments The number of orders where couriers left comments about statuses Number of downtimes during orders The number of long unplanned stops at order locations. For more information, see Courier downtime Total downtime during orders The total amount of long unplanned downtime at order locations Number of downtimes in depots The number of long unplanned stops at depots Total downtime in depots The total amount of long unplanned downtime at depots Number of downtimes in route The number of long unplanned stops between route locations Total downtime in route The total amount of long unplanned stops between route locations Number of events where network connection was lost The number of times when couriers weren't connected to the internet Total time without network connection The total amount of time when couriers weren't connected to the internet Number of routes with a logistician sequence violation The number of runs where couriers violated the planned order sequence Number of routes with a planned orders sequence violation The number of runs with recorded deviations from the planned indicators. The counter increases when the route has a courier_violated_route
flag - Routes
-
A comparison of run indicators.
For example, Planned finish time and Actual finish time.
Description of fieldsField name Description Company ID The unique identifier of the company that data is collected for Route ID The unique run ID Route number The number shown in the dashboard for the run Route date The date that the run is planned for Route IMEI The IMEI number of the GPS tracker. For more information, see Setting up data transfer from devices Link to the route in UI The link to the route on the map in the routing workspace Courier/driver ID The unique ID of the courier Courier/driver number The courier's number (the vehicle.id
field)Courier/driver name The courier's name and the name or number of the vehicle (the vehicle.ref
field)Courier/driver phone The courier's phone number (the vehicle.phone
field)Depot ID The unique identifier of the depot Depot number An additional depot ID (the depot.ref
field)Depot name The name of the depot (the depot.title
field)Depot address The address of the depot (the depot.address
field)Depot time zone The name of the time zone the depot is in Has the track been recorded? TRUE
if at least one courier location was recorded during the run, andFALSE
if there weren't any recorded geolocationsViolated orders sequence TRUE
if the courier violated the planned order sequence during the run, andFALSE
if there were no violationsPlanned order sequence has been changed TRUE
if deviations from planned indicators were recorded during the run (used if the route has acourier_violated_route
flag), andFALSE
if there were no deviationsPlanned total distance, km; Actual total distance, km The planned and actual run mileage Planned total service time, min; Actual total service time, min The planned and actual service time during the run Planned total service time, min The planned service time at depots and order locations Actual total service time on orders, min The time spent by a courier handling orders at delivery locations (handing orders over, exchanging documents, and parking) Actual total service time at depots, min The time that couriers spent on handling orders at order locations (handing over orders, exchanging documents, and parking) Planned total time, min; Actual total time, min The planned and actual total time on the route Planned number of time window violations; Actual number of time window violations The planned and actual number of time window violations during the run Planned number of locations; Actual number of locations The planned and actual number of locations in the run Planned number of orders; Actual number of orders The planned and actual number of orders delivered during the run Planned start time; Planned finish time The planned start and end time of the run Actual start time; Actual finish time The actual start and end time of the run Total amount of served orders; Total amount of served orders in % The number of orders whose status has been changed; their share in the total number of planned orders Delivered orders; Delivered orders in % The number of delivered orders; their share in the total number of planned orders Number of downtimes on orders The number of long unplanned stops at order locations. For more information, see Courier downtime Total downtime on orders The total amount of long unplanned downtime at order locations Number of downtimes in depots The number of long unplanned stops at depots Total downtime in depots The total amount of long unplanned downtime at depots Number of downtimes in route The number of long unplanned stops between route locations Total downtime in route The total amount of long unplanned stops between route locations Number of events when network connection was lost The number of times when couriers weren't connected to the internet Total time without network connection The total amount of time when couriers weren't connected to the internet Number of orders with comments from driver The number of orders where couriers left comments about statuses Field name Description Company ID The unique identifier of the company that data is collected for Route ID The unique run ID Route number The number shown in the dashboard for the run Route date The date that the run is planned for Route IMEI The IMEI number of the GPS tracker. For more information, see Setting up data transfer from devices Link to the route in UI The link to the route on the map in the routing workspace Courier/driver ID The unique ID of the courier Courier/driver number The courier's number (the vehicle.id
field)Courier/driver name The courier's name and the name or number of the vehicle (the vehicle.ref
field)Courier/driver phone The courier's phone number (the vehicle.phone
field)Depot ID The unique identifier of the depot Depot number An additional depot ID (the depot.ref
field)Depot name The name of the depot (the depot.title
field)Depot address The address of the depot (the depot.address
field)Depot time zone The name of the time zone the depot is in Has the track been recorded? TRUE
if at least one courier location was recorded during the run, andFALSE
if there weren't any recorded geolocationsViolated orders sequence TRUE
if the courier violated the planned order sequence during the run, andFALSE
if there were no violationsPlanned order sequence has been changed TRUE
if deviations from planned indicators were recorded during the run (used if the route has acourier_violated_route
flag), andFALSE
if there were no deviationsPlanned total distance, km; Actual total distance, km The planned and actual run mileage Planned total service time, min; Actual total service time, min The planned and actual service time during the run Planned total service time, min The planned service time at depots and order locations Actual total service time on orders, min The time spent by a courier handling orders at delivery locations (handing orders over, exchanging documents, and parking) Actual total service time at depots, min The time that couriers spent on handling orders at order locations (handing over orders, exchanging documents, and parking) Planned total time, min; Actual total time, min The planned and actual total time on the route Planned number of time window violations; Actual number of time window violations The planned and actual number of time window violations during the run Planned number of locations; Actual number of locations The planned and actual number of locations in the run Planned number of orders; Actual number of orders The planned and actual number of orders delivered during the run Planned start time; Planned finish time The planned start and end time of the run Actual start time; Actual finish time The actual start and end time of the run Total amount of served orders; Total amount of served orders in % The number of orders whose status has been changed; their share in the total number of planned orders Delivered orders; Delivered orders in % The number of delivered orders; their share in the total number of planned orders Number of downtimes on orders The number of long unplanned stops at order locations. For more information, see Courier downtime Total downtime on orders The total amount of long unplanned downtime at order locations Number of downtimes in depots The number of long unplanned stops at depots Total downtime in depots The total amount of long unplanned downtime at depots Number of downtimes in route The number of long unplanned stops between route locations Total downtime in route The total amount of long unplanned stops between route locations Number of events when network connection was lost The number of times when couriers weren't connected to the internet Total time without network connection The total amount of time when couriers weren't connected to the internet Number of orders with comments from driver The number of orders where couriers left comments about statuses - Nodes
-
A comparison of indicators for each individual order.
For example, Planned distance to the location, km and Actual distance to the location, km.
Description of fieldsField name Description Company ID The unique identifier of the company that data is collected for Route ID The unique run ID Route number The number shown in the dashboard for the run Route date The date that the run is planned for Courier/driver ID The unique ID of the courier Courier/driver number The courier's number (the vehicle.id
field)Courier/driver name The courier's name and the name or number of the vehicle (the vehicle.ref
field)Depot ID The unique identifier of the depot Depot number An additional depot ID (the depot.ref
field)Depot name The name of the depot (the depot.title
field)Planned location type; Actual location type Possible values: Order, Depot (the actual location type isn't specified for depots) Planned order sequence The location's sequential number in the “Plan/Fact” report. Numbering starts from 0. All location types are taken into account Actual order sequence The number of the order in the sequence that it was visited by the courier. Only locations with the “Order” type are taken into account. Order sequence edited by logistician The number of the order in the routing workspace. Only locations with the “Order” type are taken into account. Planned number Consists of either the location.id
field and the planned date for visiting the location or thedepot.id
field for the depotActual number Consists of the location.ref
field and the actual date of visiting the location. Not specified for depotsActual order status The order status. For more information, see Order statuses Planned address; Actual address The address of the location Planned latitude; Planned longitude; Actual latitude; Actual longitude The coordinates of the location Latitude specified by courier/driver; Longitude specified by courier/driver The coordinates of the location if the courier entered them manually in the mobile app Delivery detection radius The detection radius. For more information, see Detecting visits to route locations Planned client name The name of the client for uploading the route to Track & Trace Actual client name The name of the client as it was entered by the courier Planned time of arrival; Planned time of departure The planned time of arrival at and departure from the location Actual time of arrival; Actual time of departure The actual time of arrival at and departure from the location Planned service time, min The planned time for handing over an order to the client; the planned time for loading, reloading, or unloading the order at the depot Planned shared service time, min The planned time for parking or handing over documents to the client; the planned time for handing over documents at the depot Actual service time, min The time spent handing the order over to the client Actual downtime at location, min The waiting time at the location Planned transit time, min The planned time to travel from the previous location to this one Actual transit time, min The time spent traveling from the previous location to this one Actual downtime on the way to location, min The amount of extended downtime on the way from the previous location to this one Planned distance, km The planned distance from the previous location to this one Actual distance, km The distance traveled from the previous location to this one Planned order volume, cubic meters; Planned order weight, kg; Planned number of units The physical parameters of the order specified during planning Actual order volume, m³; Actual order weight, kg; Actual order size The physical parameters of the order specified by the courier Planned date of the beginning delivery interval; Planned time of the beginning delivery interval; Planned date of the ending delivery interval; Planned time of the ending delivery interval The date and time of the planned time window of the visit Delivery time window violation TRUE
if the planned delivery time window was violated, andFALSE
if there were no violationsActual date of the beginning delivery interval; Actual time of the beginning delivery interval; Actual date of the ending delivery interval; Actual time of the ending delivery interval The date and time of the actual time window of the visit to the location (if several possible time windows were specified during planning, a time window that's different from the planned one can be used) Actual delivery time window violation TRUE
if the delivery time window was violated, andFALSE
if there were no violationsComment The comments that the courier left about the order Status comments The comment that the courier left about the order status Field name Description Company ID The unique identifier of the company that data is collected for Route ID The unique run ID Route number The number shown in the dashboard for the run Route date The date that the run is planned for Courier/driver ID The unique ID of the courier Courier/driver number The courier's number (the vehicle.id
field)Courier/driver name The courier's name and the name or number of the vehicle (the vehicle.ref
field)Depot ID The unique identifier of the depot Depot number An additional depot ID (the depot.ref
field)Depot name The name of the depot (the depot.title
field)Planned location type; Actual location type Possible values: Order, Depot (the actual location type isn't specified for depots) Planned order sequence The location's sequential number in the “Plan/Fact” report. Numbering starts from 0. All location types are taken into account Actual order sequence The number of the order in the sequence that it was visited by the courier. Only locations with the “Order” type are taken into account. Order sequence edited by logistician The number of the order in the routing workspace. Only locations with the “Order” type are taken into account. Planned number Consists of either the location.id
field and the planned date for visiting the location or thedepot.id
field for the depotActual number Consists of the location.ref
field and the actual date of visiting the location. Not specified for depotsActual order status The order status. For more information, see Order statuses Planned address; Actual address The address of the location Planned latitude; Planned longitude; Actual latitude; Actual longitude The coordinates of the location Latitude specified by courier/driver; Longitude specified by courier/driver The coordinates of the location if the courier entered them manually in the mobile app Delivery detection radius The detection radius. For more information, see Detecting visits to route locations Planned client name The name of the client for uploading the route to Track & Trace Actual client name The name of the client as it was entered by the courier Planned time of arrival; Planned time of departure The planned time of arrival at and departure from the location Actual time of arrival; Actual time of departure The actual time of arrival at and departure from the location Planned service time, min The planned time for handing over an order to the client; the planned time for loading, reloading, or unloading the order at the depot Planned shared service time, min The planned time for parking or handing over documents to the client; the planned time for handing over documents at the depot Actual service time, min The time spent handing the order over to the client Actual downtime at location, min The waiting time at the location Planned transit time, min The planned time to travel from the previous location to this one Actual transit time, min The time spent traveling from the previous location to this one Actual downtime on the way to location, min The amount of extended downtime on the way from the previous location to this one Planned distance, km The planned distance from the previous location to this one Actual distance, km The distance traveled from the previous location to this one Planned order volume, cubic meters; Planned order weight, kg; Planned number of units The physical parameters of the order specified during planning Actual order volume, m³; Actual order weight, kg; Actual order size The physical parameters of the order specified by the courier Planned date of the beginning delivery interval; Planned time of the beginning delivery interval; Planned date of the ending delivery interval; Planned time of the ending delivery interval The date and time of the planned time window of the visit Delivery time window violation TRUE
if the planned delivery time window was violated, andFALSE
if there were no violationsActual date of the beginning delivery interval; Actual time of the beginning delivery interval; Actual date of the ending delivery interval; Actual time of the ending delivery interval The date and time of the actual time window of the visit to the location (if several possible time windows were specified during planning, a time window that's different from the planned one can be used) Actual delivery time window violation TRUE
if the delivery time window was violated, andFALSE
if there were no violationsComment The comments that the courier left about the order Status comments The comment that the courier left about the order status
Graphs
In this section, you can plot graphs by the number of routes or orders completed for one or more depots. You can also compare graphs for different periods with each other and download a report on the selected depot.
For more information on working with graphs, see Plan / Fact graphs.