Find Number of (New) Users That Visited MORE than Once In FIRST Week.
I have tried so many logical operations but can't seem to find the correct one. The closest I can come is the amount of users that visited more than once within a week, regardless of it being their first week or not.
Re: Find Number of (New) Users That Visited MORE than Once In FIRST We
Count of Sessions where:
Count of Sessions = 2
Days Since Last Session <= 7
i.e. the number of seconds sessions that happened less than or equal to a week after the previous (first) session. Since a user can only have ONE second session, this equals the number of Users that had more than 1 session within the 7 days.
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here.