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

    from [_Subscribers] s
    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?

  • You should be querying ent._subscribers
    – EazyE
    Feb 12 '20 at 23:40
  • Thanks for your response I already tried the query with 'ENT.', but I got an error that "ENT._subscribers" is not a valid system data extension.
    – Siva
    Feb 13 '20 at 0:12
  • Do you not have a view of the subscribers/contacts in a DE you normally send to for that BU? By default, there is no easy way to retrieve subscribers in BU level, hence custom solution is required. If you do have subscribers in a master DE you could then join with ENT._subscribers to get the lastjoined date and get those sub counts. Feb 13 '20 at 0:27
  • Did you have subscribers in brackets? If so remove the brackets
    – EazyE
    Feb 13 '20 at 0:43
  • How do you 'link' these subscribers to this child BU? Couldnt it be that the first engagement with them occurs from the parent BU?
    – SebOB
    Feb 14 '20 at 8:30

Use _Listsubscribers this will work

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.