repos / pico

commit

82dc843

parent

e7dcc74

author

Eric Bower

date

2024-10-16 01:46:46 +0000 UTC

chore: monthly active users script

 1@@ -0,0 +1,13 @@
 2+select
 3+  count(distinct user_id) as mau_posts,
 4+  date_trunc('month', updated_at) as month
 5+from posts
 6+group by month
 7+order by month DESC;
 8+
 9+select
10+  count(distinct user_id) as mau_pgs,
11+  date_trunc('month', updated_at) as month
12+from projects
13+group by month
14+order by month DESC;