Skip to content

Instantly share code, notes, and snippets.

@marketingclouded

marketingclouded/Overwrites Email_Performance_Sched w _Sent and _Job Info

Created September 23, 2020 20:29
Show Gist options
  • Save marketingclouded/9c49eebe96b37bc77d393921fc9b218a to your computer and use it in GitHub Desktop.
Save marketingclouded/9c49eebe96b37bc77d393921fc9b218a to your computer and use it in GitHub Desktop.
Download ZIP
Tracking Email Performance in SFMC: Overwrites Email_Performance_Sched w _Sent and _Job Info
Raw
Overwrites Email_Performance_Sched w _Sent and _Job Info
SELECT TOP 9223372036854775807
e.EmailName,
e.SchedTime AS 'SentTime',
e.JobID,
COUNT(d.JobID) AS 'Sent'
FROM _Job e
JOIN _Sent d
ON d.JobId = e.JobId
WHERE e.TriggererSendDefinitionObjectID IS NULL
GROUP BY e.EmailName, e.SchedTime, e.JobId
HAVING e.JobID != '' AND COUNT(d.JobId) > 10
ORDER BY e.SchedTime DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment