2 Replies Latest reply on Jan 15, 2018 11:25 AM by Keith Nyberg

    List import de-duplication rules

    Macarena Mazzeo

      Hi All,


      I know when you do a List import Marketo automatically de-duplicates those people with the same email addresses. I have a couple of questions on this matter:


      - Which record is chosen by Marketo as the master record?

      - Can you control the de-duplication rules at list import level (i.e. can you tell Marketo to de-duplicate based criteria other than email address like is possible through System Smart Lists Possible Duplicates List?)

      - What options does Advanced List Import permissions give you?



        • Re: List import de-duplication rules
          Keith Nyberg

          Hey Macarena,

          My understanding is that Marketo will always merge the new record with the existing record in the database. Meaning that the "create date" of the older lead will remain. Important to remember that the scenario you are referring to is exactly what field blocking is used to manage. Like the field Person Source, you never want to overwrite it, so this field should be blocked from updates by all sources (maybe excluding DVC if you are doing manual clean-up). When you are importing and mapping your file fields to Marketo fields, you will see a green squiggly underneath all fields that are blocked from update via import. What this means is that the field will not be overwritten during the import process. Fields without the green squiggly however, will be updated during import. You can manage blocked fields in Admin in Field Management by locating the field in question and selecting Field Actions > Block Field Updates.

          Screen Shot 2018-01-15 at 11.03.06 AM.png

          From there you can determine what sources you want to block from updating your field based on preference and how your users use Marketo (in your example, Import). You can read more about field blocking in Marketo here: Block Updates to a Field - Marketo Docs - Product Documentation . This leads us to the topic of "Trusted Import". Trusted import means that all field blocking rules will be ignored when a record is imported and all fields existing in the file and mapped during the import process will be overwritten by the new values in your file when imported. Trusted import is great, but I would caution you to only include fields in your Trusted Import file that you know for certain you want to overwrite in Marketo. I've only used Trusted import a handful of times over the past four years.

          Hope this helps! Let me know if you have any other questions.

          - Keith Nyberg

          2 of 2 people found this helpful