how to automatically blacklist unsubscribed emails on interspire email marketer

Reading Time: < 1 minute

Simply create a trigger which will insert unsubscribed users in the blacklist after every update on the subscriber table.

FOR EACH ROW INSERT IGNORE INTO ya_banned_emails 
(emailaddress, list, bandate)
SELECT emailaddress, ‘g’, UNIX_TIMESTAMP( ) 
FROM iem_list_subscribers
WHERE unsubscribed != ‘0’;
Reading Time: < 1 minute

Simply create a trigger which will insert unsubscribed users in the blacklist after every update on the subscriber table.

CREATE TRIGGER `banned_email` AFTER UPDATE ON `iem_list_subscribers` 
FOR EACH ROW INSERT IGNORE INTO ya_banned_emails 
(emailaddress, list, bandate)
SELECT emailaddress, ‘g’, UNIX_TIMESTAMP( ) 
FROM iem_list_subscribers
WHERE unsubscribed != ‘0’;

By Marc Olivier Meunier

Marc has spent the past 7 years putting oil on the fire of a hyper growth ad tech company. At Smartly.io he was in charge of scaling the support and its culture. He leads by example and puts a lot of emphasis on diversity and inclusion, constantly working to create a safe environment. A warm leader with a passion for memorable experiences and innovation.
Find me on Linkedin

Leave a Reply

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