UFood is the leading food delivery app in Brazil, operating in over a thousand cities. As the market leader, maintaining high customer engagement is critical for growth and consolidation. This case study simulates the role of a Data Analyst within UFood's data team, tasked with uncovering insights and proposing data-driven actions to optimize marketing campaigns and generate value for the company.
The dataset provided contains mock information about customers and their interactions with UFood's marketing campaigns. The goal is to analyze the data, identify business opportunities, and present actionable insights to both technical and business stakeholders.
-
Data Exploration:
- Perform an in-depth analysis of the dataset.
- Identify patterns, correlations, and causal relationships.
- Provide a better understanding of the characteristics of campaign respondents.
-
Customer Segmentation:
- Propose and describe customer segments based on their behaviors and interactions with the company.
-
Data Visualization and Insights:
- Create visualizations to support findings.
- Provide written reasoning and actionable recommendations based on the analysis.
UFood operates in the retail food sector, serving nearly one million consumers annually. The company offers products in five major categories:
- Wines
- Rare Meat Products
- Exotic Fruits
- Specially Prepared Fish
- Sweet Products
These products are further divided into gold and regular tiers. Customers can purchase products through three sales channels:
- Physical Stores
- Catalogs
- Website
Despite solid revenues and a healthy bottom line over the past three years, profit growth projections for the next three years are not promising. To address this, UFood is focusing on improving the performance of its marketing campaigns.
The marketing department is under pressure to allocate its annual budget more effectively. The success of these initiatives is critical to demonstrating the value of data-driven marketing and gaining support from skeptics within the company.
-
Exploratory Data Analysis (EDA):
- Insights into customer demographics, behaviors, and campaign responses.
- Identification of key factors influencing campaign success.
-
Customer Segmentation:
- Behavioral segmentation to target specific customer groups more effectively.
-
Recommendations:
- Data-driven strategies to optimize marketing campaigns.
- Suggestions for improving customer engagement and increasing profitability.
-
Visualizations:
- Clear and concise charts and graphs to communicate findings to stakeholders.
- Programming Language: Python
- Libraries: Pandas, NumPy, Matplotlib, Seaborn
- IDE: PyCharm
- Visualization Tools: Matplotlib, Seaborn
-
Age Groups:
- Middle-aged customers (30-70) spend more but are less likely to accept campaigns.
- Younger (21-30) and older (70+) customers accept campaigns at higher rates.
-
Sales Channels:
- Catalog sales are more effective for campaign acceptance.
- In-person purchases generate higher revenue.
-
Customer Profile:
- High-earning, middle-aged customers with no children are the most profitable segment.
-
Marital Status:
- No significant impact on spending, but married, single, and together customers spend more.
-
Targeted Campaigns:
- Focus on younger (21-30) and older (70+) customers for higher campaign acceptance rates.
- Prioritize high-earning, middle-aged customers with no children for revenue generation.
-
Sales Channel Optimization:
- Allocate marketing efforts across channels: 40% catalog, 30% web, 30% store.
-
Product Focus:
- Emphasize gold-tier products to maximize profitability.
-
Budget Allocation:
- Use insights from customer segmentation to allocate marketing budgets more effectively.
Include key visualizations here to make the README more engaging. For example:
)
This case study demonstrates the value of data driven decision-making in optimizing marketing campaigns and driving business growth.