목록2024/02/13 (1)
짜리몽땅 매거진
![](http://i1.daumcdn.net/thumb/C150x150/?fname=https://blog.kakaocdn.net/dn/bUuQr1/btsEP8YkQff/aWxYJq6dctM03GBtKq0XK1/img.png)
0. 데이터 구조 주의깊게 볼만한 테이블 : ga_sess , ga_sess_hits 1. 일별 세션 건수, 일별 방문 사용자, 사용자별 평균 세션 with temp_01 as ( select to_char(date_trunc('day', visit_stime), 'yyyy-mm-dd') as d_day -- ga_sess 테이블에는 sess_id로 unique하므로 count(sess_id)와 동일 , count(distinct sess_id) as daily_sess_cnt , count(sess_id) as daily_sess_cnt_again , count(distinct user_id) as daily_user_cnt from ga.ga_sess group by to_char(date_trunc..
Data/SQL
2024. 2. 13. 15:54