Sequential emails upon sign-up?

Use this forum for all other questions regarding OpenEMM

Moderator: moderator

Sequential emails upon sign-up?

Postby storyleader » Sat Sep 06, 2008 2:48 pm

Can OpenEMM do one or both of the following?

1. A user subscribes to a mailing list on day 1. Can OpenEMM automatically send email A to that same user on day 2, then email B on day 8, email C on day 30, etc.?

2. A user subscribes to a mailing list on day 1. Can OpenEMM automatically add that user to a second mailing list on day 90, say? And/or automatically remove that user from the first list on day 120, say?

I've searched in the docs, forums, and wiki, but can't find the answers!

Thanks!
Want to learn storytelling? Free ezine at http://www.storydynamics.com/etips
storyleader
 
Posts: 3
Joined: Sat Sep 06, 2008 2:31 pm

Yes and no

Postby maschoff » Sat Sep 06, 2008 8:50 pm

Re 1: Yes, it's called "date based mailing. An example: Every new subscriber should get a greeting mail one day after subscription, two days later a followup mails and one week later a reminder mail. You can define three target groups greeting (creation_date +1 = sysdate), followup (creation_date +3 = sysdate) and reminder (creation_date +10 = sysdate) and three date based mailings which are sent to the according target group. BTW, you can define the exact time of the delivery via the "send mailing" tab of each mailing.

Re 2: Not with OpenEMM, but you can write a SQL script to manipulate the MySQL database (see doc: http://www.openemm.org/fileadmin/docs/O ... le-Doc.txt) and trigger this script with a cronjob each day.
OpenEMM Maintainer
maschoff
Site Admin
 
Posts: 2130
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany

Good and Good Enough!

Postby storyleader » Sat Sep 06, 2008 9:19 pm

Thank you so much for the quick reply!
ma wrote:Re 1: Yes, it's called "date based mailing.

Ah! I didn't realize that "date based" included relative as well as absolute dates. Cool!
ma wrote:Re 2: Not with OpenEMM, but you can write a SQL script to manipulate the MySQL database (see doc: http://www.openemm.org/fileadmin/docs/O ... le-Doc.txt) and trigger this script with a cronjob each day.

That would do, I think! Can you give me a quick idea of the logic of such a script? What I imagine is this: for each user-signup event (a particular user joining a particular mailing list) there is a stored variable that I'll call startdate. Then the script searchs for all users who belong to List A but not List B and with a startdate for List A < X days before today. Then it creates a new user-signup event for each of those users, adding them to List B and optionally triggering the sending of Email Y (the notification that they've been added to a new list, if desired) to each of those users. Would it be something like that?
Want to learn storytelling? Free ezine at http://www.storydynamics.com/etips
storyleader
 
Posts: 3
Joined: Sat Sep 06, 2008 2:31 pm

Postby weirdgod » Sat Jan 30, 2010 3:34 pm

I am trying to use this for sequention mailings, so that each new subscriber gets 1st follow up mailing on 1 day after subscription, 2nd follow up mailing 5 days after mailing, and 3rd follow up mailing after 20 days...

I am looking over manual (date based mailing), but that example with birthdate does not help me... Could anyone be so kind and guide me step by step on what to do (or point me to an example).

thanks!
weirdgod
 
Posts: 8
Joined: Thu Dec 03, 2009 12:53 am

Re:

Postby robertkresse » Wed Nov 16, 2011 6:43 pm

weirdgod wrote:I am trying to use this for sequention mailings, so that each new subscriber gets 1st follow up mailing on 1 day after subscription, 2nd follow up mailing 5 days after mailing, and 3rd follow up mailing after 20 days...


You have to create three target groups with the following rules:

1 day after subscription: creation_date = date_sub(now(), interval 1 day ) JJJJMMTT
5 days after subscription: creation_date = date_sub(now(), interval 5 day ) JJJJMMTT
20 days after subscription: creation_date = date_sub(now(), interval 20 day ) JJJJMMTT


After that you create one date based mailing for each target group.
Remember: The mailing has to be activated to work!
robertkresse
 
Posts: 1
Joined: Wed Nov 16, 2011 6:33 pm

Re: Sequential emails upon sign-up?

Postby Ishtiaq » Fri Dec 05, 2014 10:20 am

This is very nice post thanks a lot...!!
Pass your Braindumps.com and 1z0-821 exams in first try by
Ishtiaq
 
Posts: 1
Joined: Fri Dec 05, 2014 10:19 am


Return to Miscellaneous

Who is online

Users browsing this forum: No registered users and 1 guest

cron