I cannot thank you enough! This video is simple and amazing! We raised several tickets with SFDC for help and all we needed was to watch this. Other people have said, but I'll say it again: absolute life saver!
Thanks, this is perfect and a very thorough walk through the whole process. I'll have a look at it and probably add a second verification step to the automation to check if the count of contacts to be deleted are higher than x rows and if so stop the automation and send me an email, so I can make sure the "spike" is ok and I'm not about to delete all my contacts by mistake. Thanks a million, Thomas
Thank you for making this video. It's exactly what I need. I am however having an issue filling out the necessary details in the JavaScript code. How would I go about finding these details? The only one I can find is the MID Id.
Thanks for the video. This will be extremely helpful. I have a question, how do we verify that the last email was sent was more than 180 days ago. I didn't see it the sql query? did i miss anything ??
In the SSJS for the List ID you're not clear which list we should be deleting from. I think the line should be "targetList":{"listKey":"ID for CONTACT TO DELETE extension filled by 3.1 in the Automation","listType":{"listTypeID":3}} Is this correct @Cam Also - does the entry rest instance in "HTTP.Post(authobj.rest_instance_url+'contacts/v1" need to be explicitly stated or will this work without edit (it looks like you think this will work but I am getting an error and it is proving difficult to trace.)
Hi Cameron.. In the SSJS Contact Deletion please can you tell me which DE's are you referring to "listKey":"ddddddddddddddddddddddddd" AND var de = DataExtension.Init("eeeeeeeeeeeeeeeeeeeeeeee") Thanks
For listKey, I believe you want to plug in the external ID for the Contacts to Delete DE and initialize using the external ID for the Contact API Log DE.
Am I correct in assuming we need to create an Installed Package in Setup with a Server to Server API integration component to get the Client Id and Secret?
Does this means, we can delete the contacts stored on any sendable DE? I have a DE with 100 contacts can I delete them all using the script discussed in the video?
Thanks alot. I just have one question. In case my sfmc is connected with my sales cloud and I delete or merge account/contact in sales cloud, does it affect on the target record in sfmc?
Hi, One question So we keep the reference data extension on the parent BU and run this automation, does this also deletes records from Sendable DE's from all Child BU's? or does this work only All contacts
Does the suppression rule act as a cooling off period on the off chance that you chance your mind on having deleted that contact? Eg you click delete contact with a 10 day suppression time. You then have 10 days to change you mind before the contact is actually deleted?
Hi @Bhris, great question! Adding suppression time to the contact deletion process just prevents the record from being contacted until the deletion event takes place; as a SFMC user, there is no way to undo a deletion action in the interface. SFMC Support may be able to cancel a deletion activity if it's still in the suppression phase, however this would be in extreme scenarios and should not be relied on for common usage.
Deletion is quite quick, however it depends how many records you are trying to delete at once; plus any suppression effects you have set in the Contact Delete Settings. I've not tested the speed per record, however I've seen batches of thousands be removed in just a few hours.
@@gopubhargavreddy3013 Best contact Salesforce Support to check that happened. It's rare - however contacts can get stuck during the deletion process, and a support ticket is needed to complete the deletion. Good luck!
Does this means, we can delete the contacts stored on any sendable DE? I have a DE with 100 contacts can I delete them all using the script discussed in the video?
Hi, is there any possibility to remove multiple contacts only from a specific list or DE? Unfortunately, I can't find a solution where I can delete a group of customers in one business unit and it will not affect the same users in another one.
Hi @Daddyho83, Sure - I'll put a link in the video description. Make sure you understand how the code works before running it as contact deletion can not be undone!
Newbie alert: Getting a syntax error on the query: "Errors: [AllContacts] is not a known data extension or system data view. You can only query existing data extensions or system data views." I created the AllContacts mobile list but it does not recognize it as a DE?
I cannot thank you enough! This video is simple and amazing! We raised several tickets with SFDC for help and all we needed was to watch this. Other people have said, but I'll say it again: absolute life saver!
Thanks, this is perfect and a very thorough walk through the whole process. I'll have a look at it and probably add a second verification step to the automation to check if the count of contacts to be deleted are higher than x rows and if so stop the automation and send me an email, so I can make sure the "spike" is ok and I'm not about to delete all my contacts by mistake.
Thanks a million,
Thomas
OMG - what a life saver! PERFECT video - thanks!
Thank you for making this video. It's exactly what I need. I am however having an issue filling out the necessary details in the JavaScript code. How would I go about finding these details? The only one I can find is the MID Id.
Thanks for the video. This will be extremely helpful.
I have a question, how do we verify that the last email was sent was more than 180 days ago. I didn't see it the sql query? did i miss anything ??
Nice information @Cameron
Best tutorial ever :)
Thank you for this video!!
In the SSJS for the List ID you're not clear which list we should be deleting from. I think the line should be
"targetList":{"listKey":"ID for CONTACT TO DELETE extension filled by 3.1 in the Automation","listType":{"listTypeID":3}}
Is this correct @Cam
Also - does the entry rest instance in "HTTP.Post(authobj.rest_instance_url+'contacts/v1" need to be explicitly stated or will this work without edit (it looks like you think this will work but I am getting an error and it is proving difficult to trace.)
Hi Cameron.. In the SSJS Contact Deletion please can you tell me which DE's are you referring to
"listKey":"ddddddddddddddddddddddddd" AND
var de = DataExtension.Init("eeeeeeeeeeeeeeeeeeeeeeee")
Thanks
For listKey, I believe you want to plug in the external ID for the Contacts to Delete DE and initialize using the external ID for the Contact API Log DE.
Am I correct in assuming we need to create an Installed Package in Setup with a Server to Server API integration component to get the Client Id and Secret?
What happens to the send log and tracking data in Data View, after deletion took place?
Does the customer data get anonymised?
Does this means, we can delete the contacts stored on any sendable DE? I have a DE with 100 contacts can I delete them all using the script discussed in the video?
Thanks alot.
I just have one question. In case my sfmc is connected with my sales cloud and I delete or merge account/contact in sales cloud, does it affect on the target record in sfmc?
if u dont update the contact list in marketing does not affect. SC --> MKC works only ony way
Hi,
One question
So we keep the reference data extension on the parent BU and run this automation, does this also deletes records from Sendable DE's from all Child BU's? or does this work only All contacts
It will be deleted from all the child BU's
Does the suppression rule act as a cooling off period on the off chance that you chance your mind on having deleted that contact? Eg you click delete contact with a 10 day suppression time. You then have 10 days to change you mind before the contact is actually deleted?
Hi @Bhris, great question! Adding suppression time to the contact deletion process just prevents the record from being contacted until the deletion event takes place; as a SFMC user, there is no way to undo a deletion action in the interface. SFMC Support may be able to cancel a deletion activity if it's still in the suppression phase, however this would be in extreme scenarios and should not be relied on for common usage.
@@ImplementationGuru Thanks very much for this. I really appreciate your efforts :)
HI Cameroon.. Can we do this with AmpScript (without SSJS).
thank you
How much time it takes to delete records from MC and how to prioritize this
Deletion is quite quick, however it depends how many records you are trying to delete at once; plus any suppression effects you have set in the Contact Delete Settings.
I've not tested the speed per record, however I've seen batches of thousands be removed in just a few hours.
@@ImplementationGuru i am deleting only one record and suppression 0 days but from 1 week the status showing as in processing
@@gopubhargavreddy3013 Best contact Salesforce Support to check that happened. It's rare - however contacts can get stuck during the deletion process, and a support ticket is needed to complete the deletion. Good luck!
Hi Cameron.. Can you please post the ssjs script here for reference. thank you.
Does this means, we can delete the contacts stored on any sendable DE? I have a DE with 100 contacts can I delete them all using the script discussed in the video?
Hi, is there any possibility to remove multiple contacts only from a specific list or DE? Unfortunately, I can't find a solution where I can delete a group of customers in one business unit and it will not affect the same users in another one.
Contacts are stored across the account, so deleting a contact will affect all BUs in your account.
Can you please share the SSJS script. thank you
Is it possible to have the SSJS code?
Hi @Daddyho83, Sure - I'll put a link in the video description.
Make sure you understand how the code works before running it as contact deletion can not be undone!
@@ImplementationGuru thanks, can you let me know when it's there?
Newbie alert: Getting a syntax error on the query: "Errors: [AllContacts] is not a known data extension or system data view. You can only query existing data extensions or system data views." I created the AllContacts mobile list but it does not recognize it as a DE?
I keep getting a runtime error. Are there limitations with this method?
I'm also having the same issue. @Datarati - Implementation Guru Can you please help us to resolve this?
I had the same error! How do you resolve this?
I had the same error! How do you resolve this?
Hi, could you paste the API code here please?
Can u explain a little the script?
Thank you for this!!!