Repeat Visitor (90 Days) | Community
Skip to main content
skatofiabah
skatofiabah
January 23, 2025
Solved

Repeat Visitor (90 Days)

  • January 23, 2025
  • 3 replies
  • 1290 views

Hi,

 

I'm trying to come up with a way to easily show when a visitor sees a specific URL and then comes back to that same URL in 90 Days. I think this is the right way to think about my segment? My question is though, is there an easy way that I can show this for Repeat Visitors by Month, Week, etc. granularity? In other words, if I take this segment and then expand my date range in freeform and add month as a dimension, is that a problem? Is this just going to look at visitors that did this at any point in time based on the segment and then sum up the users for that month (whether they did it that month or not?) If so, how can I alleviate that? Or am I going to have to do this in Downstream DB and SQL?

 

Thanks!

 

Best answer by Jennifer_Dungan

So if you really want the page views of that page (in this scenario), I would create a hit based segment with a Visitor Container inside of it...

 

So I did a simple:

 

HIT [

    Page equals X

]

 

and

 

 

HIT [

    Page equals X

    AND

    VISITOR [

        Page equals X

        THEN after 1 visit but within 90 days

        Page equals X

    ]

]

 

 

I can see that my date range is still constrained by Last Month, and that my Hits and UVs for the Page is higher than the "repeat" segment.

 

If I were to break it down by page, you will see I am limited to just that page (and not all pages from all visitors/visits where the visitor met the criteria):

 

 

Is this more what you are looking for?

 

Keep in mind, only the hits to the Page that fall within the panel range are included here... 

 

3 replies

skatofiabah
skatofiabahAuthor
January 23, 2025

Here is the workspace.

 

skatofiabah
skatofiabahAuthor
January 23, 2025

And also to get the repeat visitor (%) of the original page.

 

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
January 23, 2025

First off, do you does it matter if the page is in the same visit? Or it should be after the initial visit but within 90 days?

 

Also, are you trying to pull ALL content for the users in that scenario, or do you need a smaller scale (just trying to figure out if the overall scope is correct... while you will need Visitor scope somewhere, I am trying to determine if it should be at a container level within a small scoped segment (depending on what you are trying to do with the segment).

 

 

However, have you considered using a cohort table instead of a segment?

 

Where the entry criteria is your page, and the return criteria is the same page... then you can choose a granularity...

    skatofiabah
    skatofiabahAuthor
    January 23, 2025

    Hi @jennifer_dungan,

    I changed it to be "after 1 visit" but "within 90 days". I'm trying to look at all UVs for that page for the month in 1 column, then in another column see how many repeat visitors happened in a given month with a lookback window of 90 days from that month to see if they saw that page prior within 90 days (and I guess after 1 visit so as to not have page refresh or back and forth, etc.).

     

    The breakdown dimension would be month and then I want to take a percent of both columns to get "% of repeat Visitors from total UVs" for a given month.

     

    I think you might have mentioned in the past that the date range in the panels of the workspace can conflict with the segment "Then...after....but within".

     

    I was wondering if there is a way to solve this.

     

    Thanks!

      skatofiabah
      skatofiabahAuthor
      January 23, 2025

      Yeah, it's a bit odd... it should look at repeat hits within the 90 day time frame, but only the hits within the panel range will be shown...

       

      So unlike adding an actual "Last 90 Days" range inside the segment (which will supersede the panel date range, and show the report based on the last 90 days, the report will still only show you the specified range (in my example, "last month")... but the logic will be based on the last 90 days....

       

      You could make your panel and segment match... so if you are interested in the last 90 Days, use that for your panel range as well.

       

       

      The difference between adding an actual date range into your segment, and using the "within" logic, is that the actual date range forces overrides the panel date range, whereas the "within" only affects the matching criteria but not the report.


      Hi @jennifer_dungan,

      So the UVs for a given page by month based on panel date range makes complete sense to me and is straightforward. What I'd like to know is to get repeat visitors, I want to know if the panel is Jan - Dec 2024 and i breakdown by month and I have the segment above, is it going to give me the hits on those days for a given month and then look back 90 days from each of those hits? Or is the visitor container of the segment going to override that logic and just look across any point in history (could be years prior) and that would add +1 to UV?

      Terms & ConditionsAccessibility statement

      Loading footer...