Orders reports help you to have all the information about your bookings. Here you can get all the information about each particular order or monitor statistics of your company. Orders report remains the most extended tool to resolve dispute cases with clients because it gives you the time and location of the driver while providing the service. To make your navigation through the report below you have a description of every piece of data there.
Order ID
Unique identification number of the order generated by the system
Created at
Date and time of order creation. At this very moment, the order is submitted to the system and dispatched between drivers
Author ID
Unique identification number of the person/facility used to create an order. It can be the id of a: a) Customer; b) Operator; c) Web App; d) 1-click Taxi Button; f) Third party system integrated with Onde
Order source
A facility used for order creation. It can be: a) CustomerApp; b) OperatorApp; c)Web App (orders created with a One-click taxi button have operator app order source)
Bundle
Bundle identifier is the namespace of the app used to create an order. It can be: a) ios.passenger.yourbundle; b) android.passenger.yourbundle; c) web.dispatcher; d) api.dispatch.v1.2664e0df-93f5-4b41-83cf-01dd381c11e0 (One-click taxi button); e) web.passenger.yourbundle (web app)
Requested vehicle type
Service the client booked. Remember that customer always pays for the service ordered, not the one he/she finally received
Requested pickup
Time and date when the customer wants to receive a service. It can be ASAP or pre-booking. In pre-booking case, a date and time of the order are provided
Origin type
A way the author of the order chose the pick-up location. It can be: a) PointOnMap (location is set by the pin on the map); b) AddressPoint (order author inserted address); c) Location (location of the client provided by the GPS automatically)
Origin location
GPS coordinates of the pick-up location
Origin address
Address of the pick-up location
Destination type
This column notifies if the author of the booking provided a drop-off location. The cell can have two values: a) AddressPoint (author made a booking with a drop-off point); b) blank (author made booking without drop-off location)
Destination location
GPS coordinates of the drop-off location provided
Destination address
Address of the drop-off location provided
Dropoff type
A way the author of the order chose the drop-off location. It can be: a) PointOnMap (location is set by the pin on the map); b) AddressPoint (order author inserted address); c) Location (location of the client provided by the GPS automatically)
Dropoff location
GPS coordinates of the point where the order finishes
Dropoff address
Address of the location where the order finishes
Dropoffs count
The number of stops the author chose when creating the order. “1” means that the customer was taken from the pick-up to the drop-off directly.
Order notes
A note the client or operator left to the driver while creating the order
Passengers number
Number of seats that should be available in the cab for this order. Operators only can insert this information
Client documents
The list of additional documents added to the customer’s profile
N/B! Temporarily unavailable
Driver payment documents
The list of additional documents added to the driver’s profile
N/B! Temporarily unavailable
Passenger id
Unique identification number of the client who asks for a service
Passenger name
Name of the client who orders the service
Passenger email
Email of the client who orders the service
Passenger phone
Phone number of the client who orders the service
Passenger operator ID
Unique identification number of the operator who creates the order. In case the operator has not been an author of the order, the cell remains blank
Passenger operator name
Name of the operator who creates the order. In case the operator has not been an author of the order, the cell remains blank
Passenger operator email
Email of the operator who creates the order. In case the operator has not been an author of the order, the cell remains blank
Driver operator ID
Unique identification number of the operator who assigns the order. In case the operator has not participated in assigning the order the cell remains blank
Driver operator name
Name of the operator who assigns the order. In case the operator has not participated in assigning the order the cell remains blank
Driver operator email
Email of the operator who assigns the order. In case the operator has not participated in assigning the order the cell remains blank
Driver id
Unique identification number of the driver who accepts the order. In case the order is cancelled before being accepted by any driver or no driver takes the ride, the cell remains blank
Driver custom key
A unique identification the company management sets for the driver. In case the order is cancelled before being accepted by any driver or no driver takes the ride, the cell remains blank
Driver name
In case the order is cancelled before being accepted by any driver or no driver takes the ride, the cell remains blank
Driver email
In case the order is cancelled before being accepted by any driver or no driver takes the ride, the cell remains blank
Driver phone
In case the order is cancelled before being accepted by any driver or no driver takes the ride, the cell remains blank
Vehicle type
Main channel of the driver. It is can be different from the F column (Requested vehicle type) if allowed in the service settings
Vehicle plate number
In case the order is cancelled before being accepted by any driver or no driver takes the ride, the cell remains blank
Vehicle board number
In case the order is cancelled before being accepted by any driver or no driver takes the ride, the cell remains blank
Driver reputation
A driver’s reputation score is logged for any instant order that has been assigned to a driver, regardless of its final status: cancelled, finished paid or finished unpaid. No reputation data is logged in the Order report for preorders and instant orders that were manually assigned from the Operator app.
Driver reputation correction
A temporary change of a driver's reputation score. It shows the correction value applied to a driver's reputation score.
Estimation time
Estimated time of the driver's arrival at the client. The system calculates this value and shows it to the driver before he accepts the trip. After the driver takes the job, the estimated time of arrival will be shown to the customer. This indicator decides on customer or driver cancellation fee application
Estimation distance
Estimated distance from the driver's location to the client. This value is calculated by the system and shown to the driver before he accepts the trip
Driver rate plan
The name of the plan the driver was subscribed to at the moment of order processing. Driver plan name will not be shown if the order was processed before this column was released.
Offer#
The number of times the system makes an offer to the drivers. This is a number of so-called green cards
Reject#
The number of drivers who rejected the offer. Rejected offer does not imply a driver cancellation fee
Total bid#
Number of times drivers and operators bid for the order
Driver bid#
Number of times drivers bid for the order
Dispatcher bid#
Number of times operators assigned orders to themselves
Order status
The final status of the order or simply what happens with the order. It can be:
a) CancelledDecidedNotToGo (client manually cancels the order except for no taxi cases);
b) CancelledByDriver;
c) CancelledByDispatcher;
d) CANCELLED_SEARCH_EXCEEDED (assigned to all unaccepted orders: for instant customer app/web app orders - within 3 minutes upon creation, for instant operator app orders - within 30 minutes upon creation, for pre-orders - if no driver accepted it up to the pick-up time);
e) CANCELLED_EXPIRED - when the systems automatically cancel pre-booking if it hasn't been started by the driver
f) CANCELLED_DRIVER_OFFLINE - order cancelled by the system for technical reasons
g) STARTED (driver accepted the order);
h) ARRIVED (driver swiped arrived);
i) TRANSFERRING (customer is in the cab and order is in the process);
j) REVIEW_SUMMARY (cab arrived and the driver has to confirm the total amount to pay (or report no funds case or wrong total case);
k) FinishedPaid;
l) FinishedUnpaid.
UnpaidReason
This cell gives more details about FinishedUnpaid (column AX) orders. The driver chooses a reason at the end of the ride. It can be: a) WrongPrice; b) NoFunds
UnpaidMessage
Text message left by the driver to explain why a cash/terminal order couldn't be paid.
Cancellation reason
There are reasons that forced customers to cancel the order. They are: 1) FARE_IS_TOO_HIGH; 2) DRIVER_IS_TOO_FAR_AWAY; 3) VEHICLE_DOESNT_FIT_CLASS; 4) JUST_TYING_THE_APP; 5) CHANGED_MY_MIND; 6) CUSTOM_REASON
Cancellation comment
Customer note made after order cancellation with custom reason.
Trip distance
Length of the trip made. This value is essential for the calculation of the order total for regular rates if the calculation is auto
Trip time
Duration of the trip made. This value is essential for the calculation of the order total for regular and hourly rates if the calculation is auto
Intermediate driver IDs
ID of the driver who accepted the order initially, but cancelled it with "Reject service" reason before arrival
Passenger cancellation fee
The amount taken from the customer for cancelling (if configured in the company panel)
Driver cancellation fee
The amount taken from the driver for cancelling (if configured in the company panel)
Trip cost
Cost of the trip in the currency of My Hub. It is based on the major parameters for a rate cost calculation. Trip cost does not include extra costs which the driver can add at the end of the ride
Extra cost
Extra fee the driver adds to the trip cost at the end of the ride
Total cost
A sum of the trip cost (column BH) and extra cost (column BI). This is the final price charged from the client at the end of the ride
Coupon discount
Value of the coupon used for the trip
Tips
Value of tips left by the customer
Bonus amount
Starting bonus added by a customer
Including tax
Additional fee included in the trip cost
Tax
Additional fee added on top of the trip cost
Transactional fee
Additional fee taken for credit card transactions
Final cost
Cost of the trip with coupon discount and additional fees
Unpaid cost
The non-covered part of the trip cost if any
Rounding correction
The rounding value that applied if rounding rule is set
Excess payment
Change sent from driver's to customer's wallet for orders on cash payment method
Payment method
a.Cash, b.Terminal, c.Third-party, d.CreditCard, e.Wallet, f.Corporate account,
g. Apple pay, h.Taxi butler
Payment card
Last four numbers of the credit card used for the payment
Corporate account
If an order is paid by a corporate account, this cell shows the ID of the corporate account used for the payment (one can find ID in the URL of a Corporate account record).
Payment errors
Information about the reason for the unsuccessful credit card payment
Rating by driver
Here you have information about the driver rating his ride
Rating by passenger
Here you have information about your driver ratings
Started at
For asap orders, it is the exact time when the driver accepts the order. For pre-orders, it is the exact time when the driver swipes to start the order.
Started location
GPS coordinates of the location where the driver accepts the trip
Arrived at
The exact time when the driver presses "arrived" to the pick-up location
Arrived location
GPS coordinates of the location where the driver presses "arrived" at the pick-up location
Loaded at
The exact time when the driver presses "start a ride" to the drop-off location
Loaded location
GPS coordinates of the location where the driver presses "start a ride" to the drop off point
Finished at
The exact time when the driver presses "Finish" at the drop location
Finished location
GPS coordinates of the location where the driver presses "Finish" at the drop-off point
Closed at
The time when the order was finalised by the driver
Closed location
GPS coordinates of the location where the order was closed at
Service space
It can be: a) PRODUCTION; b) DEMO
Active
Shows TRUE if the order was ongoing at the time the report was generated
Linked order
In case the order is a back-to-back one, column “Linked order” contains the ID of the order the driver was on when this back-to-back order was offered. If the order is a regular instant one or a pre-order the cell in “Linked order” column is empty
Price multiplier
Dynamic pricing coefficient applied to an order.
Coupon code
Coupon code applied to the order. Applicable only for orders with applied coupons, for other orders the cell remains blank
Promo campaign name
The name of the promo campaign that contains the coupon code applied to the order. Applicable only for orders with applied coupons, for other orders the cell remains blank
Please, consult the posts below for data on other reports available in the system and their management:
