Monthly New users | Community
Skip to main content
ryzen_
September 19, 2023
Solved

Monthly New users

  • September 19, 2023
  • 1 reply
  • 1882 views

Hi to everyone,

my client asked me to find the number of new users for each months in the last three months.

While at first, this problem seemed pretty easy, it turned out to be quite a mess.

I thought about approaching the problem using a Venn Diagram in order to visualize both the returning and new users, using three segment for each months defined in this way:

But it turns out that all the segment return a wrong number of users (almost 5M higher than expected).

 

Do you have any suggestions?

Thank you in advance!

 

 

 

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

It was just in front of my eyes ;( Thank you! I've tried different ways to calculate the new users, including your segment, but I still can't get my head around what's the most suitable for my client request:

Since the beginning of this year, for each months, give me the % of new users and % of returning users. 

 

  • Create two segments (as suggested in this blog) using visits metric:
  • Create two segments using visit number dimension (I saw you mentioned it in your video but I didn't understand what you mean for "all time dimension")
  • Cohort table (as suggested in this blog)it doesn't completely respond to the question but it can gives an idea of the magnitude of returned/new visitor:

 

I put all this segments in a freeform table :

 

Thank you again for your help!


 


You're welcome 🙂

Visitor Segments can be the hardest to wrap one's head around.

 

It should also be noted that when I wrote those tips, the Visitor segments worked a bit differently (they pulled all-time visitor data, instead of limited to the panel date range... though no one will admit that change occurred, leading me to believe this was an uncaught bug since the beginning of the segment builder), those "time blocks" were needed to compensate for that "all time" processing.

 

 

So if you drop the date range, you shouldn't even need to use dynamic date ranges.

 

Here are versions of updated segments (there is still a slight variance when basing this on Months - because we are still looking at the "average" 30 day return window, instead of matching directly to that month, 31 days or 28 days for example - but as long as you say its based on 30 days in your description you should be fine)

 

New Visitors:

 

Returning Visitors:

 

 

Now that segments are taking date info from the Workspace, this means you don't have to force a date into the segment, and allows you to look at this for the current year.

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
September 19, 2023

I did a Rock Star session on Non-Overlapping New and Repeat User Segment at Summit, (then did an encore for Skill Exchange) that might help you:

 

https://experienceleague.adobe.com/docs/events/the-skill-exchange-recordings/analytics/may2023/rockstar-tips.html?lang=en

ryzen_
ryzen_Author
September 19, 2023

Hi Jennifer,

thank you for your detailed video! I followed it and I tried to calculate new users in August 2023. I guess I did something wrong since I got 0 new users 😞 (I also activated "Make date range components relative to panel calendar" option)

 

This is the segment I created:

Could you help me? Thank you again!

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
September 19, 2023

Hi... looks like a simple fix... in your first container you are using AND instead of OR

 

Days Since Last Visit is greater than 30

AND

Visit Number equals 1


should be

 


Days Since Last Visit is greater than 30

OR

Visit Number equals 1


That should fix the issue