I am trying to query all the subscriber from a child business unit who joined during a specific time frame.
Here's my SQL below
Select s.SubscriberKey, s.EmailAddress, s.DateJoined from [_Subscribers] s where DateJoined between '2019-12-01' and '2019-12-31'
When I run this query above, the output I got was really a smaller number.
Total subscriber count I got was 12K, whereas the actual numbers should be somewhere around 300K. Something is wrong, but not sure what it is! Can someone help me with this?