내 커뮤니티 업적 표시줄을 확대합니다.

Submissions are now open for the 2026 Adobe Experience Maker Awards
해결됨

Visitor with multiple visits in month

Avatar

Level 2

I am looking for a way to count visitor with at least 2 visits in one month. I tried sequential segments:

Thomas_Wolf_0-1695628706457.png

and visits >= 2:

Thomas_Wolf_1-1695628743873.png

Checking this with Data from DWH, Segment (Visits >= 2) was closest, but not exact match.

Did anyone had the same issue? How did you handle that?

 

 

주제

토픽은 커뮤니티 콘텐츠를 분류하여 관련성 있는 콘텐츠를 찾는 데 도움이 됩니다.

1 채택된 해결책 개

Avatar

정확한 답변 작성자:
Community Advisor and Adobe Champion

Again, it will be close by not exactly, but you could try adding a date constraint?

 

VISITOR

    Visit is greater than or equal to 2

    AND

    Last 30 full days

 

 

 

It won't line up with the calendar date, but at least on a rolling month basis, those 2 visits must be within the same 30 day time frame?

원본 게시물의 솔루션 보기

4 답변 개

Avatar

정확한 답변 작성자:
Community Advisor and Adobe Champion

Again, it will be close by not exactly, but you could try adding a date constraint?

 

VISITOR

    Visit is greater than or equal to 2

    AND

    Last 30 full days

 

 

 

It won't line up with the calendar date, but at least on a rolling month basis, those 2 visits must be within the same 30 day time frame?

Avatar

Community Advisor and Adobe Champion

Interesting question and I tried as well. Using your segments gives me two very different numbers, the simple segment is almost double the sequential, and I wonder if both segments really mean the same thing.

And it is not.

The sequential segment is another "visit" exists "after 1 visit" of another "visit", so there are 3 visits in total. If I change the simple segment to visits larger or equal 3, both segments give the same answer.

I tried to think about how to create a sequential segment to your intention but was unable to get that yet.

 

Avatar

Community Advisor and Adobe Champion

I am also trying variants, and in all cases right now, I have visitors coming back with only 1 visit...  (which shouldn't be the case for any of the above)... I am going to keep digging.

Avatar

Community Advisor and Adobe Champion

Tried to play around and found a way to create a sequential segment with the same result as the simple "Visits >= 2" segment

Screenshot 2023-09-27 at 12.04.26 PM.png

 The trick is adding the visit container first before the "then" operator and there is no need to specify the "after" clause to the operator