How does Pipedrive determine duplicates during Import?

Jacob Leffler
Jacob Leffler Member Posts: 4 VERIFIED MEMBER
Name Dropper First Comment Photogenic

When importing person data, how does Pipedrive identify duplicates?

I tried an import including Pipedrive Person ID, but it doesn't recognize ID as a field that can be imported (doesn't automatically map field and it doesn't list as an available field in the right-hand side...see screenshot). The use case was (1) extract person data, (2) make changes outside Pipedrive to person data, (3) import data, in hopes that updated person data would be merged successfully into the correct people instead of creating a number of duplicate person records. Using a Pipedrive Person ID would be unambiguous as to what records we wanted updated during the merge.

Pipedrive does ask if I want to Merge or create Separate Records. How does Pipedrive determine a duplicate?


Answers

  • Kreete K
    Kreete K Pipedrive Team Posts: 354 PIPEDRIVE TEAM
    Fourth Anniversary 100 Comments 25 Likes 5 Answers
    edited April 1 #2

    Hi @Jacob Leffler

    In this case, the ID field is the best solution. There should be an ID field option on the right side during import, if it didn't auto-map. You can search with ID and the full field name for a Person should be "Pipedrive System ID - Person":

    https://sharing.pipedrive.com/i/o4fpZn

    Without the ID field, default duplicate rules for a Contact Person are that they have to have the same name and the same phone number or email address or organization. You can check it out here.