Building a Shorts Analytics Spreadsheet That Lasts

A Shorts analytics spreadsheet earns its place because the dashboard forgets. In-app numbers reset to a rolling window and bury older clips, so any trend longer than a few weeks disappears. A sheet keeps every clip and lets you compare this month to six months ago.

I keep one row per clip and about eight columns. That is enough to see patterns and small enough that I actually fill it in. I have built the giant version before, with forty columns and color coding, and it lasted nine days. Simplicity is what keeps a tracker alive.

The sheet earns trust slowly, and then one day it tells you something the app never could. That is when the fifteen minutes a week starts to feel cheap.

The columns I actually use

• Date posted and clip length, so comparisons stay honest.
• Topic or format, so I can group similar videos.
• Views and viewed, the raw reach numbers.
• Average view percentage and swipe-away rate, the quality pair.
• Notes on the hook line, so I can learn from the wording.

Add context, not just counts

A number without context is trivia. A column for the hook line turns the sheet into a study of what made people stay, and a column for the day it posted catches the weekly rhythm nobody notices in real time. Context is what lets a number become a lesson.

I also note whether the clip was a test. When I know a clip was an experiment, I judge it differently than a clip built to win. Experiments get graded on what they taught me, not on how they performed.

A row of numbers can tell you a clip underperformed. Only the context columns tell you it underperformed for a reason you can fix, or for a reason outside your control, like a slow news day.

A spreadsheet is not a scoreboard. It is a lab notebook with columns.

The weekly review, fifteen minutes

Once a week I sort by average view percentage and read the top and bottom rows. The best clips tend to share a hook shape and a length, and the worst share a different pair. I write two sentences about the pattern and close the file.

Fifteen minutes is the point. A review long enough to feel like a project stops happening, and a tracker you stop reading is worse than no tracker at all. I schedule the review on the same morning every week so it becomes a habit instead of a decision.

The review also keeps me honest about my own taste. The clips I loved and the clips that performed often differ, and the sheet forces me to notice the gap instead of explaining it away.

What to leave out

I do not log anything per second, because the retention graph already lives in the app and copying it into cells wastes the time I need for writing. I skip follower count per clip, since a Short can reach people who do not follow me. Both belong in the dashboard, not the sheet.

The rule is simple. If a column has never changed a decision, it gets deleted. A tracker grows by cutting as much as by adding.

Key takeaways

• Keep one row per clip and no more than eight columns.
• Log the hook line so you can study the wording later.
• Review the sheet once a week for fifteen minutes.
• Delete any column that has never changed a decision.