Identify top-performing videos

Send me a list of the top-performing videos for the channel by watch time for the last 90 days. Include video title, URL, publish date, total watch hours, average view duration, and subscriber change attributed to each video. Put the ranking in descending order of watch hours and deliver as a Google Sheet shared with Content Lead Sarah by Tuesday 10:00 a.m.

Before I show this to the content team, surface the drivers of performance. Make the top videos list show thumbnail type, topic tag, length bracket, and whether the video was promoted via paid campaign. Flag any video where a large spike comes from a single external referrer and call out videos with low click-through but high watch time that could benefit from title/thumbnail experiments.

I noticed our March 12 video that drove a lot of subs is no longer in the top-10 by watch time this week. The content team is puzzled and wants to know if this is a reporting quirk, a real drop in engagement, or a metadata issue. I don't know if an algorithmic re-rank, a removal of embeds, or a date filter caused it. What should I check first and how would I quickly determine the real cause?

Across eight quarters we keep getting one-off viral hits but fail to replicate the pattern deliberately. We waste time chasing formats that performed once without tracking what made them work. What three habits should the content team change so we can systematically increase the number of videos that reach the top cohort each quarter?