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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
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,

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!