Loading...
Loading...
Resources / Templates
Template for planning publish cadence with trend and retention inputs.
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.
Download a free CSV for weekly YouTube analytics reviews: compare views, watch time, subscribers, CTR, and revenue with a worked example.
Repeatable framework for tracking competitor uploads, gaps, and benchmarks across a niche.
How to run this template in a weekly or monthly operating cycle.
Pair template checkpoints with recurring dashboard reports.
Use supporting calculators and diagnostics before execution.
Map this template workflow to plan capabilities and limits.
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.
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.
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.
Use enterprise support for team-specific reporting and operating requirements.