A tracking sheet: one row per video, one lesson per week

Last updated 13 Oct 2026

Without notes every video is a fresh guess. A simple table turns experience into a process.

Course · Stage 6: Publish, measure, multiply · Lesson 30/40 · 8 min

Why it matters

After 20 videos you have enough data to know which topics, hooks and lengths suit your channel — if you wrote it down.

The table separates luck (one viral hit) from patterns (several similar videos all doing well).

Step by step

1. One row per video: post date, topic, hook type, length, thumbnail/title.
2. Record numbers at 48 hours and 7 days: impressions, click-through, average view duration, new followers (plus orders / cart taps for sales).
3. Add a "why I think" column as you log.
4. Each weekend, filter the top 3 and bottom 3 and look for what they share.
5. Write one weekly lesson and apply it to next week's calendar.

Common mistakes

• Logging only views.
• Logging at random times so videos can't be compared.
• Keeping a sheet and never reading it.

Ready-made prompt (ChatGPT / Claude / Gemini)

Here is my tracking sheet for [number] videos: [paste]. Find what the best and worst groups share by topic, hook, length and title. Give 3 hypotheses and one concrete test for next week. Don't over-read the data.

Exercise

Build the sheet for your last 10 videos and write your first weekly lesson.

Done when: Every video has numbers at the same checkpoints, a "why I think" column, and one weekly lesson in the calendar.

Need help? ngocdiep3135@gmail.com