Antworten per E-Mail in Berichten

[zcuric (Zdravko)]

Hi, is it possible to have in reports how many users have used email to reply to topic?

[T_Disco (T)]

Hallo Zdravko,

Könnte das von Nutzen sein?

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…