Re-syncing restored records from Marketo to Salesforce

Question

Hello Marketo Community,

Seeking any help or guidance following a request to Marketo Support to restore a batch of data records.

The data was restored by support in March, but I’m struggling to find a way to re-sync the restored data to Salesforce.

During the restoration, I believe its common practice to not re-populate the ‘SFDC ID’, however as this field is not available as a ‘change data value’, I cannot restore this field. We have a backup field for SFDC ID called ‘Full SFDC ID (L)’ , but I cannot push any changes to the initial ‘SFDC ID’ field. Is this something that support can do on our behalf?

I try to run a SF sync, but got the following error: ‘Failed: INVALID_CROSS_REFERENCE_KEY: Record Type ID: this ID value isn't valid for the user: Marketo sync user ID number)

Once the SFDC ID field is populated, I believe in order to avoid record duplication, missing links to existing opportunities and SF tasks and interesting moments, we need to re-sync the data to SF rather than re-uploading the data to SF. Does this sound correct, and if so I’m assuming this needs actioning from SF

I have raised a ticket with Support, but its taking quite some time to hear back.

Any guidance would be great.

Thank you

SanfordWhiteman · Answer

The specific error you’re showing is about the Record Type field, which isn’t the same as the system-managed SFDC ID. You actually can change the Record Type in Marketo and I’d recommend you clear out that field for this case.

However, you don’t want to create new SFDC Contacts or Leads for these people. That just makes more work! You want to let the existing SFDC records flow into Marketo, then merge the restored Marketo people with the SFDC-linked (and SFDC-originated) Marketo people.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded