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.– JagularCommented Dec 9, 2014 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'– JeffreyCommented Dec 9, 2014 at 16:46
-
this is a query within the BU. but i end up getting everyone at the Enterprise level.– JeffreyCommented Dec 9, 2014 at 16:46
Add a comment
|
1 Answer
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.
