Someone searches for how to freeze the top row of a spreadsheet. The thumbnail shows the result, but the author spends the opening minutes describing their experience. The required command appears near the end. The search query helped find the video; the video made the answer difficult to find.
Consider an analytics school making a short demonstration with a lead-tracking spreadsheet. It wants to help viewers keep headings visible while scrolling and introduce its teacher. All numerical examples are illustrative.
Start with the viewer's action
Before recording, the author defines the result: the viewer freezes the top row and confirms that headings stay visible while scrolling. Specify the editor, device and version where they affect the procedure. This example does not name commands: take them from the interface actually being recorded.
Build the script around one spreadsheet. First scroll it to show the headings disappearing. Then perform the action and scroll the sheet again. The viewer sees the original difficulty, the solution and confirmation on the same data.
During recording, the cursor, narration and picture should address the same step. Name the command while it is visible. Enlarge the relevant area and place captions where they do not obscure the action. Correct errors in feature names before publication.
State any preparation needed at the start. An alternative method or common mistake can follow the main result. Let the task determine duration: an extended demonstration and one that moves too quickly hinder repetition in different ways.
Match the query, promise and content
In search, someone has already expressed a question. YouTube describes relevance, engagement and quality as the main elements of ranking. Matching the query to the title, description and content matters; user history can also affect results. The position an author sees need not match a future viewer's position.
A title such as “How to freeze the top row in [editor]” names the action and environment. The brackets indicate a placeholder for the real name, not text to publish. The thumbnail shows a result actually demonstrated. Promising to fix all reporting would go beyond the action shown.
The description helps clarify conditions, locate a useful segment and reach related material. Offer the next lesson after solving the current problem. Someone who needs only a frozen row should reach that result through the free explanation without a mandatory course purchase.
YouTube gives tags a limited role, apart from commonly misspelled words. Titles, thumbnails and descriptions carry more weight as metadata. A long tag list cannot repair a mismatch between the promise and demonstration.
After publication, examine the actual queries. If viewers arrive wanting to freeze a column while the video only shows a row, decide whether to make a separate recording or clarify the promise. Raising clicks without resolving that mismatch brings more people to an unsuitable answer.
Separate viewing sources
Search, a referral from another video and an external link describe different situations. A search viewer already wants an action; someone watching other material may not yet know why they need it. Do not assign all views to search optimisation merely because the title contains a key phrase.
YouTube impressions CTR relates views to counted thumbnail impressions. Not every view belongs to such an impression. Establish the numerator and denominator before comparing percentages.
In the first table, views come specifically from counted impressions for each source. Other views are excluded for now.
| Source | First-period impressions | Views from those impressions | CTR |
|---|---|---|---|
| Search | 1,000 | 80 | 8% |
| Browse features | 5,000 | 150 | 3% |
| Total | 6,000 | 230 | About 3.83% |
Suppose another 70 views came through external links without counted thumbnail impressions. The overall counter would show 300 views. Dividing 300 / 6,000 gives 5%, but that uses a different numerator and is not the CTR of counted impressions.
Lower overall CTR can conceal unchanged source results
In the second period, search produced the same 1,000 impressions and 80 views. Browse features produced 15,000 impressions and 450 views. Within each source, the rates remained 8% and 3%. Overall CTR is now 530 / 16,000 ≈ 3.31%.
CTR fell from about 3.83% to 3.31% even though both source-specific rates stayed unchanged. The source with lower CTR gained weight in the total. Views from counted impressions rose from 230 to 530.
This calculation shows that the impression mix changed, without establishing why the platform expanded impressions. It also does not prove that the thumbnail performs equally for every audience. Retain source, period, volume and publication changes in the analysis.
Replacing titles sequentially does not itself create equal conditions either. Demand and audience composition may change during that time. A report on such a comparison should describe its limits instead of treating every increase as a proven effect of a new word. Equal conditions come from A/B testing in YouTube Studio: up to three titles or thumbnails run in parallel, and the winner is picked by share of watch time, not by CTR.
Watch the disputed segment alongside the graph
The retention graph helps locate a segment to watch. Its shape alone cannot establish a cause: someone may have found the answer, skipped a familiar step or failed to see the command. Compare the segment with queries, comments and the recording itself.
| Observation | Possible explanation | What to inspect in the video |
|---|---|---|
| Leaving before the demonstration | The answer takes too long to arrive | Introduction and first action |
| Repeating one step | The step is useful or unclear | Interface scale, narration and speed |
| Leaving after the result | The task is complete | Whether the viewer has a next need |
For a row-freezing tutorial, leaving after successful scrolling may be normal. Lengthening the introduction to increase viewing time delays the promised help. Ask someone unfamiliar with the method to repeat the action using the recording. Their difficulty gives the editor a clearer task than a retention percentage alone.
Calculate production cost and the linked result
Our school sells a course for 25,000 ₸ with 15,000 ₸ contribution after variable teaching costs and before acquisition. It spent 60,000 ₸ producing the video under its own budget. These are assumptions for the exercise, not market production prices.
Over an agreed completed observation period, the team connected 6 non-refunded payments to the video. Revenue from those payments was 150,000 ₸ and contribution before production was 90,000 ₸. Deducting 60,000 ₸ production leaves 30,000 ₸ before other expenses. Retain subsequent touchpoints, but count each payment once in the overall report.
Covering production requires 60,000 / 15,000 = 4 additional payments. Six linked payments do not establish that the video added all six: someone may already have been considering the school. Show the observed result separately from an estimate of additional sales, which needs a suitable comparison.
The video may keep receiving views after the selected period, but future purchases are not yet actual results. Keep the publication date, expenses and payment history. This supports discussion of further work using known results and clearly stated expectations.
Exercise: should the thumbnail change?
The owner sees CTR falling from 3.83% to 3.31% and suggests restoring the old thumbnail. Prepare a short explanation using the two periods, then choose one segment of your own video to assess for clarity.
In the example, rates within sources stayed unchanged. Search remained at 8% and Browse features at 3%; the latter gained weight. The overall decline cannot establish that the thumbnail worsened. If you still want to compare thumbnails, put them into an A/B test in YouTube Studio, which picks the winner by watch time, not by CTR. Also check that the video delivers what the thumbnail promises.
For the video itself, open the row-freezing segment and repeat the action without the author's help. If the command is invisible or scrolling never demonstrates the result, you have identified a specific repair. It addresses the viewer's task, while production economics remains a separate calculation requiring four additional payments.
Video: a creator's view on promotion
Compare the author's explanation with your own recording: which query it answers, where it delivers its promise and which observations can actually inform the next release.