How to build segment of visitors who had visits 7 days ago but no visits within the following 6 days?

Avatar

Avatar
Publish 1
MVP
yuhuisg
MVP

Likes

195 likes

Total Posts

596 posts

Correct reply

118 solutions
Top badges earned
Publish 1
Affirm 100
Springboard
Bedrock
Validate 1
View profile

Avatar
Publish 1
MVP
yuhuisg
MVP

Likes

195 likes

Total Posts

596 posts

Correct reply

118 solutions
Top badges earned
Publish 1
Affirm 100
Springboard
Bedrock
Validate 1
View profile
yuhuisg
MVP

25-11-2020

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.

Accepted Solutions (0)

Answers (0)