I need a mass mailer (ezine) based on a mysql mailing list.
The mailing list table fields: id, name, email, active
The emails will be personalized for each registered user, will have a "mail opened" feedback, a click on link counter and unregister link.
Suggested class for sending is SWIFT Mailer.
Emails sent are registered in "sent_emails" table (id, title - email subject, date, time, sent_to - number of active users ).
Once the receiver opens the email the followings are going to "stats" table :
sent_email_id - from sent_emails,
user_id - from mailing list,
opened - which indicates how many times user opened email,
datetime (separated by ,) as text for each time he opens email,
ip - text field with ip's separated by "," for each time he opened email
links from mail will be redirected to a php which adds the link also to stats table with datetime attached (field: click = 20080303123000-link) - exception will be the unregister link and the open counter link
Well this is the suggested DB structure (which we use now) but any other ideas are well taken.
IMPORTANT:
- failed sending or receives will not be retried/resent.
- the system must not overload the server
- Domain Key setup help may be needed
- we would like someone who made this already and has a well tested - working version
we have a dedicated team of experts. we have created lot of projects based on same.
we are looking forward to get and long time relationship to assist u in future.
Thanks & Regards.