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

[T_Disco (T)]

즈드라브코, 안녕하세요.

이 정보가 도움이 될지도 모르겠네요.

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…