Can i crete a filter/query to see if I have matching ricipients in two Deliveries | Community
Skip to main content
alik98709228
alik98709228
Level 2
November 4, 2016
Solved

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

  • November 4, 2016
  • 2 replies
  • 1563 views

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!

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 florentlb

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.

2 replies

florentlb
florentlbAccepted solution
Level 10
November 7, 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.

Marcel_Szimonisz
Community Advisor
Marcel_SzimoniszCommunity Advisor
Community Advisor
December 9, 2016

Hello,

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

BR

Marcel

Terms & ConditionsAccessibility statement

Loading footer...