Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
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

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