AllContacts System Data View

Use this article if you're trying to delete contacts.

Use this article if you're trying to delete hidden managed list contacts . 

Use mobile filtered list feature to create a filtered list of All Contacts in your account.

1. Navigate to Contact Builder > All Contacts
2. Go to 'Mobile Lists' tab
3. Click 'Create Mobile List' button at the top right corner
4. Select 'MobileConnect' in 'Channel' drop-down if not selected already
5. Under 'Specify the method by which the List will be built', select 'Filtered List' radio button
6. On the next screen 'Select a Population', select the 'All Contacts' list
7. Click 'Select'
8. In the 'Filter Criteria' section, remove the existing filter by clicking on the x option
9. On the left sidebar under 'Attribute Groups', select 'Contact Key' attribute from System Data > Contact and double-click or drag and drop it to the Filter Criteria section on the right.
10. Set the filter condition as 'Contact Key is not null'.
11. Click 'Done' and 'Save as Filter'
12. Enter a name for the filtered list and click 'Save'

Please allow the operation to complete and once done, you will have a list of All Contacts in your Marketing Cloud account. 

Once the filtered list is in place, we can query the contact keys into a data extension using a SQL Query. (Please note that although there are other fields visible in the UI when viewing the filtered list, the only field that can be queried is SubscriberKey.)

1. First we need to create a new DE with one field titled SubscriberKey, make this field a Primary Key. Make the DE sendable.
2. In Automation Studio, create an SQL query to fetch records from the filtered list that resembles the below:
   select subscriberkey
from [name of MobileConnect/MobilePush filtered list name]

3. For the target Object, select the newly created DE. Save it, then place it in an Automation and run the Automation once to populate the DE.

The SubscriberKey column in the DE contains the Contact Key values seen in 'All Contacts' list in Contact Builder.

For any other use cases oriented around data available via the data view, we advise consultation with Marketing Cloud Global Support .

Some use cases can be achieved via use of alternate functionality available in the Marketing Cloud account. Other use cases may be best pursued via creation of a custom system data view as part of a scoped Statement of Work for the Marketing Cloud Success and Services teams.