16. How to check on how many mails, in TOTAL, are being sent on a day/week/month

Question

Can we check how many emails, in TOTAL, are being sent on a day/week/month?

Answer

You can check how many emails are being sent in total per day, week, or month using the SQL report in our extension Report and dashboard.

It will give counts per year/month/day, but you need to pick which one you want by - see lines 2,3,4.

SELECT
-- DATE_FORMAT(c.createdtime,'%Y') as dt, /* Count per Year */
-- DATE_FORMAT(c.createdtime,'%Y-%m') AS dt, /* Count per Month */
DATE_FORMAT(c.createdtime,'%Y-%m-%d') AS dt, /* Count per Day */
COUNT(*) num
FROM vtiger_crmentity c
INNER JOIN vtiger_activity a ON a.activityid=c.crmid
INNER JOIN vtiger_emaildetails e ON e.emailid=c.crmid
WHERE c.deleted='0'
AND c.setype='Emails'
AND c.createdtime > '2024-01-01 00:00:00'
GROUP BY dt
ORDER BY dt DESC;

Extension	Reports & Dashboard
Description	How to check/track/report on how many emails, in TOTAL, are being sent on a day/week/month
Created By	Chris (Jan 16, 2025)