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.
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?