Repeat Users to a Page Calculation | Community
Skip to main content
skatofiabah
skatofiabah
September 30, 2024
Solved

Repeat Users to a Page Calculation

  • September 30, 2024
  • 1 reply
  • 896 views

Hi All,

 

I'm trying to build a segment that will allow me to look at repeat visitors to a specific page, let's call it "Page A". I'm trying to see repeat users for July 2024 and after. I want to have the first visit be on or after July 1st. Then I want to be able to look within a rolling 90 day window to see if a user repeated or not within 90 days. If it's like July 2 (example within 90 days), I don't want to look past July 1st. Hard cap it there. The issue here too is that I cannot look at month "greater than or equal to" Jul 2024. I have to select a distinct value. Also, how can I make sure to look at repeat visitors within 90 full days? I need to also look at this on a monthly level in workspace. Get the repeat visitors within 90 full days for July, August, September 2024, etc. Is this possible? 

 

This is my attempt at it, but I don't think it's right. I also don't think it's right when I break out in a freeform table by the month dimension:

 

 



Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jennifer_Dungan

Have you considered using a cohort table, then create a segment from there and modifying it?

 

Basically, if you create a simple cohort, something like this:


Using Page Views and a segment for your page.

 

Make sure you have a date range selected that will show some cohort columns...

 

Then you can right click the column to "create segment from cell", which will build out the nested containers... you should then be able to modify it to fit your 90 day time frame.

 

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
October 1, 2024

Have you considered using a cohort table, then create a segment from there and modifying it?

 

Basically, if you create a simple cohort, something like this:


Using Page Views and a segment for your page.

 

Make sure you have a date range selected that will show some cohort columns...

 

Then you can right click the column to "create segment from cell", which will build out the nested containers... you should then be able to modify it to fit your 90 day time frame.

 

    skatofiabah
    skatofiabahAuthor
    October 1, 2024

    Hi @jennifer_dungan,

     

    This makes sense to me and I got this far. So my follow-up question is it sounds like I have to manually segment this out for each month that rolls by? In other words, I need to basically create segments for each 90 day look back window to say a user came in july or august or september and then a user came again in july august or september and I have to repeat this for each new monthly going forward? If so, once I have these segments, do I still need to filter down to the page level in my workspace and/or panel to be able to get the hits for a given month based on those metrics?

    Jennifer_Dungan
    Community Advisor and Adobe Champion
    Jennifer_DunganCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    October 1, 2024

    You might be able to make a rolling date range?

     

    This will also require setting the panel to "relative dates" and you will probably have to choose a single day (like "today" or "yesterday") at the panel level to get the correct 90 day "lookback"?

     

    I'm not saying this will be easy....

     

    Or we can try going back to your original solutions, looking for a sequence and within 90 days... and try to work through that logic together.

      Terms & ConditionsAccessibility statement

      Loading footer...