Solved

Users who did not pageview within last 90 days

  • 29 September 2023
  • 1 reply
  • 81 views

Hello,

 

I’m trying to understand how I can build a cohort of users who had a pageview before the last 90 days and have not since.

However, the way the logic is built now seems very confusing.

Is this the correct way to look at it? The way the logic stacks makes it very confusing. The way I read this is, user did page view since jan 1, then if at any point since that date they did not do pageview within 90 days, they are included.

That does not get to the essence of the question, which are users who have not done pageview in the last 90 days.

icon

Best answer by JennRu 29 September 2023, 20:31

View original

1 reply

Userlevel 4
Badge +8

Hi @Zayyan Chowdhury to setup the cohort use case of 

users who had a pageview before the last 90 days and have not since.

I would recommend to use the following setup (this is in our demo org)

Users viewed the page anytime in the last 365 days offset by 90. This offset sets the lookback to 365 days before the last 90 days. And then user did not view page in last 90 days.

 

Let me know if this helps or if you have any questions. Thank you

Reply