 Duplicate Checking
Duplicate Checking can be a fuzzy process. When you add a new name to your data Denari does a duplicate check to see if there are name records already in your data that might match the one you are adding. It then gives you the choice to continue to add the new record or not. By default, Denari checks the Last Name field, the first 10 digits of the street address, and the first 5 digits of the zip code. If it finds a match in all three of those then it will flag that record as a potential duplicate.
The problem is that there are many circumstances where matches in those fields result in a record that is not a duplicate. For example, you may have a mother and father record already in your data. Their son, who is living at home, decides to make a donation. He has the same last name, same street address, and the same zip code, but he's not a duplicate.
You also have the problem where someone may enter the street name one way while someone else enters it a different way. No computer program will be able to know what you were thinking when you typed that street differently than the one originally in the data. So Denari won't see that as a duplicate. There are many other circumstances that make it difficult for Denari to identify with 100% certainty all the duplicates in your data. So the idea of the duplicate check is to limit them as much as possible. It won't be a perfect solution.
But, Denari does give you the ability to play with these settings if you'd like. You could, for example, check the 'Email’ check box here. When you check any of the fields in this section the defaults mentioned earlier are no longer used. Denari will now use the criteria that you select here. So again, if you check that first field, Denari will look for any name records with matching email addresses and that's all it is looking at. If you check the second field, 'Dup Check on Phone' then Denari will add that with an OR operator which means that if a name record has a matching email address OR phone number then Denari will flag that as a potential duplicate. The more you check here, the more Denari will look at. If it finds a match in any of the fields you indicate it will flag it as a duplicate.
There are a couple of fields here that need an explanation.
The fields that have multiple criteria like zip, street, last name, means that Denari will be looking at all three fields and needs to find a match in all three to flag that record. So if you chose that option and also checked the email option then Denari would need to find a match in the street, zip, and street field (all three) OR the email field.
In the second option down you have the term 'fuzzy'. This option is actually trying to interpret what you mean. If it sees the last name of S M I T H in one record and S M I H T in the new record it might see the similarity and flag that as a potential duplicate. This is not a perfect system, however, but it may help pick up a few more duplicates.
The last option refers to 'Soundex of Name'. This too is trying to find anything in the last name field that is remotely similar to an existing name record. Checking this box, however, usually results in a lot of flagged records. It is pretty liberal and tends to see just about anything as a duplicate.
Again, you can play with these settings to see what works best for you.
|