Selecting 1 value of an array for a specific recipient | Community
Skip to main content
C
cbalaguer
Level 2
February 19, 2021
Solved

Selecting 1 value of an array for a specific recipient

  • February 19, 2021
  • 2 replies
  • 1218 views

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!

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 akashaj7696

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

akashaj7696
akashaj7696Accepted solution
Level 3
February 19, 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,

    Sukrity_Wadhwa
    Community Manager
    Sukrity_WadhwaCommunity Manager
    Community Manager
    February 25, 2021

    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
    Terms & ConditionsAccessibility statement

    Loading footer...