Hopthru Ridership Dashboard

Introduction

Hopthru Ridership provides a fast and seamless suite of tools for cleaning and analyzing APC data. Hopthru can be used in planning efforts including but not limited to:

• Understanding ridership data at the system, route, trip and stop level
• Comparing ridership data over multiple date ranges
• Filtering ridership data by date, day of week and time of day
• Identifying and diagnosing service inefficiencies when it comes to ridership
• Identifying which stops are good candidates for amenity enhancements
• Identifying which routes have crush loads

Accessing Hopthru Ridership

Swiftly customers with a subscription to the Hopthru Ridership platform can access the tools at platform.hopthru.com. If you are having issues accessing the tool, please email [e-mail].

Segment ridership by system, route, and stop

Consider how deeply you want to visualize your ridership data by toggling between views in your schedule and filtering by date.

By default, the Hopthru dashboard will show all routes over the last 4 weeks.

Schedule views

• All Routes Summary: by default, Hopthru aggregates data for all routes.

• All Routes: breaks down results by route.

• All Stops: dive into any stop for detailed analysis

Metrics: Ridership insights for your agency

Hopthru Ridership calculates ridership insights by ingesting and processing a static GTFS file, Vehicle Assignment data, and raw APC data. 

Using these data inputs, the platform can create valuable metrics to analyze ridership, such as:

• Boardings: how many riders boarded the vehicle by total number or by average daily
• Alightings: how many riders alighted the vehicle by total number or average daily
• Activity: boarding and alighting totals or averages
• Boardings per revenue hours: the average number of boardings per hour of scheduled revenue service
• Load: average number of passengers on a given vehicle or the max number of passengers on a given vehicle
• Passenger miles traveled: the average or daily miles traveled by passengers

By default, clicking through the to the "All routes" Report on the dashboard shows the average daily boardings for your entire agency over a four-week period, broken down by several helpful views.

For example, below, on the left you will see your average daily boardings total tallied for you in chart view. This is helpful for a high-level understanding of daily ridership. The view will also show you boardings by date and day of the week to highlight meaningful trends across dates. 

Last, a map view on the right with color-coded average daily boardings will show you which routes have higher saturations of average daily boardings, allowing you to analyze average daily boardings by routes.

Use Filter and Compare for further analysis

Dive deeper into your metrics by filtering and comparing your data.

Date filter

Further drill into your ridership metrics by filtering through various date filters.

• Date range: filter by specific dates or date ranges
• Days of the week: filter by select days of the week
• Times of day: filter by various times of day. (These are customizable for your agency)

Compare

The compare button allows you to compare several service dates side-by-side on chart view. Use this to spot trends for specific date periods, like comparing your end-of-quarter ridership data against your beginning-of-quarter ridership data.

Just need a report? Try the Tabular View

Do you just need a tabular report of your ridership insights? Hopthru Ridership has you covered. Reports allow you to toggle between the Map view and the Table view, making it easy to see your data in either format. 

These reports can be exported or scheduled for delivery to your email using subscriptions.

Save a report

Save a report by clicking on the  "Save" icon.

"Saving" will override the settings of the current report, while "Save as" will clone the current report and create a new one. 

Exports

Users can export their Reports by navigating to the Download Icon to export their results to CSV. The download will be sent via email and will be available for download in the notification center.

Subscription

Use the subscription button under “Subscriptions” to schedule a daily, weekly, or monthly delivery of your data.

Use cases

Identify and diagnose ridership service inefficiencies

Have you ever wondered where in your system there are service inefficiencies? Are you running too much service for a portion of the network that doesn't have the demand? You can use the “Boardings per revenue hour” metric to evaluate such inefficiencies.

Instructions

1. Navigate to a report where "Data Type" = Route
2. Sort by the least efficient routes on chart view.
3. Navigate to the route or stop in the map view.
4. Click through the route

The circled route, 402, is exhibiting poor route efficiency since it has a rather lower boardings per revenue hour. You can share this data with your planning team to help optimize service on these routes.

5. On the route-specific view, use the colors to identify dead zones. Areas with heavier colors approaching the route/stop are a good sign. Lighter colors should influence you to consider whether the planned route is effective.

As you can see above, the circled portion of the route does not have any activity (no boardings or alightings). In this case, even though the portion of the route is not utilized by riders, we are still running service to these locations. This causes longer running times and more expensive routes. You can share this data with your planning team to help optimize service on these routes.

Identify which routes have crush loads

Provision adequate service by quickly identifying trips that have crush loads.

Instructions

1. Create a create a report where "Data Type" = "Trips".
2. Select “filter” > “add filter” > “ridership” > “average daily max load”
3. Use a value that is just below your vehicle’s max capacity. For example 20, for a bus that fits 21 passengers
4. Run filter and adjust date ranges/filter as needed.
   1. You can customize the order of the columns under “Edit columns” as needed.

The Route 503 trips at 07:30, 15:00, 16:00, 17:00, and 18:00 seem to be experiencing crush loads. You can share this data with your planning team to help optimize service around these times.

Identify hardware issues with your APCs 

Monitor the health of your vehicle’s APC devices by using the Vehicle Issues feature. 

Instructions

1. Navigate to Settings > Vehicle issues. This view summarizes vehicle reports by time period. 
2. Identify problematic vehicles by reviewing Events. 
   1. No raw vehicle APC data: Raw APC data is missing for a vehicle in service
      1. Vehicles with ”Pending” have seen an improvement in reporting
      2. Vehicles with “Resolved” have seen a resolution in raw vehicle APC data reporting due to several days of consistent reporting
   2. Partial APC records: Very little APC data exists for a vehicle in service
   3. Raw APC activity imbalance: Delta between boardings and alightings exists for a vehicle in service
   4. Unscheduled Raw vehicle APC data: Vehicle reported data but was not scheduled for service

Based on the report of the vehicle events above, there are a number of vehicle IDs that do not have raw APC data reporting. You can share these insights with your IT or hardware maintenance team to have these devices inspected for issues.

Identify which stops are good candidates for amenity enhancements

Improve the rider experience by identifying stops that are great candidates for amenity enhancements, such as benches, shelters, and more. 

Hopthru allows you to pinpoint stops with high average daily boardings, which agencies can use as an indicator for amenity improvements.

Instructions

1. Navigate to a report of "Data Type" = "Stops"
2. Filter for high-activity stops by:
   1. Select average daily boardings as your metric
   2. On your filter, set the value to > 50 (you can switch the value depending on your definition of high-activity). 
   3. If you have imported tags labeling existing stops, add additional filter criteria for Tag = “Benches” or the name of your amenity = False

Because these stops have high average daily boardings and no benches installed at the stop, they may be great potential candidates for benches. Share these insights with the teams responsible for amenity enhancements at your agency to help improve the rider experience.

FAQs

Is there a certain period that I must wait to report Hopthru data in our System?

Data in Hopthru is not final until 14 days have passed since the service date.

There are two reasons for this:

1) Data can continue to trickle in from vehicles that were unable to previously upload data

2) Hopthru's expansion algorithm uses data up to 14 days past the service date. Expansion is a process where we use historical averages to provide ridership data for trips that ran, but where APC data is not available. 

Does Hopthru support APIs that agencies can use to pull the HopThru data out of the system?

No APIs. However, there are self-serve data exports for all reports. 

Can I customize the color scale shown in the map?

No. The scale is auto-populated into 8 categories, evenly distributing all results into those categories ranging from yellow to dark purple.

Can I customize the times of day in the date range filter?

Please contact [e-mail] if you would like to update the times of day filter.

What is the difference between max load vs. avg. max load?

The max load metric is the highest load observed over a given date range. Whereas, the avg daily max load is the max load from each day in that date range which is then averaged.

For example, if you have a time range of 5 days and the max loads are:

1. 10
2. 3
3. 6
4. 11
5. 7

The max load would be 11. The avg daily max load would be: (10 + 3 + 6 + 11 + 7) / 5 == 7.4