Completed rides
This report contains details and key figures for all dropped-off rides.
- The period type is monthly.
- The default query timeframe is seven days.
- The row access mode is
product and operator based.
Permissions:
access_reports
Report columns
| Field name | Definition | Attribute / Calculation |
|---|---|---|
Ride ID (ride_id) | Unique ID of the ride in the ioki system. | ride.id |
User ID (user_id ) | Unique ID in the ioki system of the user who booked the ride. | ride.user.id |
Pickup time (picked_up_at) | The time at which the pickup task was completed or for which it was reported as completed. | ride.picked_up_at |
Dropoff time (dropped_off_at) default | The time at which the dropoff task was completed or for which it was reported as completed. | ride.dropped_off_at |
Actual ride duration [min] (actual_ride_duration) | Time difference between pickup and dropoff time. | ride.dropped_off_at - ride.picked_up_at |
Delay at pickup [min] (delay_at_pickup) default | Difference between the initially calculated (after inserting the ride into the vehicle planning) and the actual pickup time - only if there is a delay, otherwise 0. | [ride.picked_up_at - ride.applied_pcm.pickup_calculated_negotiation_time, 0].max |
Delay at dropoff [min] (delay_at_dropoff) default | Difference between the initially calculated and the actual dropoff time only if greater or equal zero. Note: This does not have to be a “real” delay for the passenger as this can still be within the negotiated times. | [ride.dropped_off_at - ride.applied_pcm.dropoff_calculated_negotiation_time, 0].max |
Pickup lat (pickup_lat) | The latitude of the geopoint of the planned pickup task, e.g., the latitude defined on the station. | ride.pickup.lat calculated_point.geopoint.lat |
Pickup lng (pickup_lng) | The longitude of the geopoint of the planned pickup task. | ride.pickup.lng calculated_point.lng |
Pickup location (pickup_location) default | Name of the pickup location if defined. E.g., name of the station. | ride.pickup.location_name (calculated_point.location_name) |
Pickup location type (pickup_location_type) | If the pickup is at a station, then this specifies whether it is a virtual or real station. Otherwise it’s address. | |
Pickup postal code (pickup_postal_code) | Only if specified on the station or address, otherwise empty. | ride.pickup.postal_code |
Dropoff lat (dropoff_lat) | The latitude of the geopoint of the planned dropoff task, e.g., the latitude defined on the station. | ride.dropoff.lat (calculated_point.geo_point) |
Dropoff lng (dropoff_lng) | The longitude of the geopoint of the planned dropoff task. | ride.dropoff.lng (calculated_point.geo_point) |
Dropoff location (dropoff_location) | Name of the dropoff location if defined. E.g., name of the station. | ride.dropoff.location_name (calculated_point.locaction_name) |
Dropoff location type (dropoff_location_type) | If the dropoff is at a station, then this specifies whether it is a virtual or real station. Otherwise it’s address. | |
Dropoff postal code (dropoff_postal_code) | Only if specified on the station or address, otherwise empty. | ride.dropoff.postal_code (calculated_point.postal_code) |
Number of passengers (number_of_passengers) default | Number of passengers booked on the ride. | ride.passengers.count |
Requested time (requested_time) | Requested pickup time for departure based, requested dropoff time for arrival based rides. | origin.time OR destination.time_max |
Request type (request_type) | Arrival based or departure based. | origin.time present? (requested_point pickup) |
Origin lat (origin_lat) | Latitude of the requested pickup location. | origin(requested_point pickup).lat |
Origin lng (origin_lng) | Longitude of the requested pickup location. | origin(requested_point pickup).lng |
Destination lat (destination_lat) | Latitude of the requested dropoff location. | destination(requested_point dropoff).lat |
Destination lng (destination_lng) | Longitude of the requested dropoff location. | destination(requested_point dropoff).lng |
Offered pickup (offered_pickup_time) | Negotiation time after inserting the match into the task list. This is what is shown to the user after booking. | applied_pcm.pickup_calculated_negotiation_time |
Offered dropoff (offered_dropoff_time) | Negotiation times after inserting the match into the task list (after booking). This is the calculated time, it is not exposed to the user. | applied_pcm.dropoff_calculated_negotiation_time |
Offered dropoff max (offered_dropoff_time_max) | Negotiation times after inserting the match into the task list. This is the max dropoff time which is shown to the user after booking. | applied_pcm.dropoff_calculated_negotiation_time_max |
Offered ride duration [min] (offered_ride_duration) | Calculated time for the ride after booking. Difference between calculated pickup and dropoff times. | applied_pcm.dropoff_calculated_negotiation_time - applied_pcm.pickup_calculated_negotiation_time |
Deviation from requested time [min] (deviation_from_requested_time) default | The time difference of the requested time to when the journey (ride and walking times to pickup / from dropoff) starts or ends, respectively. | Departure based: applied_pcm.pickup_calculated_negotiation_time - origin.time - walking_time Arrival based: destination.time_max - applied_pcm.dropoff_calculated_negotiation_time_max - walking_time |
Ride distance (direct routing) [km] (direct_routing_distance) default | This is the distance of the shortest routing from requested pickup to requested dropoff at the time of the matching. Attention: not between calculated pickup and dropoff. | ride.direct_routing_distance.round |
Ride duration (direct routing) [min] (direct_routing_duration) | This is the duration of the shortest routing from requested pickup to requested dropoff at the time of the matching. Attention: not between calculated pickup and dropoff! | ride.direct_routing_duration.round |
Walking time from origin [min] (walking_time_from_origin) | Walking time from requested pickup to calculated pickup. | pickup.walking_duration.round |
Walking distance from origin [km] (walking_distance_from_origin) | Walking distance from requested pickup to calculated pickup. | pickup.walking_track&.length&.round |
Walking time to destination [min] (walking_time_to_destination) | Walking time from requested dropoff to calculated dropoff. | dropoff.walking_duration.round |
Walking distance to destination [km] (walking_distance_to_destination) | Walking distance from requested dropoff to calculated dropoff. | dropoff.walking_track&.length&.round |
Booking client (booking_client) | Platform, Operator, Web Booking, iOS or Android | Checking client.platform / ride.creator_type (Platform) |
Booking type (booking_type) default | Prebooked or ad-hoc booked ride. | ride.prebooked |
Part of serial booking (part_of_serial_booking) | If the ride was part of a serial booking (product feature). | ride.ride_series_id.present |
PTA offered (pta_offered) | Right now this only asks if HAFAS delivered one. But this could have been rejected, so it does not say, we offered it to the user. | ride.public_transport_alternatives |
Transportation modes (mode_sequence) | If intermodal feature is activated, was the ride part of an intermodal journey? (DRT,PT), (PT,DRT), (DRT) | applied_pcm.first_mile_public_transport_alternative_id.present? && applied_pcm.last_mile_public_transport_alternative_id.present? |
Ride option report columns (dynamic_ride_option_1 to dynamic_ride_option_4) | Values of the bookable ride options assigned to reporting columns. The displayed column names can be customized in the provider-level custom report column name settings for ride options. | Selected ride option value |
Personal discount type (personal_discount_type) | Name of an applied personal discount (if applicable). | ride.fare.personal_discount_id |
Personal discount (personal_discount_amount) | This is the difference between calculated and booking price. | calculated_booking_price - ride.fare.booking_price |
Fare (ride_fare, ride_fare_currency) | Final price of the ride. | fare.final_price |
Vehicle planning ID (task_list_id) | ID of the corresponding vehicle planning. | ride.matched_task_list |
Planned shift beginning (planned_shift_beginning) | Planned start of the vehicle planning. | task_list.starts_at |
Planned shift end (planned_shift_end) | Planned end of the vehicle planning. | task_list.ends_at |
Matching configuration ID (matching_config_id) | ID of the applied matching configuration. | ride.matched_task_list.matching_configuration |
Matching configuration (matching_config_name) | Name of the applied matching configuration. | ride.matched_task_list.matching_configuration |
Line name (line_name) | Name of the line if vehicle planning was assigned to one. | ride.matched_task_list.line |
Vehicle ID (vehicle_id) | Unique ID of the vehicle that served the ride. | ride.vehicle |
License plate (license_plate) | License plate of the vehicle that served the ride. | ride.vehicle.license_plate |
Vehicle operation mode (vehicle_operation_mode) | Checks if the autonomous flag of the vehicle is activated. Driver or autonomous. | vehicle.autonomous |
Driver ID (driver_id) | Unique ID of driver that was connected to the vehicle at the pickup time. | ride.vehicle.driver_connections.active_at(ride.picked_up_at).first&.driver |
Operator ID (operator_id) | Unique ID of the operator associated to the ride. | ride.operator |
Operator name (operator_name) | Name of the operator associated to the ride. | ride.operator |
Product ID (product_id) | Unique ID of the product in which the ride was completed. | ride.product |
Product name (product_name) | Name of the product the ride was completed in. | ride.product |