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!
Christina -
It is for precisely that reason (and a few others) that we don't automatically unsubscribe hard bounces, instead we have a 'bad email - confirm' option in our emarket restriction that we use to flag a bad email. We suppress them from any emailings until it has been resolved. We also have an icon that appears on our header when the 'bad email confirm' is set so anyone having dealings with the patron knows to confirm an email address.
Right now, it doesn't fully deal with multiple emails which is unfortunate, so there is still a little bit of heavy lifting that has to be done to manually check those.
Heather
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
We use a combination of the email marketing flag and the email purposes. I have an email purpose for hard bounces. When an email bounces, I import the list of bounces into the LT_HARDBOUNCE table. Then I have a procedure that runs off that table that marks each email address by removing the marketing flag and marking the hard bounce purpose. Then when lists are pulled together, we exclude the ones where the marketing flag is unchecked.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Christina Bledsoe Sent: Tuesday, September 07, 2010 1:22 PM To: Gloria Ormsby Subject: [Tessitura Technical Forum] WordFly and hardbounces
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!