顧哥知識系統

YouTube 影片逐字稿索引

Properties1
tagsyoutube, transcript, video-analysis, research

閱讀時間約 3 分鐘

YouTube 影片逐字稿索引

所有透過 Windows transcript worker 抓回的 YouTube 影片逐字稿索引。
原始檔案位於 raw/transcripts/youtube/youtube-{video_id}.md（逐字稿）與 youtube-{video_id}.json（metadata）。

這些逐字稿已正式納入 wiki 內容層，每支成功取得逐字稿的影片都有對應分析頁，供每週掃描與顧哥查閱影片重點。

索引說明

  • Status: success = 有完整逐字稿（含時間戳記），failed = 逐字稿無法取得或內容過短
  • 分析頁：YES = 已建立摘要、品牌啟發與可發文角度的 query 頁
  • Transcript file: 原始逐字稿路徑
#Video IDStatusTitleChannelLanguageChars分析頁
1[[queries/raw-analysis/transcripts/youtube/youtube-75yOYy7zGmY75yOYy7zGmY]]✅ success7 Online Course Trends in 2025Sarah Turner AgencyEnglish22,145
2[[queries/raw-analysis/transcripts/youtube/youtube-7Z4QLM_QMrk7Z4QLM_QMrk]]✅ successHow to ACTUALLY Sell Online Courses in 2026Stockton WalbeckEnglish49,503
3[[queries/raw-analysis/transcripts/youtube/youtube-8sv7vHxe-gY8sv7vHxe-gY]]✅ success線上課程已死？2026年知識獲利市場的趨勢傑少 JAYChinese (Taiwan)20,525
4[[queries/raw-analysis/transcripts/youtube/youtube-AV4r2Qixb1YAV4r2Qixb1Y]]✅ successHow to Sell Your Online Course With No Audience in 2025Sarah Turner AgencyEnglish20,258
5[[queries/raw-analysis/transcripts/youtube/youtube-E-tUmafs__ME-tUmafs__M]]✅ successSubscribers Don’t Mean Much on YouTube (and that’s good?)Think Media PodcastEnglish29,826
6[[queries/raw-analysis/transcripts/youtube/youtube-EX3ppZMDOgkEX3ppZMDOgk]]✅ successWhat is Cognitive Load? (Explanation + Practical Examples)The L&D AcademyEnglish14,004
7[[queries/raw-analysis/transcripts/youtube/youtube-KPicGKczYKwKPicGKczYKw]]✅ successHow to go FULL TIME on YouTube in 6 Months (or less)Think Media PodcastEnglish172,616
8[[queries/raw-analysis/transcripts/youtube/youtube-NUignG2WjLYNUignG2WjLY]]✅ successHow to Sell Online Course With No Audience in 2025Sarah Turner AgencyEnglish24,493
9[[queries/raw-analysis/transcripts/youtube/youtube-O3gpG3KujXkO3gpG3KujXk]]✅ successWhy AI Makes Human Creators More Valuable?LearnWithJeanEnglish11,414
10[[queries/raw-analysis/transcripts/youtube/youtube-P9Pgtkj5ND8P9Pgtkj5ND8]]✅ successWhat’s Actually Working on YouTube Shorts in 2026?Think Media PodcastEnglish69,624
11[[queries/raw-analysis/transcripts/youtube/youtube-S8ea0EzzFyES8ea0EzzFyE]]✅ successWhy Free Info Isn’t EnoughSarah Turner AgencyEnglish886
12[[queries/raw-analysis/transcripts/youtube/youtube-TBitxckhL5oTBitxckhL5o]]✅ success5 Trends Shaping Online Courses in 2025The Launch ScientistEnglish15,166
13[[queries/raw-analysis/transcripts/youtube/youtube-UHMiXDYdnDYUHMiXDYdnDY]]✅ successWhat is Metacognition? (Simple Explanation + Practical Example)The L&D AcademyEnglish4,195
14[[queries/raw-analysis/transcripts/youtube/youtube-dqADcZEY-p0dqADcZEY-p0]]✅ successThe New Way to Create Online Courses Into 2026Think Media PodcastEnglish59,369
15[[queries/raw-analysis/transcripts/youtube/youtube-g6-LyDSIFf4g6-LyDSIFf4]]✅ successIf I had a Dead YouTube Channel, I’d Do ThisThink Media PodcastEnglish46,776
16[[queries/raw-analysis/transcripts/youtube/youtube-iE3HmsyvA1EiE3HmsyvA1E]]✅ success5 L&D Trends for 2025The L&D AcademyEnglish9,811
17[[queries/raw-analysis/transcripts/youtube/youtube-g2mxzGOV490g2mxzGOV490]]⚠️ insufficientStop trading time for moneySarah Turner AgencyEnglish219

統計

項目數值
總影片數17
成功取得 transcript16
失敗（字幕無法取得）1
中文影片1
英文影片16
已建立分析頁17（其中 1 篇低信心）
總逐字稿字數~573,000+ chars

逐字稿路徑

所有逐字稿原始檔案位於：

  • Markdown: raw/transcripts/youtube/youtube-{video_id}.md — 含 frontmatter + 時間戳逐字稿
  • JSON: raw/transcripts/youtube/youtube-{video_id}.json — 含 metadata + 分段結構
  • Quartz mirror: /root/quartz/content/raw/transcripts/youtube/

使用方式

  1. 一對一分析：各影片分析結果寫在 index 對應頁面中。
  2. 每週掃描流程: weekly-wiki-scan.py 已修改為優先讀取本地 transcript 檔案，替代被 YouTube API 封鎖的線上抓取。
  3. 新增影片: 由 Windows transcript worker 自動抓取 → 寫入 raw/transcripts/youtube/ → 下次 cron 執行時自動被掃描流程吸收。

失敗影片說明

Video ID原因
g2mxzGOV490 (Stop trading time for money)YouTube Short — 僅 1 行語音 “Mhm” 無實質內容

相關頁面

關係圖譜

反向連結