Analyzing User Behavior and Enhancing Engagement for OkCupid

The project aimed to derive insights into user behavior, activity patterns, and audience demographics within OkCupid's dataset, consisting of over 59,000 rows. By employing Advanced MS Excel functionalities for analysis and Tableau for effective visualization, the project sought to inform strategies for business growth and user engagement.

Insights and Suggestions:

Usage Patterns: Identified peak usage hours and days, helping in scheduling promotions and user engagement activities, such as virtual meet-up options

Audience Demographics: Thoroughly analyzed user demographics, delving into factors like age, gender, and body type. Notably, a significant majority of users showcased preferences for body types categorized as fit, healthy, or slim.

Fitness Promotion Potential: The data revealed a prominent inclination towards health-conscious body preferences. This insight suggests an opportunity for the app to introduce and promote fitness-related options and activities, aligning with users' interests.

User Profile Occupations: The analysis indicated that a significant proportion of OkCupid users identified themselves as either students or working professionals. This insight highlights the app's popularity among individuals pursuing education and those actively engaged in their careers.

Targeted Engagement Opportunities: Recognizing the popularity among students and working professionals, OkCupid can tailor its engagement strategies to align with their schedules. Introducing features, prompts, or content during these post-5 PM hours can potentially yield higher interaction rates.