So we're fairly new to Tessitura and we're in the process of implementing WordFly. I need to modify LP_UPDATE_EMAIL_PROMOTION and I'm having a bit of trouble with the best way to handle hardbounces. If they have multiple eaddresses how do you identify in their account which one is the one that's bouncing back? Originally I thought we'd just add an attribute, but then I worry about those accounts that have several eaddresses and how to mark which one is bouncing back without having to do any manual work.
Thanks!
When using TMS we wrote a piece of sql that would check through the t_epromotion_response_history table for the hard bounce and the unsubscribe codes and check to see if we had more than 3 of these response since the primary email address had been created/updated.
However, as we are starting to use WordFly we have noticed that it is populating the eaddress field in t_promotion which should mean we can use this to more accurately check whether the current primary email address has had 3 hard bounce reports.
This does mean there are no actual updates on the customers record, may look to start flagging this on the constituent header so Box Office know to check the email address, and as soon as the customer changes their email address they will be reincluded in the lists, withot any additional work.
Mark