CASE STUDY TITLE

Case study: How does a bike-share navigate speedy success?

AUTHORED BY

Jayoda Jithmini Kulatunga

DATE

12/10/2024

Executive Summary

This case study explores how Cyclistic, a bike-share company in Chicago, can better understand the usage patterns of its annual members and casual riders. The primary objective is to identify key differences in how these two user groups utilize Cyclistic’s services and to provide actionable insights to guide the company’s strategic initiatives, such as increasing the conversion of casual riders to annual members.

The analysis utilized 12 months of historical trip data, focusing on metrics such as trip duration, frequency, and day-of-week trends. Data preparation involved cleaning, standardizing, and merging datasets to ensure consistency and reliability. Advanced tools, including R programming, were used to process and analyze the data, followed by visualizations to present the findings effectively.

Key findings revealed that casual riders tend to take longer trips, particularly on weekends, whereas annual members demonstrate consistent usage throughout the week with shorter trip durations. These trends suggest that casual riders likely use the service for leisure, while members use it more for commuting.

Based on these insights, the following recommendations were made:

• Develop targeted weekend promotions to encourage casual riders to purchase annual memberships.
• Introduce loyalty programs to incentivize repeat usage among casual riders.
• Create communication campaigns highlighting the cost and convenience benefits of membership for frequent riders.

This study underscores the importance of leveraging data analytics to enhance customer segmentation and improve strategic decision-making. By implementing the proposed recommendations, Cyclistic has the potential to boost membership conversion rates and achieve long-term growth.

Introduction

Cyclistic, a prominent bike-share company based in Chicago, operates in a rapidly growing urban mobility industry. With increasing global interest in sustainable transportation, bike-sharing services like Cyclistic play a pivotal role in reducing traffic congestion and promoting eco-friendly commuting options.

The company's innovative approach provides riders with access to docked and dockless bikes, catering to both casual riders and annual members. However, with the bike-sharing industry becoming increasingly competitive, Cyclistic recognizes the need to maximize its customer base by converting casual riders into loyal annual members.

This case study focuses on analyzing the distinct usage patterns of Cyclistic’s two primary customer segments: casual riders and annual members. By leveraging historical trip data, the study aims to uncover actionable insights to enhance Cyclistic’s customer retention strategies and drive sustainable growth.

The importance of this case lies in its ability to demonstrate how data-driven decision-making can transform business operations, especially in the mobility sector. The findings and recommendations derived from this study provide valuable insights into customer behavior, offering Cyclistic a competitive advantage in the bike-sharing market.

Statement
of the Problem

Cyclistic, a bike-share company in Chicago, has successfully established itself as a key player in the urban mobility sector. Offering a fleet of docked and dockless bikes, the company serves a diverse customer base, which includes casual riders and annual members. While Cyclistic has experienced steady growth, a significant challenge remains: how to convert casual riders into loyal annual members.

Casual riders often contribute to the company’s revenue through one-time or short-term passes, but their inconsistent usage patterns limit Cyclistic’s potential for predictable, long-term income. Annual members, on the other hand, offer greater revenue stability due to their commitment to a subscription model. Understanding the differences in usage behaviors between these two customer segments is essential for creating effective marketing strategies and improving customer retention.

Cyclistic’s historical trip data reveals intriguing trends: casual riders tend to take longer trips, predominantly on weekends, while annual members exhibit consistent usage throughout the week. However, the reasons behind these patterns and the factors influencing casual riders' decisions to avoid annual membership remain unclear.

This case study aims to address the following key problem:
What are the significant differences in usage patterns between annual members and casual riders, and how can Cyclistic use these insights to convert more casual riders into annual members?

By identifying and addressing this challenge, Cyclistic can refine its business strategies, enhance customer satisfaction, and strengthen its position in the competitive bike-sharing market.

Decision Criteria
and Assumptions

For the Cyclistic Rider Behavior Analysis, when evaluating alternative courses of action, the following decision criteria and assumptions could be considered:

Decision Criteria:

1. Rider Usage Patterns:

• Frequency: Analyze the number of rides per user category (annual members vs casual riders).
• Ride Duration: Compare the average ride duration for both groups.
• Time of Day: Consider the time of day riders are most active (e.g., peak hours, weekends).

2. Customer Segmentation:

• Demographics: Age, location, and income levels of the riders could influence the types of plans they prefer (annual vs casual).
• Rider Preferences: Look into factors like flexibility, commitment, and the need for frequent usage.

3. Financial Implications:

• Cost per Ride: Evaluate the cost-effectiveness for the business based on the membership vs casual pricing.
• Revenue Generation: Assess how offering different membership plans might impact overall revenue.

4. Impact on Retention:

• Conversion Rate: How likely casual riders are to convert to annual memberships based on usage patterns and incentives.
• Customer Satisfaction: Understand customer satisfaction with different membership options (e.g., ease of use, availability of bikes).

5. Operational Feasibility:

• Infrastructure Impact: How would different usage patterns affect the availability of bikes and docking stations?
• Maintenance and Logistics: Consider how frequent usage by annual members vs casual riders influences bike maintenance and availability.

Assumptions:

1. Behavior Trends:

• Annual members tend to ride more frequently and may use bikes for longer durations, whereas casual riders use bikes less frequently and for shorter trips.

2. Seasonal Variations:

• Bike usage could vary seasonally, with higher usage during favorable weather, especially for casual riders.

3. Pricing Sensitivity:

• Casual riders might be more sensitive to the cost per ride, while annual members are more likely to prioritize convenience and commitment to long-term value.

4. User Data:

• The available data on rider behavior (e.g., trip duration, frequency, ride location) is representative of the overall population.

5. Competition:

• Rival bike-share services or other modes of transport might influence rider choices and impact the business's pricing and membership strategies.

Metrics:

• Average Ride Duration (minutes): To compare the usage patterns between member types.
• Ride Frequency per User per Month: To understand how often each group uses the service.
• Conversion Rate from Casual to Annual Membership: Percentage of casual riders who opt for annual membership after a certain period.
• Net Promoter Score (NPS): To gauge customer satisfaction and loyalty.
• Revenue per User: This could be a key metric to determine the profitability of casual vs. annual riders.

By evaluating these factors, you can make a data-driven decision about which actions to take, such as offering targeted promotions, improving member retention strategies, or optimizing the pricing model.

Data Analysis

The data collected for this case study involves Divvy bike-sharing trips from Q1 2019 and Q1 2020. The dataset was cleaned and merged by ensuring consistent column names and removing irrelevant fields such as latitude, longitude, and personal data. The ride type labels were standardized, and new columns (date, month, day, year, day_of_week) were added for aggregation.

Key findings from the analysis include:

1. Ride Duration: The average ride duration for casual users is higher than that of members.
2. Ride Patterns: The number of rides and average ride duration were examined by rider type (member vs. casual) and day of the week.
3. Data Visualization: Bar charts visualized the number of rides and average duration by rider type and weekday.

The analysis also removed any faulty data, such as negative ride lengths, and aggregated ride durations by day of the week to compare patterns. The final data was exported for further visualization in tools like Tableau.

Alternative Courses of Action

In addressing the analysis of Divvy bike-share data, several alternative strategies could be considered:

1. Data Normalization and Transformation:

• Pros: Standardizes data for comparison, eliminates inconsistencies.
• Cons: May oversimplify certain trends, leading to loss of context.
• Risk: Misleading conclusions if normalization isn't done carefully.

2. Focus on Member vs. Casual User Segmentation:

• Pros: Clear insights into usage patterns based on user type.
• Cons: Ignores other potential influencing factors like weather or city events.
• Risk: Potentially overlooks broader trends that could impact the business.

3. Expanded Temporal Analysis:

• Pros: Provides detailed insights into ride patterns over longer periods (e.g., seasonal changes).
• Cons: Requires additional data cleaning and more complex analysis.
• Risk: Complexities in managing a larger dataset could delay decision-making.

Each strategy provides different angles of understanding, with pros related to granularity and clarity but possible risks of simplification or missing broader insights.

Recommendations

Based on the analysis of the Divvy bike-share data and the alternatives considered, the following recommendations are provided:

1. Target Casual Riders for Membership Conversion:

• Introduce weekend-specific membership plans to cater to casual riders, encouraging regular use. By offering discounts for frequent weekend riders, we can highlight the cost-saving benefits of membership, increasing conversion rates.

2. Optimize Bike Availability for Casual Riders:

• Increase bike availability and docking stations in popular areas, particularly during weekends, ensuring a seamless experience for casual riders and enhancing their likelihood of returning or becoming members.

3. Focus Marketing Efforts on Casual Riders During Peak Times:

• Use data-driven marketing campaigns targeted at casual riders during their peak usage days (Thursday to Sunday). Messaging should emphasize the advantages of becoming a member and how it aligns with their current riding patterns.

Rationale

These strategies directly address the key findings of the analysis, such as the longer trip durations and weekend peaks for casual riders, as well as the higher ride volumes from members. The recommendations aim to increase membership conversions and improve overall rider satisfaction. By aligning the approach with these insights, Divvy can maximize operational efficiency and customer loyalty.

Implementation Plan

1. Launch Weekend-Specific Membership Plans

• Timeline: 2 months
• Responsibilities: Marketing Team (campaign creation), Operations Team (plan execution)
• Resources Needed: Budget for promotions, marketing platform, design team for campaign materials
• Challenges: Ensuring the offer resonates with casual riders.
• Mitigation: Conduct a small-scale pilot to test the offer, adjust based on feedback.

2. Optimize Bike Availability

• Timeline: 3 months
• Responsibilities: Operations Team (bike reallocation), Logistics Team (station placement)
• Resources Needed: Additional bikes, docking stations, logistics tools
• Challenges: Managing bike inventory during peak times.
• Mitigation: Use data analytics to predict high-demand areas and times.

3. Data-Driven Marketing Campaigns

• Timeline: 1-2 months
• Responsibilities: Marketing Team (data analysis, campaign rollout)
• Resources Needed: Customer data, email/social media platforms, analytics tools
• Challenges: Engaging casual riders with effective messaging.
• Mitigation: Create personalized ads based on usage patterns and test multiple messaging approaches.

Additional Steps:

• Ongoing Monitoring & Adjustment: Set up weekly reporting on campaign performance and bike availability to identify areas needing refinement.
• Feedback Loop: Gather input from customers and internal teams to continuously refine the offerings.

This plan should be flexible to adjust based on data feedback and market response.

Exhibits and Schedules

To support the findings and recommendations presented in this case study, I have included the following exhibits. These exhibits provide a visual representation of the key trends and patterns derived from the analysis of Cyclistic’s historical trip data.

Exhibit 1: Average Trip Duration by Rider Type

This bar chart illustrates the average trip duration for both casual riders and annual members. It highlights the significant difference in trip durations, particularly during weekends, where casual riders tend to have longer rides.

Description:

• Data Source: Cyclistic trip data (last 12 months).
• Analysis: Aggregated trip durations by rider type.
• Insights: Casual riders’ average trip duration is notably higher compared to members, reinforcing the idea that casual riders engage in more leisurely activities.

Exhibit 2: Total Number of Rides by Rider Type

This bar chart displays the total number of rides taken by annual members and casual riders. It emphasizes the volume difference, with members consistently accounting for the majority of rides throughout the week.

Description:

• Data Source: Cyclistic trip data (last 12 months).
• Analysis: Count of trips by rider type.
• Insights: The data suggests that members exhibit more frequent and consistent usage patterns, whereas casual riders peak during weekends.

Reference to Exhibits in Report

• Exhibit 1 is referenced in the analysis section discussing the behavior of casual riders and members regarding trip duration.
• Exhibit 2 is cited in the section analyzing ride volume and its implications for membership strategies.

Data Sources and License Information

• Dataset Access: The data used for analysis was sourced from Cyclistic Trip Data.
• Licensing: The datasets are provided by Motivate International Inc. under their Data License Agreement.

References

Motivate International Inc. (n.d.). Divvy Trip Data. Retrieved from https://divvy-tripdata.s3.amazonaws.com/index.html

Motivate International Inc. (n.d.). Data License Agreement. Retrieved from https://www.divvybikes.com/data-license-agreement