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.
- 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
- From Survey Answers to Segments: Counting Respondents per Need, Segment Shares and Average BehaviourFree
- Persona Rules: Assigning a Persona with IFS, Counting Personas and Checking Rule Overlap with COUNTIFS Locked
- Persona Sizing: Shares Within a Market, Projection onto the Customer Base and the Largest Persona Locked
- Persona Value: Customers, Revenue, Revenue per Customer, Share of Revenue and a Value Index Locked
- Journey Stages: Step Conversion, Share of the First Stage, People Lost and a Funnel Chart Locked
- Drop-off Between Stages: Drop-off Rates, People Lost, the Biggest Leak with INDEX and MATCH and a What-If Locked
- Touchpoints per Stage: An Inventory with COUNTIF and SUMIF, the Importance–Satisfaction Gap and a Fix-First List Locked
- Channel Preference by Persona: A Crosstab with COUNTIFS and Mixed References, Row Shares and the Preferred Channel Locked
- Survey Quality: Duplicate Emails, Speeders, Straight-Liners and the Clean Sample Locked
- Needs per Persona: Average Ratings with AVERAGEIF, an Index Against All Respondents and a Heat Map Locked
- Sample Size and Margin of Error: How Sure Are We About a Persona's Share? Locked
- Weighting a Survey to the Customer Base: Shares of Base and Sample, Weights and Weighted Averages with SUMPRODUCT Locked
- Persona Lifetime Value: Profit per Customer, Expected Lifetime from Retention, Value Rank and the Total Value Pool Locked
- Journey by Persona: A Step-Conversion Matrix, End-to-End Rates, the Weakest Step and a Below-Average Flag Locked
- Acquisition Cost by Persona: Spend and New Customers with SUMIF, Cost per New Customer, Value ÷ Cost and a Chart Locked
- Time to Purchase by Persona: Days Between Dates, AVERAGEIF, a Purchase Window with COUNTIFS and the Median Locked
- Budget Allocation by Persona: Shares of Value ÷ Cost, a Budget Split, Expected New Customers and Value Created Locked
- Persona Trends and Migration: SLOPE, FORECAST.LINEAR, a Line Chart and Stay Rates with COUNTIFS Locked
- Journey What-Ifs: Baseline Profit, a Traffic × Conversion Grid with Mixed References, Target Check and Green Highlighting Locked
- Final Project: A Persona Priority Scorecard with Weighted Scores, Rank, the Priority Persona and Channel, and a Chart Locked
Learner reviews
Be the first to review this course.