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.
Solved! Go to Solution.
Views
Replies
Total Likes
Hi,
In the nms:delivery schema, you have the @created field that refers to the creation date of the delivery, and the @messageType (channel) which indicates the name of the channel (email, direct mail).
Florent
Hi,
In the nms:delivery schema, you have the @created field that refers to the creation date of the delivery, and the @messageType (channel) which indicates the name of the channel (email, direct mail).
Florent