Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    Regular Coder
    Join Date
    Dec 2002
    Location
    the windy city
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts

    what's involved in sending out and tracking email campaigns?

    we would like to be able to do the following things:
    1. just be able to send out a newsletter on a regular basis
    2. send out and track email campaigns.
    i.e. we would need to know how many people actually opened the email, how many viewed a privacy policy link, forwarded it to a colleague, submitted the form (that would need to be auto-populated because the emails will be personalized) and all that sort of stuff.
    3. sending out emails depending on when the record was created in the database (say I need to send out emails to each record that was created 7 days ago and this process would need to happen every day) and then send follow up emails based on what the response to the first one was.

    what is involved in doing it? I need to know everything from software to what one would need to know to program and manage this kind of system.

  • #2
    Super Moderator
    Join Date
    May 2002
    Location
    Perth Australia
    Posts
    4,040
    Thanks
    10
    Thanked 92 Times in 90 Posts
    Quote Originally Posted by DoubleV
    ... i.e. we would need to know how many people actually opened the email, ...
    Well I am unsure of the ethics of such, though of course an opt-in list gives you some scope.

    At the end of the day you are going to be hampered by your users choice/setup of mail client, e.g. for those who receive HTML email , you can append unique ID's to server content , e.g. img src="www.blah.com/img/pic.jpg?sid=1234" where pic.jpg is really a server-side script which logs the 'hit' and then outputs the image.

    Of course those who can not or will not accept HTML email are another matter , all you can know for sure is whether the email was accepted (e.g. not bounced to your return address) or not, also firewall configuration could hamper such with paranoid clients.

    The tracking of forward's etc is feasible if complex, but again , 1 secure client in the chain will break it.

    I would suggest that with your stipulation of working with your existing systems that you are well into custom script territory , what tools ? well you know what I would use , but any language that can utilise HTTP or sockets would do.

    not much help am I
    resistance is...

    MVC is the current buzz in web application architectures. It comes from event-driven desktop application design and doesn't fit into web application design very well. But luckily nobody really knows what MVC means, so we can call our presentation layer separation mechanism MVC and move on. (Rasmus Lerdorf)

  • #3
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    1. Easy. Run a google and you'll be swamped with mailscripts.
    2. Sending out --> see 1. Tracking them --> first ask yourself what you'll do with the tracking info and how relevant it realy is to you. Do you realy care if adressX opened the message and did nothing after that?
    I would imagine that the only real important issue is wether they submitted the form (which could contain a checkbox for the privacy policy and the clients ID). And i assume these will be posted to you so no extra coding required here
    All other info about opening/forward might be completely irrelevant.
    3. Easy. Just set up a cronjob that selects the records from the db and sends a mail to each client, and have it run at midnight. I've posted some info on that using PHP in the PHP-forum. Using the mail() function is probably the easiest, but only recommended for lower volumes (< 500 mails?) since it is quite slow.

    The only soft you need could be PHP, a db (mySQL ?) and a cron-job (Unix) or a scheduled task (Windows).
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html

  • #4
    Regular Coder
    Join Date
    Dec 2002
    Location
    the windy city
    Posts
    140
    Thanks
    0
    Thanked 0 Times in 0 Posts
    sorry I never got back to this thread sooner. but's it's never too late to say thanks, is it?


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •