Loading
ただいま大変多くのお問い合わせをいただいており、ご連絡までにお時間を頂戴しております続きを読む

Find and Delete Soft-Deleted Email Studio Contacts

公開日: Nov 17, 2022
説明
By following the steps outlined in Delete a Subscriber from Marketing Cloud, subscribers can be soft-deleted from Email Studio Lists. When this soft-delete happens, they stop showing up in All Subscribers, tracking extracts, or data views. However, these contacts still show up in All Contacts as Unspecified. They can be found by using filtered Mobile Lists and a SQL query targeting data views. They do not currently show up in the Contacts Without Channel Address Extract.
解決策

Find All Subscribers on the All Subscribers List

  • Navigate to Contact Builder | All Contacts
  • Click the "Mobile Lists" tab
  • Click Create Mobile List
  • Select the MobileConnect channel. NOTE: You do not need to have a Mobile Channel to create Mobile Filtered lists
  • Select "Filtered List" and Click OK
  • If the option presents itself, select All Contacts as your source. If no option presents itself, you should be brought to a filter screen
  • Delete whatever default criteria is added to the filter
  • On the Attribute Groups drawer, select System Data | Email Addresses | Email Address
  • Drag Email Address onto the filter criteria screen and configure it to read Email Address is not null
  • Click "Save as Filter"
  • Name it "AllEmailAddresses" leave the format as Standard, and Click Save
  • This will return every subscriber on the All Subscribers list regardless of status

Create a Data Extension to Query Results into

In order to find all soft-deleted subscribers, you will need to write a SQL query. Before this can happen, we need to create a Data Extension to hold the SQL Query Results.
  • Go to Contact Builder | Data Extensions | Create
  • Name it
  • Make it sendable if you plan to use Contact Delete | Next | Next
  • Create a field called "Subscriberkey"
  • Ensure this field is at least 254 characters long | Click Complete

 

Create and Execute SQL Query to find soft-deleted Subscribers

  • Go to Automation Studio | Activities | Create Activity
  • Select SQL Query
  • Give it a name | Next
  • In the SQL Query text box, place the below code | Next
Select Subscriberkey from AllEmailAddresses
EXCEPT
Select Subscriberkey from _subscribers
  • Select your Results Data Extension created above
  • Select Overwrite as the Data Action
  • Review the Summary screen to ensure everything looks correct | Finish
  • Go to Automation Studio | Overview | New Automation
  • Drag SQL Query onto step 1
  • Choose the SQL query you just created | Click Done
  • Drag the Schedule Starting Source onto the canvas
  • Configure it to run whenever you would like | Click Done
  • Give the Automation a name | Click Save
  • At this point you can choose to activate the schedule, or choose to "Run Once" the automation
  • Once the automation runs, check your results Data Extension for the soft-delete contacts

NOTE: To ensure that your contacts are soft-deleted, go to Email Studio | Subscribers | All Subscribers and search for any of the contacts in the result DE. You should get 0 results. Now go to All Contacts and search for a Subscriberkey/ContactKey that was in the results Data Extension. You should get a row returned that shows as "Unspecified". 

 

ナレッジ記事番号

000389421

 
読み込み中
Salesforce Help | Article