Clay Icon

Tips for De-Duplicating Contacts Using LinkedIn IDs

ยท
ยท

Hi all, i am having problems with de-duplicating contacts based on LinkedIn ID. Sometimes the linked in ID is slightly different even though it is the same contact person, so de-dupe based on linked in ID will not work. Any tips or tricks to work around this? Maybe people are adding extra protection with Person Name and Company Name combination = de-dube (although i dont know how I could create a formula for this) Here is a video explaining.

  • Avatar of Muhammad S.
    Muhammad S.
    ยท
    ยท

    Linkedin username can not be different for same person, if they are same it means one of them is obselete or incorrect. You can create a new column and do a dedupe logic based on firstname+lastname+domain.

  • Avatar of Carl W.
    Carl W.
    ยท
    ยท

    Muhammad S. but you can see in the example vid that sometimes the linked in URL is different (it has numbers at the end and some do not.) Thanks for the tip.

  • Avatar of Carl W.
    Carl W.
    ยท
    ยท

    regarding this de-dupe logic, is this a formula?? Can you give more instructions on how i can do this?

  • Avatar of Muhammad S.
    Muhammad S.
    ยท
    ยท

    You can combine firstname, lastname and domain and it will create a unqiue key

  • Avatar of Muhammad S.
    Muhammad S.
    ยท
    ยท

    you can dedupe on that