150 million records,
99.5% accuracy, 36 hours
How a major European last-mile logistics company turned hundreds of millions of fragmented customer records into trusted single customer views β laying the foundation for everything that comes next.
Last-mile logistics & e-commerce fulfilment
Single customer view β 150M records resolved into 38.1M golden profiles
Hundreds of millions of records from dozens of retailers β via Amazon, eBay and internal databases
Implementation phase β with Pinboard Consulting
The data chaos that broke traditional solutions
A major European last-mile logistics company was drowning in customer data chaos. Orders poured in from dozens β potentially hundreds β of separate retailers, each feeding customer records through its own integration. Across marketplaces like Amazon and eBay and the company's own internal databases, hundreds of millions of records piled up β and their customer service teams couldn't get a single view of who their customers actually were.
The scale was staggering:
- βΉ 150 million customer records arriving from dozens of retailers sending orders
- βΉ Inconsistent data formats and missing information
- βΉ Marketplace integrations with heavily masked email addresses
- βΉ Complex address matching requirements for accurate deliveries
Previous attempts to solve this problem either couldn't handle the scale or sacrificed accuracy for speed. The company needed something different.
Initial analysis revealed 377 data quality issues in just 1,000 sample records. Yet Tilores successfully resolved:
- βΉ Multiple records for single customers across platforms
- βΉ Heavily masked eBay email addresses
- βΉ Inconsistent address formatting and name variations
- βΉ Complex household relationship mapping
Performance that defied expectations
Tilores' entity resolution platform was implemented by Pinboard Consulting in just three weeks. The results were immediate and impressive:
- βΉ 150 million records processed in just 36 hours
- βΉ 99.5% accuracy rate confirmed by comprehensive testing
- βΉ 8 milliseconds per record processing time
- βΉ 38.1 million golden customer profiles β one single customer view per real customer β created from deduplicated data
The three-week timeline from deployment to full-scale processing shows how Tilores' no-code interface and pre-built connectors enable rapid implementation without sacrificing sophistication.
Advanced matching intelligence
Tilores' proprietary matching engine combines comprehensive data transformation with sophisticated matching rules. The platform configured:
- βΉ 10 advanced matching rules covering all business scenarios
- βΉ 10 specialised matchers for different data types
- βΉ Custom ETL pipelines for seamless integration
- βΉ Real-time API endpoints for operational systems
Beyond the numbers
A unified, trusted customer view sets up powerful new capabilities:
- βΉ Enhanced delivery accuracy through improved address matching
- βΉ First-contact resolution from a single customer view
- βΉ Automated fraud detection through pattern recognition
- βΉ Personalised service delivery based on household preferences
And perhaps most importantly, it lays the foundation for future innovation β including AI/LLM integration and advanced analytics capabilities β on top of a single, trusted view of every customer.
Why this implementation matters
This case study represents more than impressive numbers β it demonstrates that modern entity resolution can deliver immediate business value while establishing the data foundation for tomorrow's opportunities. Real-time matching at hundreds-of-millions scale is no longer aspirational; here it is a measured proof point.
Transform your customer data β
at enterprise scale
See how Tilores handles entity resolution on your own data, in real time. Available on AWS Marketplace.
Moving goods? See the Logistics solution, or download the full case study PDF.