Hey all!
I'm creating a membership dashboard and the person that I am creating it for wants to know new joins data, active members, lapsed members etc for each financial period. How would I go about doing that, is it even possible?
My colleague and I have tried using 'Initiation/expiration date - days in date' options but the data doesn't appear to be accurate.
My instinct is to create the dashboard using calendar month for the time being, and see if we can convert to financial period once I've done that?
Thank you,
Shanaé
Unless I just create a list for each financial period and filter the widget by the list?
First trying to define the things.
New joins data, is this an account with a membership with create date or purchase date in a time period with NRR status of New? If so that is fairly straight forward. If what you are looking for is the earliest new membership on an account. Something like a membership with the inception and initiation date being the same and being in a particular time period? If possible, this is harder and formula work, I'd guess.
active members (now) might be the count the customer's ids who have a membership with one of the statuses you considered active for current active members. However, active memberships "As Of" some specific time period in the past. This is harder. Maybe some fancy formula work?
Lapsed Members as of a specific period in time is going to be harder.
Shanaé Chisholm I'd also reach out to TAFFY group on these questions as well. These are their core expertise. Over in that group, we might be able to invite one of the Tessitura Staff leaders of this group to give this one a try as well. Please jump in here with an even more specific definition of the concepts you are trying to measure.
As a start here. Anyone have any thoughts on how we might build a formula to recognize which memberships are active during a specific period in the past. One of the challenges here is how we are going to get a complete list of those periods. Are we able to do this as fiscal year only using "Fiscal Current Year Offset". Do we have to write a bunch of formulas that are hardcoded to be indicators for specific time ranges? I'd love to see if we can crack this "as of" reporting challenge, with Tessitura Analytics at lease at the calendar month level. This has been one of my "holy gale" type calculations. I've done this kind of thing in SQL views, and a "date table", in power query and power bi. But I've not yet replicated in T-Stats or Analytics to date. Does anyone out there have a partial solution to this? I think this type of question is universally asked by Membership and development leaders in our organizations? To date only organizations that keep a side tally of these things manually each month, Or creates custom "date tables" and custom SQL have been able to partially or fully work this one out.
Any thought?
Yeah, maybe that would work. However, that could be a lot of lists for 4 years of monthly membership holders in the past and one year in the future. And then to set the update reports to keep the lists fresh.
Hello! Thank you for your response.
New joins data: Would be data on constituents who have purchased a membership for the first time - I'm guessing, as create date would produce the most accurate results, in terms of who has started a membership for the first time?
Active members: I'll ask in the TAFFY group about this, as I wouldn't know what date to use - inception, initiation or expiration date - in order for me to input the financial periods.
I'll try various options and compare it to my colleague's spreadsheet to see if the values match up!
Thank you