🚀 Transform YouTube research into actionable insights with Google Sheets - Free YouTube analytics tool for content creators and marketers
git clone https://github.com/clairechung/YoutubeAssistant.git🚀 Transform YouTube research into actionable insights with Google Sheets - Free YouTube analytics tool for content creators and marketers
No install command available. Check the GitHub repository for manual installation instructions.
git clone https://github.com/clairechung/YoutubeAssistantCopy the install command above and run it in your terminal.
Launch Claude Code, Cursor, or your preferred AI coding agent.
Use the prompt template or examples below to test the skill.
Adapt the skill to your specific use case and workflow.
Act as a YouTubeAssistant. Analyze the following YouTube channel [CHANNEL_NAME] and provide insights on its content strategy, audience demographics, and engagement metrics. Focus on [INDUSTRY] and compare it with [COMPETITOR_CHANNEL]. Generate a report in markdown format with clear headings and bullet points.
# YouTube Channel Analysis: [CHANNEL_NAME] ## Content Strategy - **Video Topics**: Primarily focuses on [INDUSTRY] tutorials and product reviews. - **Posting Frequency**: 2-3 videos per week, maintaining consistency. - **Video Length**: Average duration of 12-15 minutes, optimized for viewer retention. ## Audience Demographics - **Age Group**: Predominantly 18-34 years old. - **Gender Distribution**: 60% male, 40% female. - **Geographic Location**: Majority of viewers from the US, UK, and Canada. ## Engagement Metrics - **Average Views**: 50,000 per video. - **Likes to Dislikes Ratio**: 98:2, indicating high audience satisfaction. - **Comment Engagement**: Average of 500 comments per video, fostering community interaction. ## Comparison with [COMPETITOR_CHANNEL] - **Content Strategy**: [COMPETITOR_CHANNEL] focuses more on vlogs and behind-the-scenes content. - **Engagement Metrics**: [COMPETITOR_CHANNEL] has a slightly higher average view count but lower comment engagement.