27-12-TAP Attachment D - Rider Experience.xlsx
XLSX spreadsheet 16 KB Posted
- Attached to
- On Demand Rideshare Service
- Solicitation number
- BD-27-1165-COSPD-COS01-132484
- Issued by
- Essex County, Massachusetts
About this file
This file is a performance metrics report for the Massachusetts Transportation Access Program (TAP) On Demand Rideshare Service covering the contract period from August 1, 2025, through July 31, 2026. The document presents operational data and rider experience analytics for the on-demand rideshare service intended to supplement existing public transportation and provide enhanced mobility access to TAP-eligible participants statewide. The report includes comprehensive monthly performance tracking across multiple service quality indicators throughout the one-year evaluation period.
The metrics demonstrate service performance across several key operational categories. Pickup ETA accuracy shows a deviation distribution centered near zero minutes, with the majority of bookings (approximately 19% of all bookings) occurring within a five-minute window of estimated arrival. Average ride duration ranges from 10.25 to 14.99 minutes monthly, while average ride distance varies between 2.22 and 3.42 miles. Pickup and dropoff walking distances average 274–323 meters and 205–278 meters respectively across the measurement period. Rider acceptance rates remain consistent between 75.4% and 80.1% throughout the contract term. The shared ride duration ratio averages approximately 61% utilization, and average pickup ETAs range from 20.66 to 24.04 minutes. Notable variations appear in July 2026, where several metrics decline significantly, potentially reflecting reduced service demand at the contract conclusion or data collection anomalies.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 27-12-TAP Attachment E - Service Operation Visualization.jpg | JPG image | |
| 27-12-TAP Attachment B - Service Operation.xlsx | XLSX spreadsheet | |
| 27-12-TAP Attachment A - Federal Contract Supplement.doc | DOC document | |
| 27-12-TAP RFP Manual - On Demand Rideshare Service.pdf | ||
| 27-12-TAP Attachment C - Rider Growth.xlsx | XLSX spreadsheet | |
| 27-12-TAP Addendum 1.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
1.Report Filters
| Filter Name | Value |
| Start Date | 2025-08-01 |
| End Date | 2026-07-31 |
| Group by | Months |
| Request Origin Zone | |
| Request Destination Zone | |
| Origin->Destination Zones | |
| Weekdays | |
| Booking Type | |
| Service (Request) | |
| Vendor Name | |
| Booking requires >=1 WAV seat | |
| Service (Shift) |
2.Deviation ETA vs. Actual (On
| PICKUP_ETA_ERROR | Bookings | % Of Bookings |
| -56 | 1 | 0.000007 |
| -55 | 1 | 0.000007 |
| -53 | 1 | 0.000007 |
| -52 | 1 | 0.000007 |
| -47 | 2 | 0.000013 |
| -46 | 1 | 0.000007 |
| -45 | 1 | 0.000007 |
| -42 | 1 | 0.000007 |
| -41 | 2 | 0.000013 |
| -40 | 2 | 0.000013 |
| -39 | 1 | 0.000007 |
| -38 | 1 | 0.000007 |
| -37 | 2 | 0.000013 |
| -35 | 4 | 0.000027 |
| -34 | 1 | 0.000007 |
| -33 | 3 | 0.00002 |
| -31 | 4 | 0.000027 |
| -30 | 5 | 0.000033 |
| -29 | 4 | 0.000027 |
| -28 | 8 | 0.000053 |
| -27 | 4 | 0.000027 |
| -26 | 7 | 0.000047 |
| -25 | 11 | 0.000073 |
| -24 | 20 | 0.000133 |
| -23 | 47 | 0.000312 |
| -22 | 57 | 0.000379 |
| -21 | 83 | 0.000551 |
| -20 | 101 | 0.000671 |
| -19 | 148 | 0.000983 |
| -18 | 223 | 0.001482 |
| -17 | 271 | 0.001801 |
| -16 | 302 | 0.002007 |
| -15 | 412 | 0.002737 |
| -14 | 500 | 0.003322 |
| -13 | 550 | 0.003654 |
| -12 | 648 | 0.004306 |
| -11 | 761 | 0.005056 |
| -10 | 851 | 0.005654 |
| -9 | 1138 | 0.007561 |
| -8 | 1307 | 0.008684 |
| -7 | 1955 | 0.01299 |
| -6 | 2923 | 0.019421 |
| -5 | 4427 | 0.029414 |
| -4 | 6347 | 0.042171 |
| -3 | 9174 | 0.060955 |
| -2 | 12923 | 0.085864 |
| -1 | 16178 | 0.107491 |
| 0 | 15497 | 0.102967 |
| 1 | 13268 | 0.088157 |
| 2 | 10911 | 0.072496 |
| 3 | 8958 | 0.05952 |
| 4 | 7578 | 0.05035 |
| 5 | 6058 | 0.040251 |
| 6 | 5083 | 0.033773 |
| 7 | 4155 | 0.027607 |
| 8 | 3368 | 0.022378 |
| 9 | 2806 | 0.018644 |
| 10 | 2196 | 0.014591 |
| 11 | 1733 | 0.011515 |
| 12 | 1370 | 0.009103 |
| 13 | 1096 | 0.007282 |
| 14 | 919 | 0.006106 |
| 15 | 737 | 0.004897 |
| 16 | 601 | 0.003993 |
| 17 | 466 | 0.003096 |
| 18 | 410 | 0.002724 |
| 19 | 360 | 0.002392 |
| 20 | 266 | 0.001767 |
| 21 | 211 | 0.001402 |
| 22 | 169 | 0.001123 |
| 23 | 144 | 0.000957 |
| 24 | 90 | 0.000598 |
| 25 | 93 | 0.000618 |
| 26 | 76 | 0.000505 |
| 27 | 72 | 0.000478 |
| 28 | 61 | 0.000405 |
| 29 | 42 | 0.000279 |
| 30 | 25 | 0.000166 |
| 31 | 47 | 0.000312 |
| 32 | 34 | 0.000226 |
| 33 | 16 | 0.000106 |
| 34 | 18 | 0.00012 |
| 35 | 17 | 0.000113 |
| 36 | 18 | 0.00012 |
| 37 | 17 | 0.000113 |
| 38 | 10 | 0.000066 |
| 39 | 6 | 0.00004 |
| 40 | 10 | 0.000066 |
| 41 | 7 | 0.000047 |
| 42 | 7 | 0.000047 |
| 43 | 8 | 0.000053 |
| 44 | 6 | 0.00004 |
| 45 | 7 | 0.000047 |
| 46 | 1 | 0.000007 |
| 47 | 4 | 0.000027 |
| 48 | 5 | 0.000033 |
| 49 | 2 | 0.000013 |
| 50 | 3 | 0.00002 |
| 52 | 4 | 0.000027 |
| 53 | 2 | 0.000013 |
| 54 | 2 | 0.000013 |
| 55 | 1 | 0.000007 |
| 56 | 1 | 0.000007 |
| 57 | 2 | 0.000013 |
| 58 | 1 | 0.000007 |
| 59 | 1 | 0.000007 |
| 60 | 1 | 0.000007 |
| 61 | 2 | 0.000013 |
| 62 | 1 | 0.000007 |
| 69 | 2 | 0.000013 |
| 70 | 2 | 0.000013 |
| 73 | 1 | 0.000007 |
| 77 | 1 | 0.000007 |
| 89 | 1 | 0.000007 |
| 90 | 1 | 0.000007 |
| 116 | 1 | 0.000007 |
| 119 | 1 | 0.000007 |
| 237 | 1 | 0.000007 |
3.Average Ride Duration
| TIME | Average Ride Duration |
| 2025-08 | 12.78449898 |
| 2025-09 | 14.94773162 |
| 2025-10 | 14.99818247 |
| 2025-11 | 13.83351569 |
| 2025-12 | 13.24616549 |
| 2026-01 | 12.83927513 |
| 2026-02 | 13.48542053 |
| 2026-03 | 13.95699331 |
| 2026-04 | 14.27429461 |
| 2026-05 | 14.94707906 |
| 2026-06 | 14.67398864 |
| 2026-07 | 10.2527618 |
4.Average Ride Distance
| TIME | Average Ride Distance |
| 2025-08 | 3.082160058 |
| 2025-09 | 3.415354743 |
| 2025-10 | 3.365780562 |
| 2025-11 | 3.27915185 |
| 2025-12 | 3.189536697 |
| 2026-01 | 3.047418156 |
| 2026-02 | 3.120248087 |
| 2026-03 | 3.264278225 |
| 2026-04 | 3.364169594 |
| 2026-05 | 3.415950565 |
| 2026-06 | 3.321193434 |
| 2026-07 | 2.218238107 |
5.Average Pickup Walking Dista
| TIME | Average Pickup Walking Distance |
| 2025-08 | 274.25866803 |
| 2025-09 | 295.684889572 |
| 2025-10 | 296.922747036 |
| 2025-11 | 298.59718 |
| 2025-12 | 290.057904117 |
| 2026-01 | 299.173591523 |
| 2026-02 | 292.516894737 |
| 2026-03 | 300.815723083 |
| 2026-04 | 320.500289183 |
| 2026-05 | 322.867221832 |
| 2026-06 | 308.740222313 |
| 2026-07 | 281.952266654 |
6.Rider Acceptance Rate
| TIME | Rider Acceptance Rate |
| 2025-08 | 0.788093 |
| 2025-09 | 0.758181 |
| 2025-10 | 0.754546 |
| 2025-11 | 0.792651 |
| 2025-12 | 0.797771 |
| 2026-01 | 0.778092 |
| 2026-02 | 0.780268 |
| 2026-03 | 0.792274 |
| 2026-04 | 0.791657 |
| 2026-05 | 0.799498 |
| 2026-06 | 0.800697 |
| 2026-07 | 0.794263 |
7.Average Dropoff Walking Dist
| TIME | Average Dropoff Walking Distance |
| 2025-08 | 204.53959092 |
| 2025-09 | 236.34816676 |
| 2025-10 | 239.19378289 |
| 2025-11 | 230.71905974 |
| 2025-12 | 229.20507577 |
| 2026-01 | 241.58853197 |
| 2026-02 | 233.39006743 |
| 2026-03 | 244.19474855 |
| 2026-04 | 266.46766145 |
| 2026-05 | 277.77721628 |
| 2026-06 | 257.54307563 |
| 2026-07 | 209.54657406 |
8.Shared ride duration ratio
| TIME | Aggregation Rate |
| 2025-08 | 0.553393416 |
| 2025-09 | 0.6657167689 |
| 2025-10 | 0.6460789046 |
| 2025-11 | 0.6463326165 |
| 2025-12 | 0.6240218015 |
| 2026-01 | 0.5978435127 |
| 2026-02 | 0.6027173021 |
| 2026-03 | 0.6265773672 |
| 2026-04 | 0.6338756479 |
| 2026-05 | 0.6607621684 |
| 2026-06 | 0.6356036552 |
| 2026-07 | 0.4393263204 |
9.Average Pickup ETA (On Deman
| TIME | Average Pickup ETA |
| 2025-08 | 20.7401614975 |
| 2025-09 | 21.7990326983 |
| 2025-10 | 21.0717226547 |
| 2025-11 | 21.928149106 |
| 2025-12 | 22.3121863189 |
| 2026-01 | 23.0274455545 |
| 2026-02 | 24.039349201 |
| 2026-03 | 23.7695322535 |
| 2026-04 | 23.3661501781 |
| 2026-05 | 23.3978535115 |
| 2026-06 | 23.3517082443 |
| 2026-07 | 20.6649604043 |
File details come from the government source that posted it. Updated .