How many daily active users did I have in the last 30 days?
You can caluclate your Daily Active Users and your Monthly Active users using the moving time window
SELECT
b.date as date,b.dau as dau,count(distinct a.user_id , exact) as mau
FROM
( SELECT 1 as a,date(event_time_ts) as date,
max(date(date_add(event_time_ts,-30,'DAY'))) date_30,
count ( distinct user_id , exact ) dau
FROM cooladata
WHERE date_range(context)
GROUP BY 2
) AS b
join
( SELECT 1 as a ,date(event_time_ts) as date,
user_id
FROM cooladata
WHERE date_range ( between date(date_add(date_range_start,-30,'DAY')) and date(date_range_end)) group by 2,3
) AS a
ON b.a = a.a
where b.date_30<a.date and a.date<=b.date
group by 1,2
order by 1
