リードが重複する現象について（On the phenomenon that leads overlap） | Community
Skip to main content
Koki_Enomoto
Koki_Enomoto
Level 3
October 3, 2018
Question

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

  • October 3, 2018
  • 1 reply
  • 4136 views

【日本語/Japanese】

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

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

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

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

【英語/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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

SanfordWhiteman
SanfordWhiteman
Level 10
October 3, 2018

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.

    Koki_Enomoto
    Koki_EnomotoAuthor
    Level 3
    October 3, 2018

    OK！

    I thought that E-mail Address was primary key.

    In addition, it may be synchronized with Marketo and SFDC.

    【For example....】

    The following data is registered in Marketo list. (There were data with different hospital names even though they are actually the same mail address)

    Import the following leads into that list.

    At this time, is there a standard on which lead data will change the company name (hospital name)?

    * The rewriting of the Id is blocked by the system administrator.

    Terms & ConditionsAccessibility statement

    Loading footer...