More robust event registration filtering in Advanced Search, for analysis, not just emailing
Reasons we need to filter by Registrations more than we are currently able:
To analyze member activity and who's pulling their share of our load, we want to know (for example) what Members have attended more than one registration event in the past three years, and which events they are. Currently we can only filter for the number of registration events, then have to look at each one to determine when and what. People who registered for events 5 years ago are irrelevant, and people who are registered for our annual dinner are also irrelevant. We need to know who has recently registered for our more routine events.
In culling our list so as not to go over our limit, we need to do a similar search. Except this time we need to know who has NOT attended a registration event recently, including how often and which events. A non-member who was active 5 years ago but not recently is a candidate for Archives. But to determine this, we'd have to place checks in hundreds of events, and even if we laboriously do that -- it's not repeatable. Change the search, and you have to do that chore all over again. So we don't.
Randall (Randy) Rensch
shared this idea
-
Randall (Randy) Rensch
commented
I forgot to mention -- although we came to WA to avoid spreadsheets, I realize that this need might be better served by exporting to a sortable spreadsheet. But the Events Registration data is not exportable from an Advanced Search.
