Ask a club president who their most involved members are and they'll name four or five people right away. Ask who's slowly dropping off and it gets much harder to answer. That second group is what tracking is for.
This guide is about watching engagement over a semester so you can act on it. If you need a yes-or-no rule for who counts as an active member for voting or elections, that's a different job, and our guide to defining an active member covers it.
The three numbers worth tracking
- Events attended this semester. A plain count. It tells you who your regulars are.
- Last seen. The date of the last event they came to. This catches drifting faster than a count does. Someone who came to 8 events but hasn't been seen in five weeks needs a different message from someone who came to 8 and was there yesterday.
- Reliability. Of the events they signed up for, how many they came to. This only matters if you use sign-ups. For context, at clubs on Helptivo about 73% of advance sign-ups checked in (169 sign-ups at 4 clubs, a small sample). Someone well below that might need a better reminder, or a schedule that fits.
If your club does service, add hours as a fourth column. Members often need them for school or scholarship requirements, and our guide on tracking volunteer hours covers how to record them so they hold up.
What to leave out
It's tempting to track everything: group chat messages, Instagram likes, email opens, survey answers. Skip it. Those numbers take work to collect, they're easy to misread, and they rarely change what you'd do next.
Showing up is the clearest signal a student club has. It's also the one you can collect at the door in under a minute.
A simple sheet layout
You need a check-in log, where every row is one person at one event, and a member tab, where formulas count up the log. Add a sign-ups tab only if you use sign-ups. Don't type counts by hand, because they'll be wrong by October.
Engagement sheet layout (Google Sheets)
TAB "Checkins" (one row per person per event) A: Date B: Event C: Name D: Email E: Signed up first? (Y/N) TAB "Signups" (only if you use sign-ups; one row per sign-up) A: Date B: Event C: Email TAB "Members" (one row per person, formulas in row 2, then fill down) A: Email B: Name C: Events attended =COUNTIF(Checkins!D:D, A2) D: Last seen =MAXIFS(Checkins!A:A, Checkins!D:D, A2) E: Days since seen =IF(D2=0, "", TODAY()-D2) F: Signed up =COUNTIF(Signups!C:C, A2) G: Came after signup =COUNTIFS(Checkins!D:D, A2, Checkins!E:E, "Y") H: Reliability =IF(F2=0, "", G2/F2) I: Group regular / drifting / new / never came
Match people by email, not name, since names get typed three different ways. Format column D as a date and column H as a percent.
Keep the sheet in the club's shared Drive, not someone's personal account, and give one officer the job of adding each event's check-ins within a day. If the log is a week behind, nobody trusts it.
How we handle this in Helptivo
Helptivo keeps these numbers as people check in, so there's no log to copy. Each member's profile shows their hours and event history, and the member list sorts by Most Hours or Most Events Attended, with an automatic status (Active, Slipping, Inactive) next to each name. Advanced Search filters by events attended, no-shows or reliability, and the member report exports hours, events attended, no-shows and reliability to PDF, CSV or Excel.
Look at it once a month
Pick a fixed time, like the officer meeting at the start of each month, and spend 15 minutes with the sheet. Sort by days since seen, then put each person in one of four groups.
| Group | What it looks like | What to do |
|---|---|---|
| Regular | 3 or more events, seen in the last 2 to 3 weeks | Ask them to lead something small. Thank them by name. |
| Drifting | Used to come, not seen in 4 or more weeks | A short personal message. No guilt, just checking in. |
| New | 1 or 2 events so far | Make sure an officer welcomed them and told them the next date. |
| Never came | On the list, 0 events | One friendly email a semester. Don't keep chasing. |
These cutoffs assume weekly meetings. If you meet every two weeks, double them. You want to notice someone after two or three missed meetings, while a message still feels natural.
For a rough benchmark, at the 7 clubs on Helptivo that ran four or more QR check-in events, 25% of the 858 people who checked in came three or more times. If your regular group is about a quarter of the people who've ever come, you're in line with what we see.
What to do with what you find
The groups are useful on their own, but the patterns are where the real fixes are.
- Lots of people drift at once. Look at what changed that month: a new meeting time, midterms, a move to a farther room. Fix the cause before messaging everyone.
- Reliability is low across the board. Better reminders help more than lectures. Our no-shows guide has a day-before reminder you can copy.
- New people keep coming but never become regulars. The week after a first visit is the problem. See our guide to keeping members coming back.
- Officer elections are coming. Start with the regular group. People who already show up are the ones most ready to run things.
Questions people ask
What is member engagement in a club?
How much members actually take part. For a student club the simplest measure is showing up: how many events someone came to, when they last came, and whether they come when they sign up.
How do you measure member engagement?
Keep a check-in log with one row per person per event, then count events attended, last-seen date and reliability for each member. A Google Sheet with COUNTIF and MAXIFS does it.
How often should officers review engagement?
Once a month is usually enough. Spend 15 minutes sorting by who you haven't seen in a while, and decide who gets a message.
Should we track email opens or group chat activity?
Usually not. It's work to collect and rarely changes what you'd do. Attendance is easier to collect and easier to act on.

