Cyclistic Logo

Image generated by Microsoft Designer (Image Creator)

Cyclistic 2024 Final Report

Link to
Cyclistic 2019

A hypothetical data analysis project, answering a business question for a fictional bikeshare company, analyzing customer behavior, and concluding with recommendations to assist in converting casual customers into annual members.


Executive Summary

This report analyzes historical data on Cyclistic users to provide insights for a digital marketing campaign aimed at converting casual riders into annual members. Our findings suggest that casual riders use Cyclistic differently than members, and marketing strategies should leverage these behavioral patterns to drive conversions.


Key Findings

  • Casual riders use Cyclistic for leisure: Their rides are almost twice as long (~20 minutes) with peak traffic on weekends, particularly Saturday afternoons.

  • Annual members are predominantly commuters: Their rides are shorter (averaging under 12 minutes) and occur mainly during weekday commuting hours (8 AM and 5 PM).

  • Location trends: Members’ trips are concentrated in downtown Chicago’s business districts, while casual riders favor popular leisure destinations.

  • Increasing electric bike usage: Both members and casual riders show a growing preference for electric bikes.


Key Visuals

Top 10 starting stations for member and casual rides


The above hotspots correspond to The Loop and River North, neighborhoods known for a dense concentration of offices, commerical establishments, and residential buildings. They include Ogilvie Transportation Center and Union Station, serving commuters transitioning between regional trains and local destinations.



The above hotspots correspond to The Loop, Streeterville, Gold Coast, Lincoln Park, and the Near South Side, neighborhoods known for their proximity to Chicago’s lakefront, parks, cultural institutions, and tourist attractions. These destinations include Millennium Park, Museum Campus, and Navy Pier, drawing visitors for sightseeing, entertainment, and recreational activities along Lake Michigan. Many locations offer scenic waterfront views, beach access, and connections to Chicago’s extensive bike path network.

Compare the above 2024 maps with 2019’s:

2019's top member and casual stations, with a tourist sightseeing map.

2019’s top member and casual stations, with a tourist sightseeing map.


Top Recommendations

Leisure-Focused Marketing: Position membership as a way to enhance casual riders’ existing leisure habits by emphasizing benefits, such as unlimited rides, extended ride times, and the convenience of electronic bikes.

Targeted Digital Advertising: Deploy ads on platforms frequented by casual riders, particularly those related to entertainment, travel, and dining, and use geo-targeted ads near high-traffic leisure stations.

Promotional Incentives: Offer weekend-focused memberships, seasonal discounts, referral bonuses, and strategic partnerships with major Chicago events and leisure attractions.

Cyclistic Logo

Methodology

  Back to Top

Image from the [Google Data Analytics Professional Certificate](https://www.coursera.org/professional-certificates/google-data-analytics).

Image from the Google Data Analytics Professional Certificate.


This analysis follows the framework outlined in Google’s Data Analytics certificate, structured as follows:

  1. Ask: A clear statement of the business task – converting casual riders into annual members.
  2. Prepare: Use cleaned historical data from 2024, detailing trip durations, ride frequencies, and station locations.
  3. Process: Perform data cleaning, transformation, and exploratory analysis.
  4. Analyze: Identify behavioral trends and customer segment differences.
  5. Share: Provide key findings and supporting visualizations.
  6. Act: Deliver actionable marketing recommendations.


Ask

     How do annual members and casual riders differ in their use of Cyclistic bikes, and how can this inform marketing strategies to convert casual riders into members?

Summary of the Business Case

Cyclistic, a bike-share company in Chicago, aims to increase its number of annual members, as they are more profitable than casual riders. Rather than targeting new customers, the marketing team wants to convert casual riders into annual members by understanding their riding behaviors.

To support this initiative, I have been assigned to analyze how annual members and casual riders use Cyclistic bikes differently. This analysis will identify key trends in usage patterns, which will inform marketing strategies designed to encourage casual riders to become members.

For reference, the full case study details can be found in the Appendix.


Data Sources

The analysis incorporates cleaned ride data from all 5,845,479 bike rides of 2024, detailing trip durations, ride frequencies, station destinations, and date-time information.

Google linked to data provided by Lyft and Divvy from their Chicago operations. The data has been made available by Motivate International Inc. under this license.

A Data Dictionary is attached in the Appendix.


Data Cleaning and Manipulation

Google provided a starter template to clean the data, initially covering only Q1 2019 and Q1 2020. This template was significantly modified to clean all of 2024. See full data cleaning script.

Data cleaning consisted of:

● Created columns for day, month, year, season, and day of the week to support aggregation.

● Calculated ride_length in minutes.

● Removed negative ride_length values, including company-flagged quality control rides.

● Removed duplicate rides.

● Removed outliers, conservatively dropping the longest 0.25% of rides (>4.5 hours).

● Switched to Leaflet for mapping due to the transition from station-based coordinates in 2019 to more granular bike location data, making it impossible to map single stations.


Analysis

Casual riders’ trips last almost twice as long as members’ trips (20 minutes vs. 12 minutes).

Members take significantly more trips overall, with regular weekday commuting patterns.

Trip timing differs:

  • Members peak during weekday commuting hours (8 AM & 5 PM).

  • Casual riders peak on weekend afternoons.

Trip locations differ:

  • Members primarily ride to The Loop, River North, and key transit hubs for commuting.

  • Casual riders frequent tourist/leisure spots (e.g., Shedd Aquarium, Theater on the Lake).

Further insights are available in the exploratory data analysis.

Exploratory Data Analysis 2024


Supporting Visualizations

Ride Length Comparison

  • Casual Riders: ~20-minute rides

  • Members: ~12-minute rides

Ride Volume Comparison

  • Members take almost 2x more trips than casual riders (3.7 million vs. 2.1 million).

Hourly Ride Patterns

  • Casual Riders: Peak late afternoon, especially on weekends.

  • Members: Peak during weekday commuting hours (8 AM & 5 PM).

Top Stations by Rider Type

Top 10 Member Peak Stations
Station Member Rides
Kingsbury St & Kinzie St 29499
Clinton St & Washington Blvd 27712
Clinton St & Madison St 24874
Clark St & Elm St 24681
Wells St & Concord Ln 20659
Wells St & Elm St 20482
Clinton St & Jackson Blvd 20288
Dearborn St & Erie St 19468
Canal St & Madison St 19067
State St & Chicago Ave 19041
Top 10 Casual Peak Stations
Station Casual Rides
Streeter Dr & Grand Ave 50801
DuSable Lake Shore Dr & Monroe St 33884
Michigan Ave & Oak St 24969
DuSable Lake Shore Dr & North Blvd 22992
Millennium Park 22374
Shedd Aquarium 20969
Dusable Harbor 18325
Theater on the Lake 16715
Michigan Ave & 8th St 13406
Adler Planetarium 12846

This skips the top station, NA, as electric bikes commonly don’t use a docking station.



Compare the above 2024 maps with 2019’s map of top stations and sightseeing locations:

  • Members: Cluster around The Loop, River North, and transit centers, likely for commuting.

  • Casual Riders: Frequent tourist/leisure spots (Millennium Park, Shedd Aquarium, Theater on the Lake, etc.).

Bicycle Type

  • Mild, growing preference for electric bikes.

Summary

  • Members dominate total rides and peak during commuting hours.

  • Casual riders take longer, leisure-oriented trips, peaking on weekends.

  • Seasonal variation impacts both groups similarly, with low winter activity.

  • Monitor trends in electric bike usage for future marketing strategies.

  • Recommendation: Cyclistic should tailor promotions accordingly, such as discount weekend passes for casual riders or commuter incentives for members.


Actionable Recommendations

Advertising Strategies

  • Position Membership as a Lifestyle Upgrade – Frame membership as a seamless extension of leisure and commuting habits.

  • Showcase Member Testimonials – Highlight real stories from recreational users to foster social proof.

  • Emphasize Value – Promote benefits such as unlimited rides, longer trip durations, and cost savings.

Targeted Outreach:

  • Strategic Ad Placements – Advertise on travel blogs, event pages, and entertainment guides.

  • Event-Based Promotions – Offer festival-specific passes at major Chicago events (e.g., “Skip the traffic with a Lollapalooza festival pass!”)..

  • Geo-Targeted Mobile Ads – Display dynamic ads near high-traffic casual rider stations with messages like “Ride unlimited this weekend — Try a membership today!”

  • Personalized Email Marketing – Send follow-ups to casual riders: “You rode three times this month—a membership would’ve saved you $X!”

  • Influencer & Social Media Engagement – Partner with travel vloggers and lifestyle influencers to showcase scenic and group rides (e.g., “Scenic Chicago Ride”).

Promotional Incentives:

  • Weekend Membership Plans – Introduce a “Leisure Package” with extended ride times for weekend users.

  • Seasonal Discounts – Launch summer promotions when ridership peaks.

  • Referral Rewards – Encourage members to invite friends with exclusive perks, leveraging group riding behavior.

  • Trial Memberships – Offer a discounted first month to new members (“First month free!”).

  • Partnership Discounts – Collaborate with local attractions for member perks (e.g., museum or restaurant discounts).

  • Gamification & Rewards – Implement a leaderboard tracking miles ridden among friends, rewarding engagement with merchandise or guest passes.

Commuter crossover marketing.

  • Position Bike Commuting as a Smart Alternative – Highlight time and cost savings (“Beat rush hour traffic!”).

  • Rush Hour Trial Passes – Distribute free trial passes at key commuter hours (8 AM and 5 PM).

  • Corporate & Student Memberships – Establish employer and university partnerships for exclusive discounts.

  • Transit Integration – Develop bundled memberships with the Chicago Transit Authority (CTA) for seamless bike-and-train/bus commuting.

Expanding Electric Bike Adoption

  • Promote E-Bike Convenience - Emphasize the ease of longer-distance rides and reduced effort compared to traditional bikes.

  • Monitor & Leverage E-Bike Trends – Track e-bike usage patterns to refine marketing strategies and highlight their growing popularity in ads.

Cyclistic Logo

Conclusion

  Back to Top

The analysis reveals clear distinctions between casual riders and annual members, providing a strategic opportunity for conversion. Casual riders tend to use Cyclistic for leisure and social activities, while members prioritize convenience and cost savings. By tailoring marketing efforts, Cyclistic can effectively shift casual users toward membership.

A combination of targeted advertising, compelling promotions, and leisure-focused incentives will maximize conversion rates. Engaging casual riders through event-based marketing, geo-targeted ads, and influencer collaborations will help create stronger brand awareness. Additionally, promotions such as weekend memberships, referral bonuses, and trial offers will lower the barrier to entry.

Finally, strengthening partnerships with corporations, universities, and public transit systems will enhance Cyclistic’s appeal to commuters. By capitalizing on both the leisure and commuter benefits of membership, Cyclistic can expand its reach, encourage long-term adoption, and solidify its position as Chicago’s go-to bikeshare service. Through these strategic initiatives, Cyclistic is well-positioned to drive membership growth while enriching the overall rider experience.


Cyclistic Logo


Appendix

  Back to Top

Data Dictionary

  Back to Data Sources

Cyclistic Ride Data Dictionary
Column Description
ride_id Unique ride identifier.
started_at Ride start time (YYYY-MM-DD HH:MM:SS).
ended_at Ride end time (YYYY-MM-DD HH:MM:SS).
rideable_type Type of bicycle.
start_station_id Starting station ID.
start_station_name Starting station name.
end_station_id Ending station ID.
end_station_name Ending station name.
member_casual Rider type (member/casual).
gender Rider gender (if available).
birthyear Rider birth year (if available).
date Ride date (YYYY-MM-DD).
month Ride month (1–12).
day Ride day (1–31).
year Ride year (YYYY).
day_of_week Day of the week (Mon–Sun).
season Season (Winter, Spring, Summer, Fall).
hour Ride start hour (0–23).
ride_length Duration in minutes.
start_lat/lng Starting location coordinates.
end_lat/lng Ending location coordinates.

Scenario

  Back to Ask

Quoted from the Google Data Analytics Capstone (see PDF here):

You are a junior data analyst working on the marketing analyst team at Cyclistic, a bike-share company in Chicago. The director of marketing believes the company’s future success depends on maximizing the number of annual memberships. Therefore, your team wants to understand how casual riders and annual members use Cyclistic bikes dierently. From these insights, your team will design a new marketing strategy to convert casual riders into annual members. But first, Cyclistic executives must approve your recommendations, so they must be backed up with compelling data insights and professional data visualizations.

Characters and teams

● Cyclistic: A bike-share program that features more than 5,800 bicycles and 600 docking stations. Cyclistic sets itself apart by also offering reclining bikes, hand tricycles, and cargo bikes, making bike-share more inclusive to people with disabilities and riders who can’t use a standard two-wheeled bike. The majority of riders opt for traditional bikes; about 8% of riders use the assistive options. Cyclistic users are more likely to ride for leisure, but about 30% use the bikes to commute to work each day.

● Lily Moreno: The director of marketing and your manager. Moreno is responsible for the development of campaigns and initiatives to promote the bike-share program. These may include email, social media, and other channels.

● Cyclistic marketing analytics team: A team of data analysts who are responsible for collecting, analyzing, and reporting data that helps guide Cyclistic marketing strategy. You joined this team six months ago and have been busy learning about Cyclistic’s mission and business goals—as well as how you, as a junior data analyst, can help Cyclistic achieve them.

● Cyclistic executive team: The notoriously detail-oriented executive team will decide whether to approve the recommended marketing program.

About the company

In 2016, Cyclistic launched a successful bike-share offering. Since then, the program has grown to a fleet of 5,824 bicycles that are geotracked and locked into a network of 692 stations across Chicago. The bikes can be unlocked from one station and returned to any other station in the system anytime.

Until now, Cyclistic’s marketing strategy relied on building general awareness and appealing to broad consumer segments. One approach that helped make these things possible was the flexibility of its pricing plans: single-ride passes, full-day passes, and annual memberships. Customers who purchase single-ride or full-day passes are referred to as casual riders. Customers who purchase annual memberships are Cyclistic members.

Cyclistic’s finance analysts have concluded that annual members are much more profitable than casual riders. Although the pricing flexibility helps Cyclistic attract more customers, Moreno believes that maximizing the number of annual members will be key to future growth. Rather than creating a marketing campaign that targets all-new customers, Moreno believes there is a solid opportunity to convert casual riders into members. She notes that casual riders are already aware of the Cyclistic program and have chosen Cyclistic for their mobility needs.

Moreno has set a clear goal: Design marketing strategies aimed at converting casual riders into annual members. In order to do that, however, the team needs to better understand how annual members and casual riders differ, why casual riders would buy a membership, and how digital media could affect their marketing tactics. Moreno and her team are interested in analyzing the Cyclistic historical bike trip data to identify trends.

Note that data-privacy issues prohibit you from using riders’ personally identifiable information. This means that you won’t be able to connect pass purchases to credit card numbers to determine if casual riders live in the Cyclistic service area or if they have purchased multiple single passes.

Three questions will guide the future marketing program:

  1. How do annual members and casual riders use Cyclistic bikes differently?
  2. Why would casual riders buy Cyclistic annual memberships?
  3. How can Cyclistic use digital media to influence casual riders to become members?

Moreno has assigned you the first question to answer: How do annual members and casual riders use Cyclistic bikes differently?

You will produce a report with the following deliverables:

     1. A clear statement of the business task

     2. A description of all data sources used

     3. Documentation of any cleaning or manipulation of data

     4. A summary of your analysis

     5. Supporting visualizations and key findings

     6. Your top three recommendations based on your analysis

Cyclistic Logo

Source: Freepik