Hi all
I'm trying to build a widget that shows how many members we had each month, going back over time, so that we can track the change in total membership numbers month on month. I feel it's a reasonable request from our memberships team to be able to visualise this data.
In list manager I would do this by adding initiation date < month of interest and expiration dates > month of interest to find all memberships that were active in any specific month. However, I'm failing to replicate this in analytics, and wondered if anyone has already tackled this?
I've got as far as (with massive thanks to Paul Woods for getting me started) setting up values for each month, using a formula (SUM([Membership Count]), [Days in Current Membership Initiation Date], [Days in Current Membership Expiration Date]) and with date filters on the initiation and expiration date.
However the numbers are really wrong (hugely overstated for this year, and much too small for previous years). I can't find any membership data that isn't Current Membership, which may be part of the problem.
Really hoping that someone can shed some much-needed light.
best wishes
Alison
Hi all,
This is really helpful! One question though, what is the difference between using a sum of the membership count and using a count of unique constituent IDs, in particular since you are just looking at a snapshot in time? Would membership count be more focused on if an organization runs more than one membership concurrently?
Thanks!
Scotland