Tabellab
Marketing Analytics Intermediate

Conversion Rate Optimisation Programmes: Funnel Leak Analysis, Heuristic Scoring, ICE & PIE Backlogs, Test Velocity, Win Rate & Revenue Impact

Run a conversion rate optimisation programme with numbers instead of opinions. You will measure a purchase funnel step by step, size each leak against a benchmark in pounds, score pages in a heuristic review, prioritise a test backlog with ICE and PIE, check which pages have enough traffic for a test, and report test velocity, win rate and the projected revenue impact of the winners. Then you go deeper: segment breakdowns by device and channel, traffic mix shifts, test results by segment, revenue per visitor, a test calendar, a trend baseline with FORECAST.LINEAR, win rates by hypothesis theme, a scenario grid, programme cost and ROI, sample ratio checks and a backlog ranked by expected value per development day, finishing with a quarterly programme scorecard. 20 hands-on labs, fictional online shop Quillmere Outfitters, 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 a conversion rate optimisation programme in 20 interactive spreadsheet labs. You work as the analyst of Quillmere Outfitters, an online shop for hiking and camping gear, and build every calculation yourself: step conversion rates and drop-off in a purchase funnel, the monthly revenue at stake behind each leak, weighted heuristic scores, ICE and PIE scores for a test backlog, the weeks a test needs on a page's traffic, test velocity, win rate and the projected revenue impact of winning tests after a haircut. Later labs cover segment breakdowns by device and channel, traffic mix shifts, test readouts by segment, revenue per visitor, a test calendar, a trend baseline, scenario grids, programme ROI, sample ratio checks and a backlog ranked by expected value per development day. The final project is a quarterly programme scorecard. Each lab checks your formulas instantly, from simple ratios to SUMIFS, INDEX and MATCH, SUMPRODUCT and FORECAST.LINEAR. The company, its tests and all numbers are fictional, and benchmarks are illustrative.

Lessons

  1. Funnel Leak Analysis: Step Conversion Rates, Drop-Off per Step, the Share of Sessions That Reach Each Step and the Weakest StepLabFree
  2. Sizing the Leak: Step Rates Against a Benchmark, Extra Orders if One Step Is Fixed and the Monthly Revenue at StakeLab Locked
  3. Heuristic Scoring: a Weighted Page Score with SUMPRODUCT, a Fix-First Rank, the Weakest Criterion per Page and a Heat MapLab Locked
  4. Backlog Prioritisation with ICE: Impact, Confidence and Ease Scores, a Rank, Averages per Page Area and the Top IdeaLab Locked
  5. Where to Test First with PIE: Potential, a Data-Driven Importance Score, Ease, the PIE Score per Page and a Ranked ChartLab Locked
  6. Can This Page Carry a Test? Absolute Effect, Visitors Needed per Variant, Weeks to Run and a Verdict per Planned TestLab Locked
  7. Test Velocity and Win Rate: Quarters from End Dates, Tests Concluded, the Share of Winners and the Average Winning LiftLab Locked
  8. Revenue Impact Projection: a Haircut on Observed Lifts, Expected Monthly Uplift, In-Year Impact by Rollout Month and the Programme TotalLab Locked
  9. Segment Breakdowns: Conversion Rate by Device and Channel, an Index Against the Site, Device Rates with SUMIFS and the Gap in OrdersLab Locked
  10. Mix Shift: When the Site Rate Falls but the Segments Improve, a Mix-Adjusted Rate with SUMPRODUCT and the Mix EffectLab Locked
  11. Reading a Test Result by Segment: Relative Lift, a z-Score per Slice, a Stricter Threshold for Slices and a Lift ChartLab Locked
  12. Beyond Conversion Rate: Conversion Lift, Change in Order Value, Revenue per Visitor Lift and a Rollout Decision per TestLab Locked
  13. Test Calendar: End Dates from Weeks, Back-to-Back Start Dates with a Gap, Tests Concluded by a Deadline and Lane CapacityLab Locked
  14. Did the Programme Move the Needle? A Trend Baseline with SLOPE and FORECAST.LINEAR, Actual Minus Trend and Incremental OrdersLab Locked
  15. Learning from the Log: Tests per Theme, Win Rate, Average Winning Lift with IFERROR and the Expected Lift per TestLab Locked
  16. Scenario Grid: In-Year Impact by Test Velocity and Win Rate with Mixed References, Tests Needed for a Target and Compounded LiftLab Locked
  17. Programme Economics: Quarterly Cost, Incremental Margin, Cumulative Net, Payback and ROI of the CRO Programme with a Combo ChartLab Locked
  18. Quality Checks Before the Readout: Sample Ratio Mismatch with Chi-Square, a p-Value, a Check Column and Flagged RowsLab Locked
  19. From Scores to Pounds: Expected Value per Idea, Value per Development Day, a Priority Rank and What Fits into the CapacityLab Locked
  20. Final Project: CRO Programme Scorecard by Quarter with Test Velocity, Win Rate, Projected Revenue Impact, Status Flags 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