Rockbuster Stealth, LLC
Rockbuster Stealth LLC is a global movie rental company with traditional brick-and mortar stores. In order to stay competitive, Rockbuster wants to launch an online video rental service. Rockbuster is facing stiff competition from streaming services such as Netflix and Amazon Prime, and it needs is data analyzed in order to develop insights to help it launch successfully.
Tools Used:
Barbara Morrison, Data Analyst 2/13/2024
KEY QUESTIONS & ANALYSIS
Top & Bottom 5 Movies in Revenue?
Do sales vary across regions?
Top Revenue Movie - $215.75 (Telegraph Voyage)
Lowest Revenue Movie - $5.94 (Duffel Apocalypse)
India and China each make up more than $5000 in revenue
KEY QUESTIONS
& ANALYSIS
Location of Rockbuster’s customers
1). Which countries are customers based in?
Most customers are in India & China
2). Where are customers with a high lifetime value based?
Top 5 customers are located in North America & Asia
INSIGHTS
Top $$ - Top 10 countries
Avg amt paid: $107.35 (top 5)
Top 10 Countries -
Customer Count
60% in Asia
35% of Asians in India & China
Top 10 countries in revenue and number of customers
| 4. Japan | 8. Philippines |
2. China | 5. Mexico | 9. Turkey |
3. United States | 6. Brazil | 10. Indonesia |
| 7. Russia Federation | |
INSIGHTS
Highest Revenue
Video Statistics
Genre - Sports, Foreign, Family,
Documentary & Animation
Ratings - No effect on revenue
Avg rental duration: 5 days
Video titles never rented: 42/1000
Revenue - each Top 5 movie: > $190
Revenue - each Bottom 5 movie: < $7
RECOMMENDATIONS
MARKETING STRATEGY
RESEARCH -
Desired results
INCENTIVES
RESEARCH -
Resulting actions
Loyalty programs - high lifetime value customers
First-time discounts - new customers
Top 10 countries in revenue & customer count
Top 5 genres that grossed over $4 million
1). Optimize cost & rental duration for movies
2). Optimize inventory
3). Know customers’ preferences
1). Increase price and lower rental duration
2). Remove unused movie titles
3). Poll customers’ preferences on genre,
rating, film length, etc
THANKS
Does anyone have any questions?
Follow the project updates
barbaramorrisonanalyst@gmail.com