Tabellab

Customer Personas & Journey Mapping: Survey Segments, Persona Size & Value, Journey Drop-Off, Touchpoints & Channel Preference

Turn survey answers and shop data into personas that guide real decisions. You count respondents per need, assign personas with rules, project them onto the customer base and compare their value with an index. Then you map the journey: step conversion, drop-off and the biggest leak, a touchpoint inventory with an importance and satisfaction gap, and the channel each persona prefers. The second half deepens the evidence: you clean a survey of duplicates and speeders, build a needs heat map, calculate margins of error and the sample size you need, weight a lopsided sample, value personas over their lifetime, compare journey conversion by persona, cost customer acquisition, measure time to purchase, split a budget, track trends and persona migration, run a what-if grid and finish with a priority scorecard. Segments always use needs and behaviour, never protected characteristics. 20 hands-on labs, fictional Brambleway Outdoor data, every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course teaches data-based customer personas and journey mapping in 20 interactive spreadsheet labs. You work with the survey and shop data of Brambleway Outdoor, a fictional online shop for hiking and camping gear. First you turn survey answers into segments and personas with COUNTIF, AVERAGEIF and IFS, size them against the customer base and compare their value. Then you map the customer journey: stage conversion, drop-off and the biggest leak, touchpoints that deserve fixing first, and the channel each persona prefers. The second half covers the quality of the evidence and the decisions that follow: survey cleaning, margins of error and sample size, weighting, lifetime value, journey conversion by persona, acquisition cost, time to purchase, budget allocation, trends and migration, what-if scenarios and a final priority scorecard. Personas are always built on needs and behaviour, never on protected characteristics. Every formula is checked as you type. All companies, people and numbers are fictional and benchmarks are illustrative.

Why learn with Tabellab

  • Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
  • Verifiable certificatePass the final exam and get a certificate with a public verification code.
  • Try before you buyLesson 1 is free, with no sign-up or card needed.
  • Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint

Lessons

  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

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy