Extraction Suppressions

Hello All, 

I am working on an extraction for an invitation list. I have a combination of suppression and inclusion segments. Let me start off by saying that I am in a consortium environment.

One of my suppression segments identifies and suppresses those records which do not have our customer constituency. This segment is effecting one of my inclusion segments. My inclusion segment is a donor segment (looking for donors at a certain level). In our consortium, we have a script which updates/adds a customer constituency overnight. So when I add a donation to a new donor record, I do not need to manually add my customer constituency; the script will do it for me.

My suppression report tells me that 9 records are being suppressed from my donor segment because they do not have my customer constituency. My first thought is to recreate my segment in list manager, then adding the "does not have" customer constituency. I would hope to see the 9 records being suppressed. This does not produce any results.

I am looking for help in identifying those suppressed records. Any suggestions?

Parents
  • Hi Marie,

     

    Perhaps this is a long shot, but could some information be on an individual record and other information on a household?  When I suppress a segment, I make sure I am including ALL HH affiliated accounts, for instance with board members I suppress the board acct, the board spouse acct and the board HH acct.  Then if one of those accts fall in another segment, I know I won’t be accidentally including them.  This might explain why you don’t see those accts when you save the suppression list and the other list and cross reference them. 

     

    T.C. Brown

    Database Administrator

    412.392.4834

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Marie Kocher
    Sent: Monday, March 24, 2014 3:08 PM
    To: TC Brown
    Subject: RE: [Tessitura Development Forum] Extraction Suppressions

     

    Anna,

     

    Thank you for that suggestion. It, however, gives me zero.

     

    Marie

     

    --

    Marie Kocher | Development Assistant

    Kansas City Ballet

    Todd Bolender Center for Dance and Creativity

    500 W Pershing Road

    Kansas City, MO 64108

    816-931-2232 x 1382 | 816-931-1172 (fax)

    mkocher@kcballet.org

     

    Buy tickets and enroll for classes: www.kcballet.org


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Anna Wessely
    Sent: Monday, March 24, 2014 12:51 PM
    To: Marie Kocher
    Subject: Re: [Tessitura Development Forum] Extraction Suppressions

     

    Marie,

    In extractions after generating your counts open the extraction and select Save to list. Deselect all of your segments except the suppression segment.  Save that segment to a list; this will make a critirealess list of the suppressed constituents.  Create a second list that has the same criteria as your inclusion segment (the one with the contributions) and add a criterion that is List HAS the list you just created from extractions.  That should give you everyone who was suppressed who qualifies for the segment.  The only exception would be any inactive constituents (extractions by default include inactives and lists by default exclude the inactives).

    Best,

    Anna

    From: Marie Kocher <bounce-mariekocher5698@tessituranetwork.com>
    Sent: 3/24/2014 10:17:54 AM

    Hello All, 

    I am working on an extraction for an invitation list. I have a combination of suppression and inclusion segments. Let me start off by saying that I am in a consortium environment.

    One of my suppression segments identifies and suppresses those records which do not have our customer constituency. This segment is effecting one of my inclusion segments. My inclusion segment is a donor segment (looking for donors at a certain level). In our consortium, we have a script which updates/adds a customer constituency overnight. So when I add a donation to a new donor record, I do not need to manually add my customer constituency; the script will do it for me.

    My suppression report tells me that 9 records are being suppressed from my donor segment because they do not have my customer constituency. My first thought is to recreate my segment in list manager, then adding the "does not have" customer constituency. I would hope to see the 9 records being suppressed. This does not produce any results.

    I am looking for help in identifying those suppressed records. Any suggestions?




    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!

    Image removed by sender. Cinderella




    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 Marie,

     

    Perhaps this is a long shot, but could some information be on an individual record and other information on a household?  When I suppress a segment, I make sure I am including ALL HH affiliated accounts, for instance with board members I suppress the board acct, the board spouse acct and the board HH acct.  Then if one of those accts fall in another segment, I know I won’t be accidentally including them.  This might explain why you don’t see those accts when you save the suppression list and the other list and cross reference them. 

     

    T.C. Brown

    Database Administrator

    412.392.4834

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Marie Kocher
    Sent: Monday, March 24, 2014 3:08 PM
    To: TC Brown
    Subject: RE: [Tessitura Development Forum] Extraction Suppressions

     

    Anna,

     

    Thank you for that suggestion. It, however, gives me zero.

     

    Marie

     

    --

    Marie Kocher | Development Assistant

    Kansas City Ballet

    Todd Bolender Center for Dance and Creativity

    500 W Pershing Road

    Kansas City, MO 64108

    816-931-2232 x 1382 | 816-931-1172 (fax)

    mkocher@kcballet.org

     

    Buy tickets and enroll for classes: www.kcballet.org


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Anna Wessely
    Sent: Monday, March 24, 2014 12:51 PM
    To: Marie Kocher
    Subject: Re: [Tessitura Development Forum] Extraction Suppressions

     

    Marie,

    In extractions after generating your counts open the extraction and select Save to list. Deselect all of your segments except the suppression segment.  Save that segment to a list; this will make a critirealess list of the suppressed constituents.  Create a second list that has the same criteria as your inclusion segment (the one with the contributions) and add a criterion that is List HAS the list you just created from extractions.  That should give you everyone who was suppressed who qualifies for the segment.  The only exception would be any inactive constituents (extractions by default include inactives and lists by default exclude the inactives).

    Best,

    Anna

    From: Marie Kocher <bounce-mariekocher5698@tessituranetwork.com>
    Sent: 3/24/2014 10:17:54 AM

    Hello All, 

    I am working on an extraction for an invitation list. I have a combination of suppression and inclusion segments. Let me start off by saying that I am in a consortium environment.

    One of my suppression segments identifies and suppresses those records which do not have our customer constituency. This segment is effecting one of my inclusion segments. My inclusion segment is a donor segment (looking for donors at a certain level). In our consortium, we have a script which updates/adds a customer constituency overnight. So when I add a donation to a new donor record, I do not need to manually add my customer constituency; the script will do it for me.

    My suppression report tells me that 9 records are being suppressed from my donor segment because they do not have my customer constituency. My first thought is to recreate my segment in list manager, then adding the "does not have" customer constituency. I would hope to see the 9 records being suppressed. This does not produce any results.

    I am looking for help in identifying those suppressed records. Any suggestions?




    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!

    Image removed by sender. Cinderella




    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