Rolling Daily/Monthly/Yearly Active User Metrics + User stickiness metrics (i.e. MAU/YAU)

Avatar

Avatar

michael-au

Avatar

michael-au

michael-au

02-11-2020

Description - We wish to be able to create a table and line chart that contains a break-down by day which includes metrics to look back at the unique visitors for the past 30 days and 365 days, as well as including a user stickiness metric which will be defined as MAU/YAU.

 

For example:

michael-au_0-1604369081892.png

 


Why is this feature important to you - Active users indicate that people are interacting with our app/website. Determining the number of active users over time helps us with assessing the effectiveness of our marketing campaigns and the customer experience.

How would you like the feature to work - Out of the box Active User metrics (DAU, MAU [rolling 30 days], YAU [rolling 365 days]); Out of the box user stickiness metrics (DAU/MAU; DAU/WAU, WAU/MAU, MAU/YAU); Out of the box Workspace template that has the key active user and stickiness metrics trended over time; Ability to create custom active user metrics based on custom time frames - including rolling amounts and custom user stickiness metrics with the ability to trend per day based on the rolling amount. 

Current Behaviour - While we can use the Unique Visitor metric broken down by one of the out of the box date date breakdowns, it seems that it isn't possible to calculate the active users for a rolling date range, for example rolling 30 days up to and including the date that the UVs is broken up by. Trying to achieve this via the Cumulative Average Function doesn't dedupe Visitors that revisit the website within the same period.

active users DAU MAU retention user stickiness YAU
4 Comments (4 New)
4 Comments

Avatar

Avatar

tt307

Avatar

tt307

tt307

02-11-2020

This is a great suggestion - would love to get better retention analysis for our product team!

Avatar

Avatar

yuhuisg

Avatar

yuhuisg

yuhuisg

02-11-2020

Isn't this already available in the Cohort Table panel? (Though you can't get a Daily breakdown.) And at first glance, the Cohort Table could be more actionable than your suggested table.

Avatar

Avatar

stanfeldman

Avatar

stanfeldman

stanfeldman

02-11-2020

Cohort Table is different from the stickiness metric such as DAU/MAU or MAU/YAU. I'm quite frustrated that Adobe doesn't support such a widely used metric.

Avatar

Avatar

michael-au

Avatar

michael-au

michael-au

02-11-2020

Retention as reported in the cohort table and the active user metrics are two different measures.

 

Further more trying to chart the included column of the cohort results in each date being charted as a separate series. Further more the cohort report doesn't include any user stickiness metrics.

 

michael-au_0-1604371661985.png