Mautic

Mautic: Clear Bounces not working correctly

Posted on

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

Mautic

Mautic: Helpful Queries to Audit your System

Posted on

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

Mautic

Mautic: Clear Cache from Application

Posted on

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.

Mautic

Mautic: Cannot Delete Campaign

Posted on

  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”;