Free tool · runs in your browser
YouTube Analytics Analyzer
A free YouTube analytics analyzer for your own Studio export. It reads the CSV for you: outlier scores against your own median, and a verdict for every video on whether the packaging or the content is the problem. Everything runs in your browser.
How to export the right file
In YouTube Studio open Analytics, click Advanced mode in the top right, make sure the Content tab is selected, then use the Export current view button and choose CSV. The file you want contains one row per video with views, impressions, click-through rate and average view duration. Any date range works, though 90 days or more gives the medians something real to stand on.
Why compare against your own median
Industry averages tell you nothing because they average channels nothing like yours. Your own median is the honest baseline: a video doing three times your median is a signal regardless of whether your median is two hundred views or two hundred thousand. The most useful list this tool produces is the hidden gems, videos that hold viewers longer than your median but get clicked less. Those earned a second launch with new packaging, which costs an afternoon instead of a production week.
How the youtube analytics analyzer works
Export the Content view from YouTube Studio
Analytics, Advanced mode, Content tab, Export current view, CSV. Any date range works; 90 days or more gives the medians something real to stand on.
Drop the file on this page
The CSV is parsed in your browser. It needs at least a Title and a Views column; impressions, click-through rate and average view duration unlock the verdicts.
Read the medians first
Your own median views, CTR and view duration are the baseline. Every score on the page is relative to them, not to an industry average.
Act on the verdicts
Each video gets one of four verdicts. The hidden gems, videos that hold viewers but fail to get clicked, are the cheapest wins: a new title and thumbnail, not a new production.
How the four verdicts are decided
Every video is compared with your channel's median on two axes: whether it earned clicks (click-through rate against your median CTR) and whether it held people (average view duration against your median). The two answers combine into one of four verdicts: 'Working: make more like this' when both are above; 'Packaging wins, video underdelivers: fix the middle' when it was clicked but not watched; 'Hidden gem: the video holds people, the packaging fails it' when it was watched but not clicked; and 'Neither clicks nor holds: retire this format' when both are below.
The outlier score is how far a video's views sit from your median. A video at three times your median is a signal whether your median is two hundred views or two hundred thousand.
Common mistakes when reading YouTube analytics
- Comparing against industry averages. They average channels nothing like yours; your own median is the only honest baseline.
- Exporting too short a window. A 28-day export of a channel that posts weekly is four data points.
- Reading views without CTR and duration. Views alone cannot tell you whether the packaging or the content did the work.
- Remaking the flops. The videos worth touching first are the ones people watched but did not click.
- Treating one outlier as a strategy. One video at ten times the median is a lead to investigate, not a format to copy blindly.
Frequently asked questions
How do I export YouTube analytics to CSV?
In YouTube Studio open Analytics, click Advanced mode in the top right, select the Content tab, then use Export current view and choose CSV. The file has one row per video with views, impressions, click-through rate and average view duration.
Is my analytics data uploaded anywhere?
No. The CSV is parsed entirely in your browser and never leaves the tab. There is no account, no upload and no server involved in the analysis.
What is an outlier score?
How far a video's views sit from your channel's median views. A score of 3 means three times your median. It is relative to your own channel, which is why it is meaningful at any size.
What does 'hidden gem' mean?
A video that holds viewers longer than your median average view duration but is clicked less than your median CTR. The content works and the packaging fails it, which makes it the cheapest video on your channel to relaunch with a new title and thumbnail.
Which videos should I repackage first?
The hidden gems. They have already proven the content holds attention, so a new title and thumbnail is the whole fix. Then look at 'packaging wins, video underdelivers' videos to learn which promises your content is failing to keep.
Does it work without CTR and duration columns?
Partly. With only Title and Views it still gives you medians and outlier scores. The four verdicts need impressions, click-through rate and average view duration, which the Content export includes.