Showing posts with label data. Show all posts
Showing posts with label data. Show all posts

Sunday, March 2, 2008

Net Promoter Score

I'm doing some work for a client around Net Promoter Score at the moment. It's run by a company called Satmetrix.

Net Promoter Score (NPS) is a bit of a twist on recommendation/referral scores. It subtracts people who aren't likely to promote/refer your brand from those who are. The result is a score that fluctuates as both ends of the referral spectrum change.

It's not a bad idea. Makes lots of intuitive sense. And in general, I'm a fan of calculated metrics like this as they are more sensitive to variance than straight averages.

Satmetrix released a white-paper to explain the nuances of how NPS is calculated.

I loved everything about the NPS score until I read the white paper. Way to destroy an easy, intuitive and relatively obvious concept with some not so easy and less obvious logic and statistics.

There are two main things I didn't like about the way they presented the score and how it was calculated.

Firstly, this is a graphic of the inputs into their model:

(Sorry for the low resolution, I can't seem to get it much higher)

This is a pretty standard regression set up. On the left you have a bunch of things you think affect the things on the right. The things on the right (Behavior and Referral) are what you are trying to 'predict'.

The red flag was why have referral on the right? Especially when on the left you have 'likelihood to recommend'??? Essentially, you are attempting to predict referral behavior with intent to refer. Hmmm, I wonder if those might be related? Of course they are. You don't need a model to tell you that.

Why not just try and predict purchase behavior? That is, after all, what you are wanting to affect through good customer service.

The only reason to keep referral on the right is to make the result stronger. And sure enough, they get some high correlations - 80% of the time, Likelihood to Recommend was the strongest correlate with 'Behavior'.

But it's not really 'Behavior' - it's 'Behavior/Referral' and you are using things you know will affect referral ('will you refer me') to prove your point. It's like using rainfall to predict water levels and then being amazed when it does.

Ok, so there are some issues with the model. I could easily let that slide, they have all this in-market data collected over years of analysis to prove the usefulness of NPS.

Like this...


Again, I it took me a couple of looks to believe my eyes. They are calculating an almost 90% correlation between NPS and 5 year revenue growth based on what are essentially three outliers.

The thing with linear correlations like this is that if they aren't weighted in some way, one (or a few) outlining points push the correlation up (or down) significantly. In this case, take out Southwest and Alaska and the relationship takes a dive.

Besides, should it even be linear? Surely a brand like Southwest should benefit MORE from a higher NPS as recommendations will propagate virally in a way - more recommendations mean more trial, which mean more recommendations.

Considering the complexity of what makes up 5 year revenue growth, I would be AMAZED if you could eyeball a relationship like the one above and actually SEE the effect of customer referrals. It's in there somewhere, but it's not likely visible.

So, while I like the idea, the evidence leaves a lot to be desired.

UPDATE:

Just came across an article that does some validation research on NPS. Not surprisingly, it couldn't replicate the original NPS results. And this quote from the inventor Frederick Reichheld is interesting:

All we did was quantify this common sense in a way that made sense to business leaders—the target audience for my book. These practical leaders have little interest in advanced statistical methods. Frankly, we see little value in continued debate about cause versus correlation, timeframes, or statistical methods.
If I was an executive in company that got sold on this score, I'd find that a little condescending!

Digg this
Sphere: Related Content

Tuesday, December 4, 2007

We live most of our lives between 0 and 100

I just came across this nifty applet that lets you look at the popularity of every number between 0 and 100,000 - based on the results of a prominent search engine.


Not surprisingly, we live most of our lives happily ensconced between 0 and 100.

I don't think there is anything earth shattering about this - it's pretty much common sense. But it's nice to see it displayed - that 'aesthetic' value of information again.

It also reminded me of a use of this type of distribution that is not commonly known. Apparently you can tell if someone is cheating on their tax forms by looking at the distribution of integers they use. If it's more perfectly random than it should be (too many numbers with the same frequency of occurrence), they might be cheating. Normal tax returns should have skewed distributions - more 1s than 7s for instance. When we cheat, we tend to be a bit too random - some important advice there.

I can't find a link for this though, but I know this type of phenomena has a name... need to do some digging.


PS: I don't condone tax fraud. I love the IRS. No, really, I do.

PPS: Isabel came to the rescue and just commented that the phenomena is call Benford's Law - thanks Isabel, I needed that. Was driving me crazy.

Digg this
Sphere: Related Content

Monday, August 6, 2007

The greatest ever data visualization

This is an oldie (at least in web terms), but a goody.

Link to the video (I couldn't get it embedded due to some login error).

I showed this to a colleague of mine who was about to buy a house - I think it left a bad feeling in the pit of his stomach (nothing to do with the ride itself).

Why is it the greatest data visualization ever? Because it makes one point, and one point only in the most effective way possible - scaring the bejeezes out of you!

Thanks to the guys at Freakonomics for first pointing it out.

Digg this
Sphere: Related Content

Wednesday, July 11, 2007

Forgot to mention Swivel...

The previous post forget to mention Swivel - a valley start-up that is looking to democratize the world's data. Its premise isn't far from the Many Eyes mission.

I love to see people starting things like this, and it looks as if Dmitry and Brian (the founders of Swivel) are getting quite a bit of recognition - good on 'em.

However, having been back and forth on Swivel for a while (it completely slipped my mind when posting below), it's tough to get a sense for the community. There are lots of graphs and data sets, but little rhyme or easily understood reason to a lot of it. Some groups have discussions, others (it feels like the majority) are void of life.

I think it goes back to the problems of trying to build a community around data - most of it is meaningless without a good deal of context and explanation.

Still, it's only been 7 months since the site launched, so we're in the early days. I'd love to see it succeed, but it needs another hook...

Oh yeah, Freebase is doing something related.

Anyone know of any other sites?

Digg this
Sphere: Related Content