Jev built my YouTube audience dashboard
The speaker built a YouTube dashboard using the YouTube V3 API to analyze approximately 4,500 podcast comments, categorizing them as positive, negative, or neutral and identifying potential episode ideas. The analysis revealed that roughly half the comments are positive, about a quarter are negative, with 58 comments containing actionable episode ideas.
Summary
The speaker describes a project where they leveraged the YouTube V3 API to perform sentiment analysis and content extraction on their podcast's comment section. They enabled the API through Google Console and created an automated system to pull all comments and process them through multiple analytical lenses. First, the system categorizes comments into sentiment buckets: positive, negative, or neutral (or potentially as a numerical score). Second, it uses an AI tool (referred to as 'Jeff') to identify whether comments contain ideas for future episodes. Third, the system analyzes all aggregated data and presents it in a dashboard format for easy visualization. The key findings show that approximately 50% of comments are positive in sentiment, about 25% are negative, leaving roughly 25% as neutral. The analysis also extracted 58 specific comments that contained viable episode ideas that could be developed into future content. Additionally, the speaker notes a category of 'quality praise' comments that compliment aspects like the podcast's visual presentation. This project demonstrates the speaker's interest in leveraging data analysis to better understand audience sentiment and derive actionable content ideas directly from viewer engagement.
Key Insights
- The speaker reads and replies to comments daily but had never performed systematic analysis on the 4,500+ accumulated comments to understand their sentiment distribution or actionable value
- The speaker uses the YouTube V3 API, which requires enabling through Google Console, to programmatically pull all podcast comments for analysis
- The analysis identified exactly 58 comments containing viable episode ideas that could be extracted and developed into future podcast content
- Sentiment analysis of 4,500 comments revealed a 50% positive, 25% negative, and approximately 25% neutral distribution
- Beyond sentiment, the speaker tracked a separate 'quality praise' category specifically measuring compliments about the podcast's visual presentation and aesthetics
Topics
Transcript
[0:00] You wonderful people give us comments on how I I podcast and I go through them. I read them every day and I reply to them when I can, but I've never done analysis on them. There's about 4,500 comments and I just wanted to know like are they good? Are they bad? Are they happy? Are they sad? And I also wanted to know if you all had any episode ideas for me where I could extract them and come up with episodes that I could do like this Jeff one. And so I hooked up the YouTube V3 API. You just have to enable it in [0:30] Google console and then I said pull all the comments…
Full transcript available for MurmurCast members
Sign Up to AccessMore from How I AI
A perfect TikTok cut from a one sentence prompt
Claude code automatically transforms a single sentence prompt into a polished, TikTok-ready short-form video with captions, jump cuts, and zooms in approximately 4 seconds with no manual editing required. The tool demonstrates AI's capability to understand and execute high-quality short-form video production autonomously.
I made my website photo follow you (and wink)
The creator made an interactive photo of themselves that follows viewers around their website and winks when clicked. They accomplished this by converting a photo into a black-and-white dither pattern, using Claude to generate six directional versions of the image, and writing code to make it interactive.
Claude Code turned one long video take into a 15-second ad
A creator demonstrates an AI-powered video editing workflow that automatically transformed a single 5-minute phone recording into a polished 15-second vertical ad. The system used silence detection, speech recognition, facial tracking, and automated shot composition to generate cuts, captions, and graphics without manual timeline editing.
I Turned a $50 Photo Frame Into an AI Family Dashboard
A creator transformed a $50 Amazon photo frame running Android into a customized AI-powered family dashboard using OpenAI's Codeex and web technologies. The dashboard displays family schedules, photos, NASA images, news, and individual checklists for each family member, with updates automatically posted via an API connected to a grabbot that monitors calendars and emails.
Claude Code edited my TikTok
A creator describes using Claude Code to automatically edit their TikTok videos by analyzing raw footage and verbal instructions. The AI tool uses existing computer tools like FFmpeg, Whisper, and Python to process local files, intelligently cutting segments based on spoken cues and selecting the best takes.