Lens

Flow Tile

A Sankey diagram of journeys stored as path values, such as google / cpc > email / newsletter, sized by a metric. Use it to show how conversions flow through step 1, step 2 and onward.

Flow tile: step one sources flow into step two sources and on to 510 conversions; google / cpc leads with 420.
Illustration with the numbers from the Example below

What it shows

The Flow tile is a Sankey diagram drawn from a path dimension: a column where each value is a whole journey, with steps joined by " > ". The first column of nodes is step 1 of every journey, the next is step 2, and so on, ending in one final node. Each band is sized by the metric you pick, such as conversions or revenue, and the hover text gives each flow's share of the total.

Use it forNot for
Showing how conversions from an attribution table move through step 1, step 2 and step 3Building paths from raw event rows (use Journey)
Sizing journeys by revenue or conversions rather than by usersTables without a path column (the tile has nothing to draw)
A board-ready view of the same paths a Table tile listsExact counts per path (use a Table tile grouped by the path)

Example

An attribution table has a path column and a conversions metric:

path_source_mediumconversions
google / cpc300
google / cpc > google / cpc > (direct) / (none)120
facebook / paid > google / cpc80
newsletter / email > google / cpc10
SettingValue
TypeFlow
Metricconversions
Group Bypath_source_medium
Steps to show4
Group small flows as "Other" below (%)2
Final step name (optional)Empty, so the final node is named after the metric

The total is 510 conversions, so anything under 2% (10.2) at a step is grouped as Other. The tile shows these nodes:

NodeConversionsShare
Step 1: google / cpc42082.4%
Step 1: facebook / paid8015.7%
Step 1: Other102.0%
Step 2: (direct) / (none)12023.5%
Step 2: google / cpc9017.6%
conversions (final node)510100.0%

The repeated google / cpc > google / cpc counts as one step, so the 120 conversions go google / cpc, then (direct) / (none). newsletter / email (10, under 10.2) joins Other at step 1. The 300 single-step journeys flow straight from step 1 to the final node.

Data it needs

  • A path dimension: each value is one journey, with steps separated by a space, > and a space, such as google / cpc > email / newsletter. A value that starts with ... > (written by attribution tables when they keep only the last steps of a long journey) gets an Earlier steps node first.
  • A metric to size the bands, such as conversions or revenue. Paths whose value is zero or below are skipped.

Attribution tables built in Lens carry path columns of this shape. Any other table with a column in the same format works too.

Settings

SettingWhat it doesDefault
TitleThe tile header. RequiredEmpty
DescriptionOptional text behind an info iconEmpty
TypeFlowKPI
SizeSmall, Third, Medium or LargeMedium
Data TableThe table to readNone
MetricSizes the bands. RequiredNone
Group ByThe path dimension. Required for FlowNone (total only)
FiltersTile filters on the table's rows, with + Add Filter. Several filters must all matchNone
Join with Table (optional)Adds metrics from a second table, as on other standard tilesNo join
Steps to show2 to 8. Longer journeys keep their first steps4
Group small flows as "Other" below (%)0 to 50. At each step, values carrying less than this share of the total merge into "Other". 0 keeps every value2
Final step name (optional)Names the final node, up to 40 charactersThe metric's name
Date rangeInherit from board, Ignore, Relative range or Fixed dates. Unlike the user-level tiles, Flow honors this settingInherit from board

How it calculates

  1. Lens totals the metric for each path value in the date range, after tile filters and board filter chips, and keeps the 5,000 largest paths.
  2. Each path is split on " > ". Blank steps are dropped, and the same step repeated in a row counts once (a > a > b is a > b).
  3. Each path keeps its first Steps to show steps. An Earlier steps node, when present, uses one of those slots.
  4. At each step position, a value whose total is below the Other threshold becomes "Other". The threshold is a share of the metric's total for the tile's whole range, not just the 5,000 paths fetched.
  5. A node is identified by its step position and value, so google / cpc at step 1 and at step 2 are separate nodes and the diagram never loops.
  6. Every path ends with a link from its last kept step to the final node.

Within each column, nodes are ordered largest first, with Other and Earlier steps at the bottom. A step value gets the same color wherever it appears, on the board and in the public report. Other, Earlier steps and the final node are grey.

If no path has a value above zero, the board shows "No journeys in this period. Check that Group By is a path dimension (steps joined by " > ")." The public report shows "No journeys in this period."

What viewers can do

ActionBoardPublic report
Hover a nodeStep number, value, the metric and its share of the totalSame
Hover a bandFrom, to, the metric and its share of the totalSame
Info iconShows the tile descriptionSame
AI buttonSummarizes the tile, when AI features are on for the propertyNot shown
Board filter chipsAppliedSame
Change the date rangeThe tile reloads, unless it has its own date rangeSame

The board and the public report draw Flow with the same code, so they match. Nodes cannot be dragged or clicked.

Limits and gotchas

  • Group By must be a path column. On an ordinary dimension, each value becomes a one-step journey and the diagram is just a split of the total.
  • Separators need spaces. Steps must be joined by " > ". A value such as a>b is read as one step.
  • Longer journeys are cut, not merged. With Steps to show at 4, steps 5 and later of a journey are not drawn; the band goes from step 4 to the final node.
  • Only the 5,000 largest paths are fetched. Shares still divide by the full total, so the tail is not lost from the percentages, but its bands are not drawn.
  • A metric that is a ratio or average does not add up along a path. Use a count or a sum, such as conversions or revenue.
  • Other is per step. A value can be its own node at step 1 and fall into Other at step 2, where it is smaller.