Ricardo Malla's Blog

Some emails are parsed, while others are not. It depends on the format of the email. Here are some highlights: Files of interest: /app/bundles/EmailBundle/MonitoredEmail/Processor/Bounce/DsnParser.php /app/bundles/EmailBundle/MonitoredEmail/Mailbox.php: /app/bundles/EmailBundle/MonitoredEmail/Processor/Bounce.php The process as I understand it is the following: Step 1.  On Mailbox.php you define what emails are considered for un-subscription. The default criteria es UNSEEN, which the process […]

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

root@ubuntu:~# php /var/www/mautic/app/console cache:clear Note that after clearing Cache the App is Stuck because there is a Permissions problem (Mautic cannot write the Cache Folder) so you need to chmod -R 777 cache folder (this is insecure but works). You need to use the appropriate permissions based on your requirements.

https://www.mautic.org/docs/en/setup/cron_jobs.html    

  If there are contacts on the campaign you will not be able to delete it, so you have to do it Manually.     DELETE campaign_leads FROM campaign_leads WHERE campaign_id = “THE CAMPIGN ID YOU WANT TO DELETE”; DELETE campaign_lead_event_log FROM campaign_lead_event_log WHERE campaign_id = “THE CAMPIGN ID YOU WANT TO DELETE”;