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!

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

      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... 

       

        Terms & ConditionsAccessibility statement

        Loading footer...