I need help to build a query.

We have over forty BU's and we use DE's. We want to have better visibility before we send the the email as who will receive the email. We have unsubscribes by BU but HELD status is at the ENT level.

  • Please show us what you have for a query currently.
    – Jagular
    Dec 9 '14 at 16:32
  • SELECT A.EmailAddress, S.Status FROM [SubscriberProfile] as A INNER JOIN _Subscribers as S ON A.EmailAddress = S.EmailAddress Where S.Status = 'held'
    – Jeffrey
    Dec 9 '14 at 16:46
  • this is a query within the BU. but i end up getting everyone at the Enterprise level.
    – Jeffrey
    Dec 9 '14 at 16:46

Unfortunately the _subscribers view is for all subscribers across the enterprise account. There is not currently a way to restrict that view to just the BU.

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.