Deduplicate Leads

Deduplicate Leads

In my Leads module I use it for basically a dumping ground for raw data/leads I purchase from lead vendors so I can utilize in other ways.  The problem I am having is that Zoho makes it very difficult to prevent duplicate names coming in.  They only allow for a limited screen if you will to match duplicate data.  For example, you can screen out imports by email but the data I bring in does not contain any email addresses.  I believe there is also a way to screen out by street and or City but the problem with that is if I have a spouse already in Zoho it will screen out the other household person such as spouse.  

I have begged and pleaded with Zoho to add more fields that we can use to screen out duplicates upon import but for some reason this falls on deaf ears.  

I've also tried the Deduplicate under the leads module to help with this issue but there again they have limited fields that we can select and not the ones I need.  It is frustrating to me that Zoho would not make this more robust and useful in both of these areas.  

So I am left now with a very large amount of duplicates that I need to do something with.  It appears to me that I may have to export the data to MS Access or Excel or another 3rd party to try and clean this up.  Just looking to see if anyone has any ideas about the easiest way of doing this and also any ideas of how I can prevent adding more duplicates when I import names from new mailing lists I obtain from mailing vendors.

    Zoho Marketing Automation
      Zoho Mail - CRM Integration
              • Sticky Posts

              • Zoho CRM - Upcoming Features ...

                Hi, We would like to inform you about the Zoho CRM features that we are taking up in the near future.  Please go through this link. As a policy we will not commit any dates for any mentioned features. However we will try to roll out  the listed features one by one in the period of 6 months time. We will keep you posted just in case we change our priorities with respect to any features.  Thank you, With Best Regards, Dilip, Zoho CRM
              • Track and monitor sales activities with the all new Tasks, Calls, and Meetings modules

                This change will be available soon to all organizations. Hello everyone! Sales activities provide more context for where each deal is headed, helping sales reps to focus on accelerating the customer journey and close the deal. That is why it is critical
              • [Early Access - Updated to LIVE] Introducing the Canvas Design Studio.

                Greetings Customers!   Before we kick back and enjoy the holidays, we'd like to make a post about our next big thing. In January 2021, Zoho CRM will be launching its magnum opus for delivering world-class user experience - here's a sneak peek of what's
              • Introducing Multiple Sandbox Types and Support for Module's Data Population

                Register here for the upcoming Focus Group webinar on Multiple Sandbox | Help documentation to learn more about the new enhancements Hello everyone,  Sandbox in CRM is a testing environment for users to create and test new configurations like workflow
              • Include Finance Suite modules to Segment your records

                Dear All, Greetings! We have a quick update on Segmentation in Zoho CRM. Let's go! As you might know, Segmentation is a process of categorizing your customer records based on common patterns and behaviors. And, RFM is one such way to categorize customers

              Zoho Pagesense Resources

                Zoho SalesIQ Resources

                      Zoho TeamInbox Resources

                        Zoho DataPrep Resources

                          Zoho CRM Plus Resources

                            Zoho Books Resources

                              Zoho Subscriptions Resources

                                Zoho Desk Resources

                                  Zoho Projects Resources

                                    Zoho Sprints Resources

                                      Qntrl Resources

                                        Zoho Creator Resources

                                          Zoho WorkDrive Resources

                                              Zoho Campaigns Resources

                                                Zoho CRM Resources

                                                        Design. Discuss. Deliver.

                                                        Create visually engaging stories with Zoho Show.

                                                        Get Started Now