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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

SMS Delivery data summary

Avatar

Level 3

Hi, I am trying to understand why approximately one third of the messages are marked with "number of processed records=0" (in the nms:deliveryLogStats table). There are 40 duplicate telephone numbers that are removed. I am quite sure that all the 15k messages has been sent, since the logs of our SMS service provider says so. What script could be triggering the insertion of zero-values?

 

Delivery overview:

lukkyluke_0-1593165283788.png

deliveryLogStats where number of processed records=1:

lukkyluke_0-1593171040116.png

deliveryLogStats where number of processed records=0:

lukkyluke_1-1593171091220.png

 

Capture.PNG
 

Thanks in advance!

 

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @lukkyluke you can try going to the delivery in the delivery folder, right-click, Actions -> Recompute delivery and tracking indicators. I have seen SMS campaigns get out of whack with stats after a while and this seems to fix it.

Cheers Darren

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi @lukkyluke you can try going to the delivery in the delivery folder, right-click, Actions -> Recompute delivery and tracking indicators. I have seen SMS campaigns get out of whack with stats after a while and this seems to fix it.

Cheers Darren

Avatar

Level 3

Thank you so much, that worked! 🙂 @Darren_Bowers