Retail / Multi-year engagement
Millions of SKUs across hundreds of campaigns.
The marketing team at one of the world's largest retailers needed a tool to build and manage the item lists behind every promotional campaign -- rollbacks, price offers, event-specific discounts -- across a product catalog in the tens of millions. We built the platform that replaced their manual process and maintained it for years.
The problem
Creating promotional campaigns at this scale meant associating specific SKUs with specific events and pricing strategies across every store. The data lived in a massive internal database. The campaign management system lived separately. There was no integrated tool for the marketing team to bring these together, build item lists, collaborate with colleagues, and push finalized campaigns downstream. Everything happened manually.
The client is a national US retailer. The catalog runs into the tens of millions of SKUs.
What we built
MCIS -- Merchant Campaign Item Selector -- deployed within the retailer's own IT environment. The platform integrates with their enterprise data warehouse (tens of millions of SKUs with full item detail) and their existing campaign management system.
Marketing team members log in via the retailer's SSO, access their campaigns, and build item lists that function like collaborative spreadsheets -- colleagues can be invited to view, edit, and approve. Quality scoring was integrated to rank items. Full history of items from past events is accessible to inform pricing decisions for future campaigns. Deployed inside the retailer's own IT environment.
Data Warehouse Integration
Real-time access to tens of millions of product records with price, description, and linked item data pulled from the retailer's enterprise data warehouse.
Campaign Item Management
Collaborative item lists tied to specific campaigns and events, with invite-based editing, pricing history, and quality scoring.
Campaign System Integration
Campaign list sync with the retailer's existing enterprise campaign management system.
Enterprise Security
Deployed inside the retailer's own IT environment, with SSO via their internal identity system and role-based access control.
The outcome
MCIS replaced a fully manual campaign-building process and became the standard internal tool for years. Marketing teams could search tens of millions of SKUs, build collaborative item lists, reference historical pricing, and sync directly to the campaign management system -- all within the retailer's own IT environment.
Need enterprise tools built for your infrastructure?
Tell us what you're building. We'll tell you honestly whether we can help.