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.

You can find dashboard here: https://public.tableau.com/app/profile/krutarth.oza/viz/MeditationVideosAnalysis/ViewsvsDuration_1

Documenting the Formula:

Synthesized findings into a clear, actionable formula for creating viral meditation videos:

You can check a sample code here, it can be applied to any YouTube channel:- https://github.com/krutarth-dev/Youtube-api-analysis.