Recently in Data Quality Category

personator-world-main-graphic.png

By Kevin Ubay-Ubay, Sales Engineer


Personator World is Melissa's new powerful cloud based web service that gives a simple and single way to clean and verify your contact data globally. This service leverages our experience in name, phone, address & email validation to provide comprehensive contact checking and combines high quality identity level verification.

Some examples of where our new web service can be applied:

·         Age verification

·         Name-address verification

·         Anti-fraud applications

·         Online shopping cart & eCommerce platforms

·         FinTech/Banking

Trusted Reference Data

Personator World uses a number of trusted reference data to verify the identity of an individual. These types of data sources include:

·         Citizen/national databases

·         Credit agency/bureau

·         Utility and telecom sources

·         Driver's licenses

·         Electoral rolls

Personator World can then determine if the identity has been found and matched against those datasources. An example JSON response from the web service may contain something like this:

{

    "DatasourceName": "CREDIT-2",

    "Results": "KV03,KV04",

    "Messages": [

        {

            "ResultCode": "KV03",

            "Description": "First/given/forename matched"

        },

        {

            "ResultCode": "KV04",

            "Description": "Last/surname matched"

        }

    ]

},

{

    "DatasourceName": "CONSUMER-1",

    "Results": "KV01,KV14,KV13,KV12,KV10",

    "Messages": [

        {

            "ResultCode": "KV01",

            "Description": "Address matched"

        },

        {

            "ResultCode": "KV14",

            "Description": "Premise/house number matched"

        },

        {

            "ResultCode": "KV13",

            "Description": "Thoroughfare matched"

        },

        {

            "ResultCode": "KV12",

            "Description": "Locality matched"

        },

        {

            "ResultCode": "KV10",

            "Description": "Postal code matched"

        }

    ]

}


As you can see here, datasources where a match has been found are listed as well as what components of the input had been matched.

Using Personator World

To give a walkthrough of this service, when you send your contact data that you want checked and verified, Personator World starts off by standardizing and validating your data. At this stage, the service will parse and standardize your data as well as check for the following:

·         Name is in a valid format

·         Address is deliverable

·         Email address exists

·         Phone number is callable

Input

Output

Full name: John doe

Phone: 8458692102

Email: john.doe@yaoo.com

Address Line 1: 1 unicorn

City: norwich

Administrative Area:

Postal Code: NR33AB

Country: GB

Full name: John Doe

Phone: +44 8458692102

Email: john.doe@yahoo.com

Address line 1: 1 Unicorn Rd

City: Norwich

Administrative Area: Norfolk

Postal Code: NR3 3AB

Country: GB

 

In the diagram above, you can see the service standardizing (changing casings, abbreviations, etc.) and making corrections to our input data - add in missing street suffixes, add in phone country dialing code, add in missing state/province/administrative area info, correcting typographical email domain errors (yaoo.com -> yahoo.com), etc.

Next, Personator World takes your data and compares it against trusted reference data in order to verify that individual's information.

In this verification stage, the web service takes the standardized name, phone, email and address from the previous checking stage and performs ID verification. Additional input such as the individuals national ID provisioned by the country's government and date of birth can be verified as well, depending on the country.

 

Input

Output

Full name: John Doe

National ID: HJDO840230HVZRRL05

Date of birth: 2/30/1984

Phone: +56-222-226-8000

Email: john.doe@yahoo.com

Address Line 1: Paseo De Los Conquistadores 2000

City: Guadalupe

Administrative Area: NL

Postal Code: 67170

Country: MX

Results:

 

·         KV01 - Address matched

·         KV02 - National ID matched

·         KV03 - First name matched

·         KV04 - Last name matched

·         KV05 - Phone number matched

·         KV06 - Email matched

·         KV07 - Date of birth matched

 

 

 

The diagram above shows how the service will return back result codes indicating which pieces of information got matched. By observing what kinds of result codes are returned, you can determine how reliable your data is.

Availability

Personator World is currently available as a web service hosted on our servers - meaning you won't have to worry about updates and maintenance. Information about the countries supported and the level of coverage can be found by visiting our online wiki at wiki.melissadata.com. Sample code and documentation is also provided to help you get jump started on building applications and services incorporating our ID verification technology.

 

Validating Global Phone Numbers 101: A Quick, Easy Tutorial

| No Comments | No TrackBacks
iStock_000008636701Medium.jpg

By Allison Moon Data Quality Analyst 

With the advent of global communications and business, chances are you are not only capturing addresses of your contacts, but contact phone numbers as well. This is where Melissa's Global Phone Object comes into play.

Global Phone Object validates registered phone numbers in more than 240 countries and territories, as well as enrich your data by appending information such as latitude, longitude, city, predominant language spoken, and more.

Setting up the object is quick and easy, especially if you're a current customer of any other Melissa API.

Here's a quick tutorial:

First, add the Phone Object DLL or .SL file to your project and instantiate an instance of the Global Phone Object:

SET globalPhonePtr as NEW Instance of GlobalPhone

Second, set your license string: 
CALL SetLicenseString WITH LicenseString

Next, initialize the data files:
CALL Initialize WITH DataPath RETURNING Result
IF Result <> 0 THEN
     CALL GetInitializeErrorString RETURNING
ErrorString
    PRING "Error: " & ErrorString
ENDIF

Now you're ready to start validating phone numbers! Using the 'Lookup' method, you can now loop through and feed your contact phone numbers through the object. For best results, pass in both the phone number and country associated with it with the Lookup method. If you require all the digits necessary for dialing internationally from your country, you will also need to pass in the Country of Origin (e.g. the country from which the caller is dialing from).

The outputs returned from the Global Phone Object are useful for call-centers or businesses that would benefit from knowing about the general area the contact is located. For instance, the UTC (Universal Time Code) output can help the caller schedule an appropriate time to dial the contact and the language output can provide the caller information on the language most comfortable for the contact.

The appended regional information, such as the latitude, longitude, locality (city), and administrative area (state) can be sued to get a general sense of where the majority of your contacts are located.

If you're capturing international contact information, the Global Phone Object will be a useful tool in determining registered phone numbers, standardizing phone number formats, and understanding more about where the contact is located.

global-phone-chart-how-it-works[1].png

To test Global Phone for free, go to: http://www.melissa.com/contact-data-verification/global-phone.html

 

Discover Data Quality Issues Before they Arise

| No Comments | No TrackBacks
melissaprofiler.png

By Taky Djarou, Data Quality Analyst


Melissa has released its new data Profiler API. The Profiler Object offers a unique approach to profiling your data, combining years of contact data quality experience, the power of many Melissa Objects, and data source tables to help you dig deeper into your data and return hundreds of properties about the input table, columns and individual values.

For example, many existing Profilers will allow the user to set a RegEx to capture an email pattern. The Melissa Profiler offers that function, as well as checking the syntax, the domain, and whether it's disposable, has a spammy reputation, or is invalid and will return counts that reflect all of the above.

Data validation is also performed on city, state/province, ZIP and postal code fields to report any discrepancies in your data. Even if you accidentally put a phone number in a name field, Melissa's Profiler can detect and report it.

The Profiler Object returns counts of duplicate records using four different matching criteria (Exact, Address Only, Household, and Contact.) Using the power of our flagship deduplication solution MatchUp, the number of unique records, duplicates and the largest group of duplicate counts will be reported for all four matching criteria.

Melissa's Profiler also provides value specific iterators (pattern, word, data, date, Soundex, etc.) that allow the user to loop through any column in an ascending or descending order to retrieve those values and their respective counts.

The date iterator for example, allows the user to see the busiest/slowest time/day of the month/day of the week using a time stamp field of when a record was created.

To demo the Melissa Profiler, please visit us at:  http://www.melissa.com/data/profiling.html or call 1-800-MELISSA (635-4772) and one of our Sales Representatives will set you up with a free trial.

Categories