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

SOLVED

AC v.6 Include again in the workflow excluded users

eveline8
Level 4
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
RamaRajesh
Correct answer by
Employee
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
RamaRajesh
Correct answer by
Employee
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