Can i crete a filter/query to see if I have matching ricipients in two Deliveries

Avatar

Avatar
Give Back
Level 2
alik98709228
Level 2

Likes

3 likes

Total Posts

28 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
Boost 3
Boost 1
View profile

Avatar
Give Back
Level 2
alik98709228
Level 2

Likes

3 likes

Total Posts

28 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
Boost 3
Boost 1
View profile
alik98709228
Level 2

04-11-2016

Hi,

I was wondering if there's a way to create a filter to see if there are same recipients (same email) exists in two or more deliveries.

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

07-11-2016

Hi,

You can do that by using a Query activity in a workflow:

  1. Set the Targeting and Filtering dimensions to Recipients.
  2. Set two or more filtering conditions (depending on the number of deliveries - one condition per delivery) using a AND operator so that you target recipients that have a record in the Recipient delivery logs table for the deliveries you want. You can specify which delivery in a sub-condition.
  3. Validate and run the workflow. The outbound transition will contain recipients that were targeted in all specified deliveries.

For example, for two deliveries, you should have conditions that look like this:

If you are not sure recipients are unique and that several recipients could have the same email address, you can deduplicate your data using a dedicated workflow activity.

 

Hope this helps,

Florent.

Answers (1)

Answers (1)

Avatar

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

103 likes

Total Posts

227 posts

Correct reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile

Avatar
Springboard
MVP
MarcelSzimonisz
MVP

Likes

103 likes

Total Posts

227 posts

Correct reply

56 solutions
Top badges earned
Springboard
Establish
Contributor
Give Back 25
Give Back 10
View profile
MarcelSzimonisz
MVP

09-12-2016

Hello,

if you want to search recipients who got any 2 unspecified deliveries which were sent eg in the last month.

BR

Marcel