A great example of a data integrity report!

A great example of a data integrity report!

A couple months back I discussed the importance of data integrity reports. One of my past clients and a longtime reader, David Churchill at Grantmakers in Health, offered up this idea, which I think is fantastic and should be added to any association's list of data integrity reports.

As he explains: "I found that there’s a lot of email address mistakes made during our online registration process. It's not always easy to spot simple typos like .cmo (.com), .ogr (.org) so I created a query that is titled “questionable top level domains” that shows any record with likely typos (or .ru which is largely spam)."

One reason I love this query is that it's designed to capture "common" errors with the knowledge that it won't catch every error. And it has the added bonus of looking at addresses that are likely spam.

But what a great idea! If a customer mistypes their email address, other than checking bounced emails in the future, how will anyone know there is an error? By proactively checking for errors, David is weeding the garden, which is critical to long-term data management success.

Wes's Wednesday Wisdom Archives

Your RFP should go to no more than five vendors!

July 17, 2024

Your RFP should go to no more than five vendors! As a rule, when I […]

Be concise!

July 10, 2024

Be concise! I started a monthly newsletter almost 25 years ago (which I recently discontinued). […]

“If you keep doin’ what you’re doin’, you’ll keep gettin’ what you’re gettin’.”

June 5, 2024

“If you keep doin’ what you’re doin’, you’ll keep gettin’ what you’re gettin’.” I saw […]

Rather than adding something new, try subtracting

May 29, 2024

Rather than adding something new, try subtracting I read recently that sociological research suggests, when presented […]

It’s always people, process, and technology

May 22, 2024

It’s always people, process, and technology I speak and write a lot about people, process, […]

Once it’s lost, trust can be difficult to regain

May 15, 2024

Once it’s lost, trust can be difficult to regain I recall hearing once long ago […]

Share your successes!

May 8, 2024

Share your successes! I was speaking at an association meeting recently and one of the points […]

What are YOUR data integrity reports?

May 1, 2024

What are YOUR data integrity reports? Sitting in an AMS demo with a client recently, […]

You might have to do SOME of the work yourself!

April 24, 2024

You might have to do SOME of the work yourself! Many, many years ago I […]

Don’t manage to the exception!

April 17, 2024

Don’t manage to the exception! One of the universal truths about data management is, wherever possible, […]

Scroll to Top