Persona Trends and Migration: SLOPE, FORECAST.LINEAR, a Line Chart and Stay Rates with COUNTIFS
Lessons in this course
- 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