This report is currently being piloted with a limited audience. It may not yet be available in your account.
The Rider Summary report brings together key information about the riders in your account in one unified report. See data about attendance, charges, cancellation, and mileage for each rider.
Run a Rider Summary report
To run a Rider Summary Report, follow the steps below:
-
In Reports, click the Rider Summary tab.
-
Select a date range for the report, then click Run Report.
Reports that include a large number of riders over a long period of time may take a few minutes. You can navigate away to other parts of RideIQ and return to view your report later.
Download a Rider Summary report
After generating a Rider Summary report for a given date range, you can download the full report as a CSV file that you can sort, filter, and edit as needed. Downloaded reports include the columns shown by individual rider but do not include the totals shown at the top of the page.
To download a report, run a report, then click Download Report.
You can also download a previously run report. In Report History, click the Actions icon, then click Download report.
Report History
Reports are saved for 90 days on the Report History tab. You can view, download, or delete reports you generated previously. Report History includes Rider Summary reports you created by any user in your account. It does not include Rides Reports. To view other report types, use Saved Reports on the Ride Reports tab. Learn more about Saved Reports here.
Data included in the Rider Summary report
The Rider Summary report includes the following information:
For the purposes of this report, Absent means the rider was removed from a ride or the ride was canceled after 6pm the evening before and not rebooked for a ride that same day. A removal or cancellation before 6pm the day the ride does not count as absent.
| Column Name | Definition |
|---|---|
| Total Billed Amount | Total dollar amount billed across all rides in the selected date range, including cancelled rides that still incurred a charge. |
| Number of Billed Rides | Total number of rides in the date range that were billed, including cancelled rides that were charged. |
| Number of Billed Cancels | Number of cancelled rides in the date range that resulted in a charge. |
| Total Billed Cancel Amount | Total dollar amount billed for rides that were cancelled but still charged. |
| Cancellation Rate | Percentage of billed rides that were cancelled (Billed Cancels ÷ Billed Rides). |
| Rider Name | The rider's first name and last initial. |
| Rider Profile Link | Link to the rider's profile in RideIQ. |
| Rider External ID | Any external ID entered on the rider's profile, such as a student ID. |
| Rider Category | The category selected on the rider's profile. Learn more about rider categories here. |
| Completed Rides | Number of rides the rider completed. If the rider was removed before a ride finished, that ride is not included here, even if the ride was completed for other riders. |
| Attendance % | Completed Rides ÷ (Completed Rides + Absences), shown as a percentage. Shows 0% if the rider has neither. |
| Consecutive No-Shows/Cancellations | The rider's current streak of absences in a row, counting back from their most recent ride. Resets to 0 as soon as they complete a ride. |
| Total No-Shows/Cancellations | Total number of times the rider has been marked absent. |
| Absent Dates | Dates of the rider's absences, oldest to newest. |
| Total Caregiver Cancellations | Number of the rider's rides cancelled by a caregiver (parent/guardian), rather than for another reason. |
| Next Ride | The rider's next upcoming, non-cancelled ride. |
| Total Billed Canceled Rides | The total number of canceled rides for this rider that resulted in a charge. |
| Total Billed Amount (rider) | Total dollar amount billed for this rider's rides, regardless of ride status. |
| Number of Billed Rides (rider) | Number of this rider's rides that result in a charge, regardless of ride status. |
| Total Billed Cancel Amount (rider) | Total dollar amount billed for this rider's cancelled rides. |
| Cancellation Rate (rider) | The number of billed cancellations for this rider divided by the number of billed rides for this rider, as a percentage. |
| Average Cost Per Completed Ride | Average amount billed per completed ride. On shared rides, cost is split evenly among the riders, excluding any riders who were removed. |
| Total Miles | Total distance traveled across completed rides. On shared rides, miles are split by how much of the route each rider was actually in the car for. |
| Average Miles | Total Miles divided by number of completed rides. On shared rides, miles are split by how much of the route each rider was actually in the car for. |