Selecting 1 value of an array for a specific recipient

Avatar

Avatar

cbalaguer

Avatar

cbalaguer

cbalaguer

19-02-2021

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!

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

akashaj7696

Avatar

akashaj7696

akashaj7696

19-02-2021

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,

Answers (1)

Answers (1)

Avatar

Avatar

Sukrity_Wadhwa

Employee

Avatar

Sukrity_Wadhwa

Employee

Sukrity_Wadhwa
Employee

25-02-2021

Hi @cbalaguer,

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

Thanks!