Programme Economics: Quarterly Cost, Incremental Margin, Cumulative Net, Payback and ROI of the CRO Programme with a Combo Chart
Lessons in this course
- 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