We recently changed the values for our Country and State picklists in SFDC. We are working to update all the values but in the meantime folks are failing to sync because of a filed integrity issue on these fields.
What filter would you use to pull a smart list of anyone who failed to sync because of these?
Re: How to pull smartlist of failed syncs to sfdc?
How about using some Excel magic?
Identify the leads that may possibly be affected in SFDC in a report, and add the email address and state columns. Export the same list in Marketo. Then see if there is a difference between the two state values. Then you can update the field value and re-import back into Marketo.