SOLVED

Details of Custom Dedupe Logic

Go to solution
Anonymous
Not applicable

Details of Custom Dedupe Logic

Hey all,

So, I'm trying to set up a system that essentially syncs data between a our software system and Marketo. This is made more complicated by the fact that email addresses aren't unique, but I do have unique user IDs. I wanted to verify some behavior about how things work with Custom Dedupe rules and maybe get some advice from the community. Specifically, here are my cases:

Comes in through API first

  1. An API call is made, creating a new lead. Email Address: seller@coupang.com User ID: 1000
  2. There is initially no other seller@coupang.com in the system.
  3. Later, through a List Import, someone tries to bring in a lead with the email address of seller@coupang.com, but no User ID

If I don't have any custom dedupe logic, this will just update the lead in the system (I think, and I think this should be fine). If there are two sellers, I don't much care which one gets imported onto, but I'd rather not make a third record. If I do have custom dedupe logic of email + UserID, does the one that comes in blank make a separate record?

Comes in through List Import First:

  1. A list import happens, bringing in a new lead, but we don't know the user ID yet. Email Address: seller@coupang.com User ID: (blank)
  2. There is initially no other seller@coupang.com in the system. This record gets assigned a user ID of 1000 down the road in my back-end system.
  3. Later, through an API call, I try and lookup User ID 1000, don't find seller@coupang.com

At this point, if I'm clever, the code looks for the email address and gives seller@coupang.com a value for user. I think this should work fine- any gotchas? I could also have the automated process that creates the user ID update the record right then.

Anyone else doing something like this? Anything you learned the hard way? I'm mostly leaning towards not really having any custom dedupe logic turned on, and then using lookup fields in the REST API to make sure that the ones coming in that way create dupes as needed.

-Erik

1 ACCEPTED SOLUTION

Accepted Solutions
Kenny_Elkington
Marketo Employee

Re: Details of Custom Dedupe Logic

There really aren't any more general gotchas off the top of my head.  Hope you're enjoying the new gig.

View solution in original post

5 REPLIES 5
Dory_Viscoglio
Level 10

Re: Details of Custom Dedupe Logic

Totally not an answer to your question, but welcome back to the community!

Anonymous
Not applicable

Re: Details of Custom Dedupe Logic

Thanks Dory, good to be back as a customer!

Kenny_Elkington
Marketo Employee

Re: Details of Custom Dedupe Logic

An empty value will be treated as a value when using custom dedupe logic, so in your first scenario, there will be two records created if you have custom dedupe enabled on the User ID field.

For your solution to the second problem, there are a few gotchas.  What if there have been multiple list imports by now which have been intended for separate person records, but did not have User IDs?  Can you not have a webhook which assigns a User ID in this case?

Anonymous
Not applicable

Re: Details of Custom Dedupe Logic

Thanks for the answer on blanks. Good to confirm how that works.

Good point Kenny, although for imports I think that is less of an issue. The imports are just potential leads coming from something other than our software system so they probably don't even have a corresponding username and they don't contain any new information- I just want to avoid making dupes if I don't have to.

Anything else I should worry about?

Kenny_Elkington
Marketo Employee

Re: Details of Custom Dedupe Logic

There really aren't any more general gotchas off the top of my head.  Hope you're enjoying the new gig.