The "decision" process of which newsletter to send and what to put in it can be implemented by building a custom stored procedure in any relational database like SQL Server, DB2, Oracle, etc... The emailing part can be performed using either 24x7 Scheduler or even better using our DB Mail software (use the last one if you need to send thousands of emails). In the latest case 24x7 can simply kick off the stored procedure on the scheduled time (once a week I guess?) and the stored procedure can then grab list of users stored in the database, their emails, registration times, calculate which newsletter to send and then call DB Mail functions to actually send the newsletter. This process is fairly simple and straight. Alternatively, instead of a stored procedure, you can write a script in some other language (VB, Java, etc…) that can do essentially the same. Databases and stored procedures are just the most common, efficient and convenient way to perform such tasks. If you need help with such programming our consulting services will be happy to help. : Can you help me solve this problem?
: I have asked numerous people/companies
: but no-one can offer me a solution,
: perhaps you can..? : OK, the situation is this: A user signs up to become a member of our
: newsletter either from the newsletter section
: or from the checkout section, lets call them X. X goes through our existing
: 'confirmation of email'
: section however, the link in the email requesting them to confirm
: their request to become a member takes them to an html newsletter
: page which has been tailored to them and their position in the
: buying process; i.e. not bought, bought PD1, bought PD123, future
: product #1,2,3,etc. X is now in the system and therefore will be
: expecting to receive their next installment, newsletter #2 in a
: months time (as you suggested on a Friday). So at the last Friday in
: in the month the system triggers the next newsletter and they get
: their #2. : Y however signed up a month before X and so at the same time Y gets
: their #3. The clever bit is that X and Y both get emails tailored to
: their situation in the buying process at the time of the email being
: sent; i.e. if when Y received newsletter #2 it inspired them to buy a
: product from us then their status will have changed and will be 'up-sold'
: the next product in line in their next email i.e. #3. : The point is though that no matter when Z regisers in say 12 months time
: they will still receive #1 at sign up and then #2 one month later, followed
: by #3 etc. : If you can help or if you think this product can do what I am trying to do
: then PLEASE let me know as am keen to set this up... : Thank you for taking the time to read my post. : Laurence from the UK
|
