How many emails have been sent from your accounts

Salesforce Marketing Cloud

 

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

How many emails have been sent from your accounts. This query can be run for any time frame, present or past

Query Text

SELECT strftime('%Y-%m', t."EventDate") AS "Event Month", COUNT(*) AS "Count"
  FROM SentEvent AS t
WHERE (date(date(t."EventDate"), 'start of year') = date('now', 'localtime', 'start of year', '-1 year'))
GROUP BY strftime('%Y-%m', t."EventDate")
  

Open Query