Data-Driven Insights to Convert Casual Riders into Annual Members
Google Data Analytics Professional Certificate - Capstone Project (2023)
Understanding user behavior to maximize annual memberships
Cyclistic's finance analysts concluded that annual members are much more profitable than casual riders. The marketing director believes maximizing annual memberships is key to future growth. Rather than targeting all new customers, there's a better opportunity to convert existing casual riders who are already familiar with the service.
How do annual members and casual riders use Cyclistic bikes differently?
Data-driven discoveries that transform marketing strategy
Casual riders use bikes more on weekends, while annual members show consistent usage throughout the week, indicating commute-focused behavior.
Casual riders take longer trips on average, suggesting leisure and tourism purposes vs. members' short, efficient commutes.
Both user types show summer peaks, but members maintain higher baseline usage in winter months.
Annual members show clear rush hour patterns (8am & 5pm), while casual riders peak mid-afternoon on weekends.
Target casual riders with messaging about commute benefits and cost savings for regular weekday use. Highlight convenience and health benefits of bike commuting.
Launch conversion campaigns in spring/summer when casual ridership peaks. Offer limited-time discounts for annual membership to capture high-engagement users.
Dive deep into the complete R analysis with code, visualizations, and detailed findings
📊 View Full R Report GitHub Repository 🏠 Back to Portfolio