Anyone use Experian to manage their data quality? We rarely use mailing addresses, but we do use emails a lot... Anyone have a feedback on whether they find Experian worthwhile (or not) for email data?
Thanks!
Carrie
Hi Carrie, We're considering moving away from Experian as we've not found the integration particularly user friendly. I just use a basic regex to test emails, not perfect but catches a lot of the basic attempts to fake email addresses. Regex code below, should work with most coding languages and it's free!/^(([^<>()\[\]\\.,;:\s@"]+(\.[^<>()\[\]\\.,;:\s@"]+)*)|(".+"))@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}])|(([a-zA-Z\-0-9]+\.)+[a-zA-Z]{2,}))$/ThanksWill
This is awesome, thank you so much!
That is one complicated looking regex. Thanks for sharing.
Hi Carrie,
We implemented Experian QAS when I worked at the Sydney Opera House in 2014/15 which was used for both postal and email address validation. It worked quite well but was not a cheap service. I don't know if SOH continue to use the product with their recent website redesign. It was a huge benefit to have data enter Tessitura from the website or the client validated and standardized but not sure if the cost was worth it (I recall the email validation tool only worked in Tessitura for postal addresses but not email but could be wrong on that). The other option is to later run batches of your data through any number of services to validate and standardize.
Unrelated but I also worked with Experian here in the U.S. for data appends and did not have a positive experience. We found a number of problems in the data the provided back and that may have been due to one-off errors or corruption in the files. It was hard to ever determine what was the cause and get to a resolution due to their poor customer service so we changed providers.
Chuck
Out of interest Chuck who are you using now? I'm on the hunt at the moment.