Currently our email subscribers are contained in Tessitura, with an Interest selected for e-news. Each week I extract a list and import that into Oi to send out our e-news.
Each week I also perform at least 150 manual unsubsribes - I have to search for each individual con by electronic address and untick the Interest.
I would LOVE to be able to import a list of email addresses, which are then matched to IDs, and use Manage Cons to change their Interest in bulk. I know I can import a list of IDs but I don't know their IDs, only emails.
Does anyone have any ideas about how I make this less painful each week?!!
Thanks in advance.
Unknown said: I would LOVE to be able to import a list of email addresses, which are then matched to IDs, and use Manage Cons to change their Interest in bulk. I know I can import a list of IDs but I don't know their IDs, only emails. Does anyone have any ideas about how I make this less painful each week?!!
I do something like this regularly: I import the e-mail addresses via SSIS and then find the appropriate customer_no's via SQL and (in our case) setting their e-mail restriction to "No E-mail". We also flag e-mail addresses as a "bad" type, for those that come back that way, via almost the same method.
Drop me a line if you'd like more specifics.