Tabellab
Marketing Analytics Intermediate

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.

20 lessons 20 labs Certificate

  • 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

  1. Skippable In-Stream Ads: View Rate, Cost per View and the Account Average Done RightLabFree
  2. Quartile Reports: Who Reaches 25 %, 50 %, 75 % and the End of the VideoLab Locked
  3. Cost per Completed View: What You Really Pay for a Finished VideoLab Locked
  4. Reach and Frequency: How Many People, How Often and at What CostLab Locked
  5. Planning with CPV: Budget for a View Target, Daily Budgets and the Implied CPMLab Locked
  6. Watch Time and Earned Actions: Hours Bought, Cost per Hour and the Effective CPVLab Locked
  7. Audiences and Devices: View Rate and CPV per Audience Type with SUMIFSLab Locked
  8. The First Five Seconds: Hold Rate, View Rate and a Fair Benchmark by LengthLab Locked
  9. Formats Side by Side: Skippable, Non-Skippable, Bumper, In-Feed and Shorts on One ScaleLab Locked
  10. Frequency Distribution: Effective Reach, Wasted Impressions and the Case for a CapLab Locked
  11. The Reach Curve: Diminishing Returns and the Marginal Cost of the Next 1,000 PeopleLab Locked
  12. Video Ad Sequencing: Step-Through Rates, Sequence Completion and the Cost per FinisherLab Locked
  13. Reading a Brand-Lift Survey: Absolute Lift, Relative Lift and the Cost per Lifted UserLab Locked
  14. Is the Lift Real? A Two-Proportion z-Test for Survey ResultsLab Locked
  15. How Sure Is the Lift? Confidence Intervals and the Survey Size You NeedLab Locked
  16. Creative Wear-Out: Trend, Forecast and the Week to Refresh the AdLab Locked
  17. Placement Quality: When a High View Rate Is a Warning SignLab Locked
  18. A What-If Grid: The CPV for Every Combination of CPM and View RateLab Locked
  19. Filling a Fixed Budget: Ranking Video Options by Cost per Lifted UserLab Locked
  20. Final Project: A Quarterly Video Dashboard from Delivery to Brand LiftLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy