Unlocking the Formula for Successful Videos on YouTube
Krutarth Oza
Content Strategist
Data Visualizer
Data Analyst
Google App Script
Python
Tableau
Upwork
This project focuses on developing a data-driven formula for creating successful meditation videos on YouTube. By combining technical expertise, data analysis, and content strategy, I systematically identified patterns and actionable insights to help creators maximize engagement and reach. This system can be applied to any genre of content.
Data Collection:
Using a Python script, I scraped three years’ worth of video data from top-performing YouTube channels in the meditation niche.
Collected key metrics like views, duration, publishing frequency, engagement rates, and video titles to create a robust dataset.
Data Cleaning and Preparation:
Imported the raw data into Google Sheets for detailed cleaning and organization, Removed duplicates, standardized metrics, and categorized videos based on content type (e.g., guided meditations, ambient sounds).
You can find the google sheet here:
Visualization and Analysis:
Designed a dynamic dashboard in Tableau to visualize key relationships, such as the correlation between video duration and views.
Identified patterns like optimal video lengths, keywords that drive engagement, and the impact of publishing frequency on audience retention.