Master Dataset

DataDNA Dataset Challenge - Customer Satisfaction Dataset - July 2025.csv

Project Task Management

Task Management

Marketing Campaign Management

Campaign Management

๐Ÿ’โ€โ™€๏ธ๐Ÿ’โ€โ™‚๏ธResource Allocation

Support Team

The support team has a fixed capacity of 30 people. To maximize impact, 40% focus on low-satisfaction customers, 30% on the Arizona region, and the remaining 30% manage general support. This ensures critical issues are prioritized while maintaining overall service continuity.

Support Role Distribution

Product Team:

The product team has a fixed capacity of 25 people. To align with customer demand, 50% focus on developing smaller, budget-friendly packs and new product varieties, 30% work on improving existing product consistency and availability, and the remaining 20% handle innovation and long-term R&D. This ensures immediate customer needs are addressed while sustaining future growth.

Product Development Team

Marketing Team:

The marketing team has a fixed capacity of 40 people. To maximize business impact, 35% are dedicated to youth-focused campaigns (20โ€“29 age group), 30% manage mid-age customer promotions and loyalty programs, 20% focus on regional strategies (San Antonio, Arizona, New York), and the remaining 15% handle general branding and retention activities. This distribution balances growth in new segments with retention of high-value customers.

Marketing Resource Planning