Mandrill – Transactional Emails Total Number Sent (per day)

Question

What is the total number of Transactional Emails sent per day?

Schema

Blendo will sync all of your transactional email Mandrill data into your data warehouse properly re-modeled for it and ready to be used for your analytics purposes.

Output

Total Number of Mandrill Transactional Emails Sent (per day)

SQL Query

Mandrill Total Number of Transactional Emails Sent (per day)

SELECT DISTINCT date, count(event) over (partition BY date)  
FROM  
  (SELECT event,
          date_trunc('day', to_timestamp(ts)) AS date
   FROM events_
   WHERE event = 'send') t;