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 ?
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.
You may find it on NmsDeliveryLogStats table or use Broadcast statistics report.