Custom built dashboard that helps John Lewis make better marketing decisions
Using an array of technology and data experts, we collected complex market data and built an accessible data dashboard containing highly-valuable, in-depth competitor information.
-
100K
PRODUCTS
-
83
CATEGORIES
-
1
COMPREHENSIVE DASHBOARD
Objectives
John Lewis set Honcho the objective of collecting complex market data and creating an easily accessible data Dashboard that contains highly-valuable data regarding competitor abundance and pricing.
The dashboard was to include:
+ Pricing trends by categories and product lines versus key competitors
+ Insights that will help product managers make decisions about new product lines or stocking products for existing categories.
+ Competitor pricing strategies, stock abundance, new product lines and discounting strategies to inform trading teams.
+ Product demand tracking
Strategy
In order to build the most comprehensive dashboard to support and inform John Lewis’s marketing and buying teams, we knew our team had to think creatively in order to collect, process, analyse and present the findings in an easy-to-read and navigate format.
Creating a dashboard of this size and scope has many stages requiring a team of experts. Our overall strategy included the following stages:
- Audit John Lewis’s taxonomy and categories
- Use custom crawlers/web-scraping technology to extract and collect competitor data
- Cleaning, sorting, mapping and analysing data
- Collect web traffic data and ranking keywords
- Use software/tools to analyse/predict trends
- Dashboard build
Results
Introducing our sophisticated data dashboard, Pulse!
Pulse is an extremely valuable tool that can be used to inform many teams at John Lewis to make strategic, data-led marketing, sales and stock decisions giving them an advantage in the market.
Pulse is continually unlocking opportunities for John Lewis as it continually tracks and updates to inform the team in real-time.
Before any purchase or marketing decisions are made, Pulse can be used to provide evidence to support the decision, or alternatively prevent the team from making poor decisions.
Benefits
- Pulse tracks the demand for products by analysing how stock levels of competing sites are changing.
- Pulse provides market trends, gaps and opportunities for SEO, visibility and connected search purposes.
- New and emerging trends identified at a category and each sub-category level through both social and search channels
- Pulse can recommend new landing pages (It recommended 1,167 new pages for John Lewis)
Explore More Case Studies
-
Sarah Raven
Paid Search, Shopping
Multi award winning paid search for garden retailer Sarah Raven
VIEW CASE STUDY
Get in touch
Latest Blogs & Articles
-
Are There Ads in ChatGPT? Here’s What’s Being Tested
If you’ve opened ChatGPT recently and noticed something like “Testing ads in ChatGPT”, it probably made you pause. Not because anyone loves adverts, but because...Read Article → -
Google Search Console Update: AI Powered Configuration in the Performance Report
Google has introduced a new experimental feature inside Google Search Console that could make organic search traffic analysis much quicker for marketers and in house teams....Read Article → -
Google AI Mode Ads: What Direct Offers Mean for Retailers
Google is quietly moving closer to what every retailer wants, and what every ecommerce team fears: fewer steps between interest and purchase. Direct Offers, now...Read Article → -
PR in the Age of Agentic Commerce, What Still Wins When AI Recommends the Products?
“When the technical playing field is even, your brand, how you show up and what people say about you will be the difference.”-James Roach, Head...Read Article → -
SEO Readiness for Agentic Commerce, From Discoverability to Actionability
“It’s no longer enough for your content to rank, it needs to be structured in a way that an AI agent can understand and act...Read Article → -
From Click to Checkout Inside Google: The Biggest Retail Shift Since Shopping & Pmax?
Google just changed the shopping playbook (again).. At NRF 2026, Google announced a major shift in how online shopping will work over the next few...Read Article →
