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

How do I query to filter out recipients who have not opened the last 5 emails they received?

Avatar

Avatar
Validate 1
Level 1
thesse1393
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
thesse1393
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
thesse1393
Level 1

17-08-2018

I'm trying to remove targets from my workflow if they have not opened the last 5 emails we sent them. How would I do this?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 5
Employee
Garima_Gakhar
Employee

Likes

44 likes

Total Posts

77 posts

Correct Reply

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

Avatar
Boost 5
Employee
Garima_Gakhar
Employee

Likes

44 likes

Total Posts

77 posts

Correct Reply

38 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
Garima_Gakhar
Employee

22-08-2018

Hi @thesse1393, thessey

I found one approximate solution to this, you could try once to see does that map to your requirement.

1. Create a Workflow with Query Activity for BroadLogRcp, where Targeting Dimension is equal to broadLogRcp (Recipient delivery logs) and Filtering Dimension is equal to Recipient tracking log.

2. Define the Filtering Condition as: Type (URL) not equal to Open.

3. Then link this Query Activity to a Deduplication Activity, you could choose to generate a Complement if required.

1554938_pastedImage_1.png

4. Within the Deduplication Activity, Edit the Configuration as below:

a) Targeting Dimension -> Temporary Schema

b) Identification of Duplicates -> on the basis of an expression for 'Recipient Email'

c) Deduplication method -> Doubles to keep: 5

1554939_pastedImage_2.png

5. Once the 'Result' is out, you could configure List to validate that indeed each of those Recipients which have been ranked for '5' have not Opened or Clicked any of the latest Deliveries.

6. So I verified this by checking on 2 records returned from the Deduplication Activity Results.

7. I checked on these two Recipients records within the BroadLogRcp Schema to fetch details of the last 5 Deliveries.

8. I then checked on Delivery and Tracking Logs of these Deliveries, emails were indeed sent to these Recipients but there was no Tracking Log associated with it.

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
Level 1
thesse1393
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
thesse1393
Level 1

Likes

0 likes

Total Posts

2 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
thesse1393
Level 1

21-08-2018

Thanks, but each of my users would have received different emails, so can't use internal names or email category to do this. Is there a way to identify recipients who didn't open the last 5 emails we sent them? Screen shots of steps would be so helpful.

Avatar

Avatar
Validate 10
Level 4
davidl14970702
Level 4

Likes

30 likes

Total Posts

93 posts

Correct Reply

13 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Validate 10
Level 4
davidl14970702
Level 4

Likes

30 likes

Total Posts

93 posts

Correct Reply

13 solutions
Top badges earned
Validate 10
Validate 1
Ignite 5
Ignite 3
Ignite 1
View profile
davidl14970702
Level 4

18-08-2018

You could just use a split (based on the tracking logs table) to split outs people based opening those 5 internal names. Use AND statements in the split for the internal names. The complement generated will be your list of people that have not opened.