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
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:
At this point, if I'm clever, the code looks for the email address and gives firstname.lastname@example.org 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.
Solved! Go to Solution.
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?
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?