DAU/MAU "stickiness": calculated metric on a rolling date period

Avatar

Avatar

GaMeur1

Avatar

GaMeur1

GaMeur1

27-09-2019

Hi,

I'd like to calculate a "stickiness" metric for each day as DAU/MAU where DAU is the "daily active user" (i.e. uniques visitors) of a specific day and MAU is the "monthly active user" (i.e. unique visitors for the 30 last days) for the same day (so period including this day and 29 days before).

It's easy to get the DAU per day thanks to a simple table with "day" dimension as rows and "unique visitors" metric as column.

But I don't know how to get the number of unique visitors on the last 30 days for each day of a period.

I mean, it's possible one shot for a specific day, using a date range dimension, but it's not possible for each day of a period.

I can't figure out how to create a calculated metric that will give for each day of a period (day as dimension in rows) the number of unique visitors during last 30 days...

Does anyone already succeed to calculate such metric on a rolling date period?

View Entire Topic

Avatar

Avatar

GaMeur1

Avatar

GaMeur1

GaMeur1

03-10-2019

Thank you Andrey but I don't think it match my needs.

This is working only if you want to have DAU and MAU for yesterday.

For example, if today is October 3rd, I'll get DAU as uniques visitors for yesterday (October 2nd) and MAU as uniques visitors during last 30 days (from Sep 4th to October 2nd).

But I won't get it for each day of a specific past period!

For example, I would like to have those figures for each day of September. How do I do?