Insitetrack Case Studies
Leading UK DIY Retailer
Company Introduction
A leading UK-based DIY merchant with over 100 years of trading heritage and a nationwide branch network.
Operating across both retail and trade channels, the business manages multiple brands and thousands of SKUs—each with frequently changing price files, regional variations, and promotional activity.
With a strong reputation for customer service and product range, they require precise, agile pricing operations to stay competitive in a fast-moving market.
The client needed to analyse their product range quickly—consolidating competitor product and price data, aligning SKUs accurately, and gaining deeper visibility into promotional activity. All of this had to be done while maintaining a complete historical record within their own on-premise infrastructure.
However, their spreadsheet-based approach was inefficient and fragile. It involved chasing version histories, stitching together files, and relying on formulas that often broke—making the process slow, error-prone, and difficult to standardise across teams.
Day-to-Day Challenges
Manual, ad-hoc data collection
Competitor scraping was done manually across multiple sites, consuming valuable time.Inconsistent SKU matching
Spreadsheet logic varied between users, causing sign-off delays and rework.Limited promotion visibility
No consolidated view of competitor promotions across regions, brands, or time.Scattered historical data
Data was saved across different drives, with gaps and manual reconciliations required.Slow, stale range reviews
Range decisions took days and were often based on outdated or incomplete information.
We delivered a set of targeted, scalable capabilities—each mapped directly to the client’s pricing and reporting challenges, while ensuring data confidence & a flexible delivery in line with their needs.
Developed a custom data scraper
Rapidly and reliably pulled competitor and market pricing data—reducing manual effort and ensuring consistent, up-to-date insights.Applied AI-assisted product-matching algorithms
Matched SKUs across competitors with high accuracy, enabling faster, more precise range reviews.Delivered a fully integrated Power BI dashboard
Embedded into the client’s internal systems for deep promotion analysis and self-serve reporting—tailored to internal workflows.Provided a daily product feed
Designed for on-premise infrastructure, giving the business a secure and structured historical record of competitor data.
The business transitioned from spreadsheet-driven processes to an automated, governed workflow—gaining richer competitor insight and secure, centralised historical data retention.
Manual data preparation time reduced by approximately 33%
Teams went from spending 18 hours per week on data prep to just 12 hours.Reporting cycle time decreased by 70%
Weekly batch reports were replaced with next-day automated updates.Online conversion rates improved by 11%
SKUs updated more quickly and accurately saw stronger online performance.Full pricing data ownership & daily competitor feed became the single source of truth
All pricing data & historical pricing data is now stored and analysed within the client’s own infrastructure.
What The Customer Had To Say!
Before Insitetrack, we’d spend hours each week manually checking competitor prices – and still miss changes. Now, the system tells us what moved and what to do next. In the last quarter alone, we saw an 11% lift in online conversions
Pricing Manager
