Trends don't need perfect data
When it comes to analyzing data trends (changes in data over time), it's important to keep in mind that the data does not have to be perfect (data never is!) in order for it to be useful.
In a conversation with a client recently, the client pointed out that their membership dashboard over several years is not 100% accurate, and therefore can't be trusted. They explained that some of the data for certain years was inaccurate (sometimes as much as only 95% accurate). And thus they didn't think the trending data was useful.
But here's the thing: the point of trending data is to see trends. Is membership growing? It is flat? Is it shrinking? Unless you're dealing with really small data sets (e.g., 50 members), a few percentage points off perfect is unlikely to affect the overall trends.
As the old saying goes, don't let perfect be the enemy of good. If you're trying to detect trends, "close enough" is very likely to get you the information you need to act.
Wes's Wednesday Wisdom Archives
Baby Steps
One of the keys to developing good data management habits is to be aware of […]
Success Requires Discipline
When it comes to data management, most of us know what to do; we just don’t […]
Take a moment to be grateful
Because we’re so focused on always improving what we have now, it’s easy to overlook […]
KPIs and Dashboards
I saw DJ Muller from MemberClicks speak on KPIs (key performance indicators). In his session […]
Documenting Process is Critical
When it comes to managing data successfully, process is critical. For example, a client of […]
Motion vs. Action
In James Clear’s book Atomic Habits (I recommend it!), he discusses the concept of motion vs. action. […]
Are You Answering Your Calls?
I’ve written about this before, but apparently I have to keep repeating it. If you’ve […]
Who do you trust?
Who Do You Trust I was reading an article recently about Warren Buffet’s “rules” for […]
Set benchmarks to measure progress
It’s impossible to measure progress if you don’t know your starting point. This sounds axiomatic, […]
You’ll make incorrect decisions. Acknowledge them and fix it.
A client of mine recently wrote the following to me: “It’s so hard to set […]