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



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.

Mandrill Transactional Email Events
The Mandrill events table will have the following structure.

Mandrill Data ModelOutput

Transactional Emails Total Number Sent with Mandrill

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)  
  (SELECT event,
          date_trunc('day', to_timestamp(ts)) AS date
   FROM events_
   WHERE event = 'send') t;

in Transactional Emails