Lapsed membership reports

Options
Stephanie Jordan 4
Stephanie Jordan 4 ✭
Second Anniversary Name Dropper First Reply
in Blackbaud Altru® General Discussions

I am trying to ascertain how many of our memberships from last year were from lapsed members - is there a way to separate those numbers out?

Tagged:

Comments

  • Stephanie Jordan 4
    Stephanie Jordan 4 ✭
    Second Anniversary Name Dropper First Reply

    @Stephanie Jordan clarifying that I am a Altru user

  • KAS Shannon Knight
    KAS Shannon Knight ✭
    Tenth Anniversary Facilitator 2 Name Dropper Photogenic

    Hi, @Stephanie Jordan! This is easily done, but depends on your definition of lapsed. You can look at the Activity Page for your membership program and specify the dates for last year:

    d6f69eb09727d72208fc12460ff351dd-huge-me


    Or you could create a query that shows primary members only who expired last year.

    If you're looking for memberships that lapsed and then were renewed, it's a bit more complicated. You'll need a query with an export to show the most recent membership transaction and the next most recent. Then you can compare the expiration date on the next most recent with the transaction date of the most recent.

    Is this what you're looking for?

  • Stephanie Jordan 4
    Stephanie Jordan 4 ✭
    Second Anniversary Name Dropper First Reply

    @KAS Shannon Knight Yes! This activity tab helps my membership manager a lot, but for a deeper dive I would want to see which lapsed membership were renewal and guesstimate the average time it takes a lapsed membership to renew

Categories