Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
SOLVED

Time of first visit for Repeat Visitors

Avatar

Level 1

Hello!

 

Is there a way to pull the date (week, quarter, does not really matter) of the first visit for a specific cohort?

What I want to find out is: out of the Repeat Visitors (Visit Number > 0) we have seen coming in e.g. Q4, when did we see their first visit (e.g. some time in Q3)?

 

Hope I could make it clear enough!

Max

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

I haven't tried this on my own, but off the top of my head:

Create a Visitor segment where Visit Number > 1.

Then in an Analysis Workspace project, add that segment to the panel. Then in a Freeform Table, add the Visit Number dimension's "Visit Number 1" value, and break it down by Day. You can leave Occurrences as the metric, or add the Visits metric to that table.

Does that method work?

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

I haven't tried this on my own, but off the top of my head:

Create a Visitor segment where Visit Number > 1.

Then in an Analysis Workspace project, add that segment to the panel. Then in a Freeform Table, add the Visit Number dimension's "Visit Number 1" value, and break it down by Day. You can leave Occurrences as the metric, or add the Visits metric to that table.

Does that method work?