Could anyone who has a standard suppression set up for Extractions share what is on it? We are planning to set one up and want to make sure we don't miss something important. Obviously some of it is organization specific depending on our usage of attributes, mail purposes, etc... but just a general idea would be great. Thanks!
Hi Kjersten,Here are some of ours that are not totally specific to us.
Constituency BoardConstituency Board Former Constituency StaffConstituency Artist Type Non IndividualsDo Not Solicit PhoneDo Not Solicit MailDo Not Solicit EmailDo Not Market PhoneDo Not Market MailDo Not Market EmailDo Not Trade PhoneDo Not Trade MailInactive AccountNo Phone Number
Then some various ones to find bad address.
I also supress Merged constituents, along with Inactive Account as my #1 supression. The rest then vary depending on the purpose of the extraction, but those two are my 'essentials'.
From: Kjersten Schladetzky <bounce-kjerstenschladetzky7557@tessituranetwork.com>| Sent: 9/23/2009 3:08:31 PM|
Hi
Our standard postal suppressions are:
Staff members
Inactive accounts
Merged accounts
Customers with 'deceased' flag (in case these have not been inactivated for any reason)
People with 'Do Not Mail' marked in data protection
People with our organisations postcode - sometimes this is used for press accounts where we only have an email address
Hope that's helpful
Siobhan
Thanks Kevin. That helps alot. Sounds like something we should throw in just to be safe.
Unknown said:To give a little more background, when two records are merged the delete record is not really deleted but rather the status is changed to Merged. This is the record that exists in the T_CUSTOMER table, which pretty much just holds the N1, N2, and a few audit fields like last update. All the other data in a constituent record is stored in other tables and the ID on that data is changed from the delete record to the keep record. Because of that, it's pretty unlikely a merged ID would end up in an extraction (it wouldn't have any data that would meet your criteria unless you were looking at something like name status) but it never hurts to be safe by suppressing merged records. Kevin Sheehan Documentation & Learning Resources Specialist Tessitura Network 1 888 643 5778 ext 329 Office ksheehan@tessituranetwork.com
Sorry, I checked the criteria for our "Inactive Account" suppression and it also checks for merged accounts.
We tend to think of our Standard Suppression Extraction as the things we want everyone to think about when they are extracting a list. Our Standard Suppression's are extrememly similar to the ones Ryan listed for ACT as well as a segment for Subscribers and Minors.
Not that we always suppress Subs but that we want people to stop and think about whether they are mailing to Subs or not, as a lot of our mailing and email messaging is based on whether we are sending to Subs or STBS.