How to build segment of visitors who had visits 7 days ago but no visits within the following 6 days?
I want to build a segment of visitors that have the following criteria:
- Had visits 7 days ago
- Then in the following 6 days, had 0 visits
(Days are relative to today.)
For example, given today is 25 Nov, then:
Visitor A:
18 Nov: >=1 visits
19 Nov: >= 1 visits
20 Nov: 0 visits
21 Nov: 0 visits
22 Nov: 0 visits
23 Nov: 0 visits
24 Nov: 0 visits
Visitor B:
18 Nov: >=1 visits
19 Nov: 0 visits
20 Nov: 0 visits
21 Nov: 0 visits
22 Nov: 0 visits
23 Nov: 0 visits
24 Nov: 0 visits
Visitor C:
18 Nov: 0 visits
19 Nov: 0 visits
20 Nov: >=1 visits
21 Nov: 0 visits
22 Nov: 0 visits
23 Nov: 0 visits
24 Nov: 0 visits
Visitor 😧
18 Nov: >=1 visit
19 Nov: 0 visits
20 Nov: 0 visits
21 Nov: 0 visits
22 Nov: 0 visits
23 Nov: 0 visits
24 Nov: 0 visits
Visitor E:
18 Nov: >=1 visit
19 Nov: 0 visits
20 Nov: 0 visits
21 Nov: 0 visits
22 Nov: 0 visits
23 Nov: 0 visits
24 Nov: >=1 visits
Then the segment should only include visitors B and D.