Log every video in one table
One row per video, read on the same day of its life. Without a table, an archive is a pile of memories.
- A spreadsheet (Google Sheets, Excel, Airtable)
- The analytics screen of your platform
- The transcript or script of each video
- Create the columns: video id, platform, publish date, reading date, days live, distribution (main feed, test, ad), format, hook type, length, views, likes, comments, saves, shares, new followers, average watch time, retention at 3 s, 10 s and the end.
- Read the numbers on day 7 for every video, and write the reading date. Day 7 is the reference line.
- Keep the transcript of each video in a folder named by video id.
- Optional: copy the retention curve second by second for the videos you will study (one row per second, with what is said and shown).
Platforms give creators these numbers per video: TikTok's analytics show views, average watch time, the share who watched to the end, traffic sources and the moment viewers lost interest (TikTok Creator Academy). TikTok Studio on desktop exports a CSV. Copying the numbers by hand on one fixed day stays clear of TikTok's ban on automated extraction: its terms forbid extracting data with automated software unless TikTok approves it in writing (TikTok Terms of Service).
- Comparing a 2-day-old video with a 3-month-old one
- Mixing paid and organic views in the same column
- Typing numbers from memory
For your AI
Copy this prompt into your assistant:
Here are the analytics of my last 10 videos: [paste or screenshots]. Build my video log with these columns: video id, platform, publish date, reading date, days live, distribution, format, hook type, length, views, likes, comments, saves, shares, new followers, average watch time, retention at 3 s, 10 s and end. Flag every missing value.
Skill: video-post-mortem · install: npx skills add lkorczowski/content-strategist-AI-cookbook --skill video-post-mortem