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
BedrockMission!

Learn more

View all

Sign in to view all badges

elisag19795522
Community profile elisag19795522 Level 2
Job title here
Location here
6 BADGES
Level 2

Level 2

Learn more
Joined the community 06-02-2019 6:19:13 AM
Offline
Top badges earned by elisag19795522
Customize the badges you want to showcase on your profile
Re: Excluding non engaged subscribers from email delivery
Avatar
Give Back 3
Level 2
elisag19795522
Level 2

Likes

2 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
Boost 1
View profile
elisag19795522
- Adobe Campaign Standard
I've tried this and it looks like it worked:

Views

922

Like

1

Replies

0
Re: Excluding non engaged subscribers from email delivery
Avatar
Give Back 3
Level 2
elisag19795522
Level 2

Likes

2 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
Boost 1
View profile
elisag19795522
- Adobe Campaign Standard
I tried again narrowing the query, like below:And still got the following error:Do you know what the error means?Thanks

Views

890

Likes

0

Replies

0
Re: Excluding non engaged subscribers from email delivery
Avatar
Give Back 3
Level 2
elisag19795522
Level 2

Likes

2 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
Boost 1
View profile
elisag19795522
- Adobe Campaign Standard
Hi,When doing that, I get the following errors:21/11/2019 16:37:44query1WDB-200001 SQL statement 'INSERT INTO wkf61230670_1_1 (iId) SELECT DISTINCT N0.iRecipientId FROM NmsRecipient N0 WHERE ( EXISTS (SELECT 1 FROM NmsBroadLogAppSubRcp N1 WHERE (N1.iProfileId = N0.iRecipientId) AND ((((N1.iStatus = 1) AND (N1.tsEvent >= DaysAgo(180) AND N1.tsEvent < GetDate())) AND ))) OR EXISTS (SELECT 1 FROM NmsBroadLogRcp N1 WHERE (N1.iProfileId = N0.iRecipientId) AND ((((N1.iStatus = 1) AND (N1.tsEvent >= Da...

Views

898

Likes

0

Replies

0
Excluding non engaged subscribers from email delivery
Avatar
Give Back 3
Level 2
elisag19795522
Level 2

Likes

2 likes

Total Posts

4 posts

Correct reply

1 solution
Top badges earned
Give Back 3
Give Back
Ignite 1
Validate 1
Boost 1
View profile
elisag19795522
- Adobe Campaign Standard
Hello,I want to send a delivery excluding everyone who has not opened an email in the last 180 days. When adding into a query the delivery, it only allows me to select deliveries one by one, I cannot select all, nor I can select a date range.What is the easiest way to achieve this?Thanks,

Views

3.0K

Like

1

Replies

6
Likes from