Russian version of the article is available down the link.

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) Webdesk; 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 type the client booked. Remember that customer always pays for the service type 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 type 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

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

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 operator bid for the order

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) CancelledSearchExceeded (appears when in 3 minutes after creation no driver accepted the trip); e) STARTED (driver accepted the order); f) ARRIVED (driver swiped arrived); g) TRANSFERRING (customer is in the cab and order is in the process); h) REVIEW_SUMMARY (cab arrived and the driver has to confirm the total amount to pay (or report no funds case or wrong total case); i) FinishedPaid; g) FinishedUnpaid.

UnpaidReason

This cell gives more details about FinishedUnpaid (column AO) orders. The driver chooses a reason at the end of the ride. It can be: a) WrongPrice; b) NoFunds

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

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 AS) and extra cost (column AT). 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

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

Payment method

It can be: a) Cash; b) Terminal; c) CreditCard

Payment card

Last four numbers of the credit card used for the payment

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

Please, consult the posts below for data on other reports available in the system and their management:

How to manage reports?

Drivers report guide

Clients report guide

Operators report guide

Payments report guide

Drivers transactions report guide


Did this answer your question?