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 Fortune 1 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 technology infrastructure. The platform integrates with their Teradata database (tens of millions of SKUs with full item detail) and their Aprimo 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. Hosted on the retailer's own infrastructure with their own security standards.
Teradata Integration
Real-time access to tens of millions of product records with price, description, and linked item data pulled from the retailer's internal database.
Campaign Item Management
Collaborative item lists tied to specific campaigns and events, with invite-based editing, pricing history, and quality scoring.
Aprimo Integration
Campaign list sync with the retailer's existing enterprise campaign management system.
Enterprise Security
Deployed on the retailer's own infrastructure, 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 security perimeter.
Need enterprise tools built for your infrastructure?
Tell us what you're building. We'll tell you honestly whether we can help.
Start a Conversation