Reporting on New Members (i.e., "Never Members")

Options
Amelia Ketzle
Amelia Ketzle
Fifth Anniversary 100 Comments 25 Likes Name Dropper
in Blackbaud Raiser's Edge NXT®: General Discussion

Hello, wonderful colleagues!

Our Alumni Association is needing to pull people who are new members as of a certain date. By “new members” they mean people who had never previously been a member. The queries and exports they have tried always seem to include people who have historical memberships from before, which is exactly the scenario they want to exclude. We tried a constituent query where Current Standing = Active, Gift Date between 7/1/2021 and 3/25/2022 (this is the “as of” date they're interested in) and Current Total Years As Member less than or equal to 1. But we got a lot of false positives where the member had previous memberships which had been dropped.

Thoughts on how to get at this number? Insight much appreciated!

Tagged:

Comments

  • Jeannie Goings
    Jeannie Goings
    Fifth Anniversary 100 Comments 100 Likes Photogenic

    I suggest merging queries. Create one query with membership date to is blank. Create a second query with membership date to is not blank. Merge the first query with the second using the SUB operator. If you have been consistent with date from and date to, this should work. Good luck.

  • Janis Worley
    Janis Worley
    Sixth Anniversary 100 Likes 100 Comments Name Dropper

    We've been good about updating the membership date when people re-engage with us. That way pulling files by membership date gives us good consistency when people have come back.

Categories