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