Page 1 of 1

Drip email

Posted: Tue Aug 29, 2006 1:09 am
by flyboy
One of the big things I need is a structure for sending Drip marketing campaigns.

Are you guys saying this could be part of EMM, or are you thinking BI or CRM?

I'd like to easily set up campaigns that have N number of precanned messages and when you sign up, you start receiving them spread out over a given interval.

Posted: Tue Aug 29, 2006 11:20 am
by maschoff
OpenEMM can do this out of the box (if you are an advanced user ;-)

1. Create a mailing of type "date based mailing" and do not forget to activate it when you are finished (tab "Send mailing").

1. Define a target group like "FollowUp" with definition "creation_date = current_timestamp - 5" and set the mailing to this target group.

Explanation: creation_date is the date a user signed on (or a user record was imported by you) and current_timestamp is the current date. -5 means, that a user belongs to the target group on that day which is 5 days after creation. Date based mailings get sent once a day.

If you have problems with implementing please post again.

calculations with current_timestamp not working

Posted: Thu Apr 26, 2007 11:08 am
by legesund
Hello,
I tried to set up a date based mailing using the
"creation_date = current_timestamp - 5" definition.

However, when I set up a target group with a filter like
"creation_date = current_timestamp - 5 / YYYYMMTT", it does not
work as expected: No adresses are selected, although there
are some recipients in the database that should match the
filter. What's wrong?

--
OpenEMM 5.0.2
MySQL 5.0.32