Expand my Community achievements bar.

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
Level 9

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
Level 9

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