AC v.6 Include again in the workflow excluded users | Community
Skip to main content
eveline8
eveline8
Level 4
January 17, 2018
Solved

AC v.6 Include again in the workflow excluded users

  • January 17, 2018
  • 1 reply
  • 1448 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ramakatt

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

R
Adobe Employee
ramakattAdobe EmployeeAccepted solution
Adobe Employee
January 17, 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

Terms & ConditionsAccessibility statement

Loading footer...