Hello,
I've been asked to update our seed lists for mailings, emails, and robocalls. The challenge that I have is that there are different combinations of home/work addresses/phones, and some folks who don't want to receive all types of communications.
We are currently using List Manager, but I'm not sure how to pull the appropriate address/email/phone if there are multiples on the account. I have looked at the T_LIST_DECOY_NAMES system table, but I'm not sure what happens with the empty fields in the table. Will they be included in the extraction without that contact point?
And then on top of this, we have some folks who only want to get Education emails, and a whole other set of names on the Philanthropy side of things.
Does anyone have any creative solutions for this?
Thanks in advance,
Lesley
I just ran into this same issue yesterday! I hope someone is able to help solve it.
Hi Staci. I think I stumbled into a solution. (Maybe?)
Using the TR_CONTACT_POINT_PURPOSE and TR_CONTACT_POINT_PURPOSE_CATEGORY (in test, of course!), I made a new category of Seed List, and then made new purposes for "Marketing email", "Marketing mail", Marketing robocall" etc, and then pulled each of these purposes into a list. Then I use that list as an inclusion segment in an extraction.
So far, I've only done it in test, but it seems to work the way I'm expecting, so I'm going to start setup in live soon!
Hope that helps.