First Time Member Report

Cara Perez
Cara Perez New Member
Ninth Anniversary Kudos 1 Name Dropper Participant
in Blackbaud Altru® General Discussions
I am very new to Altru and I am wondering if there is an easy way to pull a report or query that pulls first time members only. I want to report on those who are brand new members for FY20. Any help would be great!
Tagged:

Comments

  • Laura Schmid
    Laura Schmid New Member
    Ninth Anniversary Kudos 1 Name Dropper Facilitator 1

    Build a membership query:





    Membership transaction type = JOIN and membership transaction date
    you want to hone in on, i.e. transaction date = this calendar
    year





    Make sure you set up both filters with AND and it should output all
    new members who joined this year.












    Laura
    Schmid     | Membership
    Manager
    4949 Tealtown Road | Milford, OH
    45150
    (513) 831-1711, ext. 416 | Membership Office
    (513) 965-4893
    www.CincyNature.org













  • Cara Perez
    Cara Perez New Member
    Ninth Anniversary Kudos 1 Name Dropper Participant
    Hi Laura,


    It is pulling members with lapsed memberships. We are looking for true brand new members. Do you know how to get rid of the lapsed members?
  • Laura Schmid
    Laura Schmid New Member
    Ninth Anniversary Kudos 1 Name Dropper Facilitator 1

    Set up your filters like this:





    Membership Transaction\\Transaction date (date only) is this
    calendar year


    and Membership Transaction\\Action is equal to Join





    This should output only Active memberships - at least that is what
    my query is outputting. I even added "Status" to my output to make
    sure and my query is only showing Active memberships.





    Hope this helps!












    Laura
    Schmid     | Membership
    Manager
    4949 Tealtown Road | Milford, OH
    45150
    (513) 831-1711, ext. 416 | Membership Office
    (513) 965-4893
    www.CincyNature.org













Categories