1 of 1 people found this helpful
I believe once you have scrubbed the Excel file (and converted it to a CSV or Unicode file, of course), you can just import it again and that should correct the situation (assuming none of the fields populated by the import are blocked from updates). I would test this first with a small batch (say 3 records) first.
As for general rules for bad data cleanup - it depends on the situation and on what data needs to be corrected.
As Marketo is based on an email address I also think you can do this and I am fairly sure I have done this myself. I agree about testing it first though.
I hate issues like this - we've all faced it!
2 of 2 people found this helpful
Not necessarily a solution for bad data cleanup, but I would look into blocking fields from list updates... This could have prevented some of the issues you had. It depends on if you think the data that you get from lists would be more or less accurate than what you already have in your database.