February 01, 2015

And Then Kevin Is Wrong

There are many times when I'm wrong ... I go into a project with pre-conceived notions of what I expect to happen, I run a series of queries, and then something unexpected happens.

Our instinct, of course, is to immediately torture the data, trying to slice and dice it in a way that yields the answer we're looking for.

Here's one example - I looked at customers with exactly three purchases in 2013, trying to measure how much customers spent in 2014, based on the number of channels they bought from in 2013, and based on the number of merchandise divisions the customer purchased from in 2013.

I didn't have much faith in the omnichannel thesis (more channels = better future value). I had tremendous faith in the merchandising thesis (more departments = better future value).

What do you see?

Channels add value if the customer only purchases from one merchandise division.

Merchandise divisions add value if the customer only purchases from one channel.

Lowest-value customers historically bought from 1 Channel / 1 Division, or bought from 3 Channels / 3 Divisions.

Lesson: Every business is different. Customers exhibit unique behaviors. You have to analyze your own data, controlling for various factors, and find the truth for your own business. In this case, my hypothesis was wrong - and instead of beating the data into submission, it's just better to acknowledge that, in this case, I'm wrong. And that's ok.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Story Time - About Analysts

Let me tell you a story. This one is from Lands' End, nearly thirty (30) years ago. I'm 29 years ago and dumb as a box of hammers. O...