Same Unique Visitors in same segment over consecutive months? | Community
Skip to main content
D
danielt36113379
Level 2
October 5, 2022
Solved

Same Unique Visitors in same segment over consecutive months?

  • October 5, 2022
  • 1 reply
  • 545 views

Hi all - hoping you can help.

 

We want to understand how many unique visitors in a specific segment continue to be in the same segment over consecutive months.

 

So, in the example below (excuse my poor Powerpoint skills), we know that there were 15,739 unique visitors are in a segment within April. We want to know how many of these same 15,739 visitors were also in the same segment in May, and then June, then July etc etc... So essentially creating a funnel of unique visitors by month.

 

We've thought of exporting all the raw data via DataWarehouse feature by month and using a series of 'VLOOKUPS' in Excel, but obviously would be far more efficient & usable if there was something within Analytics Workspace that could do the same in an automated way.

 

Any ideas / advice much appreciated! @jennifer_dungan ?

 

Example:

 

 

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

1 reply

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
October 5, 2022

Have you considered using a cohort table?

 

 

https://experienceleague.adobe.com/docs/analytics-learn/tutorials/analysis-workspace/cohort-analysis/overview-of-cohort-tables-in-analysis-workspace.html?lang=en 

    Terms & ConditionsAccessibility statement

    Loading footer...