Tabellab

What-If Grid for a Redesign: Extra Contribution by Traffic and Conversion Rate with Mixed References, Payback and a Heat Map

Lesson 17 of 20 Lab 🔒 Locked

Lessons in this course

  1. Landing Page Scorecard: Bounce Rate, Conversion Rate, Revenue per Session and the Engaged Conversion RateLabFree
  2. Message Match: Scoring Ad-to-Page Consistency and Comparing Conversion Rates by Landing Page TypeLab Locked
  3. Above-the-Fold Audit: a First-Screen Checklist with SUM, AND, IFS, Pass Shares and a Formatting RuleLab Locked
  4. Form Length vs Conversion: Start Rate, Completion Rate, Absolute References and the Cost of One More Field with SLOPELab Locked
  5. Page Speed Impact: Bounce and Conversion Rate by Load-Time Band and the Orders Missed Against the Fastest BandLab Locked
  6. Valuing a Speed Fix: Seconds to Save with MAX, a Relative Conversion Gain, Extra Revenue per Page and a Ranking with RANK.EQLab Locked
  7. Scroll Depth: Reach per Scroll Mark, Step Losses and the Share of Visitors Who See Each Page SectionLab Locked
  8. Bounce vs Conversion by Traffic Source: SUMIFS Roll-Ups, Reading the Two Rates Together and a Mismatch FlagLab Locked
  9. Device Segments: a Page-by-Device Table with Two-Criteria SUMIFS and Mixed References, the Mobile-to-Desktop Ratio and the Gap in OrdersLab Locked
  10. Form Length and Lead Quality: Cost per Lead, Qualified Rate, Cost per Qualified Lead and the Best Variant with MIN and XLOOKUPLab Locked
  11. Variant Comparison: Control and Variant Rates, Relative Uplift vs Percentage Points and a First Reading with MIN and IFSLab Locked
  12. Is the Difference Real? Pooled Rate, Standard Error, z-Score and p-Value for Two Conversion RatesLab Locked
  13. Planning a Test: Sample Size by Rule of Thumb, Days Needed with ROUNDUP, Full Weeks with CEILING and an End DateLab Locked
  14. Test Results by Traffic Source: Segment Rates, a Split Check and Why an Overall Uplift Can MisleadLab Locked
  15. The Page Funnel: Step Rates, an Index Against a Benchmark with a Row-Locked Reference and the Weakest Step by NameLab Locked
  16. Speed Over Time: Correlation, Slope and a Conversion Forecast at a Target Load Time with FORECAST.LINEAR and a Scatter ChartLab Locked
  17. What-If Grid for a Redesign: Extra Contribution by Traffic and Conversion Rate with Mixed References, Payback and a Heat MapLab Locked
  18. Prioritising the Backlog: Expected Extra Orders, Confidence, Effort, a Ranking and the Top Three with LARGELab Locked
  19. Quality Checks Before Reporting: Duplicates with COUNTIF, Impossible Values with OR, Untagged Visits and a Clean Conversion RateLab Locked
  20. Final Project: Landing Page Dashboard with SUMIFS Roll-Ups, Bounce and Conversion Rate, Revenue per Session, a Status and a Combo ChartLab Locked