Expand my Community achievements bar.

Webinar: Adobe Customer Journey Analytics Product Innovations: A Quarterly Overview. Come learn for the Adobe Analytics Product team who will be covering AJO reporting, Graph-based Stitching, guided analysis for CJA, and more!
SOLVED

Repeat Users to a Page Calculation

Avatar

Level 4

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:

 

skatofiabah_0-1727726255833.png

 



Thanks!

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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:

Jennifer_Dungan_0-1727750602031.png


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.

 

View solution in original post

6 Replies

Avatar

Correct answer by
Community Advisor

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:

Jennifer_Dungan_0-1727750602031.png


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.

 

Avatar

Level 4

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?

Avatar

Community Advisor

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.

Avatar

Level 4

Hi @Jennifer_Dungan,

 

Originally I wanted to try "Page A in Visit" THEN WITHIN 90 DAYS "Page A in Visit". This is my segment logic for September to "Page A" for rolling 90 day (rolling 3 month and/or rolling back to July 2024).

 

skatofiabah_0-1727798542113.png

I then use this segment to put over UVs to get a UV count, but then I need an overall just Hit segment to "Page A", then I break down in freeform by month to try to get the repeat users for that month based on these segments. I apply the same logic when brining in the other months on the dimensions for each segment to each month.

skatofiabah_1-1727798717245.png


Let me know if this make sense and is the optimal way and best logic. It seems doable, just tricky and super manual every month I'll need to report this (I'll need to update segments for new month historical rolling 90 days/3months).

 

Avatar

Community Advisor

So if I do something like this:

Jennifer_Dungan_0-1727800019794.png

 

 

And I pair it with a time frame (let's say we are looking at the Last 12 Full Months)... this will look for a Visitor that that hit the home page, then hit the home page again within 90 days of that original hit... but that visitor will be returned in every month for that 12 month period (if they came to the site), regardless of if they hit the home page that month...

 

Example:

January

  • page a
  • page b

February

  • page a
  • page c

March

  • home
  • page d

April

  • page e
  • home

August

  • page f

 

 

This visitor met the criteria in March>April, but they came to the site outside that range, and so, they will be counted as a UV in Jan, Feb, Mar, Apr and Aug; since the visitor as whole, has met the criteria... even if they didn't meet the criteria each month...

 

This also means that past months will change over time... yesterday you might see UVs as 158, and today you see 163, and tomorrow it might be 179.... because as new users start meeting the criteria (and they were active site users), they will be included in all those reports... and there's no easy way to only "include sequence"... you can include ALL users, you can include "Before" Sequence (which includes the sequence) and you can include "After" sequence (same as Before, this will include the sequence).... 

 

So you could apply "only After sequence" to prevent past numbers from changing... but if the user hits the page in the first half of the year, do you still want them included after they stopped coming to the page??

 

 

This is some of the complex logic that I find just doesn't work well in the Segment builder...  which is probably why the cohort table locks the dates in place... 

 

 

Now, if you are only going to be looking at 90 Days at a time... maybe this is less of an issue.... 

 

Avatar

Level 4

Hi @Jennifer_Dungan,

 

I think that's why I have to also add another hit segment to make sure that the user actually saw the page when broken down by month. I think I just have to manually create a new segment as each new month approaches and just adjust the 3 months to be the previous 3 month (90 days).