Annual Promotion Plan Management in Consumer-Packaged Goods

Enterprise software generative research to optimize promotion planning workflows and reduce operational complexity for CPG sales managers

Problem Space

In a $500+ billion global market, inefficient promotion planning processes directly affect individual performance metrics and overall company profitability, with 67% of users reporting the current planning process as burdensome.

Revenue Growth Management Summary

The Challenge

Sales managers in the Consumer-Packaged Goods industry face significant operational challenges when managing complex promotion plans, leading to compromised productivity, reduced efficiency, and missed revenue opportunities.

Revenue Growth Management User Persona

Generative and Strategic Research

Research Goals

Research Questions

  1. When do sales managers make changes to existing promotion plans and why?
  2. What repetitive tasks create the most operational burden in current planning workflows?
  3. What types of automation would provide the most value while maintaining user control and trust?

Methodology

💬

Semi-structured Interviews

60-minute sessions with CPG industry experts from billion-dollar revenue companies

🔍

Qualitative Analysis

Systematic coding and pattern identification from interview transcripts

🗂️

Affinity Mapping

Collaborative synthesis to identify themes and actionable insights

👥

Stakeholder Collaboration

Regular alignment with PM and design teams throughout the research process

My Role

My Role Process Map

Research Execution

I conducted comprehensive research with 5 end-users from CPG companies generating over $1 billion in annual revenue. Participants were recruited through multiple channels including Microsoft Teams, LinkedIn Sales Navigator, Respondent.io, with collaboration facilitated through Mural.

Participant Profile

Target User Persona: "Igor" - Sales managers responsible for overseeing CPG product sales to assigned customers, managing promotion plans to ensure compliance and achieve business goals.

Key Frustration: Navigating multiple disconnected systems to manage customer relationships and promotion plans, creating operational inefficiency.

Primary Need: Streamlined tools to complete planning and editing tasks efficiently, enabling more time for customer relationship building.

Key Findings & Strategic Recommendations

Universal Microsoft Excel Integration Dependency

All 5 participants utilize Microsoft Excel as a critical touchpoint throughout the editing and updating process, particularly for specific data category management.

Strategic Recommendation

New Feature: Microsoft Excel Upload Integration – Incorporate seamless Excel upload capability within both creation and edit workflows to eliminate manual data transfer steps.

Dynamic Guardrail Changes Prevent Full Automation

Annual spending activities are subject to mid-year guardrail modifications due to market volatility and policy adjustments, making complete automation unreliable.

Strategic Recommendation

New Feature: Flexible Configuration Framework – Develop an adaptable system allowing user-controlled adjustments within established guardrail parameters.

Complete Distrust in Automated Plan Maintenance

100% of users expressed no confidence in automated plan maintenance, requiring manual intervention for quality assurance and control.

Strategic Recommendation

Roadmap Adjustment: Deprioritize Full Automation – Shift focus from automation to user-assisted workflows until co-innovation partners demonstrate demand.

Consistent Editing Strategies Across Promotion Types

Users apply uniform editing approaches regardless of promotion duration, indicating opportunity for workflow standardization.

Strategic Recommendation

Design Strategy: Unified Workflow Architecture – Eliminate differentiated editing workflows in favor of a single, optimized editing experience.

Business Impact & Implementation

Microsoft Excel Integration Development
Product management team initiated investigation-based development to explore technical feasibility for promotion creation and maintenance via Excel integration
Administrative Configuration Features
Design team committed to developing features that enable user-driven adjustments within established guardrail parameters, improving workflow flexibility

Features currently implemented in SAP Revenue Growth Management

Challenges & Key Learnings

Research Challenges

  • Market Uncertainty: Inherent unpredictability in promotion planning made it challenging to anticipate user needs and design effective solutions
  • Process Diversity: Varied policies and workflows across different CPG companies led to inconsistent user approaches in plan maintenance

Professional Development Outcomes

  • Stakeholder Communication: Enhanced ability to translate research findings into strategic language for executive decision-making through proactive collaboration with senior leadership
  • Research Infrastructure: Established a comprehensive UX research repository and knowledge management system to improve accessibility and future research efficiency
  • User Recruitment Systems: Developed sustainable end-user referral programs and participant databases for ongoing research initiatives

Explore Additional Research Work

Discover other research projects demonstrating my systematic approach to solving complex user and business challenges.

View All Projects AI Hiring Research