We're making some use of suppression lists and I'm finding that although they seem to live in _ListSubscribers I'm not getting query results when writing SQL to query their ID or Name. Attached is a couple sample queries. What am I missing?
SELECT * FROM _listsubscribers WHERE 1=1 AND ListID = ''
SELECT * FROM _listsubscribers WHERE 1=1 AND ListName = 'My great suppression list'
Data Extension is a carbon copy of _listsubscribers and is formatted as follows:
AddedBy / Number AddMethod / Text / 17 CreatedDate / Date (Nullable) DateUnsubscribed / Date (Nullable) ListID / Number (Nullable) ListName / Text / 50 (Nullable) ListType / Text / 16 (Nullable) Status / Text / 12 (Nullable) SubscriberID / Number (Nullable) SubscriberKey / Text / 254 SubscriberType / Text / 100 (Nullable)
I've also read the documentation and they recommend a slightly different query and DE, listed below, still no results.
SELECT SubscriberKey, EmailAddress, ListName, ListType, Status, CreatedDate AS DateAdded, DateUnsubscribed FROM _ListSubscribers WHERE 1=1 AND ListName = 'My great suppression list'
SubscriberKey / Text / 255 (Key) EmailAddress / EmailAddress / 254 ListName / Text / 100 ListType / Text / 50 (Nullable) Status / Text / 25 DateAdded / Date DateUnsubscribed / Date (Nullable)