2

We want to delete all subscriber records from "All Subscribers" which are not "Unsubscribed" or "Bounced" and created before last six months. How can we do it using automation studio?

  • Do you want to remove them only from All Subscribers, or entirely from Marketing Cloud? – Lukas Lunow May 9 at 19:39
  • Thank you Lukas Lunow for your response. We want to remove entirely from Marketing Cloud – SFMC User May 9 at 20:19
6

First, you need to create a sendable data extension, which at least should contain your subscriber key. This will be populated by querying Subscribers Data View, with your criteria defined in the SQL Query. Based on your use case, you should filter on fields: DateJoined and Status.

Once you have found the subscribers you want to delete, you can use the Contact Deletion Framework, which will remove the subscribers across your SFMC. This approach can be automated with SSJS/Script Activity in Automation Studio, as I provide an example of in this thread: Marketing Cloud SSJS: trying to automate contact deletion - which utilises DeleteByListReference endpoint. This SSJS should reference the above data extension, deleting contacts listed within.

  • 1
    Thank you Lukas Lunow for details. Very helpful details. Thank you again – SFMC User May 10 at 16:05
  • You’re welcome. Remember to mark the answer as accepted if it was helpful – Lukas Lunow May 11 at 11:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.