Back to blog
Blog · Research methods
6 min read · 2026/10/08
Worksheet6 min read
Blog · Research methods2026/10/08

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.

Copy these fields into your worksheet
FieldWhat to enterWhy it belongs
Video URLDirect link to the source videoLets another person inspect the reference
ChannelChannel name or identifierExposes repeated samples from one creator
Published atVisible publication dateEstablishes the video's age
Observed atDate and time of collectionMakes changing counts interpretable
Format and languageShort or long video; observed languageDefines a comparison group
Topic and viewer problemA concise descriptionConnects performance to your brief
ViewsCount at observationPreserves the numerator
SubscribersCount at observation, or unknownPreserves the denominator
V/SViews divided by subscribersFlags scale relative to channel size
Visible evidenceSpecific opening, demonstration, or structureSeparates observation from interpretation
HypothesisOne possible explanation to testPrevents guesses becoming facts
CounterexampleLink and note, or none found in this searchRecords evidence against the idea
Original contributionEvidence or perspective you can createConnects research to production
Decision and reasonTest, investigate, or parkMakes 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.

Read three hypothetical rows as decisions
Hypothetical referenceAge in daysViewsSubscribersV/SWorking decision
A: No-drill drawer divider796,0003,00032Investigate the demonstration
B: Shared kitchen organization9180,00015,00012Examine audience fit
C: Complete apartment makeover240450,0005,00090Move 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.