How to Build a YouTube Outlier Research Worksheet
Copy a practical field table, work through hypothetical examples, and turn a shortlist into an original production decision.
A folder of impressive videos is easy to collect and difficult to use. When production begins, the team still needs to know which audience problem matters, why a reference belongs in the shortlist, and what original evidence the new video will offer. A research worksheet connects those decisions to observations you can revisit.
Build the worksheet around one production decision, such as choosing a demonstration for first-time apartment renters. This keeps the sheet small enough to review and specific enough to challenge. You can use any spreadsheet application; the method does not depend on a particular template or subscription.
Give the sheet a decision and a deadline
Write a short research brief above the table: intended viewer, practical question, video format, language, publication window, production constraints, and review date. For example, a hypothetical brief could investigate storage demonstrations for renters who cannot drill walls, using equipment already available to the creator.
Add the search phrases and filters you used. ShortsMonkey supports candidate searches with keyword, publication date, video type, region, minimum views, and maximum subscribers. Record those settings when collecting results. They describe your search boundary; they do not establish the location or preferences of every viewer.
Decide what the session must produce: perhaps one feasible concept and two alternatives. Set a time limit before browsing so that collecting references does not consume the time reserved for making the video.
Copy these fields into your worksheet
Use one row per video observation. If you revisit a video later, add another dated observation instead of replacing the original values. Keep numerical fields separate so they remain usable for sorting and calculations.
Calculate V/S only when the subscriber value is known and greater than zero. Mark other cases unavailable. Do not enter zero for an unknown count or substitute an arbitrary denominator. For a research snapshot, use counts collected together and retain the observation date.
| Field | What to enter | Why it belongs |
|---|---|---|
| Video URL | Direct link to the source video | Lets another person inspect the reference |
| Channel | Channel name or identifier | Exposes repeated samples from one creator |
| Published at | Visible publication date | Establishes the video's age |
| Observed at | Date and time of collection | Makes changing counts interpretable |
| Format and language | Short or long video; observed language | Defines a comparison group |
| Topic and viewer problem | A concise description | Connects performance to your brief |
| Views | Count at observation | Preserves the numerator |
| Subscribers | Count at observation, or unknown | Preserves the denominator |
| V/S | Views divided by subscribers | Flags scale relative to channel size |
| Visible evidence | Specific opening, demonstration, or structure | Separates observation from interpretation |
| Hypothesis | One possible explanation to test | Prevents guesses becoming facts |
| Counterexample | Link and note, or none found in this search | Records evidence against the idea |
| Original contribution | Evidence or perspective you can create | Connects research to production |
| Decision and reason | Test, investigate, or park | Makes the next action explicit |
Read three hypothetical rows as decisions
The following invented examples illustrate the worksheet. They are not channel results, measurements, or promises. Assume the videos share a language and format, and all counts were collected on the same day.
C has the largest ratio but a much longer observation window. It should not automatically outrank A for a current production decision. B may address your intended audience more precisely despite its lower ratio. None of these numbers identifies what caused the views.
Current subscriber counts also need care: a channel may have grown since publication. V/S describes the recorded relationship between two counts. It does not recover the subscriber base at release or measure a video's performance against the channel's usual videos.
| Hypothetical reference | Age in days | Views | Subscribers | V/S | Working decision |
|---|---|---|---|---|---|
| A: No-drill drawer divider | 7 | 96,000 | 3,000 | 32 | Investigate the demonstration |
| B: Shared kitchen organization | 9 | 180,000 | 15,000 | 12 | Examine audience fit |
| C: Complete apartment makeover | 240 | 450,000 | 5,000 | 90 | Move to an older-video group |
Review the shortlist in two passes
In the first pass, check comparability. Group similar formats, languages, topics, and video ages. Inspect a few comparable uploads from each channel and record whether the candidate differs from those references. Keep this channel comparison separate from V/S. Limit repeated entries from one creator so their production style does not dominate the shortlist.
In the second pass, watch the content and challenge your interpretation. Write an observable detail, such as “the first shot shows the finished drawer,” before writing “showing the result early may clarify the benefit.” Search for related videos with ordinary performance, including alternate wording and lower view thresholds. If you find none, record the search limitation rather than declaring the format universally successful.
Public counts cannot supply another creator's audience retention or click-through rate. Leave those fields out of the comparison unless you have legitimate access to actual measurements. A confident-looking estimate would make the sheet less useful.
Turn one reference into an original experiment
For hypothetical reference A, the transferable question might be how renters organize storage without permanent changes. An original experiment could compare two removable dividers in a deep, shared drawer, using your own measurements and footage. Show where each design slips, how usable space changes, and which daily task becomes easier.
Write that contribution before drafting the script. Reusing a reference's sequence with different narration is a weak research outcome. Your worksheet should explain the new constraint, evidence, or conclusion the viewer will receive. Confirm the basis for using any third-party material separately.
Close the research session and reopen it after publication
Stop collecting when the deadline arrives, new searches repeat documented patterns, or the remaining uncertainty requires production evidence rather than more browsing. Park concepts that need unavailable access, equipment, or footage. Select a feasible experiment even if another reference has a higher ratio.
Before publishing, save the hypothesis and choose a review interval. Afterward, compare your video with relevant own-channel uploads at similar ages and inspect the analytics actually available to you. Record what supported the hypothesis, what contradicted it, and what to change next. A useful worksheet ends with a decision and later acquires a correction; it never needs to become a museum of successful videos.
More articles
All postsHow to Research Viral YouTube Videos: From V/S to an Original Idea
Turn public video observations into a research brief, compare V/S carefully, seek counterexamples, and plan an original contribution.
Choose YouTube Analytics Tools Around the Decision You Need to Make
Separate public video research, authorized channel analytics, and production notes before choosing a practical tool stack.
How to Read Viral Video Statistics Without Inventing a Benchmark
Build an interpretable sample, preserve raw counts, compare meaningful groups, and describe uncertainty without inventing a market benchmark.