Hi There,
I was cleaning my database and came around multiple leads whose email address have been changed in the last year due to some company acquisitions or few have joined the new company.
So i downloaded all that data and starting working on correcting them in an excel sheet but now before uploading that i have few questions:
1. I f i upload that data with a different email address will Marketo create a new records?
1.1 If so; is there a way to over right the current data value in a bulk way?
2. If i add existing Marketo ID column will that help?
3. Or should i update the leads via Salesforce?
Hope i clarifies my question.
Hi Ravi,
Marketo De-duplicates against the email address, so if you import the list with just the new email addresses, new lead records will be created, which you'll want to avoid. But, there's actually a good work around for this by loading the new email address into another field on the existing lead record, then using a smart campaign to populate that new email address over the top of the main existing email address.
1. Create a new custom field
2. Import your list using the existing email address mapped to the standard email address field so that it de-duplicates against the existing lead.
3. During import, map the correct/updated email address to the new custom field you created. This gets the correct email address into the correct exiting lead record.
4. Create a smart campaign with a change data value flow step.Set the value to be changed as the standard email address field. For the new value, use the token value for your new custom field. This will take the updated email address from the custom field and write it into the standard custom field.
5. Run the campaign, sit back and enjoy an updated email address for your leads!