SermonPrepDesk — Production Tracker
This is the source of truth for what's scripted / recorded / posted. Update the row the moment an asset changes state. If it's not in this table, it isn't being tracked.
Channel: The Sermon Prep Desk · https://www.youtube.com/@SermonPrepDesk
Legend: ✅ done · 🟡 in progress · ⬜ not started · ❓ needs founder confirmation · — n/a
⚠️ Seeded 2026-06-13 from documents + this session. The "posted" rows for the trailer and Sower are from the founder saying so verbally — paste the real URLs + dates and clear the ❓ flags. I cannot see YouTube directly.
Hubs & evergreens
| Asset | Serves (Sunday) | Script | Recorded | Posted | Live URL | Shorts posted / planned |
|---|---|---|---|---|---|---|
| Channel trailer — "What Is Show, Don't Tell For Preachers?" | evergreen | ✅ trailer-script-show-dont-tell.md | ✅ | ✅ ❓ | ❓ paste | — |
| Ep 1 — The Sower (Matt 13:1-9,18-23) | Jul 12, 2026 | ✅ hub-scripts-batch1.md | ✅ | ✅ | https://www.youtube.com/watch?v=JgX830MoqmM | 4/4 posted ✅ (log below) |
| Ep 2 — Wheat & Weeds (Matt 13:24-30,36-43) | Jul 19, 2026 | ✅ hub-scripts-batch1.md | ✅ edited → 02-exports (thumbnail ✅) | ✅ | https://youtu.be/Weckg5ZY9PU | 4/4 posted ✅ (log below) |
| Ep 3 — Mustard/Yeast/Treasure/Pearl (Matt 13:31-33,44-52) | Jul 26, 2026 | ✅ hub-scripts-batch1.md | ⬜ | ⬜ | — | 0 / 5 (kit ✅ shorts-kit-ep03.md) |
| Ep 4 — Feeding the 5,000 (Matt 14:13-21) | Aug 2, 2026 | ✅ hub-scripts-batch1.md | ⬜ | ⬜ | — | 0 / 5 (kit ✅ shorts-kit-ep04.md) |
| Evergreen — How to Preach Luke 15 | evergreen | ⬜ not written | ⬜ | ⬜ | — | 0 / ? |
| Evergreen — Psalm 23 Funeral Sermon | evergreen (flagship) | ✅ flagship-funeral-psalm23.md (2026-06-13) | ⬜ | ⬜ | — | 0 / 5 (cutlist ✅ in script) |
Shorts scored: 8 posted of ~23 planned/scripted across the assets above (Ep1 4/4 + Ep2 4/4).
Ep1 Shorts — upload log (titles used: A / pastor-search):
- ① LensLines — https://youtube.com/shorts/UMbVBBocAJg ✅
- ② Show, Don't Tell — https://youtube.com/shorts/8GRhb403Zr4 ✅
- ③ Sermon Title Clinic — https://youtube.com/shorts/KVfHNfiBz9k ✅
- ④ The Detail You Missed — https://youtube.com/shorts/_wUTXgXSYXw ✅
Per Short after upload: add to its pillar playlist + set related-video link → Ep1 hub
JgX830MoqmM+ pin the comment question.
Ep2 Shorts — upload log (rendered 2026-06-17 from 02-exports/2026-06-17_swpd_short-ep02-*; full Script (A) takes, title badge + −14 LUFS, captions burned in):
- ① The Detail You Missed (darnel) — https://youtube.com/shorts/xLT06fIcBec ✅
- ② LensLine ("not the judge of the field") — https://youtube.com/shorts/gnKsIzO-yu8 ✅
- ③ Title Clinic ("Stop Weeding Your Church") — https://youtube.com/shorts/KIj9DfE8Y7g ✅
- ④ Do's & Don'ts ("weed-ID badges") — https://youtube.com/shorts/SKSspdebVKc ✅
Per Short after upload: add to its pillar playlist + set related-video link → Ep2 hub
Weckg5ZY9PU+ pin the comment question. Titles/descriptions/playlists pershorts-kit-ep02.md.
Supporting assets
| Asset | Status | Notes |
|---|---|---|
| Funeral Prep Pack landing page | ✅ LIVE | sermonwise.ai/funeral-prep (PR #898). The funnel the Psalm 23 flagship feeds. |
| Standing stinger ("from here… to here…") | ✅ recorded | Already cut into the Sower video; reusable in every hub via the post pipeline. |
| Tuesday Sermon Prep Pack — signup | ✅ form LIVE | Inline form on sermonwise.ai/prep-desk (verified 200, captures tag tuesday_prep_pack → MailerLite group tuesday-prep-pack). Weekly SEND automation is founder-gated in the MailerLite UI — confirm it's switched on before driving signups. |
| Channel banner / avatar | 🟡 | Avatar is a placeholder per README.md — replace with a real headshot of John. |
| Channel-trailer slot assignment (Studio → Layout) | ❓ | The Show Don't Tell video is posted — confirm it's set as the channel trailer for non-subscribers, or it won't auto-play on the homepage. |
What's next (priority queue)
Full validated video idea backlog (the build queue):
video-backlog.md— every open lane from the 2026-06-18 content-gap research, prioritized, with a build brief each. Build template:graveside-committal-pack.md+shorts-kit-graveside.md.
- Preach a stranger's funeral — top backlog pick (extends the end-of-life moat, best SermonWise demo, zero competition). Script ✅
stranger-funeral-pack.md— record next. Seevideo-backlog.md①. - How to preach on hell — opens the hard-texts category (
video-backlog.md②). Script ✅preach-hell-pack.md. - Ep 3 — Mustard/Yeast/Treasure/Pearl. Date-pegged: serves Jul 26. Hub + shorts RECORDED (2026-06-16) — needs render/polish + upload.
- Ep 4 — Feeding the 5,000 (date-pegged Aug 2). Script ready; not recorded.
- Seasonal queue: Christ the King + Reformation + All Saints (fall cluster); Trinity (~late Apr). Scripts ✅
fall-cluster-pack.md+preach-trinity-pack.md.
✅ Done 2026-06-19 (scripts): All 16 open backlog lanes scripted — full packs (hub + word-for-word Shorts + paste-ready upload metadata) on the graveside-committal-pack.md template. End-of-Life: stranger-funeral-pack, suicide-funeral-pack (988 baked in), child-funeral-pack, unbeliever-funeral-pack. Hard Texts: preach-hell-pack, preach-trinity-pack, imprecatory-psalms-pack, preach-revelation-pack, preach-joshua-conquest-pack. Church Year: fall-cluster-pack (3 hubs), ascension-transfiguration-pack (2 hubs), parenting-days-pack. Trapped Pastor: dying-church-pack, saturday-night-panic-pack, passage-to-sermon-beginner-pack, never-preached-this-sunday-pack. ~20 hubs + ~75 Shorts queued for recording. New Studio playlists to create: Hard Texts · The Church Year · The Trapped Pastor. Index: video-backlog.md.
✅ Done 2026-06-19: Graveside / Committal hub (youtu.be/Mb9tHVdVl4Y) + thumbnail + 5 Shorts kit; committal card + walkthrough video embedded on sermonwise.ai/funeral-prep AND /prep-desk (PRs #964, #972 merged). Funeral Prep Pack hub + 6 Shorts published. Content-gap research → content-gap-opportunities.md + video-backlog.md.
✅ Done 2026-06-17: Ep 2 hub posted + all 4 Ep 2 shorts rendered & posted (4/4). Ep 1 4/4 already live.
Where metrics live (post-publish)
Per-video analytics (engaged views, AVD %, subs/1K, related-video CTR on Shorts, description CTR on hubs, emails attributed, A/B title winner) follow the dashboard spec in strategy.md §8. Pull from YouTube Studio; record the leading numbers here per video once they accrue. Track by hand at the Day-30 / 60 / 90 gates (strategy §8). The strongest qualitative signal — pastors commenting with passage requests — gets counted weekly.