[SalesForce] Delete all Contacts – Export all Contacts

The problem:
We want to reset our contact database
==> we have to delete all contacts.
Unfortunately that does not work as intended with the relatively new deletion tool of salesforce.

To achieve this i created an SQL-Activity on the _Subscribers list that exports them into a sendable data extension. But the numbers between AllSubscribers and All Contacts differs by around 2000 Contacts at our side.

I then deleted all Contacts that were in the Sendable DataExtension of Salesforce. The Result is that i have 2000 Contacts still in All Contacts that i cannot delete because i do not find any solution to select all of them.

All of the contacts look like this:
Contacts that could not be deleted

And when you try to manually delete subscribers you can only delete ONE contact at a time. Doing this 2000 times is not what i want to do, rather i do wanna use an API atm.

Is there a table/structure/data_view that i could query through a SQL-Activity which can return All Contacts? I did not find any model that represents all Contacts in Salesforce Marketing Cloud.

Does anybody have a solution to this case?

Best Answer

Problem was the implementation of salesforce. We got orphaned subscribers where only the backend team of salesforce was able to delete them.

Related Topic