Currently, this visualiser only works for Tesco Clubcard data. To use it, you will need to get your data by submitting a Tesco Data Request. You can watch a demo of my data on Youtube.
To discover your Trolley Trends
scroll down
Your Tesco Clubcard data covers purchases between
[start date] and [end date] (inclusive).
That's n year(s), n month(s), and n day(s).
Remember these dates!
The following statistics all relate to this period.
You shopped with your Clubcard
On average (mean), you shop every
The longest you went between shops was
Was it a holiday? A pandemic?
You visited or have ordered from
Do you remember what stores they were?
The stores you have used
What day of the week do you shop most often?
When do you spend the most?
You shopped on these days of the week
Your most expensive shop was
Most spent on date at
store
Your biggest shop consisted of
Items items on date at
store
Do you remember what it was for?
All your shops
What patterns and trends can you see?
Are you ready for how much you spent?
Brace yourself!
In total, you have spent
But you have also saved
On average (mean), you spend
Is that what you expected?
How much you've spent each week
What trends can you see?
Can you spot your lifestyle changes or the increases in cost of living?
You have purchased
On average (mean), you purchase
What do you think you buy?
The products you have bought the most of
I bet you're not surprised!
The most expensive products you have bought
The products that you have spent the most on
I doubt you're surprised by these either!
That's it! I hope you found that interesting.
Do you want to explore your data yourself in a spreadsheet?
Here are CSV files containing your 'raw' data almost as it is supplied in the Tesco file, without data cleansing. You may want to note the , I identified.
The purchases file contains the transactions you made and the products file contains the items you purchased, plus some information from the related purchase record.
The products data should enable you to view exactly what you bought in any purchase. If you are using Excel, I suggest starting with the products file and analysing it in a PivotTable.
Please could you do me a favour?
Will you contribute your anonymised data?
This would form part of a dataset that could help observe changes in the cost of living and assist in the development of further analysis tools.
No personal data is collected.
The data is anonymised, not merely pseudo-anonymised. This not all the data you've seen above but a subset of it.