No way to see the valid or invalid subscribers in a list
Opened this issue · 0 comments
pokhiii commented
The numbers can be clickable that takes the user to the list of valid/invalid subscribers.
I used the following sql query to get the list of invalid subscribers for a list
SELECT b.email
FROM list_subscriber a
LEFT JOIN subscribers b ON a.subscriber_id = b.id
WHERE a.list_id = <list_id>
AND b.has_verified_email = 0;