Apartment Numbers

[NA]

What would be the best way to aproach finding duplicates withere:

1) One record may have an apartment number and the other does not? And then how do you make the address with the apt number the field rule winner?

2) Find dups where the Apt numbers may not be the same on two records?

Thanks

[Pugs_Validity]

@NA - That's a tough one, I'd be intersted to hear from other users who may run into this instance. If this is a common occurence in your Salesforce, it may not be the best strategy to include it in your matching criteria. You can always utilize the Match module to try different logics and see what returns the most accurate set. If you still want to include it in your identification process, I would reccomend first standarding your addresses so you can properly identify the apt term and then use a formula to compare all information before the word apt. Feel free to reach out to us at DemandToolsCOE@validity.com if you'd like to take a look at your specific use case in more detail.

[NA]

Thanks for the reply. I am not sure I understand all the answers or that I currently have the DT technical know-how (but I can learn) to implement any of this. I must note however that I never knew that the word "Standard" had evolved to be a verb (as in "standarding")  - just for that - I doubly appreciate the answer.

Seriously - DT does a great job of matching two addresses that may have an apartment number tacked on. But if one address has an apartment number and one does not - identifying that you want to keep the apt number address is important. Length as a criteria, will not do t as:

127 Fifteenth Avenue > 127 15th Ave Apt B

 So there's another rub. 

Apartment, Apt, Suite, Ste, Unit, Penthouse, Floor X, Fl X, Just a comma, just a pound sign - all these are common indicators of an additional identifier beyond the street address.

So what would be the next steps if I wanted to understand better the suggestion above?

Thanks.

[Pugs_Validity]

Hah, I'm not going to change it to standardizing just so I can stand by my new vocabulary word. 

Using Modify, we could STANDARDIZE your address fields so that everytime Apt is in an address, it gets changed to Apartment and so on and so forth with the different permutations you could find. Once we standardize it, the hope would be the evaluation process would be easier.

Selecting the winner of the two, there are a lot of options you can test but the matching will be difficult without some degree of standardization. Shoot us an email to DemandToolsCOE@validity.com if you'd like to walk through it together. 

[Pugs_Validity]

For having the field rule winner be the one containing an apartment, I'd reccomend using Custom Scoring on that field having the winner be the street field that is the Longest String and/or Contains Apt.