AnsweredAssumed Answered

Lapsed Customer Email

Question asked by Gary Goodman on Mar 3, 2017
Latest reply on Mar 3, 2017 by Devraj Grewal

I'm trying to create a campaign where we email a customer who has not ordered after their first order in the last 4 months. We have two date fields, First Order and Last Order in our database. When a customer first orders, both dates are set to the same value. If the customer has a second order etc. the last order date gets updated each time.


We have a trigger campaign that goes off when the first order field is updated (previous value empty). We then wait 4 months and trigger a second campaign.


It is the second campaign where I'm having some confusion. The trigger is "campaign requested" but i want to filter this so it will only complete if the "last order" date is not in the last 4 months, so that it only triggers with folks that haven't ordered again after their first order. I'm not sure how to use the data operators correctly. What I wish was there was a "not in past" operator.


Should I be setting the filter to "in past before" value "4 months" or is there some better way to setup this campaign to achieve the objective of emailing folks 4 months later that have not ordered again after the first order.


Thanks for any help in advance.


past order.jpg