Solved
Message center - Transactional Message deliveries
I have a requirement to create a report on the transactional messages getting sent. We have multiple templates. I am querying in Control instance.
| Header 1 | Header 2 | Header 3 | Header 4 | Header 5 | Header 6 | Header 7 | Header 8 | Header 9 | Header 10 | Header 11 |
|---|---|---|---|---|---|---|---|---|---|---|
| DAY 1 | Day 2 | |||||||||
| Template name | Sent | Open | Click | Open Rate | Click Rate | Sent | Open | Click | Open Rate | Click Rate |
| Template 1 | ||||||||||
| Template 2 | ||||||||||
| Template 3 | ||||||||||
| Total | ||||||||||
I have another query, how we differentiate standard delivery with transactional message delivery? Also, what field in nms delivery data schema has the information of the delivery creation date ? It doesn't have contact/analysis date. Last modified date is also not helpful. Delivery in control instance is weekly created for one template.
.png){kind=icon}