MS SQL Backend Data Manipulation

This is exactly what I want to do. Did you get any help with this?

I want a bounce management tool to update a couple of UDFs with Bounce_Count and Bounce_Code so I can select those records that are getting hard bounces and remove them from the list.

Since I don't want to place the Client_ld and Contact_Number into the mail body, I'll have to look up these values from the dbo.A_E_mail_Address view that contains the address the mail was sent to (e-mail addresses are unique in this DB).

Bill

Obviously there is a question as to why you would export the email addresses to a third party product when the Maximizer campaign manager can do the whole job for you? Possibly you are only using the Entrepreneur version of the product?

If you need assistance with handling bounced emails we have developed two options for this;

1. Email BounceAssist which is an outlook add-in which processes the bounced email you have open and updates Maximizer.

2. Mail Agent (available shortly) which is a fully automated bounce email processing system that will read incoming replies to your campaign and follow user defined rules for how to respond to each type of reply/bounce.

For further details of either of these products contact us as www.cabc.co.uk

At first I was looking at a service that would validate the e-mail addresses, but I found that most of the list got categorized as UNKNOWN, which ended up bouncing about 80%.

I have now integrated a tool called Bounce Studio Enterprise that pulls the bounces from the mailbox and assigns one of fourteen categories of bounces, and a score, then runs a stored procedure I wrote to update the Maximizer records that have the e-mail that bounced by incrementing their bounce score and bounce type. Then I can select all the records whose bounce score have passed the threshold and delete them. Multiple soft bounces will get a contact to the threshold.

I am using the Campaign Manager for automated opt-outs and link tracking.

It was painful learning the T-SQL needed to write the procedure, but I've wiped the blood from my keyboard and watched it process over 100,000 bounces over a few days, which allowed me to delete about 70,000 contacts with bad addresses.

It's good to know that you have a couple of options available. I wouldn't want to handle this volume of bounces through Outlook.

Just to let you know that our mail agent which is a dedicated solution for processing bounce emails arriving back from campaigns and matching them against records in Maximizer has now been deployed at our first customer. The solution is relatively simple to deploy and requires no programming knowledge to configure. The system categorises incoming email into 1 of 8 categories and offers upto 10 appropriate responses. Further details can be obtained by contacting us directly at CABC.co.uk