The Cache: Technology Expert's Forum
 
*
Welcome, Guest. Please login or register. July 29, 2010, 07:56:34 PM

Login with username, password and session length


Pages: 1 [2]
  Print  
Author Topic: Newsletters and handling bulk email  (Read 993 times)
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 8649



View Profile
« Reply #15 on: December 04, 2009, 02:23:25 PM »

Awrighty, here's the story.

First, my client-user uses a content editor to create/edit both the HTML template framework for blasts, as well as individual content for each blast. So many customers have a templates like, "quick note" and "letterhead".


They also use my list manager to construct lists of people they'd want to blast for various reasons. Here we see a pretty standard email rule set, with the silly but illustrative demonstrations of adding two more fields to the rules. I reverse engineered this look from iTunes Smart Lists - it creates a stored procedure in the database, so that when an individual record changes, all lists are automatically updated.


Users then go to the blast manager. Here we can see a list of previous blasts they can edit/reuse or create new ones.


They select a template from what they've previously created...


... then select content for the body. Templates allow for any number of macros to dereferenced and content added/customized. In this case, there is only one macro for the main body content.


All HTML email require a text equivalent. Here we've selected the same HTML content, and I've stripped out the HTML tags and made it look right for the text portion of the MIME message.


Then we select a list from the list manager...


There are a couple details specific to each blast. A caption to be placed into each contact's memos, whether to use an SMTP relay or try to deliver directly to the recipients email server, or whether to us a word salad to change up the content and each email will no longer be the same. I have no idea why you'd want to do that  Roll Eyes


Before you can blast, all the rules I have defined must at least be in the yellow, if not green. I have ditched a couple of the things from the blast to demonstrate how a red light stops the blast from being able to go forward.


Finally! Everything acceptable, user must still click 3 useless checkboxes at the bottom for the "Execute" button to appear. I know that looks funky, but it helps me stop clients from making a mistake.



Once the execute button is clicked, I compile the user's instructions into a job record, recipient records etc as described above. Then the cron job, now having something to do, will fire off dispatchlets to get it done.

My newer version allows for custom code to be called against every record, custom attachments, images, immediate adjustment of recips/minute, blast priority (so that even if you have 50K pieces going out, if you suddenly realize you want to get a press release out for (that) client, you can put it above the marketing email) and such, as well as an instant email test button which I foolishly left out in this version.

It's even prettier Wink
« Last Edit: December 04, 2009, 02:25:29 PM by perkiset » Logged

It's the things you learn after you know it all that really count.
-John Wooden
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 8649



View Profile
« Reply #16 on: December 04, 2009, 02:28:05 PM »

Side note, regarding blinky-lights for Kurdt: to the left of the title you can see a bright green and dark red LED. While the AJAX call is being made, the green light goes off and the red blinks rapidly.

Blinky lights, FTW!
Logged

It's the things you learn after you know it all that really count.
-John Wooden
nutballs
Administrator
Lifer
*****
Online Online

Posts: 5296


DAMN YOU!!!!!!!


View Profile
« Reply #17 on: December 04, 2009, 02:35:14 PM »

lordy. Dont you just have an Easy Button?

FINE! I have upgraded mine!



I WIN!
Logged
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 8649



View Profile
« Reply #18 on: December 04, 2009, 02:36:00 PM »

I humbly concede.  Praise

(side note @ easy: yes, if there are predefined emails, like the F's weekly blast, it's a one-button affair)
Logged

It's the things you learn after you know it all that really count.
-John Wooden
nutballs
Administrator
Lifer
*****
Online Online

Posts: 5296


DAMN YOU!!!!!!!


View Profile
« Reply #19 on: December 04, 2009, 02:40:07 PM »

ah ok. I figured.

Mine is very specialized to the specific needs of the behemoth corp we do these blasts for. I generally tend to spend ZERO time on looks of my stuff.
Logged
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 8649



View Profile
« Reply #20 on: December 04, 2009, 02:41:31 PM »

Different mission: you're doing the work, so it doesn't need to be. In most cases, either my clients or PinkHat are doing the blast, in which case it'd better be pretty tight and free from PEBCAK bugs.
Logged

It's the things you learn after you know it all that really count.
-John Wooden
nutballs
Administrator
Lifer
*****
Online Online

Posts: 5296


DAMN YOU!!!!!!!


View Profile
« Reply #21 on: December 04, 2009, 02:42:57 PM »

true true.
Logged
deregular
Expert
****
Offline Offline

Posts: 169


View Profile
« Reply #22 on: December 04, 2009, 07:48:06 PM »

Wow perk, that is just......

Freakn bohemoth!

Shit, just forgot about text email backup when sending html emails..

Back to work.
Logged
nutballs
Administrator
Lifer
*****
Online Online

Posts: 5296


DAMN YOU!!!!!!!


View Profile
« Reply #23 on: December 04, 2009, 07:51:12 PM »

Lol. My text-only email is standard in all I send.

This email is HTML, view it online HERE.

Screw em.
Logged
deregular
Expert
****
Offline Offline

Posts: 169


View Profile
« Reply #24 on: December 04, 2009, 08:51:55 PM »

Lol yeah thats basically what Im going to do.

I have another question....

How do you guys handle bounces?

Is there a way of determining an email address's connectivity before sending the actual email out?
Logged
nutballs
Administrator
Lifer
*****
Online Online

Posts: 5296


DAMN YOU!!!!!!!


View Profile
« Reply #25 on: December 04, 2009, 09:24:34 PM »

in a previous version i had a gmail account, that all the bounces went to.
php has some pop functions for grabbing mail.
I still have that to add back into my current version, but have had more pressing things.
Logged
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 8649



View Profile
« Reply #26 on: December 04, 2009, 11:00:26 PM »

I have a library that allows me to POP or IMAP email - I have another cron job (ghetto daemon) that gets bounced/returned email and then puts it into the database for me to evaluate. If it is a recognizable pattern (ie., straight up bounce) then I "unsubscribe" the user automatically. Keeps the lists as clean as possible.
Logged

It's the things you learn after you know it all that really count.
-John Wooden
Pages: 1 [2]
  Print  
 
Jump to:  

Perkiset's Place Home   Best of The Cache   phpMyIDE: MySQL Stored Procedures, Functions & Triggers
Politics @ Perkiset's   Pinkhat's Perspective   
cache
mart
coder
programmers
ajax
php
javascript
Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks


Valid XHTML 1.0! Valid CSS!