Expand my Community achievements bar.

SOLVED

Selecting 1 value of an array for a specific recipient

Avatar

Level 2

Hi there,

 

I want to select all the recipients who have at some point (at least) opened 1 email sent by us, as well as those who haven't.
The problem is the fields 'Status' (of delivery) and 'type (of action)' can have multiple values and depend on the delivery the system randomly selects for this report. E.g. I can filter by these fields (Status = sent and type = open) and in the complement I would still can see status = sent and type = open, because maybe in the first filter the system was looking at 1 specific delivery, but in another delivery, they have opened the email. 

 

The priority I would like to keep is: first, those people who have at least opened 1 email (we have multiple fields considered engagement here, such as email click, mirror page... and we want those too). Then, the rest.

 

Could you please help me here?

 

Thanks!

1 Accepted Solution

Avatar

Correct answer by
Level 3

Hi,

 

You can try "Recipient Tracking logs" schema, in where check for @logDate field, and filter based on logDate is not empty and then put another split and filter by type=url. As if some recipient has records in tracking logs it's confirmed that it has received email, so you don't have to look at DeliveryLogs Status="sent".

Hope this helps.

 

Thanks,

View solution in original post

2 Replies

Avatar

Correct answer by
Level 3

Hi,

 

You can try "Recipient Tracking logs" schema, in where check for @logDate field, and filter based on logDate is not empty and then put another split and filter by type=url. As if some recipient has records in tracking logs it's confirmed that it has received email, so you don't have to look at DeliveryLogs Status="sent".

Hope this helps.

 

Thanks,

Avatar

Administrator

Hi @cbalaguer,

Was the given solution helpful to resolve your query or do you need more help here? Do let us know.

Thanks!



Sukrity Wadhwa