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

How to query the soft bounce emails the emails that emails are soft bounced 3 or more times .

Avatar

Avatar
Validate 1
Level 2
jameels50927727
Level 2

Likes

3 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
jameels50927727
Level 2

Likes

3 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
jameels50927727
Level 2

15-05-2017

Hi,

  How to query the soft bounce emails the emails that emails are soft bounced 3 or more times . Please any one help me .

 

 

Thanks & regards,

jameel.sk

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

15-05-2017

Hi Jameel,

this can be computed as follows:

softBounce =  @unreachable + @mailBoxFull + @invalidDomain + @disabled + @notConnected + @refused

from nms:deliveryLogStats) this is also computed weekly in "Delivery weekly reporting" as softBounce.

if this value exceed 3 than you got what you want. 

Regards,

Amit

Answers (2)

Answers (2)

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

16-05-2017

Here you go:

This is already available in a computed field in nms:deliveryLogStats  schema even if you want to compute your own using workflow you can refer to following workflow:

<package author="Amit (amit)" buildDate="2017-05-16 06:58:52.848Z" buildNumber="8724" buildVersion="6.1"> <entities schema="xtk:workflow"> <workflow form="xtk:workflow" internalName="WKF755" label="test for soft bounces" modelName="newWorkflow" scenario-cs="Notification of the workflow supervisor (notifySupervisor)" schema="nms:recipient" simulation="false"> <activities> <query label="soft bounces greater than 3" name="query" recipientLink="" schema="nms:deliveryLogStats" x="347" y="79"> <transitions> <result name="result"/> </transitions> <select> <node alias="@softBounced" expr="ToInteger( @unreachable + @mailBoxFull + @invalidDomain + @disabled + @notConnected + @refused)" label="ToInteger(unreachable + inbox full + invalid domain + disabled account + not connected + rejected)"/> </select> <where filterName="backGroundFilterFrm" filteringSchema="nms:deliveryLogStats"> <condition expr="@softBounce &gt; 3" internalId="2713911315"/> </where> <outputFilter> <condition expr="@softBounced &gt; 3" internalId="2708340751"/> </outputFilter> <humanCond>Query: soft bounces greater than 3</humanCond> </query> </activities> <variables/> <scenario _operation="none" internalName="notifySupervisor"/> <desc>Empty template to create a new workflow</desc> <folder _operation="none" name="Folder97"/> </workflow> </entities> </package>

Hope this helps,

Regards,

Amit

Avatar

Avatar
Validate 1
Level 2
jameels50927727
Level 2

Likes

3 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
jameels50927727
Level 2

Likes

3 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
View profile
jameels50927727
Level 2

15-05-2017

Hi Amit_kumar,

     Thank you so much for valuable information.If you have please share screen short regarding soft bounced emails 3 or more times query.

 

 

Thanks & regards

jameel.sk