Tabellab
Marketing Analytics Intermediate

Video Marketing Funnel Metrics: Play Rate, Retention & Drop-Off Points, CTA Click-Through, Video-Assisted Conversions, Production Budgets & Library ROI

Measure video across the whole funnel in Excel. You calculate play rate by funnel stage, build retention curves, find the scenes where viewers leave, compare watch time by video length, split CTA click-through into reach and clicks, follow plays to orders and count video-assisted conversions. Then you cost every video from shoot days and edit hours, price a play, a completed view and a watched minute, test thumbnails and product page videos for real uplift, forecast evergreen plays, write videos down over their useful life, audit the library, measure its concentration, build a what-if grid, allocate a production budget and finish with a library ROI dashboard: 20 hands-on labs, fictional retailer Quillmoor Espresso, 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 video marketing across the funnel in 20 interactive spreadsheet labs. You work with the video library of Quillmoor Espresso, a fictional online retailer of home espresso machines, and type every formula yourself while a grader checks each cell. You start with play rate by funnel stage, then build retention curves, find the scenes where viewers drop off and compare watch time by video length. Next you split CTA click-through into reach and clicks, follow plays to orders and count video-assisted conversions. Two labs cover production budgets and the full cost per play, completed view and watched minute. Later labs test thumbnails with a z-test, measure the uplift of product page videos and their payback, forecast evergreen plays, write videos down over their useful life, audit the library and build a what-if grid and a budget ranking. The course ends with a library ROI dashboard, a 20-question exam and a certificate. All companies, videos and figures are fictional and illustrative.

Lessons

  1. Play Rate by Funnel Stage: Page Loads, Plays, Stage Totals with SUMIFS and a Target Check with XLOOKUPLabFree
  2. The Retention Curve: Share Still Watching, Segment Drop Rates, Average View Duration and a Line ChartLab Locked
  3. Drop-Off Points: Scene Loss, Loss per 10 Seconds, the Worst Scene with XLOOKUP and a Highlight RuleLab Locked
  4. Watch Time and Video Length: Average View Duration, Percentage Viewed, Length Bands with IFS and Weighted Band AveragesLab Locked
  5. CTA Click-Through: Reach Rate, Two Click-Through Rates, Placement Totals with SUMIFS and a Bar ChartLab Locked
  6. From Play to Order: Click-to-Order Rate, Orders per 1,000 Plays, Revenue per Play and a RankingLab Locked
  7. Video-Assisted Conversions: Last-Click Orders, Assisted Orders, the Assist Ratio and Revenue with a Video TouchLab Locked
  8. Production Budget per Video: Day Rates, Edit Hours, Cost per Finished Minute, Plan Variance and Cost by TypeLab Locked
  9. What Attention Costs: Full Cost per Play, per Completed View and per Watched Minute, with a Blended FigureLab Locked
  10. Viewers versus Non-Viewers: Conversion Rates, Relative Difference, Naive Extra Orders and a Warning RuleLab Locked
  11. Segments: Plays, Average View Duration, CTA Click-Through and Mobile Share by Traffic Source with SUMIFSLab Locked
  12. Thumbnail Tests: Play-Rate Difference, Pooled z-Score, p-Value with NORM.S.DIST and a VerdictLab Locked
  13. The Page Test: Conversion Uplift, Incremental Orders and Margin per Month, Payback of the Production Cost and a ChartLab Locked
  14. Evergreen Videos: Cumulative Plays, the Monthly Trend with SLOPE, a Three-Month Forecast and the Falling Cost per PlayLab Locked
  15. Video Lifetimes: Age in Months with DATEDIF, Straight-Line Book Value, Margin per Month and a Status with IFSLab Locked
  16. Library Audit: Months Since Update, Missing Captions, Stale Videos with EDATE and an Action List with IFS, AND and ORLab Locked
  17. Library Concentration: Share of the Library, RANK.EQ, the Top-Three Share with LARGE, the Long Tail and a Bar ChartLab Locked
  18. What-If Grid: Profit by Play Rate and CTA Click-Through with Mixed References, a Heat Map and the Break-Even Click-ThroughLab Locked
  19. Allocating the Production Budget: Expected ROI, a Ranking, Cumulative Cost in Rank Order and a Fund-or-Wait DecisionLab Locked
  20. Final Project: Video Library ROI Dashboard with Full Cost, Credited Margin, ROI by Funnel Stage, a Warning Rule and a Combo ChartLab 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