• Replies 3 replies
  • Subscribers 413 subscribers
  • Views 148 views
  • Users 0 members are here
Related

Membership in consecutive years

Dan Crowell
$organization

Hello,

I am looking to pull a report or list of all of our current members who have been a member for the past 5 (and 10) consecutive years.  When attempting to run this as an extraction, the results show all members within the date range..not just the members in all of the dates in the range.

  • Former Member
    Former Member $organization

    Hi Dan,

    You can also accomplish something like this using an extraction with suppression segments. I've done something like this before:

    Segment 1: suppress all constituents who were not a member in year 1
    Segment 2: suppress all constituents who were not a member in year 2
    Segment 3: suppress all constituents who were not a member in year 3
    Segment 4: suppress all constituents who were not a member in year 4
    Segment 5: include all constituents who are a member in year 5.

    Segment 5 will contain only the 5-year consecutive members as anybody who missed any of the preceding years would have been suppressed by segments 1-4. If you wanted to use that segment in a larger extraction you could run this one separately and save the 5+ year consecutive members to a list, and then use the list in your larger extraction.

  • $organization

    I’ve done this by creating a list for each year, and then using multiple “has” statements in my extraction.  Your end result will be only those constituents who are in all of the lists.

     

    Jane Voytek

    Donor Database Coordinator

    Berkeley Repertory Theatre

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Dan Crowell
    Sent: Tuesday, May 19, 2015 2:04 PM
    To: Jane Voytek
    Subject: [Tessitura Development Forum] Membership in consecutive years

     

    Hello,

    I am looking to pull a report or list of all of our current members who have been a member for the past 5 (and 10) consecutive years.  When attempting to run this as an extraction, the results show all members within the date range..not just the members in all of the dates in the range.




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • $organization in reply to Former Member

    Thank you for this info!  It helped a good bit!