We're trying to find the number of subscribers who are marked as "ACTIVE" in a Data Extension. Seems simple enough, right?
Here's our SQL
SELECT a.Email From [Newsletter List] a JOIN _ListSubscribers b ON a.email = b.subscriberkey WHERE Status = 'active'
But, when we run it the number is WAY too low (700K out of 1.1MM).
I know that's low because we sent email to 1MM names just this week.
The DE is part of a child BU. No email is sent from the parent BU.
Does this impact the query? What are we missing here?