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.
eventstable will have the following structure.
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;