Here's the deal: whenever a lead that already exists in SFDC changes their information in Marketo (i.e. a lead changes her name from Jane Smith to Jane Jones) it's not updating in SFDC. Given that it's supposed to be a bidirectional sync, whenever a lead updates information in Marketo it should be syncing to SFDC... but it's not.
Why this is especially weird:
Did you try to manually change name of a lead in Marketo. And 'manually' trigger (right click on the lead) sync with SFDC?
What do you see in the 'activity log' of that lead w.r.t. SFDC ?
Any error in the notifications?
Sounds like your user profile isn't quite right, even if it is an Admin.
Are you sure those fields aren't blocked somehow on either end?
What are your organization wide sharing settings? If it's set to private you may need to create a rule for the Marketo Sync user to access Leads/Contacts/Accounts they don't own.
Look at the activity log of the leads that show the problem, focus on the SFDC sync activities and see what is the error code. Various possibilities here, including some details on the hints already provided above:
ok, got this error: So then I went into SFDC to check the fields, and it turns out we had one called
_updateSObjectsById failed for 1 Lead record(s) - INVALID_FIELD: No such column 'mkto_si__Last_Interesting_Moment_Date__c' on entity 'Lead'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
'mkto_si_Last_Interesting_Moment_Date_c__c', so I deleted the extra '_c' and got this:
_retrieveSObjects failed for type 'Lead' - INVALID_FIELD: MasterRecordId, Mike_Old_Leads__c, mkto_si_Last_Interesting_Moment_Date_c__c ^ ERROR at Row:1:Column:945 No such column 'mkto_si_Last_Interesting_Moment_Date_c__c' on entity 'Lead'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
Now, I've never had any trouble with Mike_Old_Leads_c before, or MasterRecordId. Any idea what's going on here?
You should really not play with these fields, they arepart or Marketo Sales Insight packages.
I recommend that you deinstall MSI and reinstall it properly. It will be faster than trying to correct all this.
quick instructions on where to find MSI to uninstall? Don't see it under our managed packages in SFDC.
Also, do you have a link to reinstall it?
Sorry I'm so helpless!
I would bet MSI has been installed in the past, and then removed... Do not worry about the "Mike Old Leads" one, the error is not on it.
I would also review the rights of the Marketo user. Either it has the "system administrator" profile (non custom) or you need to make sure all fields are made visible to it in each key object.