Why keep a log at all
Analytics in the app show recent numbers, but they are not built to be a lifelong record. A log keeps the story of every video in one place, even years later.
It also answers practical questions fast: which hook format did best last spring, what sound did I use in that video, and when did I first post about this topic?
The columns that matter
Start with: date posted, link, file name of your original, caption, hashtags, sound, topic, format and length. These describe the video itself.
Then add results columns: views, likes, comments, shares, saves and new followers. Pick a fixed check-in day, such as seven days after posting, so every video is measured the same way.
Keep it fast to fill in
Use dropdown lists for topic and format so you click instead of type. Freeze the top row and sort newest first so today's row is always easy to reach.
Fill in the description columns on the day you post, then do the results columns in one weekly session. Splitting it this way keeps each task to a few minutes.
Use it to learn, then back it up
Once a month, sort by saves or follows and read the top five rows. Look for patterns in hooks, length or topics, and plan more of what works.
Your log is small but precious, so include it in your regular backups. Download a copy every month and keep it next to your video archive.
Frequently asked questions
Which spreadsheet app should I use?
Any spreadsheet app works, including free online ones. Choose one that you can open on both your phone and computer so you can add rows wherever you are.
Should I log videos that flopped?
Yes. Low performers teach you as much as hits, and a complete log is far more useful when you look back for patterns.