How can I sync past unsubscribes into SFDC? | Community
Skip to main content
Michelle_Poulio
New Participant
December 21, 2017
Solved

How can I sync past unsubscribes into SFDC?

  • December 21, 2017
  • 2 replies
  • 1692 views

Hi!  We are a newer Marketo customer and have realized that our SFDC was blocking Marketo unsubscribes from syncing with the email opt-out field in SFDC.  We've since undone the block and new unsubscribes are being reflected on the SFDC contact record.  Now how do I go back and get all the unsubscribes that happened before this fix to sync into SFDC?  TIA!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Grant_Booth

I recommend a campaign to reset the field value.

Smart List:

  Unsubscribed = true

Flow:

  Change Data Value 'Unsubscribed' -> false

  Change Data Value 'Unsubscribed' -> true

That would take everyone who is currently unsubscribed, switch to false and then back to true. That should cause the true value to sync up to SFDC for all of those records. HOWEVER, make sure you do this at a time when you are absolutely positive there are no email campaigns going out. It would be bad news.

Grant

2 replies

keithnyberg
New Participant
January 9, 2018

Grants solution works but will also reset your unsubscribe date (if you use that field). So be sure to disable the campaign appending the unsubscribe timestamp if you dont want those values corrupted.  Another method would be to pull a list of unsubscribes from Marketo and do an import/mass update or similar to append the unsubscribe field in SFDC.

Grant_Booth
Grant_BoothAccepted solution
New Participant
December 21, 2017

I recommend a campaign to reset the field value.

Smart List:

  Unsubscribed = true

Flow:

  Change Data Value 'Unsubscribed' -> false

  Change Data Value 'Unsubscribed' -> true

That would take everyone who is currently unsubscribed, switch to false and then back to true. That should cause the true value to sync up to SFDC for all of those records. HOWEVER, make sure you do this at a time when you are absolutely positive there are no email campaigns going out. It would be bad news.

Grant