Import list by ID

Rasmus_Bidstru1
Level 4

Import list by ID

Is it possible to export a list (with the system ID), change eg. email adresse or other field, and import the file again matching the record by system ID, and just updating the new values?

regards
Rasmus
Tags (1)
4 REPLIES 4
Adam_Vavrek1
Level 9 - Champion Alumni

Re: Import list by ID

Hi Rasmus,

Marketo de-dupes based on the email address. If you do what you described above and change the email address in your exported file and re-import to Marketo, a new lead will be created and will not update the existing lead's email address.
If a lead with the same email address exists upon re-import, Marketo will update that lead. You can update other fields using the email address (as opposed to the ID) but you'll need to edit the email another way.
Rasmus_Bidstru1
Level 4

Re: Import list by ID

Ok 🙂

One of our issues is that we have multiple leads with the same email address, so if we update the using by looking at the email, it will find 2-3 leads with the same email. thats why i wanted to use the Marketo ID to find the correct people.
Jep_Castelein2
Level 10

Re: Import list by ID

You'll have to use the API to update by ID. It's not that hard, but you'll need the help of a software developer. You can export a list including the Marketo ID, but you'll need the API to save back the updates. 

In the REST API, you can use the Marketo ID to update records:  http://developers.marketo.com/documentation/rest/createupdate-leads/.  Potentially you can also use the "Import Lead" functionality and specify the Marketo ID as the lookup field: http://developers.marketo.com/documentation/rest/import-lead/ (please test this, as I haven't done this myself yet). 

In the SOAP API, you can do the same: http://developers.marketo.com/documentation/soap/syncmultipleleads/ , however you cannot use the importToList function, because that only uses the email address for matching.  
Phillip_Wild
Level 10 - Community Advisor

Re: Import list by ID

Rasmus we have the same problem. We use SFID as the unique identifier, but Marketo dedupes list imports on email address. This makes no sense and makes it really difficult to update leads.