❗Note: Some features or options when building reports may vary or be limited in the Onde.Light solution.
The Drivers Report gives you a clear picture of each driver’s profile, vehicle, and activity over a selected period. Use it to assess driver KPIs and make informed fleet management decisions. Among other things, it shows:
The number of offers a driver accepted, rejected, or ignored
The number of orders a driver cancelled
The total service and transaction fees a driver paid under their plan
Example: If the report shows that a driver often ignores or rejects offers, contact them to find out why. Temporary account suspension may be an appropriate response. If the report shows a rise in driver cancellations, consider introducing cancellation fees.
Below are the report columns and what they mean. The letters match the column letters in the exported file.
Column | Field | Description |
|---|---|---|
A | Driver ID | Unique ID generated by the system. |
B | Custom key | Internal driver ID that a company manager can set in My hub. |
C | Name | Driver’s name. |
D | Driver’s email. | |
E | Phone | Driver’s phone number. |
F | Profile state | Driver’s profile status: active, invited, not activated, suspended, or closed. You can see it in the Drivers tab of My hub and update it from the driver’s profile. For example, suspending an active driver changes the status to Suspended, and deleting a profile changes it to Closed. |
G | Driver license | Driver’s license number. |
H | About driver | A note about the driver, filled in by the company owner in the driver’s profile. For example, you can use it to tell drivers from partner fleets apart. |
These columns are relevant only for partners in KSA. To activate the WASL integration, write to [email protected].
Column | Field | Description |
|---|---|---|
I | WASL status | Driver’s status in the WASL system. |
J | WASL driver eligibility expires at | Last day the driver is eligible in WASL. |
K | WASL vehicle eligibility expires at | Last day the vehicle is eligible in WASL. |
L | WASL vehicle license expires at | Last day the vehicle’s license is valid in WASL. |
Column | Field | Description |
|---|---|---|
M | Payment documents | Temporarily not available. |
N | Vehicle type | Main vehicle type the driver works on (Classic, Economy, Business, etc.). |
O | Vehicle model | Driver’s car model (for example, Volkswagen Polo). |
P | Vehicle color | Driver’s car color. |
Q | Year | Car production year. |
R | Vehicle plate number | Car plate number. |
S | Vehicle board number | Car board number. |
T | Max passengers | Number of passenger seats in the car. |
Column | Field | Description |
|---|---|---|
U | Total orders | Number of orders the driver performed during the reporting period (instant and pre-orders). Equals AJ + AK + AL + AM + AN + AO + AQ + AR (CANCELLED_BY_DISPATCHER + CANCELLED_BY_DRIVER + CANCELLED_NO_PASSENGER + CANCELLED_DECIDED_NOT_TO_GO + CANCELLED_NO_TAXI + CANCELLED_DRIVER_OFFLINE + FINISHED_PAID + FINISHED_UNPAID). |
V | Total ASAP offers | Number of ASAP offers the driver received during the reporting period. Equals W + X + Y. |
W | Accepted ASAP offers | Number of ASAP orders the driver accepted. |
X | Rejected ASAP offers | Number of ASAP orders the driver rejected. |
Y | Ignored ASAP offers | Number of ASAP orders the driver ignored. |
Z | Total future offers | Number of future-order offers the driver received during the reporting period. Offers for future orders are added once the pre-order is completed. Equals AA + AB + AC. |
AA | Accepted future offers | Number of future orders the driver accepted. |
AB | Rejected future offers | Number of future orders the driver rejected. |
AC | Ignored future offers | Number of future orders the driver ignored. |
AD | Cancelled orders | Total number of ASAP and future orders the driver cancelled during the reporting period. |
Column | Field | Description |
|---|---|---|
AE | Total balance refill (currency) | Total amount added to or debited from the driver’s balance during the reporting period. Includes successful customer card payments, payments via third-party payment methods, successful driver card top-ups, manual driver account corrections in My hub (+ and −), promo code discounts, and driver payout transactions. |
AF | Total service fees (currency) | Total “Order fees” under the driver’s subscription: fee per period + total cost per order + driver cancellation fee. |
AG | Total transaction fees (currency) | Total “Transaction fees” under the driver’s subscription (total cost per transaction). |
AH | Paid orders total (currency) | Sum of all successful trip payments by clients during the reporting period. |
AI | Unpaid orders total (currency) | Total amount for all unpaid orders during the reporting period. |
Column | Field | Description |
|---|---|---|
AJ | CANCELLED_BY_DISPATCHER | Orders cancelled by the operator. |
AK | CANCELLED_BY_DRIVER | Orders cancelled by the driver. |
AL | CANCELLED_NO_PASSENGER | Orders that ended because the customer didn’t show up. The driver can select this reason if the customer hasn’t reached the pickup location after more than 5 minutes. The customer is charged a cancellation fee, if one is set. |
AM | CANCELLED_DECIDED_NOT_TO_GO | Orders cancelled because the customer decided not to go. The customer is charged a cancellation fee, if one is set. |
AN | CANCELLED_NO_TAXI | Orders cancelled by the customer because the driver was late: more than 3 minutes past the ETA and more than 200 meters from the pickup location. The driver is charged a cancellation fee, if one is set. |
AO | CANCELLED_DRIVER_OFFLINE | Orders cancelled because the driver was offline for more than 10 minutes. |
AP | CANCELLED_EXPIRED | Pre-orders that had a driver assigned, but the driver didn’t arrive at the pickup location. This status is assigned 2 days after the pickup time requested by the customer. |
AQ | FINISHED_PAID | Orders finished with “Paid” status. |
AR | FINISHED_UNPAID | Orders finished with “Unpaid” status. |
Column | Field | Description |
|---|---|---|
AS | Current plan | Name of the driver’s current plan (if available). |
AT | Next plan | Name of the driver’s next plan (if available). |
AU | Next plan starts | Date and time of the transfer to the next plan. |
AV | Sub-state | The driver’s activation step (see values below). |
Sub-state values:
INCOMPLETE_REGISTRATION: the driver didn’t fill in all the required fields.
WAITING_FOR_ACTIVATION: all information is added, and the profile is waiting for the company manager’s approval.
REJECTED: the company manager rejected the driver’s application.
ACTIVATION_ON_HOLD: the company manager postponed accepting or rejecting the application.
