Hi,
So we have recently sent an eblast to the wrong people due to using advanced relationships and I'm trying to figure out what we did wrong....
I'm hoping someone can see what i've done and tell me what I SHOULD have done instead! Basically, we build an extraction with several segments and after counting, the segments are saved as lists and uploaded into wordfly.
What happened was that in the extraction, we did not want to email our board members, so they were suppressed by using a constituency in a suppression segment like we normally do and have been doing for years. The "Search Household" was not checked in this segment.
In the bottom segment, we had a large list of prospects which was anyone having an email address. The criteria we use for this is EAddress <> ''. It returned over 70K records. Among those records, it turns out, it returned individual accounts who were tied to households having the Board Member constituency. :(
The Replace individual with household and add all primary affiliates radio button was selected on this criteria, which MAY be to blame?.
So what did we do wrong? If I had included the advanced relationship in the suppression, would that have been best? Or did the "Add Primary Affiliates" radio button overwrite any suppression segment?
Thanks for any help you can give!
-Tiffany Evans
Database Coordinator, Huntington Theatre Company
This does help! J And yes you did read it correctly.
Does this basically apply for ANYTHING that can be attributed to a household? For example, ticket history which we keep on the household, if we wanted to suppress buyers to a specific performance, we’d want to have this advanced relationship selected as well?
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Beth Hawryluk Sent: Monday, July 13, 2015 3:57 PM To: Tiffany Evans Subject: Re: [Tessitura Marketing Forum] Advanced Relationships - When things go wrong
Hi Tiffany,
I hope I read that correctly.
We frequently have extractions where we want to exclude not only a certain type of person, but anyone attached to their household. Board members is a great example of that.
How we accomplish this is in the board member suppression segment we replace individual with household and add all primary affiliates. Then your suppression includes everyone attached to the board member household. By doing that, your inclusion segment below shouldn't pick up any of those people.
Hope that helps!
From: Tiffany Evans <bounce-tiffanyevans7088@tessituranetwork.com> Sent: 7/13/2015 3:28:46 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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!
In a nutshell, yes. Anytime I'm working with suppressions I judge whether or not I want to suppress just the selected individual or if I want anyone at their household. But the idea should work the same for most things. As John mentioned, doing the "switch to household and add affiliates" doesn't always catch everyone all the time. There are a number of factors that can cause someone to be missed by a suppression (In our case, the biggest culprit is unmerged duplicate accounts!!). But for the most part it has worked well for us once we got the hang of it.
If you're still a bit confused and you'd like to touch base offline I could show you a couple of example extractions that we've done here and I can tell you why I made some of the relationship choices I made while building them. I don't claim to be an extraction pro by any means but it might give you some food for thought!
bhawryluk@winspearcentre.com