Hello Tessiturians,
A little confused between emarket_ind (in T_CUSTOMER) and market_ind (in T_EADDRESS).
Both flag active primary email address as 'OK to emarket' yet both are different.
I've also discovered inconsistencies in our data between the two and wonder if we are missing a daily job or something to match them up?
Eg: emarket_ind.T_CUSTOMER = yes market_ind.T_EADDRESS = no
but related to the same email address?
Should we be matching up this data so that it is consistent? If so, what has priority over the other? T_CUSTOMER? or T_EADDRESS?
Any feedback appreciated,
Aaron WaapuMRC
This is tricky. Because of the way Tessitura evolved, e-mail restrictions were attached to the account when, for many purposes, they really belong on the individual e-mail address. When people unsubscribe, it is sometimes because they don't want to hear from us, and sometimes because they no longer want to receive e-mails at a particular address. Some people will unsubscribe one e-mail address and, at the same time, subscribe with another one.
WordFly updates the T_CUSTOMER emarket_ind as part of its unsubscribe process, which to me is overkill. I use a procedure to update the e-mail address being unsubscribed to a type I set up called TMS-Unsubscribe, with the marketing indicator check box unchecked. That way, this address will not be selected by extraction. I then reset the T_CUSTOMER value so that if there are other valid e-mails in the record, they may be used, where appropriate.
In cases where patrons indicate they do not want to receive any e-mails from us, the T_CUSTOMER setting, of course, stays put.
Any time patrons add an e-mail to our system, either by subscribing or by purchasing tickets or some other form of interaction with our web site, they have the opportunity to mark that e-mail address with a "no mail to this address" e-mail preference.
Lucie