Why so many outgoing emails?

[meglio (Anton)]

Hi, @SidV, learn your email statistics with using this query for data explorer:

Email statistics (SQL script for Data Explorer)

I run into 100k / mo emails limit of a free SparkPost account. To better understand what type of email exactly I have to tackle, I had to write an SQL query which calculates email statistics by email type. Sharing it with the community. Example result: [image] SQL query -- [params] -- string :date_interval = 1 month WITH stats AS ( SELECT email_type, COUNT(id) as num FROM email_logs WHERE created_at >= CURRENT_TIMESTAMP - interval :date_interval GROUP BY email_type ) SELEC…