Intersection (Clients from different recipient folders)

Avatar

Avatar
Validate 1
Level 1
rafaelc35759395
Level 1

Likes

2 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
rafaelc35759395
Level 1

Likes

2 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
rafaelc35759395
Level 1

08-07-2019

Hi,

I am having an issue about sending emails to only those clients that are added to subscription services. Since I may have the same client at different recipient folders, I want to exclude her/him entirely from my deliveries if she/he did, within a recipient folder, have opted out from subscription services.

08-07-2019 4-12-47 PM.png

08-07-2019 4-24-22 PM.png

I know that usually subscription services are connected to a client ID and not email for example. Therefore, if I have the same client in different folders, the same client will have a different ID in each one. How can I reconcile the data to only consider, from the results of these two queries, the same client (by email) that appears on both subscription lists for the two folders it appears?

Thank you in advance for your support.
Best,

Rafael

Replies

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

977 likes

Total Posts

1,096 posts

Correct reply

516 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

11-07-2019

Hi,

Use intersection activity with 'selection of columns' keyed on email field.

Thanks,

-Jon

Avatar

Avatar
Boost 5
Level 3
Yassine_N
Level 3

Likes

20 likes

Total Posts

24 posts

Correct reply

5 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Affirm 5
View profile

Avatar
Boost 5
Level 3
Yassine_N
Level 3

Likes

20 likes

Total Posts

24 posts

Correct reply

5 solutions
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Affirm 5
View profile
Yassine_N
Level 3

12-07-2019

Hello,

Try to use exclusion its better on field @email