Membership Trends Reporting
Retaining your membership is important to your organization. While Wild Apricot gives you the ability to do automatic renewals and send out reminders for non-automatic renewals, some have suggested that it would be handy to be able to report on this.
Create the ability for administrators to be able to run reports on renewal rates for members.
The important thing for this is that we identify what information should be in the reports. At first blush, I can imagine:
* In a year, how many renewals were done before the renewal date, on the renewal date, and then certain days after renewal date (5 days after, 30 days after etc). This could be set up so that it gets the dates from the reminders that you've set up on your membership level.
* Attrition - How many members within a certain time period have not renewed or have been archived .
I'd love to hear what other information about your members renewal/membership status you'd like to be able to track and analyze.
Please! It would be a great feature to share with our Boards
The ability to track membership numbers from various time points should be a no brainer for a MEMBERSHIP service... (insert eye roll here) Come on Apricots from the Wild!
Please, please, please add some features that allow us to look at historical data about our memberships. It's vital to be able to analyze what trends are, what works, how long are members staying - in every category. Have they taken classes? We desperately need historical data!!! I'm happy to talk to someone about this. Thank you, Carla Mackey, BARN Membership Coordinator 206-842-4475 ext.202 or firstname.lastname@example.org
D Lee commented
This would be useful for finding out who has been a member since a specific timeframe. Possible use would be to qualify members for voting or see how long members have been continuously active.
We need a simple option in Custom Reports that allows us to input an arbitrary date. EX- July 1 (any year) plus active membership. To see your numbers/list for any year at any time.
I am appalled that I cannot generate a report that allows me to compare monthly and yearly membership growth. I must have this type of report to present to my board, and to have a successful membership drive.
this is ridiculous
South Main Association
We have many people who join for one year and then never renew their membership. It would be very helpful if I could provide trend data on memberships: for example, how many people joined in 2015 and renewed in 2016 but not 2017 or 2018? How many joined in 2015 and never renewed their memberships? At present, since I have to aggressively archive lapsed members (because there are so many people joining for one year and then never renewing), I can't get any sense of this information. Thanks!
We need to be able to look back at last years/months numbers and see how we have grown or how memberships are falling short...
We want to know how many members we had.. on x date.. and have a snap shot and a report...
It would be helpful to have access to historical membership numbers. I'm trying to analyze our growth . I understand that membership is a fluid number, but I'd really like to be able to see a snap shot in time for the number of active members we had in the past, both in total and by category.
In addition to other requests, we'd like to know how many and which types of events each member attended, and analyze events by registration type.
Elizabeth Urban commented
We need more report functionality within our membership lists. It would be very useful to (easily) query how many new members in a certain time span, how many renewals, etc.
Cindy Cooper commented
This needs to include past members who are currently archived. When I try to retrieve info, it only looks at current members.
Alex Sirota commented
We have fully implemented the audit log feature into the Excel dashboard we have been working on. You can now export all audit log details which enables reporting around membership renewals.
There is a limit of 200 API requests per minute and the dashboard currently is calibrated to work at about 180 or so requests per minute. Retrieving 2000 records takes roughly 10 minutes.
Please see the link below to join the slack channel to get access to the latest spreadsheet.
[Deleted User] commented
We have set up a private slack to discuss. There you can get early access to our work.
[Deleted User] commented
Hi everyone! I've been reading this thread that's *********** and am happy to report that using the Excel dashboard that Wild Apricot published to access the API, we have begun implementing these type of membership reports. If you're interested in contributing to our open source effort please let me know. We hope to share our results with the community and contribute back to the official wild Apricot github. Please email ************************** of you would like to know more.
We are also looking into membership reporting. Specifically being able to check the total number of members in a specific time range.
Please! We are considering other systems that will allow us to do this and will likely switch if this does not become an option soon.
Would be great if we could customize the Summary page to our needs. Numbers are nowhere near what we track. We have to export into a spreadsheet, sort/filter.
Lisa Olinda commented
Agree. Just had a request for this information.
This type of data would is invaluable to know where our association stands year to year. Knowing our data trends on membership in order to present to the board and plan strategically for the future would be most helpful. Renewals vs new members, returning members, graphs with year to year membership levels.