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

SOLVED

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

jameels50927727
Level 2
Level 2

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

1 Accepted Solution
Amit_Kumar
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

3 Replies
Amit_Kumar
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

jameels50927727
Level 2
Level 2

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

Amit_Kumar
Community Advisor
Community Advisor

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