2 Replies Latest reply on Oct 3, 2018 12:54 AM by Koki Enomoto

    リードが重複する現象について(On the phenomenon that leads overlap)

    Koki Enomoto








      Hello. It is GE.

      If you extract one mail address with Smart List, two or more duplicates will be extracted with the same mail address.

      ※ For the figure below, both mailaddress are the same.

      I thought that the mail address was the key and it was managed on the database, but what is actually saved as data with what key?

        • Re: リードが重複する現象について(On the phenomenon that leads overlap)
          Sanford Whiteman

          Email Address is not a primary key, nor a uniquely indexed column, in the Marketo database.


          It is frequently misstated as such, despite it being very easy to demonstrate that 2 leads can have, and/or be changed to have, the same Email Address value!


          Email Address is a frequently encountered -- but not universal across the platform -- deduplication key for most methods of importing leads into Marketo.  So when you use those methods, such as a form fillout or a UI-based CSV import, Marketo will merge into the database by pre-checking for a lead with the same Email Address.


          But when you use other import methods, such as merely touching up a lead's Email Address in the Marketo UI, or using the API to import and telling it to dedupe on the Lead ID, Marketo does not care if the Email Address you enter is used by any number of other leads in the database.


          Email Address is also used to restrict the number of unique leads who qualify for a Send Email activity, so you will not be flagged for spamming the same mailbox over and over with the same send. This restriction can be annoying in certain cases but is usually a good thing.