4

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?

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

1 Answer 1

Reset to default
9

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.

Improve this answer
1
  • 1
    Thank you Lukas Lunow for details. Very helpful details. Thank you again
    – SFMC User
    Commented May 10, 2019 at 16:05

You must log in to answer this question.

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