Measure what we care about at the member, committee, and branch levels. SD317
There are a number of statistical and reporting needs and desires that many people spend a great deal of time trying to capture. I would like to see us develop metrics and create "dashboards" that automate this data collection and allow us to quickly identify trends in the data that help us plan for the most successful future. For example:
Branches and Committees often want to know (or would be interested in): # of Leaders, # of trips being posted, % of closed out trips, #of courses offered, # of students in courses, # of participants on trips sponsored by committee, # of participants per leader, # of miles hiked/climbed/paddled/sailed, # of incidents reported, #of feet in elevation gained, etc. etc.
Leaders would like to know (or may be interested in):# of trips led, # of participants per leader, # of miles hiked/climbed/paddled/sailed, elevation gained, etc. etc.
Members would like to know (or may be interested in): # of miles hiked/climbed/paddled/sailed, elevation gained.
With solid data, decisions about where to spend resources can be targeted in a much more efficient way. And automating this data can save the time of numerous volunteers who I know are diligent about analyzing it now. You focus on what you measure - so let's measure what we want to focus on: getting people outside safely.
This feedback would allow committee members to enter an activity or course start date and see all feedback for that outing in one place. It also would allow committee chairs to quickly see Leader feedback in one place. Chairs can currently see leader feedback via their my profile page.
We are also looking into the feasibility of committee admins receiving notifications for trips/courses with negative feedback.
Completed Final Part Jun 2018
The final piece we want to have available is aggregate committee leader feedback. This feedback allows committee admins to enter an activity or course start date and see all feedback for that outing in one place. It also allows committee admins to quickly see Leader feedback in one place.
We currently have monthly dashboards being sent to each branch with information about the number of trips, courses and membership information.
We also have the member services team pulling trip statistics and additional committee reporting via requests to firstname.lastname@example.org. We strive for a 48 business hour turnaround on these requests.
Cheryl Talbert commented
As a committee chair it would be very helpful to see all the participant survey information for some defined past timeframe in an excel format with the leader's name, branch, date, course or route name, etc. that then allows us to see the trip result, rating, survey answers and notation of any safety incident. Otherwise to keep track of how our leaders and instructors are doing we have to manually click on each of their activities and open the feedback - with 60+ leaders under my responsibility this is just not feasible to do one at a time.
Brian Seater commented
Committee members (or at least admins) should be able to run reports related to their committee. At a minimum would be activities run within a date range, including leader, number of participants, activity result, and if it is closed or not. More robust queries would be beneficial, such as comparing course rosters (ie students who are registered for the Scramble course but not the navigation course)
There is a ton of information in the database, but the volunteers don't have a way to access it!
Other ideas for metrics to track include: leader badges issues, number of people on a waitlist, percentage of waitlist "captured" in another course, number of leaders, number of trips (offered at the leader, committee, branch, and activity levels), incident reports (also aggregated at multiple levels), number of courses, # of students, # of participants, revenue, expenses, amount of $ in reserves (at the committee and branch levels).
Great feedback Paul thank you.
Paul Mocha commented
Chris, this is a great idea. For the purpose of sea kayaking, other items that would be worth capturing, if feasible, would be # of SK trips (levels 1-5), as well as # of overnights vs. day outings.
How many trips and what trips by date range of each activity (Susan Graham- Focus Group suggestion).
Instructors! would like to know: # of students they've helped, # of courses they've taught at, # of hours they've contributed (this should be on a self-reported basis for ALL types of activities and volunteerism), etc. etc.