Templates · user research notes

Affinity Mapping Template (free)

Organize messy user research notes into meaningful clusters so you can identify patterns, prioritize themes, and make confident product decisions.

Free to copyNo sign-upReviewed by Junu Yang

What is in it

Template components

Raw Notes & Observations
Paste or write every individual observation, quote, or note captured during research — one idea per sticky note or row.
Example: "User said she always forgets where the export button is." / "P3 mentioned onboarding felt overwhelming on day one." / "Two users tried to find billing under Settings first."
Affinity Clusters (Themes)
Group related notes together under a descriptive theme label that captures the shared idea across all notes in that cluster.
Example: Theme: "Navigation Confusion" — includes notes about misplaced export button, unexpected billing location, and difficulty finding account settings across 6 participants.
Frequency & Severity Score
Record how many participants mentioned each theme and rate its impact on a 1–3 scale so you can objectively prioritize what to act on first.
Example: "Navigation Confusion" — mentioned by 7 of 10 participants, severity 3 (blocks task completion); "Slow load times" — mentioned by 3 of 10, severity 2 (causes frustration but workaround exists).
Recommended Actions
Write one concrete next step for each theme — a design change, a follow-up question, or a team to loop in — so insights don't stall in a doc.
Example: For "Navigation Confusion": run a card sort with 5 users to validate a revised information architecture before next sprint; share findings with the design lead by Friday.

The template

The full template, ready to copy

Affinity Mapping Template
[Analyst] · [Date] · [raw research notes and observations]
1. Analysis Setup
Data source
[Raw research notes and observations from interviews, sticky note observations, and field notes]
Date range
[e.g. Jan 8, 2026 – Jan 22, 2026]
Analyst name
[e.g. Priya Shah]
Research question this analysis answers
[e.g. Where do users experience the most friction in completing cross-functional operational workflows?]

2. Step 1 — Code Your Excerpts
Excerpt 1
"I usually have the numbers in one dashboard, approvals in email, and the final update in Slack. By the time I piece it all together, the meeting has already started and I'm still screenshotting stuff."
tool switching time pressure
Excerpt 2
"Field note: participant paused for nearly two minutes looking for the latest status, then said, 'I never know which report is the real one unless I ask ops to confirm it.'"
data visibility gap collaboration need
Excerpt 3
"On the sticky note she wrote, 'I just copy the request into my own spreadsheet because if I wait for the system to update, nothing moves today.'"
manual workaround time pressure
Excerpt 4
"'The request is basically done, but it sits there until finance signs off, and if they're in meetings all afternoon, we're stuck.'"
approval bottleneck
Excerpt 5
"Field note: during handoff discussion, participant said, 'I have to ping design, then sales, then legal—otherwise everyone assumes someone else owns it.'"
collaboration need approval bottleneck
Excerpt 6
"'Every Friday turns into report cleanup. The exports don't line up, the labels are different, and I spend an hour just making it presentable for leadership.'"
reporting friction tool switching manual workaround
Excerpt 7
"Sticky note observation: 'We only notice something is off when a customer asks about it. Internally there's no clean view showing what's delayed or why.'"
data visibility gap reporting friction
Excerpt 8
"'Honestly, the work itself is fine. It's the constant chasing—asking who approved what, checking three tools, then rewriting updates so the next team can actually use them.'"
collaboration need tool switching approval bottleneck
Tip: A good code is short, reusable, and behavior-focused—it captures the underlying issue in the excerpt without rewriting the whole quote.

3. Step 2 — Group Codes into Themes
Workflow Inefficiency
Users lose time stitching together information, reformatting outputs, and creating their own stopgap processes to keep work moving.
time pressure · 2 excerpts manual workaround · 2 excerpts reporting friction · 2 excerpts
Collaboration Friction
Progress depends on repeated follow-ups, cross-team clarification, and manual coordination because ownership and handoffs are unclear.
collaboration need · 4 excerpts
Data & Visibility
Teams struggle to find a trusted, up-to-date view of status and performance, making it difficult to act confidently.
data visibility gap · 2 excerpts reporting friction · 2 excerpts
Process Bottlenecks
Work stalls at specific approval and handoff points, creating delays that feel disproportionate to the remaining effort.
approval bottleneck · 3 excerpts time pressure · 2 excerpts
Tooling Gaps
Current tools do not support the full workflow, forcing users to bounce between systems and reconstruct context manually.
tool switching · 3 excerpts manual workaround · 2 excerpts
Tip: When clustering codes into themes, look for repeated patterns in the problem—not just similar wording. A strong theme explains why several coded excerpts belong together.

4. Theme Summary Cards
Workflow Inefficiency · 4 total excerpts
Key insight: Users spend significant effort compensating for broken workflow continuity rather than completing the actual task.

Representative quote: "Every Friday turns into report cleanup. The exports don't line up, the labels are different, and I spend an hour just making it presentable for leadership."

Recommended action: Simplify recurring workflow steps by standardizing outputs and reducing the need for manual re-entry or cleanup.
Collaboration Friction · 4 total excerpts
Key insight: Cross-functional work depends too heavily on informal follow-up, which creates uncertainty about ownership and slows handoffs.

Representative quote: "I have to ping design, then sales, then legal—otherwise everyone assumes someone else owns it."

Recommended action: Clarify ownership and handoff expectations with visible status indicators, named owners, and notification rules.
Data & Visibility · 2 total excerpts
Key insight: Teams do not have a shared, trusted view of current status, causing hesitation and repeated verification behavior.

Representative quote: "I never know which report is the real one unless I ask ops to confirm it."

Recommended action: Create a single reliable source of truth for status and reporting with clearer freshness and ownership signals.
Process Bottlenecks · 3 total excerpts
Key insight: Approval steps introduce avoidable waiting time, especially when downstream teams cannot see where requests are stuck.

Representative quote: "The request is basically done, but it sits there until finance signs off, and if they're in meetings all afternoon, we're stuck."

Recommended action: Audit high-friction approval points and redesign them with SLAs, escalation paths, or reduced approval requirements.
Tooling Gaps · 3 total excerpts
Key insight: Users are forced across multiple disconnected tools, increasing context switching and making routine tasks feel fragmented.

Representative quote: "I usually have the numbers in one dashboard, approvals in email, and the final update in Slack. By the time I piece it all together, the meeting has already started and I'm still screenshotting stuff."

Recommended action: Consolidate key workflow touchpoints or improve integrations so users can complete common tasks without jumping between systems.

5. Analysis Wrap-Up
Top finding
[e.g. Users are not blocked by one single task—they are slowed by fragmented tools, unclear ownership, and manual reporting overhead across the workflow.]
Most urgent theme
[e.g. Process Bottlenecks]
Recommended next step
[e.g. Prioritize a workflow redesign workshop focused on approvals, reporting views, and cross-team handoffs.]
Share with (stakeholder)
[e.g. Head of Operations, Product Manager, Design Lead]
Date completed
[e.g. Jan 24, 2026]

How to use

How to use it

  1. Dump all your raw notes
    After your research sessions, paste every observation, quote, and field note into the Raw Notes section — don't filter or interpret yet, just get everything out.
  2. Group notes into clusters
    Read through all notes and physically or digitally move similar ones together, then write a short theme label that honestly describes what connects them.
  3. Score each theme by frequency and severity
    Count how many participants contributed notes to each cluster and rate how seriously the theme affects the user experience on a 1–3 scale.
  4. Define one action per theme
    For every cluster, write a single specific next step — a design change, a stakeholder to brief, or a hypothesis to test — so the map drives real decisions.

Filled in

What it looks like filled in

Navigation Confusion
"I kept looking for the export option under File — I never thought to check the dashboard header."
→ Redesign the top navigation to surface export and key actions as persistent, labelled icon buttons before the next usability round.
Overwhelming Onboarding
"There were so many steps on day one — I wasn't sure what I actually needed to do versus what was optional."
→ Introduce a progressive onboarding checklist that separates must-complete setup steps from optional feature discovery to reduce cognitive load.
Lack of Confidence in Data Accuracy
"I always double-check the numbers in a spreadsheet because I'm not 100% sure the dashboard is pulling from the right date range."
→ Add a persistent data source and date-range indicator to every chart so users can verify context without leaving the dashboard.

Or skip it

Why teams skip the template

Usercall reads the user research notes for you and drafts the themes, quotes and recommendations. See how qualitative analysis works.

  • Manually clustering hundreds of notes takes hours
    Moving sticky notes or rows one by one into theme groups is time-consuming and easy to abandon halfway through when research backlogs pile up.
  • Theme labels are subjective and inconsistent across teammates
    Two researchers grouping the same notes will often produce different clusters, making it hard to compare studies or build a reliable pattern library over time.
  • Insights lose urgency by the time the map is finished
    By the time you've clustered, scored, and written up actions — often days after fieldwork — stakeholder interest has moved on and the window to act has narrowed.

Reviewed by

Founder of Usercall. 15+ years in qualitative research and insight led strategy

Analyze your user research notes automatically — no template needed

Free to start. Upload transcripts, notes or survey responses and get themes with the quotes attached.