SOLVED

Re: Import list match with Marketo ID or SFDC ID

Go to solution
Stoyanova
Level 2

Import list match with Marketo ID or SFDC ID

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?

1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Import list match with Marketo ID or SFDC ID

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.

 

 

View solution in original post

1 REPLY 1
SanfordWhiteman
Level 10 - Community Moderator

Re: Import list match with Marketo ID or SFDC ID

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.

 

 

View solution in original post