This content has been marked as final. Show 2 replies
Are you planning on doing this manually in Marketo or are you using a 3rd party to assist? How many accounts are impacted? If it's only a handful, manually is good. If you're going to manipulating a lot of data, I'd use some 3rd party experts to assist or this is going to take you forever and a half.
You can block updates to the company field in the admin section if you don't want the changes that you make to be relected in SFDC, then "unblock" it when you want it to sync.
With projects like this, I generally clean in SFDC first, allow the data to sync to Marketo then pull lists of what is left in marketo and create data value changing campaigns/engagment programs to glean the new data. CRM fusion is a great product for cleaning up SFDC.
I agree with Kristen - CRM Fusion is particularly helpful for data cleanup. I use their Power Grid tool frequently and I think this tool could help you a lot. They also help merge duplicate records in bulk.
There are many tools to help with the pain point your describe. Check out Reachforce and NetProspex (they'll have a feature coming out in a month or two that will create consistency among company names). There's also a free app in the SFDC Marketplace called "Mass Update Wizard" that you should get.
You can also set up triggers based on the company name field and/or email address field. For example: if email address contains @nike.com or company name starts with Nike or equals Nike or Nike Inc -> edit company name to be Nike, Inc.