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
Segentation
kpi
Behavioral
ROI
Retention