How can I extract exoired members within date parameters

Hi, I am trying to do an extraction to identify ex-members from one of our six levels, whose memberships are now expired. I want to captur those who expired between Sept 2011 and April 2012. The segments seem to be supressing all the right people but then only pull in people who still have a current membership as well as an expiry in those dates. Is there a way of selecting by expiry date for an expired membership? Any tips gratefully received!

Parents
  • Hi Katie,

    I have an entire listbuilder folder for "membership most recent."  I know we have added some non-standard fields to our listbuilder, but I can't seem to find anything on the help site that would show me whether this is one of those custom pieces.  Might be worth checking into having it added though, it's very useful for this kind of thing.

    Beth

    * * *
    Move smartly, me hearties - the pirates have landed! In the Real Pirates exhibition, discover the true story of the Whydah, from her historic transformation from slave ship to pirate ship to her final resting place on the ocean floor. See cannons, swords and real treasure, learn what happened “below decks,” meet members of the Whydah’s crew, explore underwater archaeology, and more. Learn more and buy tickets at smm.org/pirates.


    Elizabeth A Varro
    Membership Manager
    Science Museum of Minnesota
    (651) 265-9829

    From: "Katie Fathers" <bounce-katiefathers2096@tessituranetwork.com>
    To: bvarro@smm.org
    Sent: Thursday, May 31, 2012 5:30:29 AM
    Subject: RE: [Tessitura Development Forum] How can I extract exoired members within date parameters

    Thanks for your replies.

    Beth, we don't seem to have that criterion - which folder in list builder should it be in please?

    Kevin, I'm not using Membership Current and had that suppression in, however I've just added some date parameters and seem to be getting better results.

    Thanks, Katie

     

    From: Kevin Sheehan <bounce-kevinsheehan4372@tessituranetwork.com>
    Sent: 5/29/2012 10:01:42 AM

    Hi Katie,

     

    Are you using criteria from the Membership Current folder?  If so, those criteria only look at membership records with a current status.

     

    Another thing to maybe try, add a suppression segment for all your current members.

     

    Kevin Sheehan

    Senior Documentation & Learning Resources Specialist

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com

     




    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!

Reply
  • Hi Katie,

    I have an entire listbuilder folder for "membership most recent."  I know we have added some non-standard fields to our listbuilder, but I can't seem to find anything on the help site that would show me whether this is one of those custom pieces.  Might be worth checking into having it added though, it's very useful for this kind of thing.

    Beth

    * * *
    Move smartly, me hearties - the pirates have landed! In the Real Pirates exhibition, discover the true story of the Whydah, from her historic transformation from slave ship to pirate ship to her final resting place on the ocean floor. See cannons, swords and real treasure, learn what happened “below decks,” meet members of the Whydah’s crew, explore underwater archaeology, and more. Learn more and buy tickets at smm.org/pirates.


    Elizabeth A Varro
    Membership Manager
    Science Museum of Minnesota
    (651) 265-9829

    From: "Katie Fathers" <bounce-katiefathers2096@tessituranetwork.com>
    To: bvarro@smm.org
    Sent: Thursday, May 31, 2012 5:30:29 AM
    Subject: RE: [Tessitura Development Forum] How can I extract exoired members within date parameters

    Thanks for your replies.

    Beth, we don't seem to have that criterion - which folder in list builder should it be in please?

    Kevin, I'm not using Membership Current and had that suppression in, however I've just added some date parameters and seem to be getting better results.

    Thanks, Katie

     

    From: Kevin Sheehan <bounce-kevinsheehan4372@tessituranetwork.com>
    Sent: 5/29/2012 10:01:42 AM

    Hi Katie,

     

    Are you using criteria from the Membership Current folder?  If so, those criteria only look at membership records with a current status.

     

    Another thing to maybe try, add a suppression segment for all your current members.

     

    Kevin Sheehan

    Senior Documentation & Learning Resources Specialist

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com

     




    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!

Children
No Data