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.
- 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
- Play Rate by Funnel Stage: Page Loads, Plays, Stage Totals with SUMIFS and a Target Check with XLOOKUPFree
- The Retention Curve: Share Still Watching, Segment Drop Rates, Average View Duration and a Line Chart Locked
- Drop-Off Points: Scene Loss, Loss per 10 Seconds, the Worst Scene with XLOOKUP and a Highlight Rule Locked
- Watch Time and Video Length: Average View Duration, Percentage Viewed, Length Bands with IFS and Weighted Band Averages Locked
- CTA Click-Through: Reach Rate, Two Click-Through Rates, Placement Totals with SUMIFS and a Bar Chart Locked
- From Play to Order: Click-to-Order Rate, Orders per 1,000 Plays, Revenue per Play and a Ranking Locked
- Video-Assisted Conversions: Last-Click Orders, Assisted Orders, the Assist Ratio and Revenue with a Video Touch Locked
- Production Budget per Video: Day Rates, Edit Hours, Cost per Finished Minute, Plan Variance and Cost by Type Locked
- What Attention Costs: Full Cost per Play, per Completed View and per Watched Minute, with a Blended Figure Locked
- Viewers versus Non-Viewers: Conversion Rates, Relative Difference, Naive Extra Orders and a Warning Rule Locked
- Segments: Plays, Average View Duration, CTA Click-Through and Mobile Share by Traffic Source with SUMIFS Locked
- Thumbnail Tests: Play-Rate Difference, Pooled z-Score, p-Value with NORM.S.DIST and a Verdict Locked
- The Page Test: Conversion Uplift, Incremental Orders and Margin per Month, Payback of the Production Cost and a Chart Locked
- Evergreen Videos: Cumulative Plays, the Monthly Trend with SLOPE, a Three-Month Forecast and the Falling Cost per Play Locked
- Video Lifetimes: Age in Months with DATEDIF, Straight-Line Book Value, Margin per Month and a Status with IFS Locked
- Library Audit: Months Since Update, Missing Captions, Stale Videos with EDATE and an Action List with IFS, AND and OR Locked
- Library Concentration: Share of the Library, RANK.EQ, the Top-Three Share with LARGE, the Long Tail and a Bar Chart Locked
- What-If Grid: Profit by Play Rate and CTA Click-Through with Mixed References, a Heat Map and the Break-Even Click-Through Locked
- Allocating the Production Budget: Expected ROI, a Ranking, Cumulative Cost in Rank Order and a Fund-or-Wait Decision Locked
- Final Project: Video Library ROI Dashboard with Full Cost, Credited Margin, ROI by Funnel Stage, a Warning Rule and a Combo Chart Locked
Learner reviews
Be the first to review this course.