Expand my Community achievements bar.

The 5th edition of the Campaign Community Lens newsletter is out now!
SOLVED

Adobe reporting for Hard / Soft Bounces

Avatar

Level 2

Basically what tables do I need to refer. Since I have my custom MTA, so picking up those logs and what tables to dump?

 

broadlogrcp - Delivery success / failure

 

Instead of going via import work-flow route, I manually inserted new entry in nmsbroadlogmsg table with mailbox full error against soft bounce event code, based on msgId, inserted similar kind of record in nmsbroadlogrcp with other details like success / failure and deliveryID. Now my expectation was in the background Adobe's job would insert the related entries in nmsdeliverylogstats but that wasn't the case, as a result UI didn't had the related reporting. Could anyone please suggest where am I going wrong and my understanding with the flow is correct? I did vice versa as well... like inserting first in nmsbroadlogrcp followed by nmsbroadlogmsg, but didn't succeed.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

 

Run nms.delivery.RecomputeStats() on the delivery id's you're importing.

Also make sure to upsert nms:address with the hard bounces.

 

Thanks,

-Jon

1 Reply

Avatar

Correct answer by
Community Advisor

Hi,

 

Run nms.delivery.RecomputeStats() on the delivery id's you're importing.

Also make sure to upsert nms:address with the hard bounces.

 

Thanks,

-Jon