Ricardo Malla's Blog

  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 […]

I’m using a custom field as the filter, and when I rebuild the campaign, the lead shows manually_removed on the campaign_lead table. This would make sense if you manually removed a lead (from the website) so you do not want it to be re-added to a specific campaign, but it does not make sense the […]

Cleaning the DB depends on your use case. In our company this will work, as we want to keep the DB small and organized, and have a bunch of manual integrations between multiple systems and this Mautic instance. We specifically do not want to truncate the email_stats table, as this table has a record of […]

Relevant Tables: audit_log email_stats

  The BodyParser.php did not work as AmazonSES’s bounces report the Bounces through DSN.   I had to edit the DsnParser.php and add this line: elseif (preg_match(‘/Action: Failed/i’, $dsnReport)) { #echo “\n\ntest1\n\n”; $result[‘rule_cat’] = Category::INACTIVE; $result[‘rule_no’] = ‘0106’; }