Leaking Profits? Plug up the UAA Drain!

Melissa Team | Address Check, Address Correction, Address Quality, Address Standardization, Address Validation, Address Verification, Article, Direct Mail, Mailing, Mailing & Shipping, Mailing Lists, NCOA, PAVE Certified | , , , , , , , , ,

Are you struggling to keep printing postage and service costs down? One culprit that could be putting a drain on your profit is return mail. You’d be surprised how undeliverable-as-addressed mail (UAA) can operate like a small tax on your business – costing a little bit in a lot of areas. Turn to page 24 in Mailing Systems and Technology’s June issue to see Melissa’s article: Taking Action to Void Undeliverable-as-Addressed Mail. It details the causes, affects and ways to prevent and deter this expensive, yet avoidable, tax on your business.

Hip, Hip, Hooray! The Elephant Gets Addressed Today.

Melissa Team | Address Check, Address Correction, Address Quality, Address Search, Address Standardization, Address Validation, Address Verification, Data Enhancement, Data Enrichment, Geocoding, Global Address Verification, Identity Resolution | , , , , , , , ,

What’s the elephant in your business? Every company has one! I’m talking about the thing that costs you money, customers and insight. Could it be returned mail? How about fraudulent transactions? Whatever the problem, it all stems from one big beast – bad address data. Customer communication, fraud prevention, predictive analytics and ultimately, your bottom line, all hinge on the quality of your address data. Don’t believe me? Allow me to show you.

Curate Creative Communication

The poorest form of communication is none at all. Losing touch with your best customers, unpaid invoices, undelivered merchandise – all caused by an inaccurate address. However, obtaining and maintaining correct address data means you reach your intended recipient. But, it also means you gain deeper customer knowledge. Data appends are designed to take a small piece of your customer’s profile, and create a whole picture.

Let’s start with contact information. From an address, you can append contact details such as full name, phone number, email address and social handles. By adding more contact info, you can create personalized, multichannel marketing campaigns, or reach your customer via their preferred method of communication for higher response rates.

With a single address, you can also access an encyclopedia of information about a single person or an entire household. Using demographics and psychographics, messages can be tailored to fit your audience. Completing your customer avatar also helps you identify the unique attributes of your best customer so you can target prospects just like them.

Fraud-Fighting Fitness

Identity verification is the most important aspect of protecting yourself against fraudulent transactions. This becomes a much faster process with correct addresses. With clean address data, identity verification becomes a matter of quickly cross-referencing name and other contact information to that valid address. With Melissa’s Personator Web Service, this can be done in real time.

Identity verification is integral to any fraud prevention routine. It will hinder money-laundering schemes, identity theft and many other forms of fraud that infect the internet today. Maintaining compliance with KYC and AML initiatives not only protect your organization, but your clients as well.

Powerful Predictive Analytics

Predictive analytics are only possible with clean, correct and current data. Without correct data, business decisions based on faulty analytics could have far-reaching and long-lasting negative impacts. GeoCoder® corrects, updates and appends addresses, then converts that written address into exact longitude/latitude coordinates. This creates a compelling visual map of your customers’ addresses for analytical consumption as well as logistics and marketing.

Once your addresses are standardized and up to date, you can add location intelligence. Geographic information like census tract/block number, voting district or county name with FIPS code, helps optimize route planning and resource allocation, enrich data for analytics, utilities management (water/gas/waste), and risk assessment.

The Bottom Line

77% of companies believe their bottom line is negatively affected by inaccurate and/or incomplete data. Bad address data causes waste associated with undeliverable mail and lost opportunities to connect with your clients. It makes fraud prevention more cumbersome and reliable analytics impossible. Customer satisfaction plummets and too much time is spent correcting errors caused by inaccurate data. Bad data almost always means lower profits.

Name It and Tame It

We encourage organizations of all types to address the elephant in their business. See what’s costing you money, clients or insights. Once you do that, it’s easy to tame it. Global Address Verification is a perfect start. It will verify, standardize and update addresses for 240+ countries so you can increase ROI, reduce fraud and enable better business decisions.

Address Experts

Melissa has been in the business of data quality for more than 30 years. We’re called the “address experts” for our deep domain experience in address management. Our philosophy is this – if you have a correct address, why not know more? Melissa can help with each aspect of transforming your address data into comprehensive customer profiles, fraud prevention initiatives and predictive analytics to drive reliable business decisions. Melissa will help you name and tame your elephant. Call 1-800-MELISSA or visit sign up to learn more, here.

Melissa’s Clean Suite Fights Dirty Data in CRM Platforms

Melissa Team | CRM, Data Cleansing, Data Enrichment, Data Quality, News & Events, Salesforce | , , , , , , , ,

Vibrant Data Protects Customer Experience and Boosts Value of Omnichannel Marketing; Demos at Dreamforce #DF18

Rancho Santa Margarita, CALIF – September 26, 2018 – Melissa, a leading provider of global contact data quality and identity verification solutions, today announced its Clean Suite for CRM, comprehensive data quality tools and services that provide clean data for successful omnichannel marketing. Optimized for Salesforce, Clean Suite verifies, standardizes, corrects, and appends customer contact data records – fueling marketing efforts with information that protects resources and results.

Melissa’s Clean Suite is a full-featured toolset that verifies, corrects, and standardizes global names, addresses, phones and emails in real-time so only the freshest data enters your CRM. Tapping into Melissa’s extensive multi-sourced data, records are cleaned, updated, deduped, and enriched to add value across the spectrum of enterprise needs. For example, via real-time operations or batch processing, users can add business firmographic data, demographics, and geographic data to improve targeting, segmentation, and lead scoring. Capabilities such as autocomplete addresses further ensure correct data enters the system, while also reducing cart abandonment, increasing conversions, and improving fulfillment.

Clean Suite is Lightning ready, and supports standard and custom Salesforce objects. Users can access easy-to-build individualized interfaces and verify data within their own custom templates.

Melissa will be demonstrating Clean Suite tools and strategies at Dreamforce, Booth 121, at Moscone Center in San Francisco, September 25-28, 2018. Click here to gain more insight on Melissa’s Clean Suite or to access a free trial. To connect with members of Melissa’s Salesforce data quality team outside the Dreamforce event, visit www.melissa.com or call 1-800-MELISSA.

Salesforce, Lightning and others are among the trademarks of salesforce.com, inc.

jQuery UI and Auto-Complete Address Entry

Blog Administrator | Address Check, Address Correction, Address Quality, Express Entry | , , , , , ,

By Ian Elliot, i-Programmer Author

jQuery UI has a
little-known feature that makes interactive auto-complete very easy. In this
hands-on tutorial we put it together with the cloud-based Global Express Entry
address auto-complete service from Melissa to smooth over one of the biggest
problems in getting users to sign up.

There are many things that
users hate having to do on a website, but they all come down to the same thing
– they hate having to do work. Of all of the things you can ask a user to do,
typing in their name and address probably qualifies as one that involves most
work. How many potential customers give up on a purchase because they find
typing in a full address too irksome. Even if they do go through with it, how
can you be sure they have done it correctly. Most users aren’t expert typists
and easily make a mess of their data entry. The cost of trying to ship
something to an invalid address is obvious.

The best idea is to
provide instant feedback on any data entry field. Don’t wait until they have
finished the complete form and then nag them about some mistake you could have
picked up while the field had the focus. If possible provide autocomplete so
that as they type their choice is narrowed down to the point where they can
simply click to select a data-perfect validated entry.

This is where jQuery UI’s
autocomplete widget comes into the picture. It makes adding autocomplete to any
field that can accept input. As an example of using it let’s make an
autocomplete feature for an address – the most work you can ask a user to
perform – using a cloud service that is remarkable for its ease of use and
comprehensive coverage,

Provided with the bare
minimum of an address, Melissa Global Express Entry, will autocomplete and
verify an address from anywhere in the world returning a full address in the
standard format accepted in the country concerned. Any address can be converted
into the “Latin” alphabet and, to aid delivery services, maps showing
the latitude and longitude based on Google maps are provided. The onsite demo
has examples and lets you experiment freely:

 

Obviously, not all
countries are verified to the same level, but I think you’ll be impressed by
coverage of over 250 countries with 200 of them at street level or better.

 

You can see a full list
of coverage at: Address Coverage by Country.
Currently there are 51 countries at address verification level 2, locality, the
lowest level represented, including Antarctica, British Virgin Islands and
Western Sahara. A further 77 countries, including Afghanistan, Barbados,
Bolivia, China and Ghana are at level 3. The most common classification, 77
countries, is level 4 which applies to Japan, India and many European
countries, including Austria, Belgium and Spain. Level 5, which get to
individual premises is available for 30 countries, notably USA, Canada,
Australia, Russia, France, Germany, Greece and the UK.

With regard to mapping,
this is provided at locality level for Hong Kong, at the equivalent of address
level 4 for 33 countries including Australia and most of Europe and at the
equivalent of the top level for USA, Canada, Australia, Czech Republic,
Germany, Russia, and Ukraine.

The cloud service uses a
simple REST API and returns XML or JSON. You can also use a desktop version and
there are plugins for Excel and other apps.

Adding Express
Entry 

Here we look at adding
it to a simple form.

To try this example you
will need a key which you can get as part of a free trial.

First we need to use
jQuery to add autocomplete to a form element.

<link rel="stylesheet"
href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">

<script
src="/https://code.jquery.com/jquery-3.1.1.js"
integrity=
"sha256-16cdPddA6VdVInumRGo6IbivbERE8p7CQR3HzTBuELA="
crossorigin="anonymous"></script> 
<script
src="//code.jquery.com/ui/1.12.1/jquery-ui.js"></script>

Basically all we are
doing here is loading the latest jQuery, jQuery UI and a basic stylesheet.
Update to the latest version of any of these in the future and everything
should still work.

We also need a basic
form to input some addresses. As with all examples, the simpler the better:

<form onsubmit="return
false;">

  Address:
 <input id="address"
type="text" 


style="padding:2px;width:308px;">

 </br></br>
 <textarea cols="40"
rows="6" id="result" 


style="padding:2px;width:390px;">

 </textarea>
 </br>
 <button id
="clearbutton">Clear</button>

</form>

You can see that we have
an input text field for the user to start to type the address and a text area
ready to display the address.

The way that the
autocomplete widget works is very simple and typical of the way all jQuery UI
widgets work. To create the widget all you do is call its constructor function,
which always has the name together with an options object which specifies how
it looks and behaves.

In the case of the
autocomplete widget, all we have to do to add the feature to the address text
field  is:

$('#address').autocomplete(options);

Of course, we have to
specify options to make it do what we want.

The most important
option is source which specifies where the autocomplete data comes from. It can
be an array of strings or an object containing label value pairs or it can be a
URL as a string or a function.

The array of label value
pairs is particularly useful because the label is shown to the user so that
they can pick the correct autocomplete, but it is the value that is inserted
into the field. This allows you to provide the user with data in one format,
but enter it in another.

The array and strings
option is used to provide local autocomplete data the other two are used when
the data comes from a server.

For example:

$('#address').autocomplete( 
  { 
    source:
["choice1", "choice2","choice3"] 

  }
 );

In this case when the
user types a c the list of three possible autocompletes appears.

 

Notice that autocomplete
is doing quite a lot of work for you. You don’t have to arrange the data or
select what is going to appear when the user types. In addition, if the user
selects one of the items it is entered into the field.

Using local data in this
way has the advantage of being fast, but in most cases the autocomplete is
going to be far more complicated and you are going to need to contact a remote
server. The autocomplete widget allows you to specify a URL that it will get a
JSON or JSONP response. In this case it doesn’t filter the result and so the
server needs to use the GET query parameter term to find out what the user is
typing. 

In most cases you are
going to want to use the final option, which is to provide a function that gets
and processes the data. This function has two parameters – a request object
with a single term property which stores what the user has types so far, and a
response callback which has a single parameter which is the data to suggest to
the user as string or an array. 

So for example:

$('#address').autocomplete( 
  { 
    source:
function(request,response){

      get the data from the server
passing


request.term as the expression to be


autocompleted.
 
      response(data);



  }
 );

 

More on Melissa Express Entry: https://www.melissa.com/address-autocomplete

 

Article Copyright © 2017 i-programmer.info. All
Rights Reserved.

 

Storing International Postal Data

Blog Administrator | Analyzing Data, Analyzing Data Quality, Data Quality, International Address Verification | , , , ,

By Charles Gaddy

I’m sitting in my favorite coffee shop, scanning the patrons in the room. One
thing came to mind – this restaurant reflects a good cross-section of America. I
took an impromptu poll among some of the people I met over the course of a month to ask two
questions:

1. Do you think you could make an international phone call?
2. Do you think you could address a letter to Germany?

These may seem like simple activities, but for the average American, I feel they
are quite challenging. Of my “back of the napkin” survey about seven out of 10
felt they could make the call, and two out of 10, the address. However, when
asked how to address a letter they mostly replied – “just like in the U.S., but
with a Country at the end.”

This drives home the idea that in the U.S., businesses are just now starting to
focus on international markets. I know that if I asked someone from the EU or
from Great Britain, they would be knowledgeable in telephone country codes,
shipping to mainland Europe from the UK, etc.

US Globe

What I am hoping to address in the next several blog postings are the necessary
guidelines for the configuration and storage of postal address data in a
database table or tables, which is flexible around address format, structure,
postal code indicators, and alphabets/languages.

How to Account for International Address Formats in a Database Table

In the past, I have done database work with domestic and international
companies. One very specific example, which is relevant to this blog post, is a
major international airline. This airline started as a U.S. domestic carrier and
has expanded over time into Central and South America as well as the PAC RIM and
Europe. The legacy systems they had in place stored address data in a classify
U.S. format: Address1, Address2, Address3, City, State, ZIP Code.

US Mail Format

My company was hired to do postal address verification, correction, and
standardization on their international data and put it into this legacy system.
Immediately, you can see the challenges. ZIP Code in the U.S. is a number; in
the United Kingdom, Canada, and others – it’s alphanumeric. In Mexico there can
be as many as eight address lines as well as three administrative – a village,
district, province model which does not fit with the classic U.S. city and state
model. Even the best of address verification and correction cannot account for
“putting a square peg in a round hole,” which is these legacy structures.

In the next blog post, I will suggest an optimized format for storing address
data within a single database table.

United Kingdom Mail Format