Please suggest if there is any way to get subscribers list business unit wise without actually going to each BU as we have over 50 BU.


Subscribers actually live at the parent business unit level, for all child BUs. From the Parent Business Unit, you can apply 'Business Unit Filters' to segment the All Subscriber list so a subset of subscribers may appear in the child BU level.

If you are wanting to build a list of subscribers per BU, then you could select from _Subscribers and replicate the same BU Filter criteria to build you counts for each child BU

  • How would you apply the business unit filter to the _Subscribers system data view? – Travis Naughton Oct 24 '18 at 6:39
  • Go to Admin > Business Units and select (tick) and business unit and click 'Define Business Unit Filter' where you will then see what filters are being applied for the same BU. Take note of the logic - it will work from Profile Attributed of your system. From there, you will built a SQL to select from _Subscriberd and hopefully be able to apply the same selection criteria – Gravitai Oct 24 '18 at 6:43

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.