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
BedrockMission!

Learn More

View all

Sign in to view all badges

AC v.6 Include again in the workflow excluded users

Avatar

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

5 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

5 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
eveline8
Level 3

17-01-2018

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Employee
RamaRajesh
Employee

Likes

40 likes

Total Posts

81 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Employee
RamaRajesh
Employee

Likes

40 likes

Total Posts

81 posts

Correct Reply

10 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
RamaRajesh
Employee

17-01-2018

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

Answers (0)