Best way to mass change email addresses? | Community
Skip to main content
Jose_Rafael_Par
Level 3
January 9, 2013
Question

Best way to mass change email addresses?

  • January 9, 2013
  • 2 replies
  • 1370 views
Hi everyone,

My company just changed our domain name, and we use marketo for all employee notifications. I'd like to change the email addresses on the lead records for our employees to the new one, and I was wondering if there was a better way to do that than manually going through every record. Normally to make a change like this, I would export all of the fields that need changing along with their email address and then reimport the list after making the changes, so that marketo matched the email addresses and updated the fields in the spreadsheet, but since these are different email addresses, I don't know how to get Marketo to not create new leads instead of just updating the old ones.

Any ideas?

Thanks!
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

January 9, 2013
I'd do this in SFDC using the Lead or Contact ID # as the matching method.

You might be able to do something similar using the Marketo ID, but test that on 1 record first.
January 11, 2013
Another option would be to create Smart Lists in your Lead Database. Each rep should have their own smart list dictated by "Lead Owner Email Address". Then, one rep at a time, as long as the new rep email addresses are already updated in SFDC and Marketo, you can simply select all and do a "Change Owner...".  But like Josh recommended, I'd definitely test on one record to start.