Message center - Transactional Message deliveries

[ckumari12]

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.

[florentlb · Accepted solution]

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