Jobs to Be Done Template: Two Schools, One Spreadsheet
A free jobs to be done template covering the Christensen switch-interview method and Ulwick's ODI outcome scoring. Includes a downloadable Google Sheet with six

A free jobs to be done template covering the Christensen switch-interview method and Ulwick's ODI outcome scoring. Includes a downloadable Google Sheet with six

A jobs to be done template is a structured document that captures why customers hire your product, what progress they expect to make, and what stops them from switching. Clayton Christensen's research at Harvard Business School established the framework; Strategyn's Outcome-Driven Innovation quantified it with an 86% success rate. Zoom's 354% customer growth post-COVID and Kroll Ontrack's revenue growth to $200M+ both trace back to identifying the correct job before building.
Two distinct JTBD schools exist, and they produce structurally different templates. This article explains both, tells you which to use at each stage, and gives you a free Google Sheet that covers the full workflow.
75–85% of new products launched fail financially, and the core diagnosis is building features customers didn't ask for in the form they wanted. A JTBD template forces you to define the customer's goal before writing a single requirement.
Without a structured template, teams run into what Strategyn describes as the cascading definition problem. 80% of product teams can't agree on how to define their own market, which means they can't agree on the customer, their needs, or what to build. That ambiguity compounds into roadmap fragmentation and wasted sprints.
The template also solves an internal communication problem. As u/ToStringMethod in r/ProductManagement (October 2025) explains: "By defining the product through the lens of the job the customer is hiring it to do, you establish outcome-focused language right from inception. That language carries through requirements, design discussions, and ultimately into go-to-market messaging."
Before filling in any template, choose which school you're working from.
School 1: Christensen/Moesta (qualitative, narrative) anchors on the customer's struggling moment (the trigger that made them act) and the purchase story. The switch interview is the primary tool: 10–12 one-hour conversations in which recent buyers narrate the chronological story of their decision, not product feedback. The output is a narrative job statement and a Four Forces map.
School 2: Ulwick/ODI (quantitative, measurable) anchors on desired outcomes: what the customer is trying to optimize that no current solution satisfies. The primary tool is a needs-based survey followed by cluster analysis. The output is a quantified opportunity score for each unmet need, ranking which outcomes to target next.
Both schools use the "When , I want to , so I can ___" sentence format, but for different purposes. Christensen practitioners write it as a discovery output from interviews. Ulwick practitioners write it as the anchor before running a full measurement study.
Which to use:
Stage | School | Why |
|---|---|---|
Discovery (what job is the customer doing?) | Christensen/Moesta | Switch interviews surface the struggling moment and switching context |
Innovation targeting (which needs are unmet?) | Ulwick/ODI | Opportunity scoring ranks outcomes by importance minus satisfaction |
Quick team alignment | Either | A single job statement resolves roadmap debates without a full study |
Each section below maps to a tab in the free Google Sheet. Want to skip the copy-paste? Google Sheets version is ready to fill in.
Field | Description | Example |
|---|---|---|
When (situation) | The trigger moment or context | When preparing for a Monday sprint kickoff |
I want to (motivation) | The progress the customer wants to make | Understand which tasks are blocked and by whom |
So I can (expected outcome) | The downstream benefit | Resolve dependencies before the sprint starts |
Job type | Functional / emotional / social | Functional |
Confidence | How many interviews confirm this pattern (1–10) | 7 (confirmed at 9 interviews) |
A job statement is ready to use when it passes all three of thrv's validation criteria:
Four common job-statement mistakes: writing the solution as the job, making the job too broad, skipping desired outcomes entirely, and segmenting by demographics instead of struggling moment.
Job Type | Question to Answer | Example |
|---|---|---|
Functional | What practical outcome does the customer need? | Get to a destination on time |
Emotional | How does the customer want to feel? | Feel in control of the day |
Social | How does the customer want to be perceived? | Appear organized to their team |
Customers hire products primarily for functional jobs. Emotional and social jobs shape which product they hire and build the switching inertia that keeps them from leaving. Mapping all three explains why technically superior products lose to incumbents.
Force | Question | Example (project management tool) |
|---|---|---|
Push (current pain) | What's not working in the current solution? | 4 hours/week of status meetings that don't resolve blockers |
Pull (new appeal) | What promise made them consider switching? | One dashboard replacing four Slack threads |
Anxiety (adoption fear) | What almost stopped them? | The team won't adopt another tool |
Habit (inertia) | What do they have to give up? | The Monday status email 23 people are used to |
The Four Forces determine whether customers switch, not just why they want to. A product can win on pull and still lose to habit.
As Bob Moesta explains in "ultimate guide to JTBD" (Lenny's Podcast): "The biggest misconception around jobs to be done is this notion that it's pain and gain as opposed to context and outcome. When you hear somebody's story and it seems irrational… the context makes the irrational rational."
Ulwick's Job Map breaks any functional job into eight universal steps. Map each step, then survey customers on desired outcomes for each to quantify which step is most underserved.
Step | Question to Answer | Example (job: "manage a sprint") |
|---|---|---|
1. Define | What inputs define the goal? | Understand sprint scope and team capacity |
2. Locate | What information is needed to start? | Find last sprint's velocity and backlog status |
3. Prepare | What must be organized before execution? | Assign issues, set priorities, check dependencies |
4. Confirm | How do they verify readiness? | Confirm team alignment before kickoff |
5. Execute | What is the core job execution? | Run the sprint, track daily progress |
6. Monitor | How do they measure progress? | Track velocity and blockers in real time |
7. Modify | What adaptations happen mid-job? | Re-scope when a blocker surfaces |
8. Conclude | How do they wrap up and review? | Retrospective, velocity calculation, backlog update |
For each step, list every desired outcome a customer might want to optimize. These become your survey items in an ODI study. Strategyn's original research estimates that 95% of product teams don't agree on what a customer need is; the Job Map forces that disagreement into the open before sprints start.
Pre-interview setup:
Six-phase interview flow (60 minutes):
Phase | Question | Goal |
|---|---|---|
First thought | "What happened the day you realized your old way wasn't working?" | Uncover the push trigger |
Active looking | "What did you search for? Who did you ask?" | Map the consideration set |
Decision moment | "What made you try [product]? What phrase or promise landed?" | Identify the pull |
Anxieties | "What worried you about switching? What almost stopped you?" | Surface adoption fears |
First use | "Walk me through the first time. What surprised you?" | Reveal onboarding friction |
New normal | "How is your life or work different now?" | Confirm the job was completed |
Bob Moesta's protocol from Lenny's Podcast: "Go find 10 people who recently bought your product… go talk to them not about the product but about why they bought the product. What was going on, what were they hoping for, what were they worried about, what did they have to give up, how did they convince somebody else. Just listen to the story."
Synthesis matrix: Log each interview below. A pattern converges at 8 interviews; if new themes still emerge at interview 15, the customer segment is too broad.
# | Date | Trigger (Push) | Promise (Pull) | Main Anxiety | Key Quote |
|---|---|---|---|---|---|
1 | (date) | (trigger) | (promise) | (anxiety) | (key quote) |
2 | (date) | (trigger) | (promise) | (anxiety) | (key quote) |
3 | (date) | (trigger) | (promise) | (anxiety) | (key quote) |
4 | (date) | (trigger) | (promise) | (anxiety) | (key quote) |
5 | (date) | (trigger) | (promise) | (anxiety) | (key quote) |
Switch interview synthesis matrix
AI-assisted synthesis: After running interviews, paste a transcript into Claude or ChatGPT with this prompt to categorize quotes into the Four Forces automatically:
Act as an expert PM specializing in JTBD research. Analyze this transcript. Identify and categorize quotes into the Four Forces: Pushes, Pulls, Anxieties, Habits. Present as a four-quadrant markdown table with verbatim quotes.This prompt (from Aakash G.'s PM guide) cuts manual synthesis from hours to minutes. No published SERP competitor includes this step; it's the most practical way to use AI on a JTBD project without compromising the qualitative data.
Ulwick's Opportunity Score formula quantifies which outcomes to target first:
Opportunity Score = Importance + max(Importance − Satisfaction, 0)
Survey each desired outcome on two 10-point scales. Scores above 10 are underserved (high importance, low satisfaction); scores below 5 are over-served. Target the 10+ cluster first.
Desired Outcome | Importance (1-10) | Satisfaction (1-10) | Opportunity Score |
|---|---|---|---|
Minimize time to identify who is blocking whom | 9 | 4 | 9 + (9-4) = 14 |
Minimize effort to get project status without a meeting | 8 | 3 | 8 + (8-3) = 13 |
Minimize time to update task dependencies | 7 | 5 | 7 + (7-5) = 9 |
Minimize meeting time for weekly status updates | 6 | 6 | 6 + max(0, 0) = 6 |
The Opportunity Score gives product and engineering a shared prioritization language: Strategyn's work with Microsoft used exactly this method to produce a 100% year-over-year revenue increase for the Software Assurance product line.
Scenario: A B2B SaaS team building async project management software for engineering teams at 50–200 person companies.
Job Statement (Christensen school):
When preparing for a weekly sprint kickoff, I want to understand which tasks are blocked and by whom, so I can resolve dependencies before the sprint starts. Confirmed at 11 switch interviews; pattern stable from interview 8.
Four Forces:
Force | Finding |
|---|---|
Push | 4+ hours/week of status meetings that surface blockers too late |
Pull | One dashboard replacing fragmented Slack threads |
Anxiety | Team won't adopt yet another tool |
Habit | The Monday Slack status thread 23 people are used to |
Top Opportunity Scores (SaaS sprint tool):
Outcome | Score |
|---|---|
Minimize time to see who is blocking whom | 14 |
Minimize effort to get status without a meeting | 13 |
Minimize time to update task dependencies | 9 |
Recommended build sequence: The blocker-identification feature scores 14, so build that first. Status-without-meetings (13) is the pull customers already articulate during interviews. Dependency updates (9) reduce execution friction without a separate product investment.
Skip "team pulse" features: those target the social job, not the functional one that drives switching.
Industry note for SaaS: The job statement format stays identical across sectors. In e-commerce, the core job is minimizing time to identify inventory discrepancies before a fulfillment window. In B2B services, it's minimizing effort to produce a client-ready deliverable under a deadline.
Which school to lead with:
Use Christensen/Moesta at the discovery stage when you don't know what job you're solving. Use Ulwick/ODI at the innovation stage when you know the job and want to rank which outcomes to target next. Starting with switch interviews is the right default; move to opportunity scoring once you have a job statement confirmed by 8+ interviews.
Tool | Best For | Pricing | Free Plan |
|---|---|---|---|
Free Google Sheets template pre-loaded with real examples (Wise, Trainline, Onfido) | Free | Yes | |
Collaborative team workshops with a visual canvas and pre-built JTBD sections | $8/member/mo (Starter) | Yes (3 boards) | |
4-block web template with the interview guide built into the tool | Free | Yes | |
Quantitative opportunity scoring with an Excel download | Paid | No | |
Design-native teams already working in Figma; quick one-session canvas | Free with Figma account | Yes |
JTBD template tools comparison


The Kano model classifies how customers feel if a feature is present versus absent. Satisfaction does not rise in a straight line with more functionality.

UX ResearchOps as four systems: first-party panels, consent ops, repositories, and democratization guardrails. NN/g data and a GitLab SOP.

A practical decision framework for choosing UX research methods, with cost and time benchmarks per method, the attitudinal-behavioral gap as the organizing prin