To find the total number of soft bounces of a delivery (not the percentage)

Question

I have been told to apply the query to count the total no. of soft bounces of a delivery or the campaign. And I have to use the field's available in nms: delivery schema. Can anyone suggest me how to do this?
And also explain me on which field I need to apply query and what...

saurabh99 · Accepted Answer

Hii @shubham_goyal__ and @sukrity_wadhwa ,

Thanks both of you. I have solved this query.

Invalid domains and Mailbox full are the fields which are purely soft bounces. So, I took both of them from indicators in nms:deliveries

and then add them by creating expression in Add data.

Thanks again😌

Shubham_Goyal__ · Answer

Hi @saurabh99,

To my knowledge, there is no such column or table in Adobe campaign that stores the information on the 'number of bounces - soft/hard' received for a particular delivery.
It is because as per design the feedback on the status of each email reported from ISPs is captured directly from the MTA.

Now, when soft-bouncing messages get reported back from the MTA, their log status remains unchanged (taken into account by the service provider): only the error reason is updated in the Adobe campaign and the Success percentage also remains unchanged. Soft-bouncing messages are then retried throughout the delivery validity period set in Delivery Properties.
So, the only information that you can find from the Adobe campaign is the number of recipients that were marked as 'Quarantine' in a particular delivery from nms:address schema. link

Br,

Shubham

Sign up

Login with SSO

Login to the community

Login with SSO