background shape
background shape

Data views for transactional emails

Data views in Salesforce Marketing Cloud are very handy, when it comes to getting data insights from various sources inside the platform.

I will give you a quick start on how to get data insights for you transactional emails using data views. We will use data from _Sent, _Job, and _Subscriber view

SELECT top 100
s.SubscriberKey,
s.TriggererSendDefinitionObjectID,
s.TriggeredSendCustomerKey,
s.EventDate,
j.DeliveredTime,
j.PickupTime,
j.SchedTime,
s.ListID,
s.JobID,
sk.EmailAddress,
j.EmailName,
from
_Sent s
left join _Subscribers sk ON s.SubscriberKey = sk.SubscriberKey
left join _Job j ON s.JobID = j.JobID

where ListID = 708
order by j.DeliveredTime DESC
s.TriggererSendDefinitionObjectID - object id (auto generated)
s.TriggeredSendCustomerKey - definition key (you choose)
s.EventDate - date when the first message has been triggered for a particular day
j.DeliveredTime - date when the message was actually delivered to recipient
j.PickupTime - when the message was picked up by currently running job
j.SchedTime - when the job scheduled the message
s.ListID - list where you add all who you sent transactional email 

Good to know

Use one publication list for all transactional messages. so when you will come to reduce your contacts you can remove the contacts only ever targeted in transactional messages

There is actual delay from when you send the transactional message and when it is actually written to the _Sent view

Oh hi there 👋
I have a FREE e-book for you.

Sign up now to get an in-depth analysis of Adobe and Salesforce Marketing Clouds!

We don’t spam! Read our privacy policy for more info.

Share With Others

Leave a Comment

Your email address will not be published. Required fields are marked *

MarTech consultant

Marcel Szimonisz

Marcel Szimonisz

I specialize in solving problems, automating processes, and driving innovation through major marketing automation platforms.

Buy me a coffee