Coca-Cola’s National Foodservice’s PACT System
Promotions, Assets, and Campaign Tracking (PACT) System is a comprehensive approach to organizing, storing, and distributing The Coca-Cola Company’s marketing materials efficiently.
Project Overview
Problems: The NFS team was using a burdensome spreadsheet method to track consumer promotions and customer campaigns across hundreds of locations nationwide. This led to inefficiencies in asset management and program monitoring.
Decentralized storage of marketing assets led to inefficiencies, inconsistent branding, and wasted resources as teams struggled to locate and utilize existing materials.
Goal: To streamline the tracking of marketing assets, improve brand consistency, and increase overall marketing efficiency..
Solution: Implemented a centralized digital asset management system, established clear naming conventions and metadata practices, and provided training on proper asset management techniques.
Results: Increased efficiency in asset retrieval, improved brand consistency across campaigns, and reduced redundant asset creation.
My Role: Oversaw the implementation of a centralized system and developed best practices for the organization.
Audience: NFS marketing and leadership teams
Timeline: 2016 - 2017
Discovery
Research revealed significant asset management challenges. The existing spreadsheet system with regional tabs and scattered asset links proved inefficient. Inconsistent naming and version control led to confusion and outdated asset usage. These findings emphasized the need for a more efficient, visual system.
From interviews with marketers and leadership, we learned that leadership wanted better visualization of program data, while marketers needed simpler data entry and filtering capabilities. All stakeholders expressed dissatisfaction with the current spreadsheet-based system.
Define
Through workshops and analysis, we identified essential features for the tracking system including a centralized repository, search capabilities, version control, and integration with existing marketing tools.
We opted for a proprietary system due to security, licensing, and customization concerns with out-of-the-box solutions. We built a clickable prototype to validate these needs and define dashboard specifics.
Design and Deliver
User testing highlighted opportunities to enhance search functionality and asset status tracking. The design phase involved developing and refining a prototype of key features, incorporating user feedback, and creating an efficient interface for both leadership oversight and campaign data management.
The final system resolves key challenges by creating a centralized repository with clear naming conventions, version control, and seamless tool integration - providing an efficient single source of truth for all marketing assets.
Results
The implemented system successfully addressed the initial challenges by providing a visual dashboard for quick program overview, user-friendly data input, and customizable views. The results were significant: 95% of team members reported improved workflow efficiency, with time-tracking data showing a 60% reduction in asset search time and 40% decrease in redundant asset creation. The system also enhanced program visibility for leadership while increasing team accountability and overall satisfaction.