• Replies 17 replies
  • Subscribers 962 subscribers
  • Views 1036 views
  • Users 0 members are here
Related

Membership Comparison - Number of Members Each Year

Erica Vitai
$organization

Hi all, 

I've just discovered this group and I think it's going to be very useful! I'm very new to Analytics and I don't really have a data-driven mind so it's going to take me a while to get used to things!

Apologies if this is a v basic question, or if it's been asked before, but I'm trying to create a dashboard that will show me the number of members of a specific level each year to give a comparison to track the peaks & troughs of membership each year. I have this as an excel spreadsheet but it would be much better on Analytics. I've had a look in the Memberships folder of the Tessitura dashboard but that focuses on contributions made for the memberships rather than the number of members. 

Ideally it would bring up results a little bit like this:

Thanks in advance!

Erica Slight smile

Parents
  • $organization

    I'm new to Analytics too and was looking for this - thanks Chris! We're also wanted to keep track of how many Members we had at each level year after year. Is there a way to add this as a widget as well?

  • $organization in reply to Emily (Past Member)

    Hi Emily,

    Very glad the above was helpful. For YoY, are you thinking a year is the year in which their membership started, their membership expired, or their membership was at all active? Another way, if I have a membership that started on 1-Jun-2020 and expires on 30-Apr-2021, would you want to see me counted in a 2020 membership started bucket, in a 2021 membership expiration bucket, or in both a 2020 and a 2021 active members bucket?

  • $organization in reply to Chris Wallingford

    I will tag in here as I have been trying to create something similar to what Emily has asked about and only been moderately successful- for PCT this could be the Membership Campaign it was assigned to (which is seperate from the Campaign the contributions might be booked to. Where it become a little extra complicated is that we might have a gift in December 2019, the membership wouldn't start until Jan 2020, but we would consider the membership part of our 2019 renewals. I currently work with inexact numbers and remind everyone we are looking at trend analysis and use a combination of membership and contribution widgets. 

Reply
  • $organization in reply to Chris Wallingford

    I will tag in here as I have been trying to create something similar to what Emily has asked about and only been moderately successful- for PCT this could be the Membership Campaign it was assigned to (which is seperate from the Campaign the contributions might be booked to. Where it become a little extra complicated is that we might have a gift in December 2019, the membership wouldn't start until Jan 2020, but we would consider the membership part of our 2019 renewals. I currently work with inexact numbers and remind everyone we are looking at trend analysis and use a combination of membership and contribution widgets. 

Children
No Data