에디터 크기조정 이벤트 이용 규모

WITH p AS (
  SELECT p_date, nullif(user_id,'') uid, user_pseudo_id upid,
         ga_session_id sid, event_timestamp ts
  FROM bronze.google_analytics_miricanvas.events
  WHERE p_date BETWEEN '2026-09-07' AND '2026-09-13'
    AND event_name='generic_event_mican'
    AND label1='에디터_상단바_크기조정'
    AND ga_session_id IS NOT NULL
),
r AS (
  SELECT p_date, nullif(user_id,'') uid, user_pseudo_id upid,
         ga_session_id sid, event_timestamp ts, chunk_uuid rid
  FROM bronze.google_analytics_miricanvas.events
  WHERE p_date BETWEEN '2026-09-07' AND '2026-09-13'
    AND event_name='mican_action_page'
    AND action_name='PageResizeWithRemoveConstraintsCommand'
    AND ga_session_id IS NOT NULL
),
m AS (
  SELECT DISTINCT r.p_date, r.uid, r.rid
  FROM r JOIN p ON p.upid=r.upid AND p.sid=r.sid AND p.p_date=r.p_date
   AND r.ts > p.ts AND r.ts - p.ts <= 60000000   -- 60초
)
SELECT p_date, count(DISTINCT uid) true_exec_users,
       count(DISTINCT rid) true_exec_events
FROM m GROUP BY 1 ORDER BY 1;

WITH b AS (
  SELECT p_date, nullif(user_id,'') uid,
    CASE WHEN event_name='page_view'
          AND (page_location LIKE '%/design2/%' OR page_location LIKE '%/design/%')
         THEN 1 ELSE 0 END pv,
    CASE WHEN event_name LIKE 'mican_action_%' THEN 1 ELSE 0 END ea,
    CASE WHEN event_name='generic_event_mican' AND location1='에디터' THEN 1 ELSE 0 END eg,
    CASE WHEN event_name='generic_event_mican'
          AND label1='에디터_상단바_크기조정' THEN 1 ELSE 0 END pop
  FROM bronze.google_analytics_miricanvas.events
  WHERE p_date BETWEEN '2026-09-07' AND '2026-09-13'
    AND (event_name='page_view' OR event_name LIKE 'mican_action_%'
         OR event_name='generic_event_mican')
)
SELECT p_date,
  count(DISTINCT CASE WHEN pv=1 OR ea=1 OR eg=1 THEN uid END) AS editor_users,
  count(DISTINCT CASE WHEN pop=1 THEN uid END) AS popup_users
FROM b GROUP BY 1 ORDER BY 1;