ColoredCow/campaigns

No way to see the valid or invalid subscribers in a list

Opened this issue · 0 comments

The numbers can be clickable that takes the user to the list of valid/invalid subscribers.
image

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;