I would like to update the score of existing leads in Marketo by importing a list. But since we have duplicates in our database I would like to link the new score with the right Marketo ID (or SFDC ID) not the email. When matching with the email Marketo matches with the email but with the wrong duplicate records. Is this anyhow possible?
A UI-based upload dedupes on Email.
An API-based upload can dedupe on ID instead.
Another way to do an update by ID is to call a webhook that can do the lookup in the file by ID.
If you're feeling adventurous and need to use the UI, you can (a) temporarily copy the Email Address to a secondary Email Address type field, (b) replace the Email Address with the {{lead.Id}}, (c) reimport with the ID in the Email Address column, then (d) copy the original {{lead.Email Address}} back. If you embark on this, test, test, test with a group of dummy leads first.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.