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

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

    Koki Enomoto

      【日本語/Japanese】

      お世話になっております。GEです。

      あるメールアドレス1件をスマートリストで抽出すると、同じメールアドレスで2件以上重複して抽出されます。

      ※以下図について、mailaddressは2つとも同じ。

      メールアドレスがキーとなって、データベース上に管理されていると思っていたのですが、実際には何をキーにしてデータ保存しているのでしょうか?

       

      【英語/English】

      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.