Importing a list to update database records | Community
Skip to main content
Ashley_Fawcett
New Participant
July 31, 2019
Question

Importing a list to update database records

  • July 31, 2019
  • 1 reply
  • 4710 views

My company does customer surveys pretty frequently and we just switched over to Marketo so this is a bit new. We assign each of our customers their own unique survey link so we can get more information comparing their responses to their account. When I upload a list with their individual survey link it creates a new lead in the database. Is it possible to do a list upload to update the existing record? Or will the new record just have to be deleted once it is sent? 

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

1 reply

SanfordWhiteman
New Participant
July 31, 2019

A list import via the Marketo UI can use the Email Address field as a lookup key. Do you have that as a column and have it mapped correctly? You should not be constantly creating new leads.

Ashley_Fawcett
New Participant
July 31, 2019

Yes, I map both email address and a user ID that should technically map it to the existing lead. It creates a new on every time and when I try to skip new people and updates it fails. 

SanfordWhiteman
New Participant
July 31, 2019

Marketo Lead ID is irrelevant here (that isn't supported). Remove that column from the file and try again.