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

Even your online directory is out of date!

May 5, 2021

Even your online directory is out of date! Back in the day of printed directories, […]

Start small

April 28, 2021

Start small When I work with my clients on projects that involve measuring member engagement, […]

Some context, please

April 21, 2021

Some context, please A pet peeve of mine: A report about associations (e.g., marketing benchmarks report) where […]

Eventually automated emails get ignored

April 14, 2021

Eventually automated emails get ignored During the discovery and development phase of implementing a new […]

The challenge the AMS providers see

April 7, 2021

The challenge the AMS providers see Over the years I’ve asked AMS providers what they […]

Be careful about “solutioning” too quickly

March 31, 2021

Be careful about “solutioning” too quickly One of the great things about software developers is […]

What’s our next action?

March 24, 2021

What’s our next action? As you can imagine, I spend a lot of time in […]

Don’t automate for the sake of automation

March 17, 2021

Don’t automate for the sake of automation I’m the laziest person in the world. I […]

Don’t forget about what got better

March 10, 2021

Don’t forget about what got better Negativity bias is the tendency to focus on only […]

Give a little at a time rather than taking away

March 3, 2021

Give a little at a time rather than taking away I’m sure there’s research somewhere […]

Leave a Comment

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

Scroll to Top