보고서에서 이메일로 답변하기

[T_Disco (T)]

Hi Zdravko,

This might be of use?

Email statistics

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…