I would like to retrieve All Subscriber from a List where the Add Method is 'Import'.
I tryed do a query like this:
SELECT * FROM _ListSubscribers WHERE ListID = 2677 AND addMethod = 'Import'
But I retrieved nothing.
If I try to get All Subscriber where Status is active it works and i got a result.
SELECT * FROM _ListSubscribers WHERE ListID = 2677 AND status = 'active'
This seems like a basic query. What I doing wrong? Or one could give me suggestions to get the result on another way?