Mautic

Mautic: Helpful Queries to Audit your System

 

To  check how many emails are triggered and sent for your campaigns Today.

SELECT
leads.id,
leads.email,
leads.company,
leads.custom_mkt_drip,
campaign_lead_event_log.*

FROM
campaign_lead_event_log
left join leads on campaign_lead_event_log.lead_id = leads.id
left join email_stats ON leads.email = email_stats.email_address

WHERE
DATE(date_triggered) = DATE(NOW())
AND campaign_lead_event_log.is_scheduled = 0
AND campaign_lead_event_log.channel = “email”
AND metadata NOT LIKE “%failed%”

ORDER BY campaign_lead_event_log.date_triggered DESC

 

Leave a Reply

Your email address will not be published. Required fields are marked *