Bounce counts | Community
Skip to main content
R
Ramaswami
Level 4
July 2, 2020
Solved

Bounce counts

  • July 2, 2020
  • 1 reply
  • 2260 views

Hi Team, 

I have a couple of questions about the open,email clicks, opt-out and email bounces. : 

 

question 1 : through delivery parameters we can see the metrics like opens, email clicks, opt-out, reactivity rate etc., for a delivery. So these metrics are for whole delivery 

for example : if i have a delivery - "delivery A" which was been running through a campaign from Jan - May 2020 is there a way through which i can filter the counts of open, email clicks, opt-outs by months like "delivery A" for month of Jan how many opens/clicks/opt-outs, for the month of Feb how many opens/clicks/opt-outs and so on... i didn't found from and to dates on delivery table. So alternatively i am pulling all the tracking logs and filtering by month ( is it the only way to do it>)

 

question 2: i found open, opt-outs, email clicks parameters on delivery table but there is no bounce rate or bounce count on delivery table. Where can i see the bounce count on a delivery ?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Milan_Vucetic

Hi @ramaswami 

  1.  We cannot have everything in delivery table this is why database normalization exists. Tracking information is in tracking table so you have to join tables and use result.You can make your own cube/report and make month filter and just change it in fronted while join works in background.
  2. You may find it on NmsDeliveryLogStats table or use Broadcast statistics report.
    • iUnknownUser  -> Hard bounce
    • iUnreachable + iMailBoxFull + iInvalidDomain + iDisabled + iNotConnected + iRefused -> Soft bounce

Regards, Milan

1 reply

Milan_Vucetic
Milan_VuceticAccepted solution
Level 9
July 3, 2020

Hi @ramaswami 

  1.  We cannot have everything in delivery table this is why database normalization exists. Tracking information is in tracking table so you have to join tables and use result.You can make your own cube/report and make month filter and just change it in fronted while join works in background.
  2. You may find it on NmsDeliveryLogStats table or use Broadcast statistics report.
    • iUnknownUser  -> Hard bounce
    • iUnreachable + iMailBoxFull + iInvalidDomain + iDisabled + iNotConnected + iRefused -> Soft bounce

Regards, Milan

R
RamaswamiAuthor
Level 4
July 6, 2020

Hi @2897273,

 

i have checked "NmsDeliveryLogStats" which is under campaign management and i can see the number of occurences and type of failure there and created date, modified date. 

 

How can i query BroadlogRCP or TrackinglogRCP or Delivery table with NmsDeliveryLogStats to see the count of bounces per month or for particular date. Can you please provide an example query with joins. 

Terms & ConditionsAccessibility statement

Loading footer...