Three things about data

Share
Three things about data

Some recent conversations have reminded me that I have opinions about data and its use inside organisations. Especially for marketing-type stuff.

Here are three of those opinions

Gather less of it

A few years ago in a sales meeting some ad-tech person said 'I bet you wish you had more data on your customers' and the my perpetually contrary inner voice said 'oh no I don't, I wish I had far less'. I may have actually said it. I may have said 'No I don't, I wish I had less, and if you came to me promising an effective service with far less data I might have been interested.'

That's what I'd have said now.

Because:

a. Data is a risk. Every bit of data has to be managed/looked after/cared for. That costs time and money. And most of it is useless.

b. Data is distracting. Most of it is just noise. You're gathering it because you can, just in case, because it seems valuable. Then you spend ages trying to work out what to do with it. When you should be paying attention to just a couple of bits of it and actually doing something about it.

c. It becomes a job. Get enough data and you need data scientists. Then you're stuck in a self-perpetuating structure that requires more data to feed the data scientists.

The best expression for all this I've ever seen is from James Timpson, a column in The Sunday Times towards the end of the pandemic. Here's a (long) excerpt:

"I vividly remember being shown the charts room in fund manager Fidelity’s huge London office. There were graphs of everything under the sun. Was the theatre of the chart room the big sell to clients, or was it a useful tool for the analysts? No doubt Debenhams’ bosses had lots of facts at their fingertips, but data didn’t help them save the business.

Now our shops are open again and everyone is back at the office, the data is pouring forth. We have a culture where we want to produce as little information as possible, but it can feel like watching a dripping roast, with statistics flowing from every department at an alarming rate. With 2,100 shops, there’s always lots of information to consume and my eyes can quickly glaze over.I prefer to focus on a few things, as well as the basics of retailing. Are the shops open? Is everyone happy? If so, we can start taking money.

There must be a point where the costs of interpreting and using data exceed the benefits of collecting it. Can you afford a chief data officer paid £120,000 a year plus bonus? We can’t, so instead we have three simple ways of understanding what’s going on.Every night at 7pm, I get an email listing that day’s sales. This data isn’t collected by an “Epos” (electronic point of sale) till system, but by colleagues filling out a form online. They also write the sales numbers on a piece of paper and keep it on a bulldog clip. This takes five minutes a day. It sounds old-fashioned, but when people physically write things down they seem to take more notice. If you ask our colleagues what their sales are so far today, I bet they’ll know to within the nearest £50.

Over the past 25 years, we have acquired a number of (loss-making) retail chains. The first thing we do is switch off their Epos tills. All we need is a drawer to keep the cash in and a calculator to add up the sales. We have thrown away more than £8 million of kit — and it’s made life easier for us.The businesses we bought were often collecting vast amounts of data from their fancy tills, yet the managers were actually reading very little of it, and it rarely helped colleagues give better customer service. As sales plummeted, they analysed more data, and brought in more finance experts and consultants to work out where the problems were. Redundancies weren’t made from the data team — it was the people on the front line, serving customers, who lost their jobs first. These companies failed because they lost focus on what’s important: great customer service.

So our second barometer is customer service scores, which I look at every day. We ask customers to use an online form to rate their experience out of ten (our average score last week was 9.4). Every colleague sees their feedback in real time, and if we get a bad score our area managers are expected to call the unhappy customer straight away to apologise and fix the problem.

One piece of data beats everything else. A quarter of a century ago, my dad taught me the best way to measure the health of our business was to look at the cash figure every day. Each morning at 10am, I get an email from Caroline in the finance team showing the cash we have in the bank compared with the same day last year. This fact offers no hiding place."

Here's the whole thing

Keep it in your hands

Data is most useful when it's in the hands of the teams who create it or need it. The more it gets abstracted away to other teams and other softwares the more dangerous and misleading it gets.

So start off with writing it on pieces of paper or sticking it on the wall. Graduate to spreadsheets only when you have to. Move on from spreadsheets very, very reluctantly. Dashboards are dangerous. Everyone knows the stories about pilots flying into the ground while staring at their instruments. Dashboards abstract away the reality.

The trick is to keep the data in your hands. Get it from the source yourselves, regularly, daily, weekly and copy it into your spreadsheets then get together and talk about what you're seeing. Yes, you might have transcription errors but you should catch them because you know the data directly.

You know, because you've been sticking it in a spreadsheet every week, how many subscribers you have. Or whatever. That's different to seeing it go green on a dashboard or seeing the lines on a pie chart move.

This has the additional advantage of matching the fidelity of the presentation to the quality of the data. When you don't have much data - and therefore don't know much - then keep it scratchy and on paper. It might look less whizzy but it reminds you of the uncertainty. There's a massive risk in taking the tiny amounts of data that startups have and pasting it into fancy dashboards and vibe coded analytics. You start forgetting you've got a tiny sample size.

Translate to human

I used to have regular rows with engineers who told me that various things they'd built worked for 99% of our customers and were therefore ready to go. But, I'd say, we've got two million customers, so twenty thousand people are about to be massively inconvenienced and most of them will phone us.

You have to think through the data to the people-sized reality.

I find two things help with that:

  1. How many Wembley stadiums?

Numbers of people are hard to visualise. It helps if you think of things you've actually seen. Like 'that's the same number of people who can fit in Wembley stadium'. You might realise that a number is bigger, or smaller than you thought.

  1. Talk through the reality

Check the data by imagining the story behind it. Say, out loud, in your data meeting, what you think might be happening. So, if you've changed something on your emails and the click-through rate is going down then talk it though 'I think this means that people aren't sure what they'll get when they click so they're reluctant to do it. Does that make sense?' It doesn't have to be right, it just has to be plausible. Because if you can't think of a plausible explanation for what's happened you need to revisit the data or check some assumptions.