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.
Drip email
Moderator: moderator
Drip email
Fedora Core 5
OpenEMM 5.0.1
Java 1.5.0_08-b03
MySQL v5.0.22
Thanks,
Sam Eads
Sales & Investments
Crown Realty & Management
OpenEMM 5.0.1
Java 1.5.0_08-b03
MySQL v5.0.22
Thanks,
Sam Eads
Sales & Investments
Crown Realty & Management
-
- Site Admin
- Posts: 2628
- Joined: Thu Aug 03, 2006 10:20 am
- Location: Munich, Germany
- Contact:
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.

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.
OpenEMM Maintainer
calculations with current_timestamp not working
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
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