Tabellab

Drop-off Between Stages: Drop-off Rates, People Lost, the Biggest Leak with INDEX and MATCH and a What-If

Lesson 6 of 20 Lab 🔒 Locked

Lessons in this course

  1. From Survey Answers to Segments: Counting Respondents per Need, Segment Shares and Average BehaviourLabFree
  2. Persona Rules: Assigning a Persona with IFS, Counting Personas and Checking Rule Overlap with COUNTIFSLab Locked
  3. Persona Sizing: Shares Within a Market, Projection onto the Customer Base and the Largest PersonaLab Locked
  4. Persona Value: Customers, Revenue, Revenue per Customer, Share of Revenue and a Value IndexLab Locked
  5. Journey Stages: Step Conversion, Share of the First Stage, People Lost and a Funnel ChartLab Locked
  6. Drop-off Between Stages: Drop-off Rates, People Lost, the Biggest Leak with INDEX and MATCH and a What-IfLab Locked
  7. Touchpoints per Stage: An Inventory with COUNTIF and SUMIF, the Importance–Satisfaction Gap and a Fix-First ListLab Locked
  8. Channel Preference by Persona: A Crosstab with COUNTIFS and Mixed References, Row Shares and the Preferred ChannelLab Locked
  9. Survey Quality: Duplicate Emails, Speeders, Straight-Liners and the Clean SampleLab Locked
  10. Needs per Persona: Average Ratings with AVERAGEIF, an Index Against All Respondents and a Heat MapLab Locked
  11. Sample Size and Margin of Error: How Sure Are We About a Persona's Share?Lab Locked
  12. Weighting a Survey to the Customer Base: Shares of Base and Sample, Weights and Weighted Averages with SUMPRODUCTLab Locked
  13. Persona Lifetime Value: Profit per Customer, Expected Lifetime from Retention, Value Rank and the Total Value PoolLab Locked
  14. Journey by Persona: A Step-Conversion Matrix, End-to-End Rates, the Weakest Step and a Below-Average FlagLab Locked
  15. Acquisition Cost by Persona: Spend and New Customers with SUMIF, Cost per New Customer, Value ÷ Cost and a ChartLab Locked
  16. Time to Purchase by Persona: Days Between Dates, AVERAGEIF, a Purchase Window with COUNTIFS and the MedianLab Locked
  17. Budget Allocation by Persona: Shares of Value ÷ Cost, a Budget Split, Expected New Customers and Value CreatedLab Locked
  18. Persona Trends and Migration: SLOPE, FORECAST.LINEAR, a Line Chart and Stay Rates with COUNTIFSLab Locked
  19. Journey What-Ifs: Baseline Profit, a Traffic × Conversion Grid with Mixed References, Target Check and Green HighlightingLab Locked
  20. Final Project: A Persona Priority Scorecard with Weighted Scores, Rank, the Priority Persona and Channel, and a ChartLab Locked