How I Track Every Movie and Show I Watch (and Why My Watchlist Finally Works)

My watchlist had 247 items on it. I was adding 3 or 4 new entries every week and watching maybe one. Sometimes not even that. I'd open the list on a Friday night, scroll past everything and put on something I'd already seen twice.

That's backlog paralysis. The list was supposed to help me find things to watch. Instead it became a graveyard of good intentions. I didn't start tracking to fix the list – I started tracking because I wanted to understand what I was actually choosing to watch versus what I was hoarding for some imaginary future where I had unlimited free time.

The watchlist trap

Every friend recommendation goes on the list. Every trailer that looks halfway interesting. Every "you should watch this" from a podcast. The list only grows. It never shrinks.

The real problem isn't finding things to watch. Streaming services have made that trivially easy. The problem is choosing from 200+ options when you're tired on a Wednesday night and just want something good. The paradox of choice kicks in and you end up re-watching The Office for the fourth time because that's a decision you don't have to make.

I realized my watchlist wasn't a plan. It was a collection of impulses. Tracking what I actually watched – not what I wanted to watch someday – gave me a completely different picture.

What I actually log

After the credits roll, I open a spreadsheet and add one row. It takes about 30 seconds. Here's what goes in:

• Title – the movie or show name
• Type – movie or TV show
• Genre – whatever fits best, not agonized over
• Platform – where I watched it
• Date watched – today's date, usually
• Rating – 1 to 5 stars, gut reaction
• Season number – for shows, so each season gets its own row
• Notes – optional, usually one sentence if anything

I don't log things I watched halfway and stopped. That's a different status. If I bailed 20 minutes in, it doesn't go in the "watched" column – it either gets marked as "Did Not Finish" or stays on the list for another attempt later.

The key is keeping it fast. If logging a movie takes longer than the time it takes to scroll through the credits, you'll stop doing it.

Movies and shows are different data

This is something I didn't appreciate at first. A movie is one row. Clean and simple. But a 5-season binge is 5 separate rows spread across weeks or months. They look completely different in charts.

My year-end count of "things watched" was 127 last year. That sounds like a lot until you realize 38 of those were individual seasons of TV shows. Eight seasons of a long-running series and eight standalone movies are not equivalent experiences, but they take up the same number of rows.

I track both together because the alternative – maintaining two separate logs – is more effort than it's worth. But I keep the "type" column populated so I can filter when I want to see just movies or just series. The charts break them out automatically.

Platform math

This was the part that actually changed my behavior. After six months of tracking, I looked at where I was watching things.

43% of what I watched was on Netflix. That made sense – it's the service I open first by default. 31% was on a friend's Disney+ account I'd been borrowing since the pandemic. The remaining 26% was scattered across four other services I was paying for.

Four services. For a quarter of my viewing. Two of them were getting used about once a month each. I was spending $28 a month on subscriptions that accounted for maybe 12% of my actual watching.

I cancelled those two. If something comes up on one of them that I genuinely want to watch, I'll subscribe for a month and cancel again. The data made that decision obvious in a way that gut feeling never did.

My watchlist isn't a to-do list anymore. It's a pool of options. The tracker is what shows me what I actually chose.

The rating honesty problem

Most streaming platforms give you a thumbs up or thumbs down. That's not enough information and we all know it. A 3-star movie and a 5-star movie are completely different experiences, but they'd both get a thumbs up.

Forcing yourself to pick a number on a 1-to-5 scale makes you actually think about whether something was good or just fine. "Did I enjoy this?" is a different question from "Was this worth two hours of my life?" and both are different from "Would I recommend this to someone?"

I just go with my gut. How did I feel when the credits rolled? That's the number. No overthinking.

After a year of doing this, most of what I watch lands at 3 stars. That's not a failure – it means most things are decent but not memorable. The 5-star entries genuinely stand out when you scroll through. There are only 11 of them from last year and I can tell you every one without looking.

Documentary clusters

I watch documentaries in waves. Two weeks of nothing, then four in a row. It happens every couple of months and I never noticed it until the genre chart made it obvious.

The same thing happens with horror in October. And rom-coms in December. The data shows these seasonal spikes clearly. My genre distribution isn't even close to what I would have guessed if you'd asked me to estimate it.

I thought I watched a lot of sci-fi. Turns out I watch a lot of sci-fi trailers and then choose thrillers instead. The genre I actually watch most often is drama, which is boring to admit but the numbers don't lie.

These are patterns you'd never notice without data. Your self-image as a viewer and your actual viewing habits are rarely the same thing.

Tips for getting started

Don't log while watching

Log after credits. During the movie you're watching, not data-entering. Picking up your phone to fill in a row while something is playing defeats the entire point. The 30-second log at the end is enough. If you can't remember the genre the next morning, that tells you something too.

Rate it before you read reviews

Your opinion changes after reading what other people thought. A movie you liked becomes "guilty pleasure" after seeing a 40% Rotten Tomatoes score. A movie you thought was fine becomes "underrated gem" after someone explains the symbolism you missed.

Lock in your rating the night you watch it. Your gut reaction is the honest one. You can always update it later if you change your mind, but the initial score is usually the most accurate reflection of your actual experience.

Track re-watches – they count

Re-watching a favorite isn't wasted time. It's data. If you've watched the same movie 4 times, that tells you something important about your taste that a single viewing never would.

I have three movies that show up more than once in my log. They're all comfort picks – the kind of thing I put on when I don't want to think about what to watch. Knowing that about myself is more useful than any recommendation algorithm.