When is the best time to clean your data?

When is the best time to clean your data?

One of the most common questions I get from my clients who want to clean up their data is "This is all so overwhelming. Where do we start?"

My response is typically: "Start somewhere, and start today."

I've heard a variation of this phrase applied to many different worlds (e.g., exercise, planting a tree), and I'll use it here. "The best time to start cleaning your data was 20 years ago; the second best time is to start today."

The thing about data is it's never completely "clean." You will always have some bad data. But the only way to make sure you don't have a lot of really bad data is to clean it as frequently and effectively as you can.

So where to start? Maybe start with your board list. Or some subset of your members (e.g., everyone with a last name starting with A). Or everyone who attended your last meeting.

Pick a set of data, clean it up, and them move to the next set of data. But whatever you do, start today.

Wes's Wednesday Wisdom Archives

Just start. And it’s never done.

August 27, 2025

Just start. And it’s never done. Last week I had the opportunity to lead a […]

Don’t ask if you’re not going to answer!

August 20, 2025

Don’t ask if you’re not going to answer! In the past week, on three different […]

Seek forgiveness rather than permission

August 6, 2025

Seek forgiveness rather than permission “Seek forgiveness, not permission.” I can’t remember when I first […]

Is a 360 degree view necessary?

July 30, 2025

Is a 360 degree view necessary? “A 360 degree view of our members should NOT […]

Why data matters

July 23, 2025

Why data matters I write about data because managing our data effectively will help us […]

It’s about process

July 16, 2025

It’s about process I’m in the midst of adding an AI agent to my website […]

Data integrity reports

July 9, 2025

Data integrity reports I speak and write a lot about data integrity reports. So I […]

The most important training tip

June 25, 2025

The most important training tip I’ve been sitting in a lot of database training sessions […]

Be careful about getting tangled

June 18, 2025

Be careful about getting tangled “We had done a lot to tangle ourselves up.” – […]

Discipline. Always discipline.

June 11, 2025

Discipline. Always discipline. I’ve been producing a newsletter in some form for over 25 years […]

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top