Netflix Subscription Analysis
Analyzing Netflix Subscription Trends from 2021 - 2023
Link to project repository on GitHub
Project Background
Netflix, founded in 1997, is a global streaming platform offering a wide range of TV shows, movies, and original productions to audiences worldwide.The company has extensive data on user preferences, viewing habits, and subscription trends that has yet to be fully leveraged. This project analyzes Netflix subscription trends to provide valuable insights into market behavior, helping to predict future industry patterns and consumer preferences.
Insights and recommendations are provided in the following key areas:
- Total Subscriptions: total subscription sales from all plan types
- Plan Type: Basic, Premium, and Standard
- Country: Australia, Brazil, Canada, France, Germany, Italy, Mexico, Spain, UK, and US
- Plan Device: Device on which the subscription will be used. Laptop, Smart TV, Smartphone, and Tablet
The SQL queries used to clean, organize, and prepare data for analysis can be found here
Data Structure
The dataset provides a snapshot of a sample Netflix userbase, showcasing various aspects of user subscriptions, revenue, account details, and activity.
The database can be accessed here: https://www.kaggle.com/datasets/arnavsmayan/netflix-userbase-dataset
Executive Summary
Plan Type:
- Basic plans are the most popular plan.
- Near the end of June 2022 all plan types saw a significant spike and the basic plan type hit a high of $811.00. These spikes significantly decreased until the end of October 2022 when all plan types spiked again, and Premium and Standard plan types hit highs of $576.00 and $727.00 respectively.
- All plan types seemed to drop off after this second spike completely.
Plan Country:
- Spain and the US are the top two countries with subscription totals of $5,664 and $5,662 respectively.
- Most countries followed the same spike and decrease pattern as the plan types (spikes in June 2022 and late October 2022) except France which hit its high in August 2022, and Germany which hit its high at the beginning of October 2022.
Plan Device:
- All four devices are evenly popular for Netflix Subscriptions, each getting a total of around $7,700.
- The devices followed the same spike and decrease pattern as the other two graphs (spikes in June 2022 and late October 2022) with Smartphones and Tablets peaking in June, and Smart TVs and Laptops peaking in October.
Recommended Next Steps For Company
-
Budget Recommendations
- Allocate more budget for localized content and promotions in Spain and the US, given their strong subscription performance.
- Increase the budget for marketing efforts and promotions during the months of june to october as these months had a significant dip in subscriptions. Device Related Recommendations
- Ensure the quality of the Netflix app is optimized across all devices, particularly Smartphones and Tablets, since they appear to lead subscriptions during the June peak.
- Experiment with bundling strategies (offering discounts for multi-device users). Other Recommendations
- Analyze competitors activities during June and October to identify any overlaps with Netflix’s trends and adjust strategies accordingly.