Document 196765
Click to edit Master /tle style • Click to edit Master text styles • Second level • Third level How Click to Seeamlessly dit master C/leanse tle style • Fourth level • Fi8h level & Enrich Your Customer Data All Content © 2014 EXTOL InternaDonal, Inc. presented by Speaking Today Click to edit Master /tle style • Click to edit Master text styles Moderator:" • Second level • Third lMark evel Denchy! Director, International Partnerships! • Fourth level • Fi8h level All Content © 2014 EXTOL InternaDonal, Inc. Presenter:" Patrick Bayne! DQT Software Engineer! presented by © EXTOL International Inc. All rights reserved. Who We Are • Founded in 1985, Melissa Data is a leading provider of internaDonal contact data quality and address management tools. Our soluDons verify, consolidate, enhance and update contact data including name, address, email and phone for improved communicaDons and ROI • Over 130 employees, consisDng of: v Programmers v Data Analysts v Web Developers v MarkeDng v Support v Sales and Sales Engineers © EXTOL International Inc. All rights reserved. Our Clientele Customers in a wide variety of industries, including:" v v v v v v v v Direct Marketing/Mailing Operations Government/Municipalities Universities/Colleges Insurance/Financial Real Estate/Mortgage Food/Retail Automotive Telecommunications © EXTOL International Inc. All rights reserved. How Much Does Bad Data Cost You? " • $611 billion - estimated cost to U.S. businesses annually according to TDWI¹. " - Extra time to reconcile customers" - Delays in deploying marketing" - Loss of credibility" - Lost revenue due to missed marketing opportunities" - Extra costs (e.g. duplicate mailings)" - Customer dissatisfaction and perception" - Compliance problems (Sarbanes Oxley, HIPPA)" - Data integration issues with non-standardized data" ¹The Data Warehousing Institute © EXTOL International Inc. All rights reserved. Remember: Contact Data is Always in Flux More than 100,000 changes (adds, deletes, or modificaDons) every month 40 million Americans and businesses (1 in 6) move annually Quality of stored U.S. addresses declines 17% per year © EXTOL International Inc. All rights reserved. Contact Data is Always in Flux Phone Area Code Splits Disconnected Phone Numbers Email Domain Changes © EXTOL International Inc. All rights reserved. USPS – PriceWaterHouseCoopers Study" Stored Addresses:" " - 23.6% Require correction" " - 2.7% Completely undeliverable" " Additional Costs:" " - USPS currently charges a minimum of 21 cents for address correction and bulk parcel returned as undeliverable cost nearly $2 per item" - Items sent via UPS and FedEx can cost as much as $6 per correction" © EXTOL International Inc. All rights reserved. The Half-Life of Customer Data" • In the U.S. with a population of 316 million the U.S. Census Bureau estimates that annually there are:" - - - - - - - - - - Marriages = 2.3 million" Divorces = 1.2 million" Births = 4.3 million" Deaths = 2.5 million" Moves = 47 million" Total Changes per year = 57.3" Total Changes per month = 4.8" The half-life formula is:" t1/2 = (t ln 1/2)/(ln mf / mi)" t1/2 = ln (1/2)/ln((316-4.8)/316) = 45.4 months means:" • After 3 ½ years - half the records in a typical database are incorrect." © EXTOL International Inc. All rights reserved. Top 7 Data Quality Challenges" NormalizaDon v Name Ordering: Joe VerDdo vs VerDdo, Joe v Address: Main St. vs Main Rd. Apt vs Suite vs # v Phone Format: 8008006245 vs (800) 800 -‐ 6245 Data Accuracy & Validity Data StandardizaDon v Are my addresses deliverable? v AbbreviaDons: North vs N CorporaDon vs Corp LA vs Los Angeles v Casing: JOHN vs John [email protected] vs [email protected] v Misspellings: Main vs Mein Chris vs Kris v Are my phone numbers callable? v Are my email addresses sendable? v Are the names vulgar or suspicious? Inconsistencies v Without any form of Data Quality control, allowing data to come in as-‐is introduces problems. v Human error such typos, misspellings. v TruncaDon and formafng issues from data migraDon. © EXTOL International Inc. All rights reserved. Top 7 Data Quality Challenges" Matching Timeliness v Name: Joe VerDdo vs Joseph VerDdo v Address: Main Street. vs Main St v Company: IBM vs IBM CorporaDon v Address Move Address is old v Area Code split: (714) vs. (949) v Divorce or Deceased v Maiden vs. Married Name v Address is Vacant or Seasonal © EXTOL International Inc. All rights reserved. IdenDty v VerificaDon and Completeness v Does the name match the address? v Do the other contact data elements match? v Is the record complete? -‐ Missing address? -‐ Missing phone? -‐ Missing email? The Answer to Data Quality Challenges: All in one next generation service with four powerful capabilities for data quality and enrichment. © EXTOL International Inc. All rights reserved. Personator™ Check: Address Verification" - Verify & standardize delivery address elements to USPS " - Delivery Point DPV Confirm" - Add missing components such as postal codes, region " - Add missing ZIP+4, carrier route & delivery point codes" - Add missing suite or apartment numbers" - Identify addresses vacant for 90 days or more" - Verify delivery type as residential or business" - Recognize over 5 million non-USPS addresses" © EXTOL International Inc. All rights reserved. Personator™ Check: Geocoding" Append Latitude/Longitude coordinates " - Rooftop geocoding " - Conflates Multi-sourced data for increased accuracy & coverage" - Adds census tract/block numbers, county names & FIPS" " " © EXTOL International Inc. All rights reserved. Personator™ Check: Name Verification" • Increase Response Rates with accurate personalized marketing materials • Parse full names & multiple names Invalid Characters Ordering @@Joseph VerDdo • Correct misspelled names & catch vulgar/ suspicious words • Identify & standardize company names • Identify gender makeup of your list for segmentation & target marketing © EXTOL International Inc. All rights reserved. Cleaned Name Joseph VerDdo Joseph VerDdo VerDdo, Joseph Personator Check: Phone Verification" • Focus telemarketing efforts on active phone numbers " • Verify phone leads as landline, VOIP or mobile; residential, business or SOHO" Various Forma=ng (800) 800 – 6245 8008006245 Invalid Characters " 800***800 6245 Extension (800) 800-‐6245 x827 © EXTOL International Inc. All rights reserved. Cleaned Phone (800) 800-‐6245 Personator Check: Email Verification" • Focus marketing efforts on active emails & create alternate marketing channels • Correct formatting & Invalid Characters john###@gmail.com Unstandardized syntax errors • Validate & correct top level domain names • Verify domain exists through MX lookup [email protected] Syntax Errors john@@@gmail.com • Validate against a proprietary database of domains Misspellings [email protected] Coming: Soon: Full mailbox validation © EXTOL International Inc. All rights reserved. Cleaned Email [email protected] Personator™ Verify: Crossmatch Verification" • Boost confidence in the data • Compares incoming records against multi-sourced data sets: • telecom, USPS, title and deed, financial and GIS data sets • Verifies that the address, name, phone & email match the same person for fraud prevention • Advanced Address Correction (AAC) – correct and append most current address data © EXTOL International Inc. All rights reserved. Verifica/on: Input Output James Douglas 22382 Avenida Empresa Rancho Santa Margarita CA (123) 456-‐7890 Results: VR01: Full name and address match VR02: Phone not found in reference data AAC: Input Output James Douglas avenida empresa 92606 James Douglas 22382 Avenida Empresa Rancho Santa Margarita CA 92688 Personator™ Append: Record Completion" • Adds missing contact data or overwrites bad or outdated data • Adds address, name, phone, and/or email data to a record Input Output Address: 22382 avenida empresa Postal Code: 92688 Full Name: James Douglas Address: 22382 Avenida Empresa City: Rancho Santa Margarita State: CA Postal Code: 92688-‐2112 Phone: 949-‐589-‐5200 © EXTOL International Inc. All rights reserved. Personator Move: Update movers" • Identifies move records before your next mailing or campaign" • Has over 10 years of Move-Update history " Move: Input Output Bud Walker 21624 Via Pera Mission Viejo CA 92691 Results: Bud Walker 21243 Beechwood Way Lake Forest CA 92630 © EXTOL International Inc. All rights reserved. Personator: Free-‐Form Parse Patrick Bayne 22382 Avenida Empresa Name Address City State Zip Phone Email Geocordinates © EXTOL International Inc. All rights reserved. 92688 800-‐800-‐6245 [email protected] Personator: Free-‐Form Parse Patrick Bayne 22382 Avenida Empresa Name Address City State Zip Phone Email Geocordinates © EXTOL International Inc. All rights reserved. 92688 800-‐800-‐6245 [email protected] Personator: Free-‐Form Parse Name Address City State Zip Phone Email Geocordinates Patrick Bayne 22382 Avenida Empresa Rancho Santa Margarita CA 92688 800-‐800-‐6245 [email protected] 33.637550,-‐117.606840 © EXTOL International Inc. All rights reserved. Personator: Coming Soon….." • Demographics append for the Personator service" - - - - - - - - Date of Birth" Dwelling Type" Income" Marital Status" Length of Residence" Presence of Children" Occupation" Homeowner or Renter" " © EXTOL International Inc. All rights reserved. C o mi n g Soon… Personator™ Benefits" • Certified Accuracy: Clean, Valid, and Up-to-Date Data" • Confident: Name and Address Matched and Verified" • Cost Savings: Postal Discounts, Reduced Undeliverable Shipments, Marketing, Fraud Prevention" • Campaign Intelligence: Accurate and Up-to-Date Location Information (Geocoding)" • Completed: Missing Data Elements Appended" • Compliant: Meets and exceeds industry recognized quality standards" " © EXTOL International Inc. All rights reserved. Click to edit Master /tle style • Click to edit Master text styles to Seamlessly Cleanse & Enrich Your Customer Data • How Second level • Third level Ques/ons? • Fourth level • Fi8h level All Content © 2014 EXTOL InternaDonal, Inc. presented by Next S teps… Click to edit Master /tle style Take the plunge and sign up for a FREE Data Quality Audit p to 10,000 records and we’ll provide you with a free analysis that includes: • Click tSend o eudit Moaster text styles Number f Address corrected of Suite/Apartment Numbers added • Second Number l evel Number of Rural to City updates • Third level of Invalid addresses Number Vacant addresses • Number Fourth olf evel Number of Individuals, Families or Companies that have moved • Fi8h level records Number of Duplicate www.melissadata.com/audit-‐extol Learn more about EXTOL: w: www.extol.com/info e: [email protected] All Content © 2014 EXTOL InternaDonal, Inc. presented by
© Copyright 2024