Web Optimisation, Maths and Puzzles Mostly my experiences with web analytics and online testing; some maths, some opinions, and the occasional Chess game.
Header tag
Saturday, 25 February 2023
Zero Traffic
Wednesday, 4 January 2023
The Parable of the 99 Sheep
The parable of the lost sheep/good shepherd is very well known, especially in church circles. I learned the parable in Sunday school, and I've heard sermons on it many, many times from many different preachers and teachers. It's a reminder to the church that God, the Good Shepherd, wants to gather as many people into the church as possible, and it's frequently used as part of what might be called a recruitment drive - time to evangelise to neighbours, friends and family who aren't part of the flock. After all, the sheep are all equally valuable, and introducing more sheep to the flock is a good thing.
Here it goes:
"Suppose one of you has 99 sheep, and you decide you want to increase your flock by one. Would you not leave the 99 sheep in the open country, and go out to find a hundredth sheep, and bring it home on your shoulders with rejoicing? In the same way, there is more rejoicing over one sinner who repents than over 99 righteous people who do not need to repent."
As you can see if you check your Bible, that's not what the parable says.
But when it's read out in church, the message that often accompanies the reading is the 'recruitment drive'. It's as if the parable says we need to get the hundredth sheep because the hundredth sheep is equally important to the 99 already safe in the flock. And: we the church need to get the extra sheep. I'm not saying that evangelism is unimportant (it's crucial), but there's another way of reading this parable: what does Jesus say?
Then Jesus told them this parable: “Suppose one of you has a hundred sheep and loses one of them. Doesn’t he leave the ninety-nine in the open country and go after the lost sheep until he finds it? And when he finds it, he joyfully puts it on his shoulders and goes home. Then he calls his friends and neighbors together and says, ‘Rejoice with me; I have found my lost sheep.’ I tell you that in the same way there will be more rejoicing in heaven over one sinner who repents than over ninety-nine righteous persons who do not need to repent.
Matthew 18:10-14; Luke 15:1-7; John 10
At the start of the parable, the shepherd already has 100 sheep in the flock. And the truth is that sometimes, sheep wander off. It's in their nature - they keep their nose to the grass, and they follow their instincts towards what they think is the next best grass... the next thing they know, they're not in the flock any more. And we are just the same. Yes we are. We go to church every Sunday, we join house groups and we attend the prayer meetings. We all think we're so clever, and we know what's going on in our lives, but we get comfortable, and then we get distracted from where we're supposed to be going. And then suddenly, we're not sure where we are any more.
It happens. Christians get criticised for being willing to identify with sheep, but we people aren't half as clever as we think we are, and we follow the crowd far more often than we'd like to admit.
Sometimes, even members of the flock need to be found. And it's ok if that's you (it's been me). If you read the parable, you'll notice that there is no blame attached to the sheep. The sheep isn't berated or criticised, because sheep are sheep (that's why they need shepherds). Also: it's the shepherd who goes to search and retrieve the 100th sheep, not some of the 99.
The parable isn't described as the parable of the bad sheep, it's the parable of the good shepherd - who cares when a member of the existing flock wanders off and gets lost. He doesn't shrug his shoulders and say, "Oh well, a 1% loss is acceptable for this year's performance, I still have the other 99 and that'll balance the books." He's searching for even one who goes astray, just as much as for the ones who aren't yet part of the flock.
Other articles I've written based on Biblical principles
10 things I learned from not quite reading the Bible in a year
Advent and a Trip to London
Advent: Names and Titles
Reading Matthew 1
My reading of Matthew 2
The Parable of the 99 Sheep
Why I Like Snow (it's not as crazy as you may think)
Wednesday, 28 December 2022
First Times of 2022
In what is becoming an annual tradition (here's the 2021 list), here's my list of 'things I did for the first time this year', which shows no sign of getting any shorter, even though I'm getting older.
1. I taught someone how to tie a necktie. It wasn't complicated, and my student was a very capable learner who simply hadn't needed to learn how to tie a tie before. Took us about three minutes.
2. I taught someone how to tie their shoelaces (because Velcro has been around for a while now, but hasn't taken over completely). It took us five minutes: four minutes for me to analyse and work out how I've done it on autopilot for the last 40 years, and then one minute to demonstrate it step by step.
3. I dressed up as Darth Vader. Quite a few times, in fact, starting off with comic conventions initially, then a few charity events, but later in the year I also then attended a birthday party as an invited guest. I mean, they weren't inviting me, they were inviting Darth Vader as part of my local Star Wars group and it would have been rude not to accept. We attended a birthday party for a young man with cystic fibrosis, and for his friends, some of whom had other disabilities.
And to complete the year, I attended a Christmas Carol service as Darth Vader, playing the role of King Herod, sharing the stage with a ballet dancer who played the role of the Angel Gabriel. Not something I'd anticipated at the start of the year!
4. I spoke at my church on a Sunday morning. I was invited to speak for 10 minutes on one of the Fruits of the Spirit, and chose patience (because people think I'm patient when I'm actually just very good at not speaking out). I've spoken at Sunday evening youth group meetings, but that was 20+ years ago, and this audience was a little more mature. I enjoyed it (I wrote and practised for weeks) and might get to do it again next year.
Here's the link to the video recording: Youtube Link
5. I became a Trustee at my church. This means I have responsibilities (legal responsibilities) for the finances and legal behaviour of the church. I'm not the only Trustee - we have four in total, plus the senior minister- and the others have all been in the role for several years. I'm hoping to get up to speed pretty quickly.
6. I found, and completed, a South Korean "K-Drama" series which I selected. As I mentioned last year, my wife introduced me to K-dramas in early 2021, and we watched "Crash Landing On You" which is one of the best drama series I've ever watched - her suggestion. We also watched "My Love From The Star" which was good (after CLOY, the others tend to pale by comparison).
This year, I found "Extraordinary Attorney Woo", which is set in a South Korean law firm. Attorney Woo has autistic spectrum disorder, and is a spectacular law student who's just graduated and started work practising law. It's dubbed, but you soon forget that as the production and sound is exceptionally good. I recommend it, it's heart-warming and life-affirming.
Here are some other K-dramas that we've watched and enjoyed on Netflix
Crash Landing On You - the original and best
My Love from the Star - an alien lands on Earth, and doesn't age.
7. I taught myself to solder. Yes, I'm a late developer, but I taught myself out of necessity. I needed to fix my Darth Vader voice box, and didn't want to wait until I could get somebody else to do it. I have since soldered a couple of other small electronics items, and only burned myself slightly once, on my thumb.
8. I taught Ben to play a piece of music on the piano. In early September, he came home from school with music homework: perform a piece of music to a backing track. Ben won't mind me telling you that he has zero interest in music and hence no experience or musical knowledge. However, by clever planning and careful choices, he learned to play firstly Twinkle Twinkle Little Star, and then the main theme from Star Wars on the piano, single-finger melody, in a weekend (and then practised it for the next two weeks ready for his music lesson).
A piano will always play the same note when you hit the same key (unlike a violin, which requires skill just to extract a sound from it), irrespective of which finger you use or how close you get to the middle of the key. This makes it ideal for a beginner who is going to play through a brute-force memorisation exercise. It was a triumph of perseverance and determination for both of us, but for Ben especially. Music is already one of his least favourite subjects at school (what other subject expects you to take the end-of-year test before teaching you the course material?).
I'm pleased and surprised at how I'm still learning, teaching and doing new things. I wish you a happy 2023 and many more new opportunities!
The Lists of Firsts
A first time for everything: 2018
2019 in reflection
First times in 2021 list
First times of 2022
First times in 2023
Things I did for the first time in 2024
Friday, 18 November 2022
The BBC Micro and sums of 2^n

The heart shape has some new and some familiar combinations, but the same principle applies.
Other similar posts that I've written
My Life in 10 Computer Games (including a few that I played on the Acorn Electron and BBC Micro)
Sums to Infinity and Refuelling Aircraft (based on a puzzle from a BBC Micro coding book)
And this post: The BBC Micro and Sums of 2^n
Monday, 14 November 2022
How many of your tests win?
If I ask you, I don't imagine you'd tell me, but consider for a moment: how many of your tests typically win? How many won this year? Was it 50%? Was it 75%? Was it 90%? And how does this reflect on your team's performance?
50% or less
It's probably best to frame this as 'avoiding revenue loss'. Your company tested a new idea, and you prevented them from implementing it, thereby saving your company from losing a (potentially quantifiable) sum of money. You were, I guess, trying some new ideas, and hopefully pushed the envelope - in the wrong direction, but it was probably worth a try. Or maybe this shows that your business instincts are usually correct - you're only testing the edge cases.
Around 75%
If 75% of your tests are winning, then you're in a good position and probably able to start picking and choosing the tests that are implemented by your company. You'll have happy stakeholders who can see the clear incremental revenue that you're providing, and who can see that they're having good ideas.
90% or more
If you're in this apparently enviable position, you are quite probably running tests that you shouldn't be. You're probably providing an insurance policy for some very solid changes to your website; you're running tests that have such strong analytical support, clear user research or customer feedback behind them that they're just straightforward changes that should be made. Either that, or your stakeholders are very lucky, or have very good intuition about the website. No, seriously ;-)
Your win rate will be determined by the level of risk or innovation that your company are prepared to put into their tests. Are you testing small changes, well-backed by clear analytics? Should you be? Or are you testing off-the-wall, game-changing, future-state, cutting edge designs that could revolutionise the online experience?
I've said before that your test recipes should be significantly different from the current state - different enough to be easy to distinguish from control, and to give you a meaningful delta. That's not to say that small changes are 'bad', but if you get a winner, it will probably take longer to see it.
Another thought: the win rate is determined by the quality of the test ideas, and how adventurous the ideas are, and therefore the win rate is a measure of the teams who are driving the test ideas. If your testing team is focused on test ideas and has strengths in web analytics and customer experience metrics, then your team will probably have a high win rate. Conversely, if your team is responsible for the execution of test ideas which are produced by other teams, then a measure of test quality will be on execution, test timing, and quantity of the tests you run. You can't attribute the test win rate (high or low) to a team who develop tests; in fact, the quality of the code is a much better KPI.
What is the optimal test win rate? I'm not sure that there is one, but it will certainly reflect the character of your test program more than its performance.
Is there a better metric to look at? I would suggest "learning rate": how many of your tests taught you something? How many of them had a strong, clearly-stated hypothesis that was able to drive your analysis of your test (winner or loser) and lead you to learn something about your website, your visitors, or both? Did you learn something that you couldn't have identified through web analytics and path analysis? Or did you just say, "It won", or "It lost" and leave it there? Was the test recipe so complicated, or contain so many changes, that isolating variables and learning something was almost completely impossible?
Whatever you choose, make sure (as we do with our test analysis) that the metric matches the purpose, because 'what gets measured gets done'.
Similar posts I've written about online testing
Getting an online testing program off the ground
Building Momentum in Online testing
Testing vs Implementing Directly
Sunday, 30 October 2022
What is the highest product of numbers that sum to 10?
I'm always on the lookout for maths puzzles, especially ones which can be described simply but require some work to find the solution. The most popular article on my blog is the one "Can you use the digits 1,2,3 and 4 to make the numbers from 1 to 50." It's depressingly popular, when I have spent so much more time on many of the other posts here. Ah, well, that's life.
A puzzle I found recently goes like this: "What is the highest product (i.e. multiply them all together) of numbers that sum to 10?"
Simple enough.
I started with the pairs, 1+9, 2+8 and so on:
1 * 9 = 9
2 * 8 = 16
3 * 7 = 21
4 * 6 = 24
5 * 5 = 25
Well, there we are. The answer so far is 25. The highest value we can reach for x (10 - x) is when x = 5 and 5 * 5 = 25. We can even prove this, using differention:
If y = x(10-x) = 10x - x^2
then dy/dx = 10 - 2x
And the maximum value is when dy/dx = 0 and if 10 - 2x = 0 then x = 5. QED
However, there are multiple other ways of making 10 by summing numbers together; nobody said it had to be just two numbers.
For example, 4 + 4 + 2 = 10, and 4 * 4 * 2 = 32, which is higher than the 25 we achieved previously.
A few more examples:
2 * 4 * 2 * 2 = 32
2 * 3 * 5 = 30
3 * 3 * 4 = 36
The highest that can be achieved, it seems, is 36.
Let's try another number - let's try summing to 15, and see if we can find a pattern.
3 * 6 * 6 = 108
5 * 5 * 5 = 125
3 * 3 * 3 * 4 * 2 = 162
3 * 4 * 4 * 4 * 4 = 192
3 * 3 * 3 * 3 * 3 = 243
Summing to 15, the highest product we can achieve is 243.
Summing to 19 (if you fancy a challenge) is 972, where 3 * 3 * 3 * 3 * 3 * 4 = 972.
Proof (or general principle)
When forming the product with the highest value, the highest value can be achieved by using 2s and 3s.
Every larger number can be broken down to 2s and 3s which will multiply together to form a larger product.
For example, 9 can be be broken down to 5 and 4, which will multiply to form 20 (which is higher than 9).
9 --> 5 * 4 = 20
5 --> 3 * 2 = 6
9 --> 3 * 2 * 4 = 24
4 --> 2 * 2 = 4 (hence it does not matter if we choose a 4 or two 2s).
7 --> 3 * 4 = 12
6 --> 3 * 3 = 9
Any number n can be broken down to 2s and 3s which will multiply together to form a product which is greater than n. Hence, the largest product we can obtain for 10 is 3 * 3 * 2 * 2 = 36, and the general principle is to break down the sum number into 3s (and 2s if the number is not a product of 3) to obtain the highest product, using only integers.
Other Maths puzzle articles:
Snakes and Ladders (Collatz Conjecture)
Crafty Calculator Calculations (numerical anagrams, five digits)
More Multiplications (numerical anagrams, four digits)
Over and Out (reduce large numbers to zero in as few steps as possible)
Wednesday, 21 September 2022
A Quick Checklist for Good Data Visualisation
One thing I've observed during the recent pandemic is that people are now much more interested in data visualisation. Line graphs (or equivalent bar charts) have become commonplace and are being scrutinised by people who haven't looked at them since they were at school. We're seeing heatmaps more frequently, and tables of data are being shared more often than usual. This was prevalent during the pandemic, and people have generally retained their interest in data presentation (although they wouldn't call it that).
This made me consider: as data analysts and website optimisers, are we doing our best to convey our data as accurately and clearly as possible in order to make our insights actionable. We want to share information in a way that is easy to understand and easy to base decisions on, and there are some simple ways to do this (even with 'simple' data), even without glamorous new visualisation techniques.
Here's the shortlist of data visualisation rules
- Tables of data should be presented consistently either vertically or horizontally, don't mix them up- Graphs should be either vertical bars or horizontal bars; be consistent
- If you're transferring from vertical to horizontal, then make sure that top-to-bottom matches left-to-right
- If you use colour, use it consistently and intuitively.
For example, let's consider the basic table of data: here's one from a sporting context: the English Premiership's Teams in Form: results from a series of six games.
| Pos | Team | P | Pts | F | A | GD | Sequence |
|---|---|---|---|---|---|---|---|
| 1 | Liverpool | 6 | 16 | 13 | 2 | 11 | W W W W W D |
| 2 | Tottenham | 6 | 15 | 10 | 4 | 6 | W L W W W W |
| 3 | West Ham | 6 | 14 | 17 | 7 | 10 | D W W W W D |
| Pos | Category | Metric 1 | Metric 2 | Metric 3 | Metric 4 | Derived metric | Sequence |
|---|---|---|---|---|---|---|---|
| 1 | Liverpool | 6 | 16 | 13 | 2 | 11 | W W W W W D |
| 2 | Tottenham | 6 | 15 | 10 | 4 | 6 | W L W W W W |
| 3 | West Ham | 6 | 14 | 17 | 7 | 10 | D W W W W D |
| Player | Pass Yds | Yds/Att | Att | Cmp | Cmp % | TD | INT | Rate | 1st | 1st% | 20+ |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Deshaun Watson | 4823 | 8.9 | 544 | 382 | 0.702 | 33 | 7 | 112.4 | 221 | 0.406 | 69 |
| Patrick Mahomes | 4740 | 8.1 | 588 | 390 | 0.663 | 38 | 6 | 108.2 | 238 | 0.405 | 67 |
| Tom Brady | 4633 | 7.6 | 610 | 401 | 0.657 | 40 | 12 | 102.2 | 233 | 0.382 | 63 |
A real life example of good data visualisation
The challenge (or the cognitive challenges) come when we ask our readers to compare data in long rows, instead of columns... and it gets more challenging if we start mixing the two layouts within the same document/presentation. In fact, challenging isn't the word. The word is confusing.
| Pos | Category | Metric 1 | Metric 2 | Metric 3 | Metric 4 | Derived metric | Sequence |
|---|---|---|---|---|---|---|---|
| 1 | Liverpool | 6 | 16 | 13 | 2 | 11 | W W W W W D |
| 2 | Tottenham | 6 | 15 | 10 | 4 | 6 | W L W W W W |
| 3 | West Ham | 6 | 14 | 17 | 7 | 10 | D W W W W D |
And keep this consistent across all the data points on all the slides in your presentation. You don't want your audience performing mental gymnastics to make sense of your data. It would be like reading a book, then having to turn the page by 90 degrees after a few pages, then going back again on the next page, then turning it the other way after a few more pages.
You want your audience to spend their mental power analysing and considering how to take action on your insights, and not to spend it trying to read your data.




