Skip to content
tezvyn:

How to visualize a complex, multi-stage customer funnel?

Source: Wikipedia: Alluvial diagramMediumHow cards are made

How to visualize a complex, multi-stage customer funnel?

Tests your ability to choose the right visualization for non-linear user flows. Propose a Sankey or Alluvial diagram to show flow volume, drop-off, and re-entry. A red flag is suggesting multiple simple charts that fail to show the paths between stages.

What's really being asked

This question tests your data literacy and ability to translate a complex business requirement into a specific, appropriate visualization. Interviewers want to see if you can move beyond basic charts (like funnels or bars) to accurately model system dynamics. It's a test of both your technical knowledge of visualization types and your ability to communicate their value to a business stakeholder.

The full answer

First, briefly acknowledge why a standard funnel chart is insufficient for this problem: it assumes a simple, linear progression and cannot represent users re-entering or skipping stages. Second, propose a Sankey diagram or an Alluvial diagram as the solution. These are types of flow diagrams. Third, explain the mechanics: the diagram consists of nodes (the stages) and links (the paths between them). The width of each link is directly proportional to the flow quantity (e.g., number of users), making it intuitive to spot the most significant paths and drop-offs. Fourth, tie it back to the business need by explaining how this visualization clearly shows not just drop-off (a flow to an 'Exited' node), but also complex behaviors like re-engagement (a flow from a later stage back to an earlier one) or skipping stages.

The mistakes people make

Suggesting a series of separate charts, like one bar chart per stage. This is a major red flag because it shows the volume at each stage but completely hides the flow and pathways between them, which is the core of the problem. Another mistake is proposing a complex, custom-built interactive dashboard without first naming the specific chart type (Sankey/Alluvial) that solves the core problem. Finally, giving a vague answer like "I'd use a more advanced flow chart" is too weak; you must name the specific type and explain why it works.

What usually comes next

Expect questions like "How would you handle a funnel with 20+ stages?" (Answer: It can get cluttered; you might need to aggregate less important stages into an 'Other' category or focus on the top N paths). Or, "What data would you need to generate this?" (Answer: Event-level data with user IDs, timestamps, and stage names. This is processed into a list of source-target-value triplets). They might also ask about tooling (D3.js, Plotly, Tableau, Looker).

A concrete example

Imagine 100,000 users visit a homepage (Stage 1). A Sankey diagram would show a thick band representing these users. From there, a band representing 60,000 users might flow to 'Product Search' (Stage 2), while a 40,000-user band flows to an 'Exit' node. From 'Product Search', perhaps 30,000 go to 'Add to Cart' (Stage 3), 20,000 exit, and a 10,000-user band flows back to the 'Homepage' to search again. A standard funnel cannot show that 10,000-user re-entry loop. A Sankey makes it visually obvious.

Interview question

To visualize a complex user journey with non-linear paths, like users returning to previous steps, which chart type is most effective for showing the flow and volume between stages?

  • a.A series of bar charts, one for each stage, to display the total number of users.
  • b.A standard funnel chart, as it is designed for visualizing user progression.
  • c.An Alluvial or Sankey diagram.Correct
  • d.A custom dashboard with KPIs and trend lines for each stage.
Why?

An Alluvial or Sankey diagram is correct because it is specifically designed to visualize flow between stages, with link widths representing volume. A series of bar charts is a tempting distractor because while it shows stage volume, it completely hides the paths users take between stages.

Just read this? Test yourself on what you have been reading.

Read the original → en.wikipedia.org

You just looked this up. Could you explain it out loud?

That is the part interviews actually test. Tezvyn takes questions like this one and gives you what the interviewer is really checking, the answer that lands, and the mistake that ends the conversation, in the four minutes before your next meeting.

The iPhone app is on the way

We are building it. Until it lands, nothing here is held back from you: every interview card, your saved cards, streaks and the job board all work in Safari, plus hundreds of free practice quizzes of thirty questions each. Sign in and it all carries over to the app the day it arrives.

Want it as an icon? Tap Share at the bottom of Safari, then Add to Home Screen. It opens full screen and the cards you have read stay available offline.

Get it on Google PlayiPhone app coming soon

We are hiring for this. Open roles that interview on analytics — each one lists the topics its interview covers.

See open roles