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