Connected rows, groups and journeys
Real questions are rarely about one row on its own. They are about the pages inside a session, the forms behind a lead, the page someone saw next. This page covers how to ask about all of that.
Connected rows
Every kind of row is connected to others. A session has page views, away periods, form submissions, form activity and its visitor. A form has its fields. A page view has its session, its visitor and its forms. Under + Look at its... you choose a connection, and a box opens where you add conditions for those connected rows.
Then you choose how to use them.
| Choice | Meaning | Example |
|---|---|---|
| has at least one | At least one connected row matches. | Sessions that have a page view where page is /pricing. |
| count or total | Measure the connected rows and compare the result with any operator: exactly 2, fewer than 3, between 2 and 5. | Sessions where the number of page views where page is /blogs is at least 2. |
Measures you can use
number of, number of different, total, average, lowest, highest, median and percentile. Which ones are offered depends on the field you measure (you cannot total a text field). The Field reference lists them.
"Page is /blogs and time on page more than 5 sec" means one page view that is both, not one page view of each. If you want two different page views, add two separate connected-row conditions.
Connected rows can have connected rows of their own: the page views of a session, and the fields of the forms on those page views. There is a limit on how deep you can nest, and Hook tells you if you reach it.
Any of, all of, none of (groups)
+ Any of / none of adds a group. Inside it, choose match any (OR) or match all (AND), and tick exclude (NOT) to turn it into "none of these". Groups nest as deep as you need.
| Group | Keeps a row when |
|---|---|
| match all (AND) | Every condition in the group is true. This is also how top-level conditions combine. |
| match any (OR) | At least one condition in the group is true. |
| exclude (NOT) | None of the conditions in the group is true. |
"Not campaign source is facebook or google" also keeps sessions that have no campaign at all, because a missing campaign is certainly not facebook. If you only want sessions that have a campaign, add is not empty as well.
Journeys: the page before and after
Every page view has four extra connections under + Look at its...:
- the next page and the previous page: the single page view right after or right before this one in the same session.
- the pages after it and the pages before it: all the page views later or earlier in the session.
They work like any other connected rows: has at least one, or count or total with any comparison.
The preview draws these in order, so you can see the path you described before you run it.