Hello together,
one of our customers is currently trying to identify Contacts in All Contacts that qualify for deletion. In order to get an overview of all contacts (and not only subscribers), we created a Mobile List in Contact Builder (using MobileConnect) with one condition (ContactKey is not null) and then queried the list for further analysis (as described by @Rafał Wolsztyniak on stackexchange). So far, so good.
Now I'd like to know if there's an easy way to pre-filter Contacts based on the Business Unit they're related to (if any)? We specified the MID for "Business Unit ID" (System Data > Contact > ... ) as an attribute filter in the Mobile List to narrow it down, but this does not return any result, meaning we get an empty list (although we do know that "Business Unit ID" is not empty when we filter for "BU ID is not null").
So, when MID is obviously not working, which value do we need to specify as "Business Unit ID"? Any other ideas on how to filter Contacts based on BU? Thanks in advance! #Marketing Cloud
Hi Ramon,
By default, All Contacts are assigned Top-Level MID for the 'Business Unit MID' attribute, irrespective of the Business Unit they reside in and the deletion only takes place at the Top-level.
If you try the condition Business Unit MID = 'Top-Level MID' in any BU, it would pull all the records (i.e., Top-level + Child BU), and in the case of Business Unit MID = 'Child MID' it would return empty.
In order to filter the contacts at a BU level, create a list and use Email Demographics(contactsID) / Mobile Demographics(contactID) where ID is not NULL. If needed, pull the records from this list using query and place them in a Data Extension.
You can also try to filter the contacts using the queries as Pablo mentioned.
