Can't update specific record due to Duplicate email address | Community
Skip to main content
G
Guitarrista82
Level 6
November 29, 2022
Solved

Can't update specific record due to Duplicate email address

  • November 29, 2022
  • 1 reply
  • 2334 views

Hello,

I am tasked with updating a data value (Shore Ex Code) on around 2K records in Marketo.

I have been provided an excel document with the list of contacts whose records need to be updated.

The problem I am running into is that some email addresses have duplicate records.

Case in point:

This person below signed up for two GVR accounts using the same email address.

They were assigned a unique Member ID for each account via our CRM and then added to the GVR Person Partition in Marketo:

In the excel doc I was provided (see below), the record with Member ID GVR06288EHZ should be assigned the Shore Ex Code in Marketo:

However, when I uploaded the excel doc to Marketo, the account with Member ID GVR34921EMZ was updated with the Shore Ex Code.

Is there any way for me to ensure that when dealing with duplicate email addresses, a specific record is updated and not a different one?

Thank you,

LK

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

You can’t target one specific person record using a standard UI-based list upload and default dedupe rules.

 

You can target the record in 2 ways:

  • using an API-based list upload, which can lookup on a custom field
  • calling a webhook call to a service that can match people based on a custom field (you pass the webhook your {{lead.Member ID}} and it looks that up in a spreadsheet/file/local list/whatever)

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
November 30, 2022

You can’t target one specific person record using a standard UI-based list upload and default dedupe rules.

 

You can target the record in 2 ways:

  • using an API-based list upload, which can lookup on a custom field
  • calling a webhook call to a service that can match people based on a custom field (you pass the webhook your {{lead.Member ID}} and it looks that up in a spreadsheet/file/local list/whatever)
G
Guitarrista82Author
Level 6
November 30, 2022

Hi Sanford,

Thank you!

I have no idea how to do an API-based list upload.

How would I go about doing this?

SanfordWhiteman
SanfordWhiteman
Level 10
November 30, 2022

You’d be using the Bulk Import endpoint but to be clear, you need to be or have a developer. It’s one of the easiest endpoints to use, but it’s still a dev task.

Terms & ConditionsAccessibility statement

Loading footer...