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