Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Exclude recipients schema from Recipient Delivery Log schema + Recipient tracking Log schema

Avatar

Level 4

Hi guys,

 

I created an exclusion from Recipient Delivery Log schema vs Recipient tracking Log schema from several deliveries to get the "No Openers". Now I have received a list that was uploaded into Recipients schema and I need to exclude this list to the No Openers result.

 

I have tried Change dimension or Enrichment to find a workaround but either I get errors or the exclusion throws 0 results.

 

Do you guys know how to solve it?

 

Regards,

Raúl

 

 

1 Accepted Solution

Avatar

Correct answer by
Level 2

Hello @RaulOcana ,

 

You can directly use the recipients to query on delivery logs and tracking logs.
The exclusion query should look like this. i am checking the deliveries on the basis of delivery codes

manojepsilon_0-1585754572329.png

 

Let me know if that helps.

 

Thanks,

Manoj

 

View solution in original post

2 Replies

Avatar

Correct answer by
Level 2

Hello @RaulOcana ,

 

You can directly use the recipients to query on delivery logs and tracking logs.
The exclusion query should look like this. i am checking the deliveries on the basis of delivery codes

manojepsilon_0-1585754572329.png

 

Let me know if that helps.

 

Thanks,

Manoj

 

Avatar

Level 2
The Status operator should be "equal to" instead of "greater than or equal to"