Emails with 'Completed' status

Salesforce Marketing Cloud


Salesforce Marketing Cloud (formerly, ExactTarget) is a provider of digital marketing automation and analytics software and services.

Emails with 'Completed' status

Query Text

SELECT Send.ID, Send.CreatedDate, Send.SendDate, Send.SentDate, Send.FromAddress, Send.FromName, Send_Email.CreatedDate AS "Email CreatedDate", Send.EmailName, Send.Subject, Send.Status AS "Send Status", Send_Email.Status AS "Email Status"
  FROM Send
LEFT OUTER JOIN Email AS Send_Email ON Send.Email_ID = Send_Email.ID
WHERE (Send.Status IN ('Complete') AND Send.SentDate IS NOT NULL AND date(date(Send.CreatedDate), 'start of month') = date('now', 'localtime', 'start of month', '-1 month'))
ORDER BY Send.SendDate

Open Query