Solved

Matching Lead Records

Posted on 2007-11-26
2
185 Views
Last Modified: 2010-04-21
This goes back to the age old question, how to match lead records given that users often input names and addresses incorrectly and often times there is no universal ID across divergent systems.

In the way past, i used phone number.  Phone number is awful cause phone numbers can change.  Then i started to use a match code.  I would substring n characters off of name, address, city, zip, etc and see if i could match.  That works fairly well.

Now i'm thinking about going to a soundex match.  

Anyone got THE best way to match lead records across systems?
0
Comment
Question by:davidcahan
2 Comments
 
LVL 18

Accepted Solution

by:
Yveau earned 500 total points
ID: 20349852
... create a single database for lead data and connect to that database from any other database that needs that kind of data ... only store the 'central ID' in all databases.
Not much help right now, but that is the way to do it ...

soundex can help ... however if there are errors in the first character, soundex won't be any help (see code snippet). as the soundex function is mainly based on the first character ...

Hope this helps ...


select soundex('Weststreet 10'), soundex('reststreet 10')
 

-->> Result:

----- -----

W232  R232

Open in new window

0
 

Author Closing Comment

by:davidcahan
ID: 31410963
good advice on soundex
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Group by correlation 4 43
SQL Select * from 6 30
Selection from table2 where criteria for table1 10 23
Caste datetime 2 22
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now