I've created a SQL query to get me all unsubscribed contacts, but is there a query I can write to get all contacts without an email address into one data extension? There isn't a data view for contacts that I can find and all subscribers inherently have email addresses. Any thoughts?

1 Answer 1


This help page has the best information 'Permanently remove Contacts or Subscribers and associated data from Contact Builder'

In MobileConnect or MobilePush, create a filtered mobile list that meets 4 conditions:

Contact Key is not null AND Email Address is null AND Mobile Number is null AND Device ID is null ​

Note: This is sourced from these attribute paths:

System Data | Contact | Contact Key

System Data | Email Addresses | Email Address

MobileConnect Data | MobileConnect Demographics | Mobile Number

MobilePush Data | MobilePush Demographics | Device ID

This provides every record that does not belong to any channel (Contact Key with no source in All Contacts). Follow the below only if you need to review your data. Otherwise you can delete Mobile Filtered Lists using Contacts Delete.

  • Thank you, I was able to delete the records without email addresses/subkeys from the synchronized. Do you know how I would capture the other contacts without email address that are not from the synhcronized? Jun 18, 2019 at 19:49

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .