Resources / Templates
Weekly Content Planning Template
Template for planning publish cadence with trend and retention inputs.
Download the free CSV template
Open in Excel, Google Sheets, or LibreOffice. No signup required. Rows marked SAMPLE are fictional worked examples; replace them with your own observations. Keep unavailable metrics blank and record the source, date range, and next action.
Download Weekly Content Planning Template (CSV)Your completed worksheet stays in your spreadsheet. Only use private channel data you are authorized to access, and remove it before sharing the file publicly.
Published by TubeAnalytics, founded by Mike Holp. Data sources and limitations · Corrections and support.
What this template covers
The weekly content planning template structures the process of selecting, validating, and scheduling video topics for a 7-day publish window. It integrates three input sources: trending topic signals, audience retention data from prior videos, and competitor gap analysis — combining them into a prioritized topic list with assigned publish days.
The template addresses the most common content planning failure mode: topic selection based on intuition alone without reference to data. By requiring each topic candidate to be scored against trend signal strength, prior retention performance, and competitive opportunity, the template creates a repeatable decision process that improves content selection consistency over time.
Template workflow
The planning process starts Monday with a topic candidate list built from three inputs: trending topics in your niche from TubeAnalytics's trend discovery module, topics from prior videos where audience retention was above your channel average, and topics where competitor channels have gaps or under-indexed content. Each candidate is scored 1–3 on each dimension, and the top-scoring topics are assigned to the week's publish slots.
Wednesday and Thursday are production windows. The template includes a pre-production checklist that validates thumbnail concept, title keyword placement, and end-screen CTA before recording begins. This prevents the common problem of producing a video and then discovering the title or thumbnail strategy is weak.
- Monday: topic candidate list from trend signals, retention patterns, and competitor gaps
- Tuesday: topic scoring and publish slot assignment
- Wednesday–Thursday: production with pre-production checklist validation
- Friday: upload scheduling with thumbnail, title, and description review
- Sunday: prior week performance review (CTR, retention, RPM) as input for next cycle
Pairing the template with TubeAnalytics
Use YouTube Studio, audience questions, and public competitor research to fill the evidence fields. TubeAnalytics can support the workflow with your authorized channel's performance and public competitor context. A suggested topic or keyword score is a hypothesis, not measured demand or a guarantee of ranking.
The CSV includes the viewer problem, primary query, language, market, intent, format, source URL, observation date, and unanswered question. Check whether an existing video should be updated before assigning a new upload. Record the title promise, thumbnail concept, owner, publication date, success metric, baseline, and review date so research leads to an accountable experiment.
Explore your options
YouTube Weekly Channel Review Template
Download a free CSV for weekly YouTube analytics reviews: compare views, watch time, subscribers, CTR, and revenue with a worked example.
YouTube Competitor Analysis Template
Repeatable framework for tracking competitor uploads, gaps, and benchmarks across a niche.
Template Usage
How to run this template in a weekly or monthly operating cycle.
Reporting Workflow
Pair template checkpoints with recurring dashboard reports.
Related Tools
Use supporting calculators and diagnostics before execution.
Plan & Pricing
Map this template workflow to plan capabilities and limits.
Need template customization?
Use enterprise support for team-specific reporting and operating requirements.