YouTube & Video Ads: View Rate, CPV, Cost per Completed View, Reach & Frequency, Video Sequencing & Brand Lift
Measure video advertising the way an analyst does. You will calculate view rate and cost per view for skippable in-stream ads, read quartile reports, price a completed view, work out reach, average frequency and the cost per 1,000 people reached, plan budgets from a view target and translate CPV into CPM. Then you go deeper: watch time and earned actions, audiences and devices with SUMIFS, the first five seconds and benchmarks by length, five ad formats on one scale, frequency distributions and caps, reach curves with marginal cost, video sequences step by step, brand-lift surveys with absolute and relative lift, a significance test, confidence intervals and survey sizes, creative wear-out, a placement audit, a what-if grid and a budget ranked by cost per lifted user, finishing with a quarterly dashboard. 20 hands-on labs, fictional e-bike brand Tarnwick Cycles, every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This course teaches the numbers behind YouTube and video advertising in 20 interactive spreadsheet labs. You work with the campaign reports of Tarnwick Cycles, a fictional e-bike brand, and type every formula yourself while a grader checks each cell. You start with view rate and cost per view for skippable in-stream ads, then read quartile reports, price completed views, and calculate reach, frequency and the cost per 1,000 people reached. Later labs cover budget planning, audience and device roll-ups with SUMIFS, creative benchmarks, format comparisons, frequency caps, reach curves, video ad sequencing, creative wear-out and placement quality. Four labs are devoted to brand-lift surveys: absolute and relative lift, cost per lifted user, a two-proportion z-test, confidence intervals and the survey size a study needs. The course ends with a budget allocation, a quarterly dashboard, a 20-question exam and a certificate. All companies, campaigns and figures are fictional and illustrative.
Why learn with Tabellab
- Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
- Verifiable certificatePass the final exam and get a certificate with a public verification code.
- Try before you buyLesson 1 is free, with no sign-up or card needed.
- Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint
Lessons
- Skippable In-Stream Ads: View Rate, Cost per View and the Account Average Done RightFree
- Quartile Reports: Who Reaches 25 %, 50 %, 75 % and the End of the Video Locked
- Cost per Completed View: What You Really Pay for a Finished Video Locked
- Reach and Frequency: How Many People, How Often and at What Cost Locked
- Planning with CPV: Budget for a View Target, Daily Budgets and the Implied CPM Locked
- Watch Time and Earned Actions: Hours Bought, Cost per Hour and the Effective CPV Locked
- Audiences and Devices: View Rate and CPV per Audience Type with SUMIFS Locked
- The First Five Seconds: Hold Rate, View Rate and a Fair Benchmark by Length Locked
- Formats Side by Side: Skippable, Non-Skippable, Bumper, In-Feed and Shorts on One Scale Locked
- Frequency Distribution: Effective Reach, Wasted Impressions and the Case for a Cap Locked
- The Reach Curve: Diminishing Returns and the Marginal Cost of the Next 1,000 People Locked
- Video Ad Sequencing: Step-Through Rates, Sequence Completion and the Cost per Finisher Locked
- Reading a Brand-Lift Survey: Absolute Lift, Relative Lift and the Cost per Lifted User Locked
- Is the Lift Real? A Two-Proportion z-Test for Survey Results Locked
- How Sure Is the Lift? Confidence Intervals and the Survey Size You Need Locked
- Creative Wear-Out: Trend, Forecast and the Week to Refresh the Ad Locked
- Placement Quality: When a High View Rate Is a Warning Sign Locked
- A What-If Grid: The CPV for Every Combination of CPM and View Rate Locked
- Filling a Fixed Budget: Ranking Video Options by Cost per Lifted User Locked
- Final Project: A Quarterly Video Dashboard from Delivery to Brand Lift Locked
Learner reviews
Be the first to review this course.