Sync Pre-Existing Fields and data with Salesforce | Community
Skip to main content
Sean_Hardaker
New Participant
September 27, 2016
Solved

Sync Pre-Existing Fields and data with Salesforce

  • September 27, 2016
  • 2 replies
  • 2630 views

I've got some fields in salesforce that were only made visible to Marketo recently and have pre-existing data in them.  There is one field which is on the Lead object and another on the Account object.  I can see both fields inside Marketo.

The problem is that these fields are empty inside Marketo while they are complete in salesforce and I don't know how to sync the data without manually updating the fields in salesforce.

Is there a way to do this?

thanks

Sean

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 Sean_Hardaker

Here's what I've done in the end:

  • In SFDC I've exported a Contacts and Account report for all owners, for all time where the field i want is not empty.
  • In MKTO I've segmented and exported all leads with the empty field, SFDC source and contacts only.
  • Use index(match()) in excel to create 2 column CSV (email, field) and import back into MKTO

Job done.

2 replies

Sean_Hardaker
Sean_HardakerAuthorAccepted solution
New Participant
September 28, 2016

Here's what I've done in the end:

  • In SFDC I've exported a Contacts and Account report for all owners, for all time where the field i want is not empty.
  • In MKTO I've segmented and exported all leads with the empty field, SFDC source and contacts only.
  • Use index(match()) in excel to create 2 column CSV (email, field) and import back into MKTO

Job done.

Josh_Hill13
New Participant
September 27, 2016

They should update automatically if Marketo has permission to Read to the fields. Perhaps it is happening slowly over time. If you want to  modify the sysModTimeStamp, you could force it...but do you want ALL of your records to sync suddenly?

Sean_Hardaker
New Participant
September 28, 2016

HI Josh

Thanks for the quick response.  The fields in question have been visible to Marketo for some time (weeks/months) the data is available for some and not for others.

Going off your suggestion, I could modify sysModTimeStamp for just the records who's fields are empty and using a few other segments to only sync the records in question.

What's the best way to bulk modify the sysModTimeStamp? It's a salesforce field, not visible to Marketo AFAIK