youtube-audit
Analyze a YouTube channel with evidence-first metadata, transcripts, performance fields, portfolio shape, and repeated content-quality patterns
- License 许可
- MIT
- 最近更新
- 2026-11-10
- Stars
- ★ 1
- Forks
- 0
01 前言 Front Matter
- name
- youtube-audit
- type
- research
- version
- v0.2
- description
- Analyze a YouTube channel with evidence-first metadata, transcripts, performance fields, portfolio shape, and repeated content-quality patterns
- argument-hint
- <channel URL or handle> [--count N]
03 SKILL.md 正文
YouTube Audit — Evidence-First Channel Analysis
Invoke as $youtube-audit.
Report-First Approval Gate
Default to report-only: present findings, evidence coverage, assumptions, recommended artifact path, and proposed file changes in a pre-approval alignment page plus a concise conversation summary for user approval before creating or updating canonical research, spec, or task files.
Do not write or overwrite synthesized deliverables until the user explicitly approves, unless the user invoked an explicit write/update/fix mode or clearly asked to write files upfront. Raw evidence capture may be persisted before analysis when reproducibility requires it; report those raw paths separately and still gate synthesized research/report writes.
When stopping for approval, build and attempt to open the alignment preview page first, then ask the user to review it and approve, question, or request adjustments. Do not include Recommended next skill, Recommended next command, or downstream routing language. The approval request itself is the next action. Only emit next-skill routing after the approved artifact has been written or updated.
Fetch full video metadata and transcripts from a YouTube channel, persist raw evidence, then analyze both performance shape and content quality. The output identifies repeated strengths, repeated weaknesses, portfolio concentration, content roles, archetypes, and cleanup candidates with evidence cited from specific videos.
Prerequisites
Two CLI tools are required. Neither needs API keys.
- yt-dlp: Lists channel videos as JSON. Install:
brew install yt-dlporpip install yt-dlp. - youtube-transcript-api: Fetches transcripts via Python. If the active Python is externally managed, such as Homebrew Python on macOS under PEP 668, install this package in a project-local virtual environment instead of the system Python.
Check yt-dlp before proceeding. The transcript dependency should be handled through a project-local .venv when it is missing.
Workflow
1. Parse Arguments
$ARGUMENTSmust contain a YouTube channel URL or handle (e.g.@handle).- Optional
--count Nsets how many recent videos to fetch (default 20, max 50). - If no channel is provided, ask the user for one and stop.
- Normalize handles to channel video URLs when needed:
@handle->https://www.youtube.com/@handle/videos. - Validate that
yt-dlpis available first:
command -v yt-dlp
- Select the Python interpreter for transcript fetching. Prefer a workspace-local virtual environment when present; if one is not present, create it before checking the transcript import:
if [ ! -x .venv/bin/python ]; then
python3 -m venv .venv
fi
TRANSCRIPT_PYTHON=.venv/bin/python
"$TRANSCRIPT_PYTHON" -c "from youtube_transcript_api import YouTubeTranscriptApi; print('ok')"
- If the import check fails, install the missing package into the project-local virtual environment, then rerun the import check:
.venv/bin/python -m pip install youtube-transcript-api
"$TRANSCRIPT_PYTHON" -c "from youtube_transcript_api import YouTubeTranscriptApi; print('ok')"
- Store the selected interpreter path and use it for every transcript-fetching command in this audit.
- If package installation fails because network access is unavailable or denied, stop and report the exact safe install commands below:
python3 -m venv .venv
.venv/bin/python -m pip install youtube-transcript-api
Do not recommend installing youtube-transcript-api into Homebrew/system Python with python3 -m pip install ..., and do not recommend --break-system-packages. The local-venv path avoids PEP 668 externally-managed-environment failures on Homebrew Python.
2. Archive Previous Audit
If research/youtube/youtube-audit-*.md or legacy research/youtube-audit-*.md already exists for the same channel (check the > Channel: header in existing files):
- Copy the existing file to
docs/history/archive/YYYY-MM-DD/HHMMSS/research/youtube-audit-*.md. - Preserve the archived snapshot exactly.
- Then proceed to overwrite the canonical path.
New files do not need archive snapshots.
3. Fetch Video List
Create:
research/youtube/data/<slug>/
Run full metadata export, not flat playlist metadata:
yt-dlp --dump-json --playlist-end N "CHANNEL_URL/videos"
Persist the raw newline-delimited response exactly to:
research/youtube/data/<slug>/videos-YYYY-MM-DD.jsonl
Parse each JSON object for at least:
| Field | Notes |
|---|---|
id, webpage_url, title, description |
Identity and audit links |
channel, channel_id, uploader, uploader_id |
Channel identity |
upload_date, timestamp |
Used for recency and views/day |
duration |
Used for views/minute |
view_count, like_count, comment_count |
Performance |
tags, categories, chapters |
Positioning and packaging signals |
thumbnail, thumbnails |
Packaging review signal |
Build a video table sorted by upload date (newest first). Report total videos found.
4. Fetch Transcripts
Use the same Python interpreter that passed the import check. If .venv/bin/python exists and passed the import check, run transcript fetching with .venv/bin/python; otherwise use the Python executable that passed the import check. Fetch transcripts sequentially and persist raw transcript JSON:
from youtube_transcript_api import YouTubeTranscriptApi
from pathlib import Path
import json, sys, time
video_ids = json.loads(sys.argv[1])
out_dir = Path(sys.argv[2])
out_dir.mkdir(parents=True, exist_ok=True)
results = {}
errors = []
for vid in video_ids:
try:
transcript = YouTubeTranscriptApi.get_transcript(vid)
(out_dir / f"{vid}.json").write_text(json.dumps(transcript, ensure_ascii=False, indent=2))
results[vid] = " ".join(entry["text"] for entry in transcript)
except Exception as e:
errors.append({"id": vid, "reason": str(e)})
time.sleep(1.5)
summary = {"transcripts": results, "errors": errors}
(out_dir / "transcripts-summary.json").write_text(json.dumps(summary, ensure_ascii=False, indent=2))
json.dump(summary, sys.stdout)
- Fetch sequentially with 1.5s delay to avoid rate limiting.
- Skip videos without transcripts and log the reason.
- If more than 80% lack transcripts, warn the user and ask whether to proceed.
- Do not fabricate transcript text; transcript gaps are evidence quality limits.
5. Prepare Analysis Context
Build structured records per video:
| Field | Computation |
|---|---|
| Title, date, URL, duration, views, likes, comments | Direct from metadata |
| Age in days | From upload date to current date |
| Views/day | view_count / max(age_days, 1) |
| Views/minute | view_count / max(duration_minutes, 1) |
| Like rate | like_count / view_count when both exist |
| Transcript coverage | yes, no, or partial |
| Archetype | Format pattern such as founder update, interview, tutorial, analysis, vlog, launch, reaction, teardown |
| Content role | Strategic role such as acquisition, trust-building, proof, education, launch support, community retention, cleanup candidate |
If total transcript text exceeds 80,000 words, truncate each transcript to preserve:
- First 500 words (hook and intro)
- Last 300 words (outro and CTA)
- Trim the middle proportionally across all videos to fit the budget
6. Analyze Content
Analyze performance and content in one pass.
Performance And Portfolio Fields
Include:
- Total videos analyzed, transcript coverage, total views, median views, top video, bottom video.
- Views/day and views/minute leaders.
- Top-video concentration: top 1, top 3, and top 5 share of analyzed views.
- Portfolio distribution by archetype and content role.
- Packaging signals from titles, thumbnails, tags, descriptions, and chapters.
- Cleanup candidates: videos with poor fit, weak performance relative to channel median, stale positioning, or inconsistent audience promise. Mark as
keep,refresh,unlist/private candidate, orneeds human review; do not recommend deletion as an automated action.
Content Quality Patterns
Split into positive patterns (double down) and critical patterns (fix).
Every finding must cite evidence from 2+ videos to qualify as a pattern. Single-video observations are not patterns — discard them.
Analyze across these dimensions:
| Dimension | What to look for |
|---|---|
| Positioning | Who is this channel for? Is it consistent? Does the creator own a niche? |
| Hooks | First 30 seconds — do they create curiosity, state a problem, or waste time? |
| Interview style | If applicable — question quality, follow-ups, guest chemistry, interruptions |
| Credibility | Does the creator demonstrate expertise? Name-drop experiences? Show receipts? |
| Topic selection | Are topics timely, evergreen, niche, or scattered? Do they match the audience? |
| Pacing | Does the content drag or rush? Are there dead zones? |
| Editing signals | Verbal cues for cuts, chapters, graphics. Does the script feel edited or rambling? |
| Startup rigor | If startup/business content — are frameworks used? Is advice actionable or generic? |
| Audience trust | Does the creator build trust or erode it? Sponsorship handling, honesty, consistency |
| Portfolio fit | Does each video serve a clear role in the channel strategy? |
| Packaging | Do title, thumbnail, topic, and opening promise align? |
7. Write Report
Save to research/youtube/youtube-audit-<slug>-YYYY-MM-DD.md:
# YouTube Audit — [Channel Name]
> Channel: [URL]
> Videos analyzed: N
> Transcripts available: N of M
> Date: YYYY-MM-DD
> Raw metadata: research/youtube/data/<slug>/videos-YYYY-MM-DD.jsonl
> Raw transcripts: research/youtube/data/<slug>/transcripts/
## Videos Analyzed
| # | Title | Date | Views | Likes | Views/day | Views/min | Duration | Archetype | Role | Transcript |
|---|-------|------|-------|-------|-----------|-----------|----------|-----------|------|------------|
| 1 | [Title](URL) | YYYY-MM-DD | N | N | N | N | Xm | [type] | [role] | Yes/No |
| ... | | | | | |
## Performance Snapshot
- **Total views analyzed**: N
- **Median views**: N
- **Top 1 concentration**: N%
- **Top 3 concentration**: N%
- **Views/day leader**: [video]
- **Views/minute leader**: [video]
## Portfolio Shape
| Archetype | Videos | View share | Notes |
|---|---:|---:|---|
| ... | | | |
| Content role | Videos | View share | Notes |
|---|---:|---:|---|
| ... | | | |
## Positive Patterns (Double Down)
### [Pattern Title]
- **Frequency**: Found in N of M videos
- **Evidence**: [Video 1 title] — "[quote or description]"; [Video 2 title] — "[quote or description]"
- **Recommendation**: [What to keep doing or amplify]
### ...
## Critical Patterns (Fix)
### [Pattern Title]
- **Severity**: High / Medium / Low
- **Frequency**: Found in N of M videos
- **Evidence**: [Video 1 title] — "[quote or description]"; [Video 2 title] — "[quote or description]"
- **Impact**: [Why this hurts the channel]
- **Recommendation**: [Specific fix]
### ...
## Cleanup Candidates
| Video | Recommendation | Evidence | Human check |
|---|---|---|---|
| [Title](URL) | Keep / Refresh / Unlist-private candidate / Needs human review | [performance + fit evidence] | [what to inspect before action] |
## Summary
### Top 3 Strengths
1. [Strength] — [one-line why]
2. [Strength] — [one-line why]
3. [Strength] — [one-line why]
### Top 3 Weaknesses
1. [Weakness] — [one-line why]
2. [Weakness] — [one-line why]
3. [Weakness] — [one-line why]
### Strategic Recommendation
[2-3 sentences: the single most impactful change the channel should make, grounded in the patterns found]
Create the research/youtube/ and research/youtube/data/<slug>/ directories if they do not exist.
8. Summarize In Thread
After saving the report, output: top 3 strengths, top 3 weaknesses, performance/portfolio headline, strategic recommendation, report path, and raw data paths.
Constraints
- Pattern-only reporting: Every finding must have evidence from 2+ videos. No single-video observations.
- Sequential fetching: Do not parallelize transcript fetches — use 1.5s delay to avoid IP rate limiting.
- No API keys: Both tools work unauthenticated against public data. Do not ask the user for API keys.
- Smart truncation: When truncating, always preserve hooks (first 500 words) and outros (last 300 words).
- Honest coverage: If transcripts are sparse, say so. Do not fabricate transcript content or hallucinate quotes.
- Raw evidence first: Always persist raw
yt-dlpJSONL and transcript JSON before writing analysis. - No automated destructive content advice: Cleanup candidates are review recommendations, not instructions to delete content.
- Stay in analysis mode: Do not propose video ideas, scripts, or content calendars. The job is to audit what exists.
Approved Artifact Handoff
After an approved synthesized write, explicit write/update mode, or any direct artifact mutation:
- List every created or updated synthesized artifact path in the final response.
- State the verification performed, such as readback, schema/check command, or why no executable verification applies for a Markdown-only strategy artifact.
- Check and report the relevant git status for intended artifacts when the project is a git repository. If intended artifacts are modified or untracked, make the next action shipping, committing, or an explicit dirty-artifact handoff before recommending downstream strategy work.
- Do not imply the research workflow is complete while approved artifacts remain untracked or uncommitted unless the user explicitly asked not to ship.
- If stopping for approval before writing, the approval request remains the next action; do not include downstream routing.
Intent-Aware Routing
Before applying the default next-step routing, classify the user's immediate intent and route to the missing action that best serves that intent:
- Strategy refresh: recommend the missing or stale positioning, programming, portfolio, metrics, or product-media artifact.
- Recording prep: recommend the missing series spec, script, build proof, walkthrough guide, or validation artifact needed before recording.
- Upload prep: recommend packaging, title/thumbnail, description, chapters, or final metadata work before broader strategy work.
- Performance review: recommend metrics, cadence, portfolio, peer benchmark, or owner-analytics export work before new content planning.
- Owner analytics or private/manual platform evidence: route to an explicit manual/guide handoff instead of inventing unavailable metrics.
- Dirty intended artifacts: route to shipping/commit/handoff first, not another creator strategy skill.
Use the default next-skill sequence only when no stronger user intent, missing artifact, manual blocker, or dirty-artifact handoff applies.
Alignment Page
When this skill produces durable deliverables (research, specs, plans, reports, prototypes, or any document output), build a full-depth HTML alignment page following ALIGNMENT-PAGE.md in this skill's directory. Output: alignment/youtube-audit-{topic}.html.
Default Shipping Contract
Follow the shared shipping contract convention in CLAUDE.md.
04 同仓库更多 Skills
source-checkout-allowed
Valid source-checkout-only fixture.
deck-install-valid
Valid deck install fixture.
codex-pack-guard-valid
Valid Codex Pack Availability Guard fixture.
codex-missing-skill-valid
Valid Codex missing skill fallback fixture.
codex-base-skill-fallback-valid
Valid Codex base skill fallback fixture.
claude-pack-guard-valid
Valid Claude Pack Availability Guard fixture.