Bounce vs Conversion by Traffic Source: SUMIFS Roll-Ups, Reading the Two Rates Together and a Mismatch Flag
Lessons in this course
- Landing Page Scorecard: Bounce Rate, Conversion Rate, Revenue per Session and the Engaged Conversion RateFree
- Message Match: Scoring Ad-to-Page Consistency and Comparing Conversion Rates by Landing Page Type Locked
- Above-the-Fold Audit: a First-Screen Checklist with SUM, AND, IFS, Pass Shares and a Formatting Rule Locked
- Form Length vs Conversion: Start Rate, Completion Rate, Absolute References and the Cost of One More Field with SLOPE Locked
- Page Speed Impact: Bounce and Conversion Rate by Load-Time Band and the Orders Missed Against the Fastest Band Locked
- Valuing a Speed Fix: Seconds to Save with MAX, a Relative Conversion Gain, Extra Revenue per Page and a Ranking with RANK.EQ Locked
- Scroll Depth: Reach per Scroll Mark, Step Losses and the Share of Visitors Who See Each Page Section Locked
- Bounce vs Conversion by Traffic Source: SUMIFS Roll-Ups, Reading the Two Rates Together and a Mismatch Flag Locked
- Device Segments: a Page-by-Device Table with Two-Criteria SUMIFS and Mixed References, the Mobile-to-Desktop Ratio and the Gap in Orders Locked
- Form Length and Lead Quality: Cost per Lead, Qualified Rate, Cost per Qualified Lead and the Best Variant with MIN and XLOOKUP Locked
- Variant Comparison: Control and Variant Rates, Relative Uplift vs Percentage Points and a First Reading with MIN and IFS Locked
- Is the Difference Real? Pooled Rate, Standard Error, z-Score and p-Value for Two Conversion Rates Locked
- Planning a Test: Sample Size by Rule of Thumb, Days Needed with ROUNDUP, Full Weeks with CEILING and an End Date Locked
- Test Results by Traffic Source: Segment Rates, a Split Check and Why an Overall Uplift Can Mislead Locked
- The Page Funnel: Step Rates, an Index Against a Benchmark with a Row-Locked Reference and the Weakest Step by Name Locked
- Speed Over Time: Correlation, Slope and a Conversion Forecast at a Target Load Time with FORECAST.LINEAR and a Scatter Chart Locked
- What-If Grid for a Redesign: Extra Contribution by Traffic and Conversion Rate with Mixed References, Payback and a Heat Map Locked
- Prioritising the Backlog: Expected Extra Orders, Confidence, Effort, a Ranking and the Top Three with LARGE Locked
- Quality Checks Before Reporting: Duplicates with COUNTIF, Impossible Values with OR, Untagged Visits and a Clean Conversion Rate Locked
- Final Project: Landing Page Dashboard with SUMIFS Roll-Ups, Bounce and Conversion Rate, Revenue per Session, a Status and a Combo Chart Locked