Target engaged sessions with no order yet, is this the right query?
We see a segment of visitors who browse for 6-8 minutes, view a handful of products, and leave without buying. I want to nudge them with an incentive before they bounce. My draft:
session's duration > 300 and session's stats' orders is 0Two questions. Is duration in seconds, or do I need some unit? And do the session counters like orders update live during the visit or only after the session closes? If they lag, the whole audience is pointless for what I want to do with it.
1 answer
Durations are first-class in CQL, so skip the raw seconds and write the unit:
session's duration > 5 minutes and session's stats' orders is 0Much harder to misread in six months than a bare 300.
The counters update in real time as events come in, audiences are evaluated per interaction, so a visitor enters this audience mid-session the moment they cross 5 minutes without an order. That is exactly what you want for an exit-intent style nudge.
Related bits you may want for tuning:
- session's stats' pageviews > 3 if duration alone catches people idling on one tab
- session is starting targets the very first interaction, the opposite end of the spectrum
- session also exposes start, end, landingPage, and referrer if you want to limit the nudge to certain entry points