Drip email

Use this forum to suggest new features, language support, documentation, etc. for OpenEMM's roadmap

Moderator: moderator

Posts: 24
Joined: Tue Aug 22, 2006 6:50 pm
Location: Atlanta, Georgia U.S.A.

Drip email

Post by flyboy » Tue Aug 29, 2006 1:09 am

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.
Fedora Core 5
OpenEMM 5.0.1
Java 1.5.0_08-b03
MySQL v5.0.22

Sam Eads
Sales & Investments
Crown Realty & Management

Site Admin
Posts: 2373
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany

Post by maschoff » Tue Aug 29, 2006 11:20 am

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.
OpenEMM Maintainer

Posts: 3
Joined: Thu Apr 26, 2007 10:39 am

calculations with current_timestamp not working

Post by legesund » Thu Apr 26, 2007 11:08 am

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

Post Reply