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 Alison,
Our Membership folks would like to see the same thing you outlined above - a count by level for each month going back several years. Since our memberships run for one or two years, it's tricky to get there by reporting sales or renewals. It sounds like you were able to set up a count dashboard successfully. Would you mind sharing it with me?-Susan