Expand my Community achievements bar.

SOLVED

AC v.6 Include again in the workflow excluded users

Avatar

Level 4

Hi,

I created a recurring campaign to send an email to users who have purchased last week (purchase date on or before current date - 7days and purchase date on or after current date -14days). The scheduler is set in the afternoon.

In this workflow there is also a query that excludes users who have already received another email in the same day (the campaigns that they can receive in one day are several, for example: birthday mail, product mail... because they are scheduled in the morning).

For example:

Day 0: User XXX didn't purchase last week but today he receives birthday mail

Day1: User XXX didn't purchase last week but today he receives product mail

Day2: User XXX didn't purchase last week and he can receive the campaign

Now the problem is: which is the correct way to include again in the workflow excluded users (who did not receive the delivery but were part of the initial target)?

Thanks,

Eveline

1 Accepted Solution

Avatar

Correct answer by
Employee

Day0:

Inclusion: Select customers whose Purchase date on or before current date - 7days and    purchase date on or after current date -14days

Exclusion: Exclude customers users who have already received another email in the same day (for example: birthday mail, product mail)

Day1 and so forth:

Inclusion1: Select customers whose Purchase date on or before current date - 7days and    purchase date on or after current date -14days

+

Inclusion2: [Yesterday’s targeted population: Select customers whose Purchase date on or before current date - 8days and purchase date on or after current date -15days] minus [customers who received yesterday’s (Day0) email for product purchase]

Exclusion: Exclude customers users who have already received another email in the same day (for example: birthday mail, product mail)

Thanks,

Rajesh

View solution in original post

1 Reply

Avatar

Correct answer by
Employee

Day0:

Inclusion: Select customers whose Purchase date on or before current date - 7days and    purchase date on or after current date -14days

Exclusion: Exclude customers users who have already received another email in the same day (for example: birthday mail, product mail)

Day1 and so forth:

Inclusion1: Select customers whose Purchase date on or before current date - 7days and    purchase date on or after current date -14days

+

Inclusion2: [Yesterday’s targeted population: Select customers whose Purchase date on or before current date - 8days and purchase date on or after current date -15days] minus [customers who received yesterday’s (Day0) email for product purchase]

Exclusion: Exclude customers users who have already received another email in the same day (for example: birthday mail, product mail)

Thanks,

Rajesh